Home » RDBMS Server » Backup & Recovery » Restore error RMAN-03015,RMAN-06026,RMAN-06023 (OS: Solaris, Oracle 9i)
Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331278] Wed, 02 July 2008 18:41 Go to next message
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
Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331280 is a reply to message #331278] Wed, 02 July 2008 19:29 Go to previous messageGo to next message
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.
Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331281 is a reply to message #331278] Wed, 02 July 2008 19:39 Go to previous messageGo to next message
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
Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331283 is a reply to message #331278] Wed, 02 July 2008 21:38 Go to previous messageGo to next message
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 ?
Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331287 is a reply to message #331278] Wed, 02 July 2008 21:57 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331334 is a reply to message #331287] Thu, 03 July 2008 01:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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

Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #331875 is a reply to message #331336] Sun, 06 July 2008 05:23 Go to previous messageGo to next message
lengkunpeng
Messages: 1
Registered: July 2007
Junior Member
check controlfile is newest ???? i meet this problem!
Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #383710 is a reply to message #331283] Thu, 29 January 2009 19:05 Go to previous messageGo to next message
Erdenejargal
Messages: 18
Registered: July 2008
Junior Member
Some files are missing. And I copied it. Restored again. Than it was completed.

Thanks,
Enjgaa
Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #383712 is a reply to message #383710] Thu, 29 January 2009 19:07 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Appreciate the follow-up after 7 months.
Re: Restore error RMAN-03015,RMAN-06026,RMAN-06023 [message #383713 is a reply to message #383712] Thu, 29 January 2009 19:09 Go to previous message
Erdenejargal
Messages: 18
Registered: July 2008
Junior Member
Laughing sure ... Embarassed
Previous Topic: Connecting Oracle 10g Database from Oracle 8i Client for backup
Next Topic: Restore problem with RMAN (merged)
Goto Forum:
  


Current Time: Fri Dec 09 21:02:28 CST 2016

Total time taken to generate the page: 0.18814 seconds