recovery error.

All posts relating to Oracle database administration.

Moderator: Tim...

Posts: 10
Joined: Thu Mar 15, 2012 7:01 am

recovery error.

Postby jayakrishna » Mon Nov 18, 2013 12:16 pm

Hi Tim,

While recovering the DB im getting the below error.
Please let me know how can i recover?

RMAN> restore controlfile;

Starting restore at 18-NOV-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=45 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=44 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: reading from backup piece /ora1/oradata/orcl/RMANc-1354511467-20131118-00
channel ORA_DISK_1: restored backup piece 1
piece handle=/ora1/oradata/orcl/RMANc-1354511467-20131118-00 tag=TAG20131118T154904
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/ora1/oradata/orcl/controlfile/control1.ctl
Finished restore at 18-NOV-13

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1
released channel: ORA_DISK_2

RMAN> restore database;

Starting restore at 18-NOV-13
using channel ORA_DISK_1
using channel ORA_DISK_2

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/18/2013 16:22:24
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 7 found to restore

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: recovery error.

Postby Tim... » Mon Nov 18, 2013 3:52 pm


It looks like your backup is not complete. You have no backup of file "7". Is that an important file?

If you have to you could restore and recover the other files. Mark file 7 as offline for drop, then open the database using resetlogs. Looks like you will not be getting that datafile back, unless you can find a suitable backup.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests