How to log on to and connect to the target database using RMAN
How to log on to and connect to the target database using RMAN
I. Method 1:
A) [Oracle @ odd-oelr4u8 ~] $ Rman target sys/oracle @ PROD1521 catalog catalog_admin/catalog_admin @ PROD21521
B)
C) Recovery Manager: Release 10.2.0.1.0-Production on Mon Jan 20 07:56:30 2014
D)
E) Copyright (c) 1982,200 5, Oracle. All rights reserved.
F)
G) connected to target database: PROD (DBID = 248672105)
H) connected to recovery catalog database
(I) This method specifies the catalog Database and connects to the target database. It is a CATALOG Mode.
Method 2:
A) [oracle @ odd-oelr4u8 ~] $ Rman target sys/oracle @ PROD1521
B) RMAN> connect catalog_admin/catalog_admin @ PROD21521
C)
D) connected to recovery catalog database
E) This method first connects to the target database and then specifies the catalog database. It is also a CATALOG Mode.
3. Method 3:
A) [oracle @ odd-oelr4u8 ~] $ Rman
B) RMAN> connect target sys/oracle @ PROD1521
C)
D) connected to target database: PROD (DBID = 248672105)
E) RMAN> connect catalog_admin/catalog_admin @ PROD21521
F)
G) connected to recovery catalog database
H) This method connects to rman first, then connects to the target database, and then specifies the catalog Database, which is also a CATALOG Mode.
Iv. Method 4:
A) [oracle @ odd-oelr4u8 ~] $ Rman
B)
C) Recovery Manager: Release 10.2.0.1.0-Production on Mon Jan 20 07:59:21 2014
D)
E) Copyright (c) 1982,200 5, Oracle. All rights reserved.
F)
G) RMAN> connect target sys/oracle @ PROD1521
H)
I) connected to target database: PROD (DBID = 248672105) -- dbid indicates that the database has been connected to the target database.
J)
K) RMAN> show all;
L)
M) using target database control file instead of recovery catalog -- use the control file instead of restoring the directory database to store rman metadata information
N) RMAN configuration parameters are:
O) configure retention policy to recovery window of 30 DAYS;
P) configure backup optimization on;
Q) configure default device type to disk; # default
R) configure controlfile autobackup on;
S) configure controlfile autobackup format for device type disk to '/home/oracle/backup/control/controlfile _ % F ';
T) configure device type disk parallelism 2 backup type to backupset;
U) configure datafile backup copies for device type disk to 1; # default
V) configure archivelog backup copies for device type disk to 1; # default
W) configure channel device type disk format'/home/oracle/backup/PROD _ % U ';
X) configure maxsetsize to unlimited; # default
Y) configure encryption for database off; # default
Z) configure encryption algorithm 'aes128 '; # default
Aa) configure archivelog deletion policy to none; # default
Bb) configure snapshot controlfile name to '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default
Cc)
Dd) RMAN> connect catalog_admin/catalog_admin @ PROD21521
Ee)
Ff) RMAN-00571: ========================================================== ==============================
Gg) RMAN-00569: ====================== error message stack follows ========================
Hh) RMAN-00571: ========================================================== ==============================
Ii) RMAN-06445: cannot connect to recovery catalog after NOCATALOG has been used
Jj) in this case, after connecting to the target database, other operations are performed not to connect to the catalog Database. Therefore, the default system MODE is no catalog mode, and the system uses controlfile as the knowledge base by default, when connected to the catalog database, an error is reported.
Kk) If you want to use the catalog library again and synchronize the content in the controlfile to the catalog library, you need to reconnect the target and catalog, and perform the synchronization as follows:
Ll) connect the target and catalog in any of the methods 1, 2, and 3 above, and then execute the following in rman:
Mm) RMAN> resync catalog;
Nn)
Oo) starting full resync of recovery catalog
Pp) full resync complete
Recommended reading:
RMAN: Configure an archive log deletion policy
Basic Oracle tutorial-copying a database through RMAN
Reference for RMAN backup policy formulation
RMAN backup learning notes
Oracle Database Backup encryption RMAN Encryption