Category: Restoring Archivelog Files
-
Create a Directory Object and Granting Access – External Tables
First, create a directory object that points to the location of the file on disk: SQL> create directory example_dir as ‘/oradata/sales’; Grant READ and WRITE on the directory object to the user (your account or application account) that is accessing the directory object. SQL> grant read, write on directory example_dir to app_user; Create Table Then,…
-
Restoring and Recovering to a Different Server – RMAN Backups and Reporting
When you think about architecting your backup strategy, as part of the process, you must also consider how you are going to restore and recover. Your backups are only as good as the last time you tested a restore and recovery. A backup strategy can be rendered worthless without a good restore-and-recovery strategy. The last…
-
Restoring to a Restore Point – RMAN Backups and Reporting
There are two types of restore points: normal and guaranteed. The main difference between a guaranteed restore point and a normal restore point is that a guaranteed restore point is not eventually aged out of the control file; a guaranteed restore point will persist until you drop it. Guaranteed restore points do require an FRA.…
-
Incomplete Recovery – RMAN Backups and Reporting
The term incomplete database recovery means you cannot recover all committed transactions. Incomplete means you do not apply all redo to restore up to the point of the last committed transaction that occurred in your database. In other words, you are restoring and recovering to a point in time in the past. For this reason,…
-
Restoring Archivelog Files – RMAN Backups and Reporting
RMAN will automatically restore any archivelog files that it needs during a recovery process. You normally do not need to restore archivelog files manually. However, you may want to do so if any of the following situations apply: • You need to restore archivelog files in anticipation of later performing a recovery; the idea is…
-
Performing Block-Level Recovery – RMAN Backups and Reporting
Block-level corruption is rare and is usually caused by some sort of I/O error. It can rescue you from having to do a complete restore of a data file with recovery. However, if you do have an isolated corrupt block within a large data file, it is nice to have the option of performing a…
-
Restoring and Recovering Tablespaces – RMAN Backups and Reporting
Sometimes you will have a media failure that is localized to a particular tablespace or set of tablespaces. In this situation, it is appropriate to restore and recover at the tablespace level of granularity. The RMAN RESTORE TABLESPACE and RECOVER TABLESPACE commands will restore and recover all data files associated with the specified tablespace(s). Restoring…
-
Previewing Backups Used for Recovery – RMAN Backups and Reporting
Use the RESTORE … PREVIEW command to list the backups and archive redo log files that RMAN will use to restore and recover database data files. The RESTORE … PREVIEW command does not actually restore any files. Rather, it lists the backup files that will beused for a restore operation. This example previews in detail…
-
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…
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
Tags
There’s no content to show here yet.
