Category: Incomplete Recovery
-
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,…
-
FLASHBACK DATABASE – RMAN Backups and Reporting
The Flashback Database brings the database back to a point in time in the past. Flashback Database uses information stored in flashback logs; it does not rely on restoring database files (as do cold backup, hot backup, and RMAN). Flashback Database is not a substitute for a backup of your database. If you experience a…
-
Performing Log Sequence–Based Recovery – RMAN Backups and Reporting
Usually this type of incomplete database recovery is initiated because you have a missing or damaged archivelog file. If that is the case, you can recover only up to your last good archivelog file, because you cannot skip a missing archivelog. How you determine which archivelog file to restore up to (but not including) will…
-
Using an Autobackup – RMAN Backups and Reporting
When you enable the autobackup of your control file and are using an FRA, restoring your control file is fairly simple. First, connect to your target database and then issue a STARTUP NOMOUNT command, followed by the RESTORE CONTROLFILE FROM AUTOBACKUP command, like this: $ rman target / RMAN> startup nomount; RMAN> restore controlfile from…
-
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…
-
Restoring a Container Database and Its Pluggable Databases – RMAN Backups and Reporting
You saw the commands already to recover the database, which will include all of the data files for the root and pluggables. Also, the examples showed how to validate just the pluggable databases with RESTORE DATABASE and RECOVER DATABASE. This will restore and recover the root container, seed, and all associated pluggable databases. $ rman…
-
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…
-
Restoring and Recovering the Entire Database – RMAN Backups and Reporting
The RESTORE DATABASE command will restore every data file in your database. The exception to this is when RMAN detects that data files have already been restored; in that case, it will not restore them again. If you want to override that behavior, use the FORCE command. When you issue the RECOVER DATABASE command, RMAN…
-
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…
-
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…
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
