데이터베이스

Total 205
Today 0
profile_image
슈퍼아이피
10-07-27 16:17 0개 640회
Oracle
Oracle RMAN 설치 방법

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 

추천 0 비추천 0

댓글목록

등록된 댓글이 없습니다.