OraFAQ Forum: Backup & Recovery » Restore error RMAN-03015,RMAN-06026,RMAN-06023

Home » RDBMS Server » Backup & Recovery » Restore error RMAN-03015,RMAN-06026,RMAN-06023 (OS: Solaris, Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331278]

Wed, 02 July 2008 18:41

Erdenejargal
Messages: 18
Registered: July 2008

Junior Member

Hi guys,

I restored my DB.

But there is following error occurred.
My file size is okay.
Owner is okay.
time is okay.

How to fix that?

RMAN> DUPLICATE TARGET DATABASE TO test until TIME "TO_DATE('22/06/08 20:05:16','DD/MM/YY hh24:mi:ss')"
LOGFILE
'/oradata/test/redo01a.log' SIZE 100M,
'/oradata/test/redo02a.log' SIZE 100M,
'/oradata/test/redo03a.log' SIZE 100M;
2> 3> 4> 5>
Starting Duplicate Db at 03-JUL-08
using channel ORA_AUX_DISK_1

printing stored script: Memory Script
{
set until scn 39607167;
set newname for datafile 1 to
"/oradata/test/system01.dbf";
...
restore
check readonly
clone database
;
}
executing script: Memory Script

executing command: SET until clause

...

executing command: SET NEWNAME

Starting restore at 03-JUL-08

using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/03/2008 07:32:35
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 30 found to restore
RMAN-06023: no backup or copy of datafile 29 found to restore
RMAN-06023: no backup or copy of datafile 28 found to restore
RMAN-06023: no backup or copy of datafile 26 found to restore
RMAN-06023: no backup or copy of datafile 25 found to restore
RMAN-06023: no backup or copy of datafile 24 found to restore
RMAN-06023: no backup or copy of datafile 23 found to restore
RMAN-06023: no backup or copy of datafile 22 found to restore
RMAN-06023: no backup or copy of datafile 21 found to restore
RMAN-06023: no backup or copy of datafile 20 found to restore
RMAN-06023: no backup or copy of datafile 19 found to restore
RMAN-06023: no backup or copy of datafile 18 found to restore
RMAN-06023: no backup or copy of datafile 17 found to restore
RMAN-06023: no backup or copy of datafile 16 found to restore
RMAN-06023: no backup or copy of datafile 15 found to restore
RMAN-06023: no backup or copy of datafile 14 found to restore
RMAN-06023: no backup or copy of datafile 13 found to restore
RMAN-06023: no backup or copy of datafile 12 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

BR,
Erdenejargal.B

Report message to a moderator

Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331280 is a reply to message #331278]

Wed, 02 July 2008 19:29

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Are you sure the time is correct? Did you backup the archivelogs with the database backup? If not, then archive the current log and then backup the archivelogs and try the duplicate again.

Report message to a moderator

Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331281 is a reply to message #331278]

Wed, 02 July 2008 19:39

Erdenejargal
Messages: 18
Registered: July 2008

Junior Member

Yes,
I'm sure the time is correct.
I checked many times.

I read following information from http://www.cis.unisa.edu.au/oracle/server.101/b10734/rcmtroub.htm

Duplication Fails with Multiple RMAN-06023 Errors: Scenario
In this scenario, you back up the database, then run the DUPLICATE command. You receive the following error stack:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/04/2001 13:55:11
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 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
Duplication Fails with Multiple RMAN-06023 Errors: Diagnosis
The DUPLICATE command recovers to archived redo logs, but cannot recover into online redo logs. Thus, if the restored backup cannot be made consistent without applying the online redo logs, then duplication fails with RMAN-06023 errors because RMAN is looking for backups created before the most recent archived log.

Duplication Fails with Multiple RMAN-06023 Errors: Solution
After backing up the source database, archive and back up the current redo log:

RMAN> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
RMAN> BACKUP ARCHIVELOG ALL;

This archives all records in the online redo logs so that RMAN can now recover the backup by applying the most recent archived redo log.

And I executed following commands:

RMAN> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
RMAN> BACKUP ARCHIVELOG ALL;
RMAN> DUPLICATE TARGET DATABASE TO test until TIME "TO_DATE('22/06/08 20:05:16','DD/MM/YY hh24:mi:ss')"
LOGFILE
'/oradata/test/redo01a.log' SIZE 100M REUSE,
'/oradata/test/redo02a.log' SIZE 100M REUSE,
'/oradata/test/redo03a.log' SIZE 100M REUSE;

But error messages are still appeared.

I don't know what step is wrong?

BR,
Erdenejargal

Report message to a moderator

Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331283 is a reply to message #331278]

Wed, 02 July 2008 21:38

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Erdenejargal wrote on Wed, 02 July 2008 19:41

I restored my DB.

What exactly do you mean by this?

What is the output of list backup ?

Report message to a moderator

Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331287 is a reply to message #331278]

Wed, 02 July 2008 21:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>RMAN-03002: failure of Duplicate Db command at 09/04/2001 13:55:11
2001 ??????
Somebody or something seems very confused.

Report message to a moderator

Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331334 is a reply to message #331287]

Thu, 03 July 2008 01:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Quote:

>RMAN-03002: failure of Duplicate Db command at 09/04/2001 13:55:11
2001 ??????

Seems the OP is just quoting the reference notes @school.

@OP.
Usually RMAN Duplication needs this date format

NLS_DATE_FORMAT = "MON DD YYYY HH24:MI:SS"

But your date format is

"TO_DATE('22/06/08 20:05:16','DD/MM/YY hh24:mi:ss')"

Edit:
I would manually set the environment (just export NLS_DATE_FORMAT) before starting the duplication.

[Updated on: Thu, 03 July 2008 01:12]

Report message to a moderator

Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331336 is a reply to message #331281]

Thu, 03 July 2008 01:13

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

And quoting your reference note at
http://www.cis.unisa.edu.au/oracle/server.101/b10734/rcmtroub.htm

Set the character set environment variable in the client to
 the same value as the variable in the server. For example, you can
 set the NLS_LANG environment variable on a UNIX system as follows:


% setenv NLS_LANG american_america.we8dec
% setenv NLS_DATE_FORMAT "MON DD YYYY HH24:MI:SS"

[Updated on: Thu, 03 July 2008 01:14]

Report message to a moderator