修复oracle配置文件,Oracle 配置 catalog 成功恢复control file

Oracle 配置 catalog 成功恢复control file

再说catalog 的配置：

1: catalog 数据库上：

export Oracle_SID=ezhoudg

1>在catalog数据库上创建一个表空间供catalog使用

create tablespace rman_ts datafile '/u02/ezhou/rman01.dbf' size 50m extent management local uniform size 126k;

2>在catalog数据库上创建用户并赋予权限

create user rman_user identified by rman_user default tablespace rman_ts quota unlimited on rman_ts;

grant recovery_catalog_owner to rman_user;

grant connect,resource to rman_user;

2: 在主数据库上ezhou：

vi tnsname.ora (这个文件是在ezhou 和ezhoudg)

[oracle@aoracle admin]$ vi tnsnames.ora

PRD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.190.140)(PORT = 1521))

)

(CONNECT_DATA =

(SID = EZHOU)

)

)

catalog =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.190.140)(PORT = 1521))

)

(CONNECT_DATA =

(SID = EZHOUDG)

)

)

启动监听lsnrctl start

在数据库上tnsping catalog

[oracle@aoracle ~]$ tnsping catalog

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 09-DEC-2011 19:41:31

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.190.140)(PORT = 1521))) (CONNECT_DATA = (SID = EZHOUDG)))

OK (10 msec)

3: 在主数据库上：

export ORACLE_SID=ezhou

注册主数据库 到catalog

[oracle@aoracle ~]$ rman target / catalog rman_user/rman_user@catalog

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Dec 9 19:45:32 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database (started)

connected to recovery catalog database

RMAN> create catalog tablespace rman_ts;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

=====================

下面进行测试一下:

[oracle@aoracle ~]$ rman target / catalog rman_user/rman_user@catalog

RMAN> run {

2> restore controlfile;

3> }

Starting restore at 09-DEC-11

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=155 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: reading from backup piece /u02/rman/ctl_c-4046377924-20111209-00

channel ORA_DISK_1: restored backup piece 1

piece handle=/u02/rman/ctl_c-4046377924-20111209-00 tag=TAG20111209T115410

channel ORA_DISK_1: restore complete, elapsed time: 00:00:04

output filename=/u02/ezhou/control01.ctl

output filename=/u02/ezhou/control02.ctl

output filename=/u02/ezhou/control03.ctl

Finished restore at 09-DEC-11

，

本文原创发布php中文网，转载请注明出处，感谢您的尊重！