| Bishal |
Posted: Apr 30, 2008 01:01:32 AM |
Total Post: 196
Joined: Apr, 2008
|
| I have a backup of my database and also control file was backed up in autobackup format on mode.. Now my original control file is deleted... What are the steps to restore my control file using both user managed backups and recovery manager. |
|
|
 GOPU |
| Posted: Apr 30, 2008 01:04:50 AM |  |
|
Total Post: 242
Joined: Apr, 2008
|
What type of backup you have ?
Is it RMAN or any other backup ?
can you elaborate the question ?
|
|
|
|
|
| Bishal |
| Posted: Apr 30, 2008 01:16:04 AM | |
|
Total Post: 196
Joined: Apr, 2008
|
|
|
|
|
| GOPU |
| Posted: Apr 30, 2008 01:25:24 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
Hi,
please try this...
1.Start RMAN and connect to the target database.
2.Run the STARTUP FORCE NOMOUNT command.
3.Run the SET DBID command to distinguish this connected target database from other target databases that have the same name.
4.Run the RESTORE CONTROLFILE command. After restoring the control file, you can mount the database to restore the rest of the database
Regards
Gopu
|
|
|
|
|
| Bishal |
| Posted: Apr 30, 2008 01:34:56 AM | |
|
Total Post: 196
Joined: Apr, 2008
|
it shows
Rman-06563: contol file or spfile must be resotred form autobackup
But when i give RMAN>restore controlfile from autobackup
it shows
Rman-06172:no autobackup found or specified handle is not a valid copy or piece
|
|
|
|
|
| GOPU |
| Posted: Apr 30, 2008 01:36:16 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
Hi,
you can check in this link...to get the things in detail
http://www.orafusion.com/art_rman3.htm
Regards
Gopu
|
|
|
|
|
| GOPU |
| Posted: Apr 30, 2008 01:44:51 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
you try like this by giving the path of the backup....
restore controlfile from 'e:\backup\CTL_SP_BAK_C-1507972899-20050228-00';
|
|
|
|
|
| Bishal |
| Posted: Apr 30, 2008 01:47:32 AM | |
|
Total Post: 196
Joined: Apr, 2008
|
|
|
|
|
| Mohammed Taj |
| Posted: May 01, 2008 02:26:16 AM | |
|
Total Post: 704
Joined: Jul, 2007
|
...And in USER MANAGED backup...
If you have backup then restore...
or
create new controlfile with CREATE CONTROLFILE STATEMENT with SIZE clause.
http://dbataj.blogspot.com/2007/04/lost-all-controlfile-and-redolog-files.html
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
