当前位置: 代码迷 >> 数据库 >> Oracle 配备 catalog
  详细解决方案

Oracle 配备 catalog

热度:3137   发布时间:2013-02-26 00:00:00.0
Oracle 配置 catalog

1: catalog 数据库上创建表空间:
export Oracle_SID=ORCL

create tablespace rmants datafile '/home/oracle/rman/rmants.ora' size 20M;

注意:这里面表空间名一定不要叫rman,如果叫rman,接下来操作会报错,因为rman是关键字;

2. catalog 数据库上创建用户:

SQL>Create user rman identified by rman default tablespace rmants

????? 2temporary ?tablespace temp quota unlimited on rmants;

SQL>grant recovery_catalog_owner to rman;

本次举例子2个数据库在同一台服务器上。

接下来进入target数据库

1、 [oracle@aoracle admin]$ vi tnsnames.ora

catalog =
????????????? (DESCRIPTION =
????????????????????? (ADDRESS_LIST =
????????????????????? (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.190.140)(PORT = 1521))
?????????????????)
????????????????? (CONNECT_DATA =
?????????????????????????(SID = ORCL)
?????????????????????)
???????????????? )

2、[oracle@aoracle ~]$ tnsping catalog

看是否能连上。

3、在主数据库上:
export ORACLE_SID=niutest
[oracle@aoracle ~]$ rman target / catalog rman/rman@catalog

****此处如果出现有关连TNS错误,则将listener.ora加上一个连接串

SID_LIST_LISTENER =
? (SID_LIST =
??? (SID_DESC =
????? (SID_NAME = PLSExtProc)
????? (ORACLE_HOME = /home/lc_orauser/app)
????? (PROGRAM = extproc)
??? )
??? (SID_DESC =
????? (GLOBAL_DBNAME = ORCL)
????? (ORACLE_HOME = /home/lc_orauser/app)
????? (SID_NAME = ORCL)
??? )
?? )

4、如果3成功后,则:

RMAN> create catalog tablespace? rmants;

?

recovery catalog created

5、在target库中注册catalog库

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

?

  相关解决方案