| Bishal |
Posted: Apr 21, 2008 04:04:22 AM |
Total Post: 207
Joined: Apr, 2008
|
| How do you recover a control file if it is accidentally deleted using RMAN... i have the backup of my database though. |
|
|
 GOPU |
| Posted: Apr 21, 2008 05:02:40 AM |  |
|
Total Post: 335
Joined: Apr, 2008
|
IF you have the RMAN backups of the controlfile
RMAN> restore controlfile from 'e:\backup\CTL_SP_BAK_C-1507972899-20050228-00';
|
|
|
|
|
| Bishal |
| Posted: Apr 21, 2008 05:08:08 AM | |
|
Total Post: 207
Joined: Apr, 2008
|
Thanx for ur reply but i before control file got deleted i had given command
Rman>Backup database
I THINK THAT CREATES BACKUP ONLY FOR DATA FILE AND REDO LOG FILE RIGHT?
THANX IN ADVANCE.
|
|
|
|
|
| GOPU |
| Posted: Apr 21, 2008 06:09:59 AM | |
|
Total Post: 335
Joined: Apr, 2008
|
No,first you go through the RMAN backups and recovery throughly.
RMAN does not take the backup of redologs.it will take the backups of datafiles,controlfiles,spfile and the archivelog files.
if you taken the backup of the database using the command backup database;
it taken the backup of datafile,controlfile and the spfile.
i am requesting you to go throuhg the notes of RMAN and then do the recovery
Gopu
|
|
|
|
|
| Bishal |
| Posted: Apr 21, 2008 06:41:40 AM | |
|
Total Post: 207
Joined: Apr, 2008
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
