Hi All,
Wanted some opinions/advice on a problem I'm having. My goal is to have a nice easy script (that I can give to an inexperienced DBA) that copies a prod database to DEV. I've been googling around and found similar problems but noe seem to apply to me, and the procedures given seem to be missing things...The details are:
10.2.0.4 on both sides. Prod is in archivelogmode. Backups run to tape normally but since we have no netbackup license for DEV I'm doing a special backup to disk. Backup script is:
export ORACLE_HOME=/u01/app/oracle/product/10.2
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=PLTPRD01
rman nocatalog target=sys/prodpw@PLTPRD01 log=/home/oracle/logs/full_rman_to_disk.log <<-EOF
configure backup optimization on;
configure default device type to disk;
configure device type disk parallelism 1 backup type to compressed backupset;
configure datafile backup copies for device type disk to 1;
configure maxsetsize to unlimited;
run {
allocate channel ch1 type Disk maxpiecesize = 1900M;
allocate channel ch2 type Disk maxpiecesize = 1900M;
allocate channel ch3 type Disk maxpiecesize = 1900M;
allocate channel ch4 type Disk maxpiecesize = 1900M;
allocate channel ch5 type Disk maxpiecesize = 1900M;
allocate channel ch6 type Disk maxpiecesize = 1900M;
backup full database noexclude
include current controlfile
format '/u10/PLTPRD01/backup/datafile_%s_%p.bak'
tag 'datafile_daily';
}
run {
allocate channel ch1 type Disk maxpiecesize = 1900M;
allocate channel ch2 type Disk maxpiecesize = 1900M;
backup archivelog all
format '/u10/PLTPRD01/backup/archivelog_%s_%p.bak'
tag 'archivelog_daily';
}
run {
allocate channel ch1 type Disk maxpiecesize = 1900M;
backup format '/u10/PLTPRD01/backup/controlfile_%s.bak' current controlfile;
}
quit
EOF
That gives me the following files:
-rwxrwSrwt 1 oracle dba 494244352 Dec 6 01:43 archivelog_6007_1.bak
-rwxrwSrwt 1 oracle dba 373885952 Dec 6 01:42 archivelog_6008_1.bak
-rwxrwSrwt 1 oracle dba 2048000 Dec 6 01:43 controlfile_6010.bak
-rwxrwSrwt 1 oracle dba 1990311936 Dec 6 00:54 datafile_5999_1.bak
-rwxrwSrwt 1 oracle dba 1990213632 Dec 6 01:15 datafile_5999_2.bak
-rwxrwSrwt 1 oracle dba 1990303744 Dec 6 01:35 datafile_5999_3.bak
-rwxrwSrwt 1 oracle dba 388759552 Dec 6 01:39 datafile_5999_4.bak
-rwxrwSrwt 1 oracle dba 1990254592 Dec 6 00:51 datafile_6000_1.bak
-rwxrwSrwt 1 oracle dba 1990287360 Dec 6 01:12 datafile_6000_2.bak
-rwxrwSrwt 1 oracle dba 1990328320 Dec 6 01:33 datafile_6000_3.bak
-rwxrwSrwt 1 oracle dba 567746560 Dec 6 01:38 datafile_6000_4.bak
-rwxrwSrwt 1 oracle dba 1990213632 Dec 6 00:52 datafile_6001_1.bak
-rwxrwSrwt 1 oracle dba 1990221824 Dec 6 01:13 datafile_6001_2.bak
-rwxrwSrwt 1 oracle dba 1990336512 Dec 6 01:36 datafile_6001_3.bak
-rwxrwSrwt 1 oracle dba 60645376 Dec 6 01:37 datafile_6001_4.bak
-rwxrwSrwt 1 oracle dba 1990230016 Dec 6 00:52 datafile_6002_1.bak
-rwxrwSrwt 1 oracle dba 1990344704 Dec 6 01:12 datafile_6002_2.bak
-rwxrwSrwt 1 oracle dba 1990311936 Dec 6 01:32 datafile_6002_3.bak
-rwxrwSrwt 1 oracle dba 233996288 Dec 6 01:34 datafile_6002_4.bak
-rwxrwSrwt 1 oracle dba 1371709440 Dec 6 00:45 datafile_6003_1.bak
-rwxrwSrwt 1 oracle dba 1990361088 Dec 6 00:50 datafile_6004_1.bak
-rwxrwSrwt 1 oracle dba 1990230016 Dec 6 01:11 datafile_6004_2.bak
-rwxrwSrwt 1 oracle dba 1990230016 Dec 6 01:31 datafile_6004_3.bak
-rwxrwSrwt 1 oracle dba 713326592 Dec 6 01:38 datafile_6004_4.bak
-rwxrwSrwt 1 oracle dba 2048000 Dec 6 00:45 datafile_6005_1.bak
So, I move over to the target server and database (UAT in this case) and run a restore using those files. But, it won't restore the archlog files and gives the old "RMAN-06102: no channel to restore a backup or copy of log thread" error. I can recover by copying over the relevant archlogs and doing a "recover using backup controlfile until cancel", but I wondered why the restore didn't recover automatically for me? The restore is as follows:
rman nocatalog target sys/prodpw@PLTPRD01 AUXILIARY sys/UATpw@UAT cmdfile='/home/oracle/scripts/oracle/duplicate_database.rman' log=/home/oracle/logs/UAT_restore_201112080930.log
(script is)
RUN
{
ALLOCATE AUXILIARY CHANNEL aux1 TYPE DISK FORMAT '/u10/PLTPRD01/backup/datafile_%s_%p.bak';
ALLOCATE AUXILIARY CHANNEL aux2 TYPE DISK FORMAT '/u10/PLTPRD01/backup/datafile_%s_%p.bak';
ALLOCATE AUXILIARY CHANNEL aux3 TYPE DISK FORMAT '/u10/PLTPRD01/backup/datafile_%s_%p.bak';
ALLOCATE AUXILIARY CHANNEL aux4 TYPE DISK FORMAT '/u10/PLTPRD01/backup/datafile_%s_%p.bak';
ALLOCATE AUXILIARY CHANNEL aux5 TYPE DISK FORMAT '/u10/PLTPRD01/backup/datafile_%s_%p.bak';
ALLOCATE AUXILIARY CHANNEL aux6 TYPE DISK FORMAT '/u10/PLTPRD01/backup/datafile_%s_%p.bak';
ALLOCATE AUXILIARY CHANNEL aux7 TYPE DISK FORMAT '/u10/PLTPRD01/backup/archivelog_%s_%p.bak';
SET NEWNAME FOR DATAFILE 1 TO '/u07/oradata/UAT/system01.dbf';
SET NEWNAME FOR DATAFILE 2 TO '/u07/oradata/UAT/undotbs01.dbf';
SET NEWNAME FOR DATAFILE 3 TO '/u07/oradata/UAT/sysaux01.dbf';
SET NEWNAME FOR DATAFILE 4 TO '/u07/oradata/UAT/users01.dbf';
SET NEWNAME FOR DATAFILE 5 TO '/u07/oradata/UAT/bidata_index.dbf';
SET NEWNAME FOR DATAFILE 6 TO '/u07/oradata/UAT/bistage_constraint.dbf';
SET NEWNAME FOR DATAFILE 7 TO '/u07/oradata/UAT/bistage_data.dbf';
SET NEWNAME FOR DATAFILE 8 TO '/u07/oradata/UAT/bistage_index.dbf';
SET NEWNAME FOR DATAFILE 9 TO '/u07/oradata/UAT/bss_constraint.dbf';
SET NEWNAME FOR DATAFILE 10 TO '/u07/oradata/UAT/bss_data.dbf';
SET NEWNAME FOR DATAFILE 11 TO '/u07/oradata/UAT/bss_index.dbf';
SET NEWNAME FOR DATAFILE 12 TO '/u07/oradata/UAT/bussrules_constraint.dbf';
SET NEWNAME FOR DATAFILE 13 TO '/u07/oradata/UAT/bussrules_data.dbf';
SET NEWNAME FOR DATAFILE 14 TO '/u07/oradata/UAT/bussrules_index.dbf';
(plus lots more lines of datafile mappings)
SET NEWNAME FOR TEMPFILE 1 TO '/u07/oradata/UAT/temp01.dbf';
SET NEWNAME FOR TEMPFILE 2 TO '/u07/oradata/UAT/temp02.dbf';
DUPLICATE TARGET DATABASE TO UAT
PFILE='/u01/app/oracle/product/10.2/dbs/initUAT.ora'
NOFILENAMECHECK
LOGFILE GROUP 1 ('/u03/redo/oradata/UAT/redo1a.dbf',
'/u04/redo/oradata/UAT/redo1b.dbf') SIZE 500M REUSE,
GROUP 2 ('/u03/redo/oradata/UAT/redo2a.dbf',
'/u04/redo/oradata/UAT/redo2b.dbf') SIZE 500M REUSE,
GROUP 3 ('/u03/redo/oradata/UAT/redo3a.dbf',
'/u04/redo/oradata/UAT/redo3b.dbf') SIZE 500M REUSE,
GROUP 4 ('/u03/redo/oradata/UAT/redo4a.dbf',
'/u04/redo/oradata/UAT/redo4b.dbf') SIZE 500M REUSE,
GROUP 5 ('/u03/redo/oradata/UAT/redo5a.dbf',
'/u04/redo/oradata/UAT/redo5b.dbf') SIZE 500M REUSE,
GROUP 6 ('/u03/redo/oradata/UAT/redo6a.dbf',
'/u04/redo/oradata/UAT/redo6b.dbf') SIZE 500M REUSE,
GROUP 7 ('/u03/redo/oradata/UAT/redo7a.dbf',
'/u04/redo/oradata/UAT/redo7b.dbf') SIZE 500M REUSE,
GROUP 8 ('/u03/redo/oradata/UAT/redo8a.dbf',
'/u04/redo/oradata/UAT/redo8b.dbf') SIZE 500M REUSE;
RELEASE CHANNEL aux1;
RELEASE CHANNEL aux2;
RELEASE CHANNEL aux3;
RELEASE CHANNEL aux4;
RELEASE CHANNEL aux5;
RELEASE CHANNEL aux6;
RELEASE CHANNEL aux7;
}
I tried this with and without the aux7 for the archlogs, along with adding a "set until time", but always get the same errors. The logfile is as follows, but truncated (I can put it all in if anyone really wants it):
allocated channel: aux1
channel aux1: sid=155 devtype=DISK
allocated channel: aux2
channel aux2: sid=154 devtype=DISK
allocated channel: aux3
channel aux3: sid=153 devtype=DISK
allocated channel: aux4
channel aux4: sid=152 devtype=DISK
allocated channel: aux5
channel aux5: sid=151 devtype=DISK
allocated channel: aux6
channel aux6: sid=150 devtype=DISK
allocated channel: aux7
channel aux7: sid=149 devtype=DISK
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
(more set newname commands)
Starting Duplicate Db at 08-DEC-11
contents of Memory Script:
{
set until scn 2076483089;
set newname for datafile 1 to
"/u07/oradata/UAT/system01.dbf";
set newname for datafile 2 to
"/u07/oradata/UAT/undotbs01.dbf";
set newname for datafile 3 to
"/u07/oradata/UAT/sysaux01.dbf";
set newname for datafile 4 to
"/u07/oradata/UAT/users01.dbf";
set newname for datafile 5 to
"/u07/oradata/UAT/bidata_index.dbf";
set newname for datafile 6 to
"/u07/oradata/UAT/bistage_constraint.dbf";
(more set newname output)
set newname for datafile 60 to
"/u07/oradata/UAT/ibmslob_data4.dbf";
restore
check readonly
clone database
;
}
executing Memory Script
channel aux1: starting datafile backupset restore
channel aux1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u07/oradata/UAT/system01.dbf
restoring datafile 00002 to /u07/oradata/UAT/undotbs01.dbf
restoring datafile 00005 to /u07/oradata/UAT/bidata_index.dbf
restoring datafile 00008 to /u07/oradata/UAT/bistage_index.dbf
restoring datafile 00016 to /u07/oradata/UAT/customiz_data.dbf
restoring datafile 00020 to /u07/oradata/UAT/galaxybe_data2.dbf
restoring datafile 00023 to /u07/oradata/UAT/galaxydal_data.dbf
restoring datafile 00026 to /u07/oradata/UAT/galaxy_data.dbf
restoring datafile 00029 to /u07/oradata/UAT/ibmsarch_data.dbf
restoring datafile 00037 to /u07/oradata/UAT/ibmstask_constraint.dbf
channel aux1: reading from backup piece /u10/PLTPRD01/backup/datafile_6003_1.bak
channel aux2: starting datafile backupset restore
channel aux2: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /u07/oradata/UAT/users01.dbf
restoring datafile 00007 to /u07/oradata/UAT/bistage_data.dbf
restoring datafile 00015 to /u07/oradata/UAT/customiz_constraint.dbf
restoring datafile 00022 to /u07/oradata/UAT/galaxydal_constraint.dbf
restoring datafile 00028 to /u07/oradata/UAT/ibmsarch_constraint.dbf
restoring datafile 00032 to /u07/oradata/UAT/ibmsaudit_index.dbf
restoring datafile 00035 to /u07/oradata/UAT/ibmsdynm_index.dbf
restoring datafile 00040 to /u07/oradata/UAT/mag_ctl.dbf
restoring datafile 00043 to /u07/oradata/UAT/odyssey_constraint.dbf
restoring datafile 00057 to /u07/oradata/UAT/ibmslob_data1.dbf
channel aux2: reading from backup piece /u10/PLTPRD01/backup/datafile_6002_1.bak
channel aux3: starting datafile backupset restore
channel aux3: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /u07/oradata/UAT/sysaux01.dbf
restoring datafile 00010 to /u07/oradata/UAT/bss_data.dbf
restoring datafile 00011 to /u07/oradata/UAT/bss_index.dbf
restoring datafile 00012 to /u07/oradata/UAT/bussrules_constraint.dbf
restoring datafile 00017 to /u07/oradata/UAT/customiz_index.dbf
restoring datafile 00024 to /u07/oradata/UAT/galaxydal_index.dbf
restoring datafile 00030 to /u07/oradata/UAT/ibmsarch_index.dbf
restoring datafile 00038 to /u07/oradata/UAT/ibmstask_data.dbf
restoring datafile 00041 to /u07/oradata/UAT/mag_data.dbf
restoring datafile 00046 to /u07/oradata/UAT/pilatdba_constraint.dbf
channel aux3: reading from backup piece /u10/PLTPRD01/backup/datafile_6001_1.bak
channel aux4: starting datafile backupset restore
channel aux4: specifying datafile(s) to restore from backup set
restoring datafile 00006 to /u07/oradata/UAT/bistage_constraint.dbf
restoring datafile 00014 to /u07/oradata/UAT/bussrules_index.dbf
restoring datafile 00019 to /u07/oradata/UAT/galaxybe_constraint.dbf
restoring datafile 00021 to /u07/oradata/UAT/galaxybe_index.dbf
restoring datafile 00027 to /u07/oradata/UAT/galaxy_index.dbf
restoring datafile 00034 to /u07/oradata/UAT/ibmsdynm_data.dbf
restoring datafile 00036 to /u07/oradata/UAT/ibmslob_data.dbf
restoring datafile 00044 to /u07/oradata/UAT/odyssey_data.dbf
restoring datafile 00045 to /u07/oradata/UAT/odyssey_index.dbf
restoring datafile 00060 to /u07/oradata/UAT/ibmslob_data4.dbf
channel aux4: reading from backup piece /u10/PLTPRD01/backup/datafile_6004_1.bak
channel aux5: starting datafile backupset restore
channel aux5: specifying datafile(s) to restore from backup set
restoring datafile 00009 to /u07/oradata/UAT/bss_constraint.dbf
restoring datafile 00013 to /u07/oradata/UAT/bussrules_data.dbf
restoring datafile 00018 to /u07/oradata/UAT/dbcc_repos.dbf
restoring datafile 00025 to /u07/oradata/UAT/galaxy_constraint.dbf
restoring datafile 00033 to /u07/oradata/UAT/ibmsdynm_constraint.dbf
restoring datafile 00039 to /u07/oradata/UAT/ibmstask_index.dbf
restoring datafile 00042 to /u07/oradata/UAT/mag_index.dbf
restoring datafile 00048 to /u07/oradata/UAT/pilatdba_index.dbf
restoring datafile 00050 to /u07/oradata/UAT/ratings_data.dbf
restoring datafile 00058 to /u07/oradata/UAT/ibmslob_data2.dbf
channel aux5: reading from backup piece /u10/PLTPRD01/backup/datafile_6000_1.bak
channel aux6: starting datafile backupset restore
channel aux6: specifying datafile(s) to restore from backup set
restoring datafile 00031 to /u07/oradata/UAT/ibmsaudit_data.dbf
restoring datafile 00047 to /u07/oradata/UAT/pilatdba_data.dbf
restoring datafile 00049 to /u07/oradata/UAT/ratings_constraint.dbf
restoring datafile 00051 to /u07/oradata/UAT/ratings_index.dbf
restoring datafile 00052 to /u07/oradata/UAT/tools.dbf
restoring datafile 00053 to /u07/oradata/UAT/undotbs02.dbf
restoring datafile 00054 to /u07/oradata/UAT/workflow_constraint.dbf
restoring datafile 00055 to /u07/oradata/UAT/workflow_data.dbf
restoring datafile 00056 to /u07/oradata/UAT/workflow_index.dbf
restoring datafile 00059 to /u07/oradata/UAT/ibmslob_data3.dbf
channel aux6: reading from backup piece /u10/PLTPRD01/backup/datafile_5999_1.bak
channel aux4: restored backup piece 1
piece handle=/u10/PLTPRD01/backup/datafile_6004_1.bak tag=DATAFILE_DAILY
channel aux4: reading from backup piece /u10/PLTPRD01/backup/datafile_6004_2.bak
channel aux2: restored backup piece 1
piece handle=/u10/PLTPRD01/backup/datafile_6002_1.bak tag=DATAFILE_DAILY
channel aux2: reading from backup piece /u10/PLTPRD01/backup/datafile_6002_2.bak
channel aux3: restored backup piece 1
piece handle=/u10/PLTPRD01/backup/datafile_6001_1.bak tag=DATAFILE_DAILY
channel aux3: reading from backup piece /u10/PLTPRD01/backup/datafile_6001_2.bak
channel aux5: restored backup piece 1
piece handle=/u10/PLTPRD01/backup/datafile_6000_1.bak tag=DATAFILE_DAILY
channel aux5: reading from backup piece /u10/PLTPRD01/backup/datafile_6000_2.bak
channel aux6: restored backup piece 1
piece handle=/u10/PLTPRD01/backup/datafile_5999_1.bak tag=DATAFILE_DAILY
channel aux6: reading from backup piece /u10/PLTPRD01/backup/datafile_5999_2.bak
channel aux1: restored backup piece 1
piece handle=/u10/PLTPRD01/backup/datafile_6003_1.bak tag=DATAFILE_DAILY
channel aux1: restore complete, elapsed time: 01:48:13
channel aux4: restored backup piece 2
piece handle=/u10/PLTPRD01/backup/datafile_6004_2.bak tag=DATAFILE_DAILY
channel aux4: reading from backup piece /u10/PLTPRD01/backup/datafile_6004_3.bak
channel aux3: restored backup piece 2
piece handle=/u10/PLTPRD01/backup/datafile_6001_2.bak tag=DATAFILE_DAILY
channel aux3: reading from backup piece /u10/PLTPRD01/backup/datafile_6001_3.bak
channel aux5: restored backup piece 2
piece handle=/u10/PLTPRD01/backup/datafile_6000_2.bak tag=DATAFILE_DAILY
channel aux5: reading from backup piece /u10/PLTPRD01/backup/datafile_6000_3.bak
channel aux6: restored backup piece 2
piece handle=/u10/PLTPRD01/backup/datafile_5999_2.bak tag=DATAFILE_DAILY
channel aux6: reading from backup piece /u10/PLTPRD01/backup/datafile_5999_3.bak
channel aux2: restored backup piece 2
piece handle=/u10/PLTPRD01/backup/datafile_6002_2.bak tag=DATAFILE_DAILY
channel aux2: reading from backup piece /u10/PLTPRD01/backup/datafile_6002_3.bak
channel aux4: restored backup piece 3
piece handle=/u10/PLTPRD01/backup/datafile_6004_3.bak tag=DATAFILE_DAILY
channel aux4: reading from backup piece /u10/PLTPRD01/backup/datafile_6004_4.bak
channel aux5: restored backup piece 3
piece handle=/u10/PLTPRD01/backup/datafile_6000_3.bak tag=DATAFILE_DAILY
channel aux5: reading from backup piece /u10/PLTPRD01/backup/datafile_6000_4.bak
channel aux4: restored backup piece 4
piece handle=/u10/PLTPRD01/backup/datafile_6004_4.bak tag=DATAFILE_DAILY
channel aux4: restore complete, elapsed time: 02:49:24
channel aux2: restored backup piece 3
piece handle=/u10/PLTPRD01/backup/datafile_6002_3.bak tag=DATAFILE_DAILY
channel aux2: reading from backup piece /u10/PLTPRD01/backup/datafile_6002_4.bak
channel aux3: restored backup piece 3
piece handle=/u10/PLTPRD01/backup/datafile_6001_3.bak tag=DATAFILE_DAILY
channel aux3: reading from backup piece /u10/PLTPRD01/backup/datafile_6001_4.bak
channel aux6: restored backup piece 3
piece handle=/u10/PLTPRD01/backup/datafile_5999_3.bak tag=DATAFILE_DAILY
channel aux6: reading from backup piece /u10/PLTPRD01/backup/datafile_5999_4.bak
channel aux3: restored backup piece 4
piece handle=/u10/PLTPRD01/backup/datafile_6001_4.bak tag=DATAFILE_DAILY
channel aux3: restore complete, elapsed time: 02:57:18
channel aux2: restored backup piece 4
piece handle=/u10/PLTPRD01/backup/datafile_6002_4.bak tag=DATAFILE_DAILY
channel aux2: restore complete, elapsed time: 02:57:20
channel aux5: restored backup piece 4
piece handle=/u10/PLTPRD01/backup/datafile_6000_4.bak tag=DATAFILE_DAILY
channel aux5: restore complete, elapsed time: 02:57:45
channel aux6: restored backup piece 4
piece handle=/u10/PLTPRD01/backup/datafile_5999_4.bak tag=DATAFILE_DAILY
channel aux6: restore complete, elapsed time: 02:58:50
Finished restore at 08-DEC-11
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "UAT" RESETLOGS ARCHIVELOG
MAXLOGFILES 48
MAXLOGMEMBERS 3
MAXDATAFILES 400
MAXINSTANCES 8
MAXLOGHISTORY 4674
LOGFILE
GROUP 1 ( '/u03/redo/oradata/UAT/redo1a.dbf', '/u04/redo/oradata/UAT/redo1b.dbf' ) SIZE 500 M REUSE,
GROUP 2 ( '/u03/redo/oradata/UAT/redo2a.dbf', '/u04/redo/oradata/UAT/redo2b.dbf' ) SIZE 500 M REUSE,
GROUP 3 ( '/u03/redo/oradata/UAT/redo3a.dbf', '/u04/redo/oradata/UAT/redo3b.dbf' ) SIZE 500 M REUSE,
GROUP 4 ( '/u03/redo/oradata/UAT/redo4a.dbf', '/u04/redo/oradata/UAT/redo4b.dbf' ) SIZE 500 M REUSE,
GROUP 5 ( '/u03/redo/oradata/UAT/redo5a.dbf', '/u04/redo/oradata/UAT/redo5b.dbf' ) SIZE 500 M REUSE,
GROUP 6 ( '/u03/redo/oradata/UAT/redo6a.dbf', '/u04/redo/oradata/UAT/redo6b.dbf' ) SIZE 500 M REUSE,
GROUP 7 ( '/u03/redo/oradata/UAT/redo7a.dbf', '/u04/redo/oradata/UAT/redo7b.dbf' ) SIZE 500 M REUSE,
GROUP 8 ( '/u03/redo/oradata/UAT/redo8a.dbf', '/u04/redo/oradata/UAT/redo8b.dbf' ) SIZE 500 M REUSE
DATAFILE
'/u07/oradata/UAT/system01.dbf'
CHARACTER SET UTF8
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=769350658 filename=/u07/oradata/UAT/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=769350658 filename=/u07/oradata/UAT/sysaux01.dbf
datafile 4 switched to datafile copy
(etc)
datafile 60 switched to datafile copy
input datafile copy recid=59 stamp=769350674 filename=/u07/oradata/UAT/ibmslob_data4.dbf
contents of Memory Script:
{
set until scn 2076483089;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 08-DEC-11
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u07/oradata/UAT/system01.dbf'
released channel: aux1
released channel: aux2
released channel: aux3
released channel: aux4
released channel: aux5
released channel: aux6
released channel: aux7
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/08/2011 12:31:54
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 101913 lowscn 2076390043
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 101912 lowscn 2076281132
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 101911 lowscn 2076093182
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 101910 lowscn 2076023375
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 101909 lowscn 2075932322
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 101908 lowscn 2075932310
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 101907 lowscn 2075896928
(more no channel errors)
Recovery Manager complete.
Thoughts? Ideas? I'm thinking the backup script is wrong somehow.