시나리오21: Recovery Catalog Creation
작성자 관리자 작성시간 2003-07-30 15:51:02
 

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


목록 | 입력 | 수정 | 답변 | 삭제