oracle catalog 设置,Oracle 配备 catalog

1: catalog 数据库上创建表空间：

export Oracle_SID=ORCL

create tablespacermantsdatafile '/home/oracle/rman/rmants.ora' size20M;

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

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

SQL>Create userrmanidentified byrmandefault tablespacermants

2temporary tablespacetempquota unlimited onrmants;

SQL>grant recovery_catalog_ownerto 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