Start communicating
Oracle_People
learn oracle as well..
Recent Village Updates
Login to find out
has added a new journalNow in oracle10g you can easy see, which components are updated and what versions they are using.
select * from dba_feature_usage_statistics;
The following query will show you the high water mark of different components.
select * from dba_high_water_mark_statistics;
Login to find out
has added a new journalHow will your recover your database when all control file corrupted or deleted.
----------------------------------------------------
Case#1
If you have mirrored copies of your control file do the following.
1. Copy all the existing control files at any different location just for the save side in case you massed with what you have.
2. Copy one of the good control file from the mirrored location to the corrupted location and start the database... simply no recovery needed!!
Case#2
If you have lost your all control files do the following.
You should have all the archived logs and online log available.
You have to recover the database by using backup control file.
1. rman
2. connect target /
3. connect catalog rmanowner/password@catalog (if available)
4. startup force nomount;
5. restore controlfile from autobackup;
6. alter database mount;
7. restore database;
8. recover database;
9. alter database open resetlogs;
After database started, take full backup again
Hopefully it will help!!
-Asif