No. 17151
RMAN: HOW TO USE ORACLE 9I CATALOG WITH ORACLE 8I DATABASE
==========================================================
PURPOSE
-------
Oracle8i database를 RMAN을 사용하여 backup하고 restore하고자 한다.
이때 Recovery catalog로서 oracle 9i를 사용하는 방법을 설명한다.
EXPLANATION
-----------
# ORACLE 9i DATABASE(catalog)에서 수행해야 하는 작업
1 - Oracle9i db안에 rman user를 위한 tablespace를 생성한다.
SQL> create tablespace example datafile '/oracle/oradata/example.dbf'
size 200M;
2 - Oracle9i database안에 rman user를 생성한다.
SQL> create user rman identified by rman temporary tablespace temp
2 default tablespace example quota unlimited on example;
3 - rman user에게 connect, resource,recovery_catalog_owner role을 부여한다.
SQL> grant recovery_catalog_owner to rman;
4 - 9i RMAN executable를 사용하여 catalog를 생성한다.
frtru1:ora901>rman catalog rman/rman@rman -> connection to Oracle9i database
Recovery Manager: Release 9.0.1.2.0 - Production
(c) Copyright 2001 Oracle Corporation. All rights reserved.
connected to recovery catalog database
recovery catalog is not installed
RMAN> create catalog;
recovery catalog created
# ORACLE 8I DATABASE(target)에서 수행해야 하는 작업:
5 - 8i database로 가서 8i RMAN executable을 수행한다.
frtru1:test817> rman
Recovery Manager: Release 8.1.7.3.0 - Production
RMAN>
RMAN> connect rcvcat rman/rman@v901 <=== Catalog에 connect
RMAN-06008: connected to recovery catalog database
RMAN> connect target test817/Test817 <=== Target에 connect
RMAN-06005: connected to target database: BASEP15 (DBID=511673964)
6 - 마지막으로 target database를 catalog에 register한다.
RMAN> register database;
RMAN-03022: compiling command: register
RMAN-03023: executing command: register
RMAN-08006: database registered in recovery catalog
RMAN-03023: executing command: full resync
RMAN-08002: starting full resync of recovery catalog
RMAN-08004: full resync complete
RMAN>
RMAN> list incarnation of database; <= 현재의 database incarnation확인
RMAN-03022: compiling command: list
List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 2 BASEP15 511673964 YES 1 30-JAN-02
NOTE: TARGET ===> BASEP15(Oracle8i)
CATALOG ===> V901 (Oracle9i)
RMAN EXECUTABLE FROM 8.1.7.3
RELATED DOCUMENTS
-----------------
NOTE:176513.1
'DATABASE > ORACLE' 카테고리의 다른 글
OS 명령으로 DATAFILE을 삭제한 경우 : ORA-1157, ORA-1110 (0) | 2012.07.11 |
---|---|
BACKUP AND RECOVERY USING RMAN (0) | 2012.07.11 |
ORACLE8 (RECOVERY MANAGER) 기본적인 사용법 (0) | 2012.07.11 |
Recovery Manager를 사용하지 않은 완전 복구(Book 8i) (0) | 2012.07.11 |
Cold Backup 후 Recovery (0) | 2012.07.11 |