Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to backup clone database, the article is very detailed, has a certain reference value, interested friends must read!

---Based on backup clone

1. Create pfile

create pfile from spfile

added

log_archive_dest

compatible=

2. Create password files and folders

orapwd file=D:\app\product\11.2.0\dbhome_1\database\PWDGTJ.ora password=GTJ entries=4

3, listener.ora, tnsnames.ora to create local names must be created in the target database and auxiliary database

4. Register a new instance

oradim -new -sid GTJ -intpwd GTJ

5. Create spfile

create spfile from pfile='D:\app\product\11.2.0\dbhome_1\database\initgtj.ora'

STARTUP NOMOUNT FORCE PFILE='D:\app\product\11.2.0\dbhome_1\database\initgtj.ora'

alter system set compatible='11.2.0.4.0' scope=spfile;

DUPLICATE TARGET DATABASE

FOR STANDBY

FROM ACTIVE DATABASE

PASSWORD FILE

SPFILE

PARAMETER_VALUE_CONVERT '/disk1', '/disk2'

SET DB_FILE_NAME_CONVERT '/disk1','/disk2'

SET LOG_FILE_NAME_CONVERT '/disk1','/disk2'

SET DB_UNIQUE_NAME 'dup1'

SET SGA_MAX_SIZE 200M

SET SGA_TARGET 125M;

6. Connect rman

Both the target database and the secondary database are created

rman AUXILIARY sys/gtj@gtjtest

7. Clone database

---------------------------

RUN{

SET NEWNAME FOR DATABASE TO 'D:\APP\ORADATA\GTJ\%b';

DUPLICATE DATABASE TO 'GTJ' BACKUP LOCATION 'D:\app\flash_recovery_area\orcl\ORCL\BACKUPSET\2017_08_09' NOFILENAMECHECK;

}

rman nocatalog

connect target sys/oracle@zz

connect AUXILIARY sys/gtj@gtjtest

rman target sys/oracle@zz AUXILIARY sys/gtj@gtjtest

run{

SET NEWNAME FOR DATABASE TO 'D:\APP\ORADATA\GTJ\%b';

duplicate target database to GTJ FROM ACTIVE DATABASE

logfile

group 1 ('D:\APP\ORADATA\GTJ\REDO01.LOG') size 10m,

group 2 ('D:\APP\ORADATA\GTJ\REDO02.LOG') size 10m,

group 3 ('D:\APP\ORADATA\GTJ\REDO03.LOG') size 10m;

}

---------

RUN{

DUPLICATE DATABASE ORCL TO 'GTJ' BACKUP LOCATION 'D:\app\flash_recovery_area\orcl\ORCL\BACKUPSET\2017_08_09'

SET DB_FILE_NAME_CONVERT ('D:\APP\ORADATA\ORCL','D:\APP\ORADATA\GTJ')

SET LOG_FILE_NAME_CONVERT ('D:\APP\ORADATA\ORCL','D:\APP\ORADATA\GTJ');

}

DUPLICATE DATABASE TO GTJ

UNTIL TIME "TO_DATE('08/09/2017 19:00:00', 'MM/DD/YYYY HH24:MI:SS')"

BACKUP LOCATION 'D:\app\flash_recovery_area\orcl\ORCL\BACKUPSET\2017_08_09'

NOFILENAMECHECK;

alter system set db_recovery_file_dest='D:\app\flash_recovery_area'

RUN

{

ALLOCATE AUXILIARY CHANNEL newdb DEVICE TYPE sbt;

DUPLICATE TARGET DATABASE TO newdb

PFILE ?/ dbs/initNEWDB.ora

UNTIL TIME 'SYSDATE-1' # specifies incomplete recovery

SKIP TABLESPACE example, history # skip desired tablespaces

DB_FILE_NAME_CONVERT ('/h2/oracle/dbs/trgt/','/h3/oracle/oradata/newdb/')

LOGFILE

GROUP 1 ('/h3/oradata/newdb/redo01_1.f',

'/h3/oradata/newdb/redo01_2.f') SIZE 4M,

GROUP 2 ('/h3/oradata/newdb/redo02_1.f',

'/h3/oradata/newdb/redo02_2.f') SIZE 4M,

GROUP 3 ('/h3/oradata/newdb/redo03_1.f',

'/h3/oradata/newdb/redo03_2.f') SIZE 4M REUSE;

}

RUN

{

SET NEWNAME FOR DATABASE TO '/oradata1/%b';

DUPLICATE TARGET DATABASE TO dupdb

LOGFILE

GROUP 1 ('/duplogs/redo01a.log',

'/duplogs/redo01b.log') SIZE 4M REUSE,

GROUP 2 ('/duplogs/redo02a.log',

'/duplogs/redo02b.log') SIZE 4M REUSE;

}

DUPLICATE DATABASE TO GTJ

UNTIL TIME "TO_DATE('08/09/2017 19:00:00', 'MM/DD/YYYY HH24:MI:SS')"

BACKUP LOCATION 'D:\app\flash_recovery_area\orcl\ORCL\BACKUPSET\2017_08_09'

NOFILENAMECHECK;

DUPLICATE DATABASE 'PROD' dbid 8675309 to 'TEST'

UNTIL TIME "to_date('11/01/2007', 'MM/DD/YYYY')"

BACKUP LOCATION '/backups' NOFILENAMECHECK

PFILE='?/ dbs/inittest.ora' db_file_name_convert='prod','test';

The above is "How to backup clone database" all the content of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.