Home » RDBMS Server » Backup & Recovery » RMAN-06023
RMAN-06023 [message #74576] Sun, 09 January 2005 23:48 Go to next message
arun
Messages: 67
Registered: January 2000
Member
Not sure what it is saying, any help is appreciated. Thanks

RMAN> run
2> {
3> allocate auxiliary channel c1 type disk;
4> DUPLICATE TARGET DATABASE TO IFMOON
5> logfile
6> '/u50/app/oradata/IFMOON/redo01_1.log' size 6M REUSE,
7> '/u50/app/oradata/IFMOON/redo01_2.log' size 6M REUSE
8> NOFILENAMECHECK;
9> }

allocated channel: c1
channel c1: sid=10 devtype=DISK

Starting Duplicate Db at 10-JAN-05

printing stored script: Memory Script
{
set newname for datafile 1 to
"/u40/app/oradata/IFDEVL11i/system01.dbf";
set newname for datafile 2 to
"/u40/app/oradata/IFDEVL11i/temp03.dbf";
set newname for datafile 3 to
"/u40/app/oradata/IFDEVL11i/temp02.dbf";
set newname for datafile 4 to
"/u40/app/oradata/IFDEVL11i/tools01.dbf";
set newname for datafile 5 to
"/u40/app/oradata/IFDEVL11i/users01.dbf";
set newname for datafile 6 to
"/u40/app/oradata/IFDEVL11i/gegeid01.dbf";
set newname for datafile 7 to
"/u40/app/oradata/IFDEVL11i/gegeix01.dbf";
set newname for datafile 8 to
"/u40/app/oradata/IFDEVL11i/data01.dbf";
set newname for datafile 9 to
"/u40/app/oradata/IFDEVL11i/data02.dbf";
set newname for datafile 10 to
"/u40/app/oradata/IFDEVL11i/gegeix02.dbf";
set newname for datafile 11 to
"/u40/app/oradata/IFDEVL11i/gegeid02.dbf";
set newname for datafile 13 to
"/u40/app/oradata/IFDEVL11i/temp01.dbf";
set newname for datafile 15 to
"/u40/app/oradata/IFDEVL11i/undo01.dbf";
restore
check readonly
clone database
;
}
executing script: Memory Script

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

executing command: SET NEWNAME

Starting restore at 10-JAN-05

released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/10/2005 04:44:58
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 15 found to restore
RMAN-06023: no backup or copy of datafile 13 found to restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>
Re: RMAN-06023 [message #74581 is a reply to message #74576] Mon, 10 January 2005 04:11 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
RMAN is not finding all the necessary thingies it need to do the duplication.
Most likely it would be archived logs( assuming you have backed up the datafiles already and it is valid).

During backup, did you backup your archived logs also?
Previous Topic: RMAN-01005
Next Topic: rman backups scheduling in unix
Goto Forum:
  


Current Time: Sun Dec 22 22:22:28 CST 2024