Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rman restore error 06026/06023

user12854173Nov 17 2010 — edited Nov 18 2010
hi all,

i am trying to restore my database into a different server (same SID, DBID, same file location).

i was able to restore my backup to the new server before but now i cannot restore my backup to the other server.
my backup was cold backup and i do not use catalog.

here is what i run since yesterday.

MAN> restore controlfile from '/rman/backup/november17/controlfile....';

Starting restore at 17-NOV-10
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1088 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output filename=/u02/oradata/PGAPRPHP/control01.ctl
output filename=/u03/oradata/PGAPRPHP/control02.ctl
output filename=/u04/oradata/PGAPRPHP/control03.ctl
Finished restore at 17-NOV-10

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> restore database;

Starting restore at 17-NOV-10
Starting implicit crosscheck backup at 17-NOV-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1088 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=1087 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=1085 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=1084 devtype=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: sid=1083 devtype=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: sid=1082 devtype=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: sid=1081 devtype=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: sid=1080 devtype=DISK
Crosschecked 8 objects
Crosschecked 83 objects
Finished implicit crosscheck backup at 17-NOV-10

Starting implicit crosscheck copy at 17-NOV-10
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
Crosschecked 4 objects
Finished implicit crosscheck copy at 17-NOV-10

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u05/oradata/..
File Name: /u05/oradata/..
File Name: /u05/oradata/..
File Name: /u05/oradata/...

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/17/2010 06:04:48
RMAN-06026: some targets not found - aborting 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 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 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

please help. thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2010
Added on Nov 17 2010
2 comments
389 views