Home » RDBMS Server » Backup & Recovery » RESTORE DATABASE FAILED (ORACLE 10G (10.2.0.1)ON LINUX 32 BIT)
RESTORE DATABASE FAILED [message #310852] Wed, 02 April 2008 11:22 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,
I am working on test database for testing database disaster recovery.

1) i made full database backup by RMAN and ui also have archive log
2) i noted DBID and all folders of database
3)Turn on the Controlfile auto backup
4) then i drop database
5) then i follow all the steps , which include restoration of spfile and controlfile
6)After that when i have mounted database and in RMAN WRITING RESTORE DATABASE, it is giving following error.

Starting restore at 02-APR-08
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/02/2008 17:54:56
RMAN-06026: some targets not found - aborting 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 1 found to restore

Please help me

Regards,



Re: RESTORE DATABASE FAILED [message #310853 is a reply to message #310852] Wed, 02 April 2008 11:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Too bad you continue to not follow the rules and post your title in upper case.
I will not help you.

Regards
Michel
Re: RESTORE DATABASE FAILED [message #310942 is a reply to message #310852] Wed, 02 April 2008 21:54 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
RMAN-06026: some targets not found


Issue list backup and see the available backups.
Catalog the backup that you have taken if you want to restore from that.

Or did you added any tablespaces since your backup? You then have to set set until clause.

[Updated on: Wed, 02 April 2008 22:03]

Report message to a moderator

Re: RESTORE DATABASE FAILED [message #310963 is a reply to message #310852] Thu, 03 April 2008 00:00 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You may also have a look at
http://arjudba.blogspot.com/2008/04/rman-06026-rman-06023-during-restore.html
to know more about this error.
Re: Restoring database fail [message #310993 is a reply to message #310963] Thu, 03 April 2008 03:28 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Sorry for tite in Upper case,
I do not have catalog database, as i was using control file
Should i write something with restore database to include Controlfile in restoring.
I did not add any any object since my backup.
When i am executing List backupset it is showing nothing, though i have placed backup in flash_recovery_area.

Re: RESTORE DATABASE FAILED [message #311003 is a reply to message #310852] Thu, 03 April 2008 03:57 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Time to read oracle documentation.

The thing is you have not restored correct control file.
Re: Restoring database fail [message #311022 is a reply to message #310993] Thu, 03 April 2008 04:40 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
i restore control file from autobackup successfully. It shows me the result.

There is only one confusion,when i took full database backup using EM, after Configuring the Auto backup of control file,

the string used in backup was as follows

backup device type disk tag '%TAG' database include current controlfile;
backup device type disk tag '%TAG' archivelog all not backed up;

so in autobackup folder there were two backups of same size.

First for Autobackup i used latest , the autobackup gives an error then i provide it backup which was created 2 minutes back it was successful.

What should i do now, do i need to catalogue backupset to controlfile and how do i

[Updated on: Thu, 03 April 2008 05:05]

Report message to a moderator

Re: Restoring database fail [message #311044 is a reply to message #311022] Thu, 03 April 2008 05:18 Go to previous message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
thank you very much all
It was my mistake i did not catalog backuppiece, i thought that using controlfile as repositroy i donot need to catalogue backuppiece.

Thank you very much again
Previous Topic: RMAN Backup strategy
Next Topic: HOW TO RECOVER DATABSE FROM ARCHIVE LOGS
Goto Forum:
  


Current Time: Wed Dec 07 14:20:46 CST 2016

Total time taken to generate the page: 0.17252 seconds