Database Reference
In-Depth Information
Using RESTORE...VALIDATE
The
RESTORE...VALIDATE
command is used to verify backup files that would be used in a restore operation.
This command validates backup sets, data file copies, and archive redo log files:
RMAN> restore validate database;
No actual files are restored when using
RESTORE...VALIDATE
. This means that you can run the command while
the database is online and available.
Using a Recovery Catalog
When you use a recovery catalog, it's possible to create the recovery catalog user in the same database, on the same
server, as your target database. However, that approach isn't recommended because you don't want the availability of
your target database or of the server on which the target database resides to affect the recovery catalog. Therefore, you
should create the recovery catalog database on a server different from that of your target database.
Creating a Recovery Catalog
When I use a recovery catalog, I prefer to have a dedicated database that is used only for the recovery catalog. This
ensures that the recovery catalog isn't affected by any maintenance or downtime required by another application
(and vice versa).
Listed next are the steps for creating a recovery catalog:
1.
Create a database on a server different from that of your target database, to be used
for the recovery catalog. Make sure the database is adequately sized. I've found that
Oracle's recommended sizes are usually much too small. Here are some adequate
recommendations:
SYSTEM
tablespace: 500MB
SYSAUX
tablespace: 500MB
TEMP
tablespace: 500MB
UNDO
tablespace: 500MB
Online redo logs: 25MB each; three groups, multiplexed with two members per group
RECCAT
tablespace: 500MB
2.
Create a tablespace to be used by the recovery catalog user. I recommend giving the
tablespace a name such as
RECCAT
so that it's readily identifiable as the tablespace that
contains the recovery catalog metadata:
CREATE TABLESPACE reccat
DATAFILE '/u01/dbfile/O12C/reccat01.dbf' SIZE 500M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128k
SEGMENT SPACE MANAGEMENT AUTO;
