Category: RMAN Restore and Recovery
-
Restoring Read-Only Tablespaces – RMAN Backups and Reporting
RMAN will restore read-only tablespaces along with the rest of the database when you issue a RESTORE DATDABASE command. For example, the following command will restore all data files (including those in read-only mode): RMAN> restore database; If you are using a backup that was created after the read-only tablespace was placed in read-only mode,…
-
Validating Backup Files Before Restoring – RMAN Backups and Reporting
There are several levels of verification that you can perform on backup files without actually restoring anything. If you just want RMAN to verify that the files exist and check the file headers, then use the RESTORE … VALIDATE HEADER command, as shown here: RMAN> restore database validate header; The command only validates the existence…
-
Changing the Status of a Failure – RMAN Backups and Reporting
One last note on the Data Recovery Advisor: if you know that you have had a failure and that it is not critical (e.g., a data file missing from a tablespace that is no longer used), then use the CHANGE FAILURE command to alter the priority of a failure. In this example, there is a…
-
Suggesting Corrective Action – RMAN Backups and Reporting
The ADVISE FAILURE command gives advice about how to recover from potential problems detected by the Data Recovery Advisor. If you have multiple failures with your database, you can directly specify the failure ID to get advice on a given failure, like so: RMAN> advise failure 6222; Here is a snippet of the output for…
-
Using SQL – RMAN Backups and Reporting
There are a number of data dictionary views available for querying about backup information. Table 13-1 describes RMAN-related data dictionary views. These views are available regardless of your use of a recovery catalog (the information in these views is derived from the control file). Table13-1.DescriptionofRMAN Backup Data Dictionary Views Sometimes, DBAs new to RMAN have…
Recent Posts
- Create a Directory Object and Granting Access – External Tables
- External Table Types – External Tables
- SQL*Loader vs. External Tables – External Tables
- Restoring and Recovering to a Different Server – RMAN Backups and Reporting
- FLASHBACK DATABASE – RMAN Backups and Reporting
