FIGURE 12-2 Persisting RMAN repository credentials
428 Oracle Database 11g DBA Handbook
Registering a Database
For each database for which RMAN will perform a backup or recovery, we must register the
database in the RMAN repository; this operation records information such as the target database
schema and the unique database ID (DBID) of the target database. The target database need only
be registered once; subsequent RMAN sessions that connect to the target database will automatically
reference the correct metadata in the repository.
[oracle@dw ~]$ rman target / catalog rman@rac
Recovery Manager: Release 11.1.0.6.0 -
Production on Tue Aug 28 21:34:08 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: DW (DBID=3048318127)
recovery catalog database Password: **********
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN>
In the preceding example, we connect to the target database using operating system
authentication and to the repository with password authentication. All databases registered
with the repository must have unique DBIDs; trying to register the database again yields the
following error message:
RMAN> register database;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of register command on default channel
at 08/28/2007 21:38:44
RMAN-20002: target database already registered in recovery catalog
RMAN>
Persisting RMAN Settings
To make the DBA??™s job easier, a number of RMAN settings can be persisted.
Pages:
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667