Site icon DBA의 정석

RMAN catalog DB 생성하고 catalog 로 접속하기

# catalog DB 생성하고 catalog 로 접속하기

 아래에서 PROD db가 target DB, REPO DB가 catalog DB 


(REPO DB) 

SQL> create tablespace rcat datafile ‘/oradata/REPO/Disk1/rcatalog.dbf’ size 500M; 

SQL> create user rman identified by rman 

 default tablespace rcat 

 temporary tablespace temp; 

SQL> grant connect, resource, recovery_catalog_owner to rman; 

REPO@~~$ rman catalog rman/rman@REPO 

RMAN> create catalog tablespace rcat; 

RMAN> exit

(PROD DB) 

PROD@~ $ rman target \’sys/change_on_install@PROD as sysdba\’ catalog rman/rman@REPO 

RMAN> register database;

Exit mobile version