½Ã³ª¸®¿À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


¸ñ·Ï | ÀÔ·Â | ¼öÁ¤ | ´äº¯ | »èÁ¦