Create Catalog Database and User
1. First Create a catalog database.
2.Log in as sys and create tablespace for RMAN backup;
SQL> create tablespace rman_ts datafile ‘/cityfs/test/rman_ts01.dbf’ size 100M;
Tablespace created.
3.Create the Recovery Catalog Owner in the database
CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE rman QUOTA UNLIMITED ON rman_ts;
SQL> CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE rman_ts;
User created.
SQL> grant dba to rman;
Grant succeeded.
SQL> grant recovery_catalog_owner TO rman;
Grant succeeded.
4. Now login RMAN as catalog owner to create catalog
rman catalog rman/rman@test
RMAN> CREATE CATALOG;
recovery catalog created
Register your DB To Catalog Database
1.Create tnsnames from your database to catalog database (such as catdb)
a. export ORACLE_SID=sibl
b. [oracle@localhost ~]$ rman target / catalog rman/rman@test
Recovery Manager: Release 10.2.0.1.0 – Production on Tue May 10 19:09:10 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: SIBL (DBID=404877640)
connected to recovery catalog database
c. RMAN> REGISTER DATABASE;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
2. Make sure that the registration was successful by running REPORT SCHEMA:
RMAN> REPORT SCHEMA;
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 20480 SYSTEM YES /siblfs/sibl/system01.dbf
2 2898 UNDOTBS1 YES /siblfs/sibl/undotbs01.dbf
3 500 SYSAUX NO /siblfs/sibl/sysaux01.dbf
4 32767 ABABIL_TS NO /usr/sibl_data_files/ABABIL_TS01.dbf
5 1024 ABABIL_IMAGE_TS NO /siblfs/sibl/ABABIL_IMAGE_TS_01.dbf
6 23200 ABABIL_TS NO /siblfs/sibl/ABABIL_TS02.dbf
7 9216 ABABIL_TS NO /siblfs/sibl/ABABIL_TS03.dbf
8 1500 ABABIL_TS NO /siblfs/sibl/ABABIL_TS04.dbf
9 15360 ABABIL_INDEX_TS NO /usr/sibl_data_files/ababil_index_ts01.dbf
10 10240 ABABIL_TS NO /usr/sibl_data_files/ababil_data_ts05.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 1024 TEMP 32767 /siblfs/sibl/temp01.dbf
2 5000 TEMP 5000 /siblfs/sibl/temp02.dbf
*****************************************************************
RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 365 DAYS;
*************************************************************
rman configuration for Tivoli
allocate channel t1 type ‘sbt_tape’ parms
‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’;