| RESTORE DATABASE FAILED [message #310852] |
Wed, 02 April 2008 11:22  |
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 #310942 is a reply to message #310852] |
Wed, 02 April 2008 21:54  |
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: Restoring database fail [message #310993 is a reply to message #310963] |
Thu, 03 April 2008 03:28 |
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: Restoring database fail [message #311022 is a reply to message #310993] |
Thu, 03 April 2008 04:40 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
