----本次实验oracle 11g r2
---在本机中安装有两个数据库，分别为sid=sjjc sid=dndn
---现使用sjjc为catalog库来备份dndn
sys@sjjc> select version from v$instance;
VERSION
-----------------
11.2.0.1.0
sys@dndn> select version from v$instance;
VERSION
-----------------
11.2.0.1.0
１.首先把两个库的listener.ora和tnsnames.ora来配制一下
vim $ORACLE_HOME/network/admin/tnsnames.ora
SJJC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle1.jsu.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sjjc.jsu.com)
)
)
DNDN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle1.jsu.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dndn.jsu.com)
)
)
vim $ORACLE_HOME/network/admin/listener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=sjjc.jsu.com)
(SID_NAME=sjjc)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
(PRESPAWN_MAX=20)
(PRESPAWN_LIST=
(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
)
)
(SID_DESC=
(GLOBAL_DBNAME=dndn.jsu.com)
(SID_NAME=dndn)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
(PRESPAWN_MAX=20)
(PRESPAWN_LIST=
(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle1.jsu.com)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
现在开启监听来测试一下
[oracle@oracle1 ~]$ lsnrctl start
ok!
[oracle@oracle1 ~]$ tnsping dndn
ok!
[oracle@oracle1 ~]$ tnsping sjjc
ok!
[oracle@oracle1 ~]$ sqlplus sys/runner@sjjc as sysdba
ok!
[oracle@oracle1 ~]$ sqlplus sys/runner@sjjc as sysdba
ok!
这样，网络就配制好了
２.在sjjc中创建rman用户和表空间
sys@sjjc> create tablespace rman_tbs datafile '/u01/app/oracle/oradata/sjjc/rman_tbs01.dbf' size 100m autoextend on;
Tablespace created.
sys@sjjc> create user rman identified by rman default tablespace rman_tbs;
User created.
sys@sjjc> grant recovery_catalog_owner ,resource to rman; --授权
Grant succeeded.
--测试一下
sys@sjjc> conn rman/rman
Connected.
3.配制rman
[oracle@oracle1 ~]$ rman catalog rman/rman@sjjc --用catalog方式连接到rman(连接到恢复目录)
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Dec 9 10:34:21 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN>
RMAN> create catalog tablespace rman_tbs; --创建恢复目录
recovery catalog creat
--现在可以使用sjjc库中的catalog来连备份dndn库
[oracle@oracle1 ~]$ rman target sys/runner@dndn catalog rman/rman@sjjc
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Dec 9 10:42:22 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DNDN (DBID=2705026088)
connected to recovery catalog database
RMAN>
RMAN> register database; --将目标数据库(dndn)注册到恢复目录
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
---可以sjjc库自己连接
[oracle@oracle1 ~]$ rman target / catalog rman/rman
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Dec 9 17:20:46 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: SJJC (DBID=3775066873)
connected to recovery catalog database
RMAN>
RMAN> register database; --将目标数据库(sjjc)库注册到恢复目录
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
--至此基本配制完成－－－－－－－－－－－－－－－－－－－－－－－－－－
--每次登陆