src="http://pagead2.googlesyndication.com/pagead/show_ads.js">

Quick RMAN Catalog Setup....
Enjoy.....
SQL> create tablespace rman_tbs
datafile '/u01/test/rman_01.dbf' size 200M;
Tablespace created.
SQL> create user rman identified by pass123
temporary tablespace temp
default tablespace rman_tbs
quota unlimited on rman_tbs;
User created.
SQL> grant recovery_catalog_owner,connect,resource to rman;
Grant succeeded.
SQL> EXIT
$ rman catalog rman@test
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 12 11:21:00 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
recovery catalog database Password:
connected to recovery catalog database
RMAN> create catalog;
recovery catalog created
exit
$
$ rman target / catalog rman@test
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 12 11:29:33 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: TEST (DBID=3068100200)
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> show all;
starting full resync of recovery catalog
full resync complete
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u07/rmanbk/test/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u07/rmanbk/test/%U' MAXPIECESIZE 100 G;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 100 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/app/oracle/product/10gR2/dbs/snapcf_test.f'; # default
RMAN>
0 comments:
Post a Comment