Category: External Table Types
-
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,…
-
Flashing Back a Table to a Previous Point in Time – RMAN Backups and Reporting
If a table was erroneously deleted from, you have the option of flashing back the table to a previous point in time. The Flashback Table feature uses information in the undo tablespace to restore the table. The point in time in the past depends on your undo tablespace retention period, which specifies the minimum time…
-
Determining the Type of Incomplete Recovery – RMAN Backups and Reporting
Time-based restore and recovery are commonly used when you know the approximate date and time to which you want to recover your database. For instance, you may know approximately the time you want to stop the recovery process, but not a particular SCN. Log sequence-based and cancel-based recovery work well in situations in which you…
-
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 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…
-
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 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 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,…
-
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…
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.
