Thanks But the same doubt what if rman backup is not there. Assume you work in a company as a senior DBA and on your absence your buck up has corrupted all the control files while working with the alter dba backup control files command. What would restore database and recover database command do. Do they restore all the data files and what if I have a TBs of database…? Your email address will not be published.
Notify me of follow-up comments by email. Notify me of new posts by email. Skip to content This document will detail recovery scenarios dealing with missing or corrupted control files using RMAN disk based backups. Scenario 1: Corrupt or Missing control file When attempting to start the database you see the following error. Or you may see the file is missing when looking in the alert log.
Scenario 2: All control files are corrupt or missing When starting the database we see the following error. Mon Apr 26 Checker run found 2 new persistent data failures Since all of the control files are missing we will need to restore them from a backup using RMAN. All rights reserved. We need to restore the database. Question and Answer. You Asked I have couple of questions regarding controlfiles 1.
Adding to question 2 if i have old control file in backup scn number older than current datafiles how can we get this situation fixed. More to Explore. You must specify the filename of the online logs containing the changes in order to open the database.
If the online logs contain redo necessary for recovery, then re-create the control file. If possible, restore the control file to its original location. In this way, you avoid having to specify new control file locations in the initialization parameter file. For example, enter:. Apply the prompted archived logs. If you then receive another message saying that the required archived log is missing, it probably means that a necessary redo record is located in the online redo logs.
This situation can occur when unarchived changes were located in the online logs when the instance crashed. You can specify the name of an online redo log and press Enter you may have to try this a few times until you find the correct log :. If the online logs are inaccessible, then you can cancel recovery without applying them.
If all datafiles are current, and if redo in the online logs is required for recovery, then you cannot open the database without applying the online logs. If you cannot restore the control file to its original place because the media damage is too severe, then you must specify new control file locations in the server parameter file.
If not, then the database prevents you from the mounting the database. Follow the steps in "Restoring a Backup Control File to the Default Location" , except after step 2 add the following step:. For example, if the control file locations listed in the server parameter file are as follows, and both locations are inaccessible:. If all control files have been lost in a permanent media failure, but all online redo log members remain intact, then you can recover the database after creating a new control file.
Use the control file copy to obtain SQL output.
0コメント