0) Network setting
tnsname.ora 에 셋팅
1) Recovery Catalog관리자 user 생성 (Catalog DB)
SQL> create tablespace rman_ts
2 datafile '/opt/oracle/oradata/ORA9/rman_ts.dbf' size 20M
3 autoextend on;
SQL> create user rmanhan
2 identified by rmanhan
3 quota unlimited on rman_ts
4 default tablespace rman_ts;
SQL> grant recovery_catalog_owner to rmanhan;
SQL> exit
$ sqlplus rmanhan/rmanhan@ora920 (catalog DB)
SQL> select * from user_role_privs;
SQL> select object_name from user_objects where object_type='VIEW';
no rows selected
SQL> exit
2) Catalog의 Install
$ rman catalog rmanhan/rmanhan@ora920
connected to recovery catalog database
recovery catalog is not installed
RMAN>
RMAN> create catalog tablespace rman_ts;
recovery catalog created
RMAN> exit
$ sqlplus rmanhan/rmanhan@ora920
SQL> select object_name from user_objects where object_type='VIEW';
SQL> @$HOME/LABS/rmanpkg
SQL> exit
3) Rman으로 Target DB와 Catalog DB에 접속
$ rman target \'sys/oracle as sysdba\' catalog rmanhan/rmanhan@ora920
connected to target database: HUMAN (DBID=561079227)
connected to recovery catalog database
|