Category: Restoring to a Restore Point
-
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,…
-
SQL*Loader vs. External Tables – External Tables
One general use of an external table is to employ SQL to load data from an OS file into a regular database table. This facilitates the loading of large amounts of data from files into the database. Almost anything you can do with SQL*Loader, you can achieve with external tables. An important difference is that…
-
Flashback – RMAN Backups and Reporting
Although the RECOVER TABLE command is a nice enhancement, I recommend that if you have an accidentally dropped table, you first explore using the recycle bin or Flashback Table to Before Drop feature to restore the table. Or, if the table was erroneously deleted from, then use the Flashback Table feature to restore the table…
-
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,…
-
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 to a Nondefault Location – RMAN Backups and Reporting
Use the SET ARCHIVELOG DESTINATION clause if you want to restore archivelog files to a location different from the default. The following example restores to the nondefault location /u01/archtemp. The option of the SET command must be executed from within an RMAN run{} block. run{set archivelog destination to ‘/u01/archtemp’; restore archivelog from sequence 8 force;}…
-
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 and Recovering Data Files While the Database Is Not Open – RMAN Backups and Reporting
In this scenario, the database is first shut down and then started in mount mode. You can restore and recover any data file in your database while the database is not open. This example shows the restoring of data file 1, which is associated with the SYSTEM tablespace of the container database (CDB): $ rman…
-
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…
-
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
