RMAN CATALOG DB / TARGET DB REGISTER하는 방법
=========================================================
SQL>create tablespace rman_tbs
datafile ‘/oracle/oradata/DB02/rman01.dbf’ size 100M;
SQL>create user rman identified by rman
default tablespace rman_tbs
temporary tablespace temp
quota unlimited on rman_tbs;
SQL>grant connect, resource, recovery_catalog_owner to rman;
SQL> conn rman/rman
SQL> select * from rc_database
ORA-XXXXX catalog 미등록 에러 발생!
===================================================================================
$ rman target system/manager catalog rman/rman
target database connect
catalog database connect
catalog database is not installed.
RMAN> create catalog tablespace "RMAN_TBS";
RMAN> register database;
===================================================================================
SQL> conn rman/rman
SQL> select * from rc_database
DB_KEY DBINC_KEY DBID NAME RESETLOGS_CHANGE# RESETLOGS_TIME
----------------------------------------------------------------------------------
1 2 1258084597 DB02 3598325 2006-12-20:19:25:55
NT------------
C:\>rman target system/manager00@DB02 catalog rman/rman@DB02

댓글목록
등록된 댓글이 없습니다.