Clone the output of the Oracle 10g R2 database using RMAN DUPLICATE

The output of this command shows that the duplicate command of Oracle RMAN is executed internally and has a deeper understanding of cloning.For demonstration of the previous steps, see:

C: \ oracle \ product \ 10.2.0 \ client_1 \ BIN> rman target sys/password @ DGP

Recovery Manager: Release 10.2.0.1.0-Production on Tuesday January 31 00:59:06 2012 Copyright (c) 1982,200 5, Oracle. all rights reserved. connect to the target database: DG (DBID = 1686618574) RMAN> connect auxiliary sys/password @ DGS connected to the secondary Database: DGC (not loaded) RMAN> duplicate target database to dgc;Start Duplicate Db from month 31 to Month 12. Use the target database control file to replace ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: sid = 155 devtype = DISK memory script content: {set until scn 526998; set newname for datafile 1 to "/u01/app/oracle/oradata/dgc/system01.dbf "; set newname for datafile 2 to "/u01/app/oracle/oradata/dgc/undotbs01.dbf "; set newname for datafile 3 to "/u01/app/oracle/oradata/dgc/sysaux01.dbf "; set newname for datafile 4 to "/u01/app/oracle/oradata/dgc/users01.dbf"; restore check readonly clone database;} is executing the memory script and executing the command: SET until clause is executing the command: set newname starts restore on month 31-12 using the channel ORA_AUX_DISK_1 ORA_AUX_DISK_1: restoring the data file backup set channel ORA_AUX_DISK_1: the data file that is being restored from the backup set is being restored to/u01/app/oracle/oradata/dgc/system01.dbf restoring data file 00001 to/u01/app/oracle/oradata /dgc/undotbs01.dbf is restoring data file 00003 to/u01/app/oracle/oradata/dgc/sysaux01.dbf is restoring data file 00004 to/u01/app/oracle/oradata/dgc/users01.dbf channel ORA_AUX_DISK_1: reading the backup segment/home/oracle/all_DG_2.bak channel ORA_AUX_DISK_1: recovered backup segment 1 handle =/home/oracle/all_DG_2.bak mark = TAG20120125T110557 channel ORA_AUX_DISK_1: The restoration is completed. Time: at 00:00:54, the restore statement from month 1 to Month 12 was completed: create controlfile reuse set database "DGC" resetlogs archivelog maxlogfiles 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 logfile group 1 ('/u01/app/oracle/oradata/dgc/redo01.log ') SIZE 50 m reuse, GROUP 2 ('/u01/app/oracle/oradata/dgc/redo02.log') SIZE 50 m reuse, GROUP 3 ('/u01/app/oracle/oradata/dgc/redo03.log ') SIZE 50 m reuse datafile '/u01/app/oracle/oradata/dgc/system01.dbf' character set ZHS16GBK memory script content: {switch clone datafile all ;} channel for executing memory script release: ORA_AUX_DISK_1 data file 2 has been converted to a data file copy input data file copy recid = 1 stamp = 773487060 file name =/u01/app/oracle/oradata/dgc/undotbs01.dbf data file 3 has been converted to a data file copy input data file copy recid = 2 stamp = 773487060 file name =/u01/app/oracle/oradata/dgc/sysaux01.dbf data file 4 has been converted to data file copy input data file copy recid = 3 stamp = 773487060 file name =/u01/app/oracle/oradata/dgc/users01.dbf memory script content: {set until scn 526998; recover clone database delete archivelog;} executing memory script Executing command: SET until clause starting the channel allocated by recover from month 1 to Month 12: ORA_AUX_DISK_1 ORA_AUX_DISK_1: sid = 155 devtype = DISK is starting to restore the archive log thread 1 Series 14 files/u01/app/oracle/flash_recovery_area/DGP/archivelog/2012_01_25/o1_mf_1_14_7kywg5q6 _. the arc exists on the disk. The archived log file name is =/u01/app/oracle/flash_recovery_area/DGP/archivelog/2012_01_25/o1_mf_1_14_7kywg5q6 _. arc thread = 1 sequence = 14 media Recovery completed, time: 00:00:01 completed recover at 31-1 month-12

1 2 Next Page