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
|