Databases Reference
In-Depth Information
How It Works
New with Oracle Database 10
g
, you can now add metadata about backup pieces directly to your control file via the
catalog
command. If you're not using a recovery catalog, this can be particularly useful if you ever have to re-create
your control file. This is because when re-creating the control file, all of your RMAN information is wiped out.
You can use the
catalog
command to add the following types of information to your control file:
•
Backup pieces
•
Archived redo log files
•
Control file copies
•
Data file copies
•
Files in the fast recovery area
■
Note
See moS note 550082.1 for details on how to catalog backup pieces to tape.
You can verify the backup information via the following command:
RMAN> list backup;
Restoring Data Files Using DBMS_BACKUP_RESTORE
Problem
You're using an old version of Oracle (9i and lower). You had to re-create your control file, and you are not using a
recovery catalog. You want to restore data files from an RMAN backup piece, but your control file now contains no
information whatsoever about previously taken backups.
■
if you are using oracle Database 10
g
or newer, we strongly recommend that you use the
catalog
command
and do not use DBmS_BaCKUp_reStore. See recipe 11-18 for details on how to add metadata to your control file for
uncataloged backup pieces.
Note
Solution
Use the DBMS_BACKUP_RESTORE package to restore files from backup pieces. If you have output logs from your
backups, you can visually inspect those and determine the names of the data files within a backup piece. If you don't
have any output logs, you'll have to figure out through trial and error which data files are in which backup piece.
In this example, we know from our RMAN backup output logs that three data files are contained within the specified
backup piece. You'll need to modify this anonymous block of PL/SQL code to specify the files in your environment:
SET SERVEROUTPUT ON
DECLARE
finished BOOLEAN;
v_dev_name VARCHAR2(10);
TYPE v_filestable IS TABLE OF varchar2(500) INDEX BY BINARY_INTEGER;
