SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 10 14:58:44 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL> Connected. SQL> System altered. SQL> alter system archive log all * ERROR at line 1: ORA-00271: there are no logs that need archiving SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option JServer Release 8.1.7.2.0 - Production SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 10 14:58:45 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL> Connected. SQL> System altered. SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option JServer Release 8.1.7.2.0 - Production Recovery Manager: Release 8.1.7.2.0 - Production RMAN> RMAN-06005: connected to target database: TEST2 (DBID=536102344) RMAN> RMAN-06008: connected to recovery catalog database RMAN> 2> 3> 4> 5> RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=12 devtype=DISK RMAN-03022: compiling command: backup RMAN-03025: performing implicit partial resync of recovery catalog RMAN-03023: executing command: partial resync RMAN-08003: starting partial resync of recovery catalog RMAN-08005: partial resync complete RMAN-03023: executing command: backup RMAN-08009: channel d1: starting archivelog backupset RMAN-08502: set_count=101 set_stamp=458837934 creation_time=10-APR-2002 14:58:54 RMAN-08014: channel d1: specifying archivelog(s) in backup set RMAN-08504: input archivelog thread=1 sequence=55 recid=117 stamp=458834650 RMAN-08504: input archivelog thread=1 sequence=56 recid=118 stamp=458834661 RMAN-08504: input archivelog thread=1 sequence=57 recid=119 stamp=458834674 RMAN-08504: input archivelog thread=1 sequence=58 recid=120 stamp=458834920 RMAN-08504: input archivelog thread=1 sequence=59 recid=121 stamp=458835186 RMAN-08504: input archivelog thread=1 sequence=60 recid=122 stamp=458835187 RMAN-08504: input archivelog thread=1 sequence=61 recid=123 stamp=458835199 RMAN-08504: input archivelog thread=1 sequence=62 recid=124 stamp=458835214 RMAN-08504: input archivelog thread=1 sequence=63 recid=125 stamp=458837702 RMAN-08504: input archivelog thread=1 sequence=64 recid=126 stamp=458837702 RMAN-08504: input archivelog thread=1 sequence=65 recid=127 stamp=458837714 RMAN-08504: input archivelog thread=1 sequence=66 recid=128 stamp=458837727 RMAN-08504: input archivelog thread=1 sequence=67 recid=129 stamp=458837925 RMAN-08504: input archivelog thread=1 sequence=68 recid=130 stamp=458837927 RMAN-08013: channel d1: piece 1 created RMAN-08503: piece handle=/data/oracle8/BACKUP/rman_ARC_101_1_458837934.bus comment=NONE RMAN-08525: backup set complete, elapsed time: 00:00:02 RMAN-03023: executing command: partial resync RMAN-08003: starting partial resync of recovery catalog RMAN-08005: partial resync complete RMAN-08031: released channel: d1 RMAN> Recovery Manager complete. SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 10 14:58:59 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL> Connected. SQL> System altered. SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option JServer Release 8.1.7.2.0 - Production SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 10 14:59:00 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL> Connected. SQL> ORACLE instance shut down. SQL> ORACLE instance started. Total System Global Area 74919828 bytes Fixed Size 73620 bytes Variable Size 33808384 bytes Database Buffers 40960000 bytes Redo Buffers 77824 bytes SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option JServer Release 8.1.7.2.0 - Production Recovery Manager: Release 8.1.7.2.0 - Production RMAN> RMAN-06005: connected to target database: TEST2 (DBID=536102344) RMAN> RMAN-06008: connected to recovery catalog database RMAN> RMAN-06020: connected to auxiliary database RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> RMAN-03022: compiling command: resync RMAN-03023: executing command: resync RMAN-08002: starting full resync of recovery catalog RMAN-08004: full resync complete RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d1 RMAN-08500: channel d1: sid=11 devtype=DISK RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: d2 RMAN-08500: channel d2: sid=12 devtype=DISK RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: sql RMAN-06162: sql statement: alter system switch logfile RMAN-03023: executing command: sql RMAN-03022: compiling command: Duplicate Db RMAN-03027: printing stored script: Memory Script { set until scn 281474976710655; set newname for datafile 1 to "/data/oracle8/TEST3/systemTEST3.dbf"; set newname for datafile 2 to "/data/oracle8/TEST3/rbsTEST3.dbf"; set newname for datafile 3 to "/data/oracle8/TEST3/tempTEST3.dbf"; set newname for datafile 4 to "/data/oracle8/TEST3/dataTEST3.dbf"; restore check readonly clone database ; } RMAN-03021: executing script: Memory Script RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: restore RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel d2: starting datafile backupset restore RMAN-08502: set_count=99 set_stamp=458837826 creation_time=10-APR-2002 14:57:06 RMAN-08089: channel d2: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 00003 to /data/oracle8/TEST3/tempTEST3.dbf RMAN-08016: channel d1: starting datafile backupset restore RMAN-08502: set_count=98 set_stamp=458837819 creation_time=10-APR-2002 14:56:59 RMAN-08089: channel d1: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 00002 to /data/oracle8/TEST3/rbsTEST3.dbf RMAN-08523: restoring datafile 00004 to /data/oracle8/TEST3/dataTEST3.dbf RMAN-08023: channel d2: restored backup piece 1 RMAN-08511: piece handle=/data/oracle8/BACKUP/rman_BACKUP_TEST2_458837826.1.99.1.TEST2xxx.33dlijq2.bus tag=BACKUP_1 params=NULL RMAN-08024: channel d2: restore complete RMAN-08023: channel d1: restored backup piece 1 RMAN-08511: piece handle=/data/oracle8/BACKUP/rman_BACKUP_TEST2_458837819.1.98.1.TEST2xxx.32dlijpr.bus tag=BACKUP_1 params=NULL RMAN-08024: channel d1: restore complete RMAN-08016: channel d2: starting datafile backupset restore RMAN-08502: set_count=100 set_stamp=458837834 creation_time=10-APR-2002 14:57:14 RMAN-08089: channel d2: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 00001 to /data/oracle8/TEST3/systemTEST3.dbf RMAN-08023: channel d2: restored backup piece 1 RMAN-08511: piece handle=/data/oracle8/BACKUP/rman_BACKUP_TEST2_458837834.1.100.1.TEST2xxx.34dlijqa.bus tag=BACKUP_1 params=NULL RMAN-08024: channel d2: restore complete RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "test3" RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 30 MAXINSTANCES 8 MAXLOGHISTORY 907 LOGFILE GROUP 1 '/data/oracle8/TEST3/redoTEST301.log' SIZE 1048576 , GROUP 2 '/data/oracle8/TEST3/redoTEST302.log' SIZE 1048576 , GROUP 3 '/data/oracle8/TEST3/redoTEST303.log' SIZE 1048576 DATAFILE '/data/oracle8/TEST3/systemTEST3.dbf' CHARACTER SET WE8ISO8859P1 RMAN-03027: printing stored script: Memory Script { switch clone datafile all; } RMAN-03021: executing script: Memory Script RMAN-03022: compiling command: switch RMAN-03023: executing command: switch RMAN-08015: datafile 2 switched to datafile copy RMAN-08507: input datafilecopy recid=1 stamp=458838010 filename=/data/oracle8/TEST3/rbsTEST3.dbf RMAN-08015: datafile 3 switched to datafile copy RMAN-08507: input datafilecopy recid=2 stamp=458838010 filename=/data/oracle8/TEST3/tempTEST3.dbf RMAN-08015: datafile 4 switched to datafile copy RMAN-08507: input datafilecopy recid=3 stamp=458838011 filename=/data/oracle8/TEST3/dataTEST3.dbf RMAN-03027: printing stored script: Memory Script { set until scn 281474976710655; recover clone database check readonly ; } RMAN-03021: executing script: Memory Script RMAN-03022: compiling command: set RMAN-03022: compiling command: recover RMAN-03022: compiling command: recover(1) RMAN-03022: compiling command: recover(2) RMAN-03022: compiling command: recover(3) RMAN-03023: executing command: recover(3) RMAN-08054: starting media recovery RMAN-03022: compiling command: recover(4) RMAN-06050: archivelog thread 1 sequence 67 is already on disk as file /appl/oracle8/admin/TEST2/arch/arch.log1_67.dbf RMAN-06050: archivelog thread 1 sequence 68 is already on disk as file /appl/oracle8/admin/TEST2/arch/arch.log1_68.dbf RMAN-06050: archivelog thread 1 sequence 69 is already on disk as file /appl/oracle8/admin/TEST2/arch/arch.log1_69.dbf RMAN-03023: executing command: recover(4) RMAN-08515: archivelog filename=/appl/oracle8/admin/TEST2/arch/arch.log1_67.dbf thread=1 sequence=67 RMAN-08515: archivelog filename=/appl/oracle8/admin/TEST2/arch/arch.log1_68.dbf thread=1 sequence=68 RMAN-08515: archivelog filename=/appl/oracle8/admin/TEST2/arch/arch.log1_69.dbf thread=1 sequence=69 RMAN-08060: unable to find archivelog RMAN-08510: archivelog thread=1 sequence=70 RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: d1 RMAN-08031: released channel: d2 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure during compilation of command RMAN-03013: command type: Duplicate Db RMAN-03015: error occurred in stored script Memory Script RMAN-03002: failure during compilation of command RMAN-03013: command type: recover RMAN-03006: non-retryable error occurred during execution of command: recover(4) RMAN-07004: unhandled exception during command execution on channel clone_default RMAN-20000: abnormal termination of job step RMAN-06054: media recovery requesting unknown log: thread 1 scn 508128341 RMAN> Recovery Manager complete.