This forum is currently locked. You can't register or post questions at this time. (read more)

recovery error.

All posts relating to Oracle database administration.

Moderator: Tim...

jayakrishna
Member
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

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

Re: recovery error.

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

Hi.

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.

Cheers

Tim...
Tim...
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: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 6 guests

cron