一、

方法一：

a)

[oracle@odd-oelr4u8

~]$ rman target sys/oracle@PROD1521 catalog

catalog_admin/catalog_admin@PROD21521

b)

c)

Recovery

Manager: Release 10.2.0.1.0 - Production on Mon Jan 20 07:56:30 2014

d)

e)

Copyright

(c) 1982, 2005, Oracle.  All rights

reserved.

f)

g)

connected

to target database: PROD (DBID=248672105)

h)

connected

to recovery catalog database

i)

该方法指定catalog库并连接了target库，是一种CATALOG Mode

二、

方法二：

a)

[oracle@odd-oelr4u8

~]$ rman target sys/oracle@PROD1521

b)

RMAN>

connect catalog catalog_admin/catalog_admin@PROD21521

c)

d)

connected

to recovery catalog database

e)

该方法先连接target库，再指定catalog库，也是一种CATALOG Mode

三、

方法三：

a)

[oracle@odd-oelr4u8

~]$rman

b)

RMAN>

connect target sys/oracle@PROD1521

c)

d)

connected

to target database: PROD (DBID=248672105)

e)

RMAN>

connect catalog catalog_admin/catalog_admin@PROD21521

f)

g)

connected

to recovery catalog database

h)

该方法先连接rman，再指定连接target库，再指定catalog库，也是一种CATALOG Mode

四、

方法四：

a)

[oracle@odd-oelr4u8

~]$ rman

b)

c)

Recovery

Manager: Release 10.2.0.1.0 - Production on Mon Jan 20 07:59:21 2014

d)

e)

Copyright

(c) 1982, 2005, Oracle.  All rights

reserved.

f)

g)

RMAN>

connect target sys/oracle@PROD1521

h)

i)

connected

to target database: PROD (DBID=248672105) --有dbid证明已连接到目标库

j)

k)

RMAN>

show all;

l)

m)

using target database control file instead of recovery catalog --使用控制文件来代替恢复目录数据库存放rman元数据信息

n)

RMAN

configuration parameters are:

o)

CONFIGURE

RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;

p)

CONFIGURE

BACKUP OPTIMIZATION ON;

q)

CONFIGURE

DEFAULT DEVICE TYPE TO DISK; # default

r)

CONFIGURE

CONTROLFILE AUTOBACKUP ON;

s)

CONFIGURE

CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO

'/home/oracle/backup/control/controlfile_%F';

t)

CONFIGURE

DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;

u)

CONFIGURE

DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

v)

CONFIGURE

ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

w)

CONFIGURE

CHANNEL DEVICE TYPE DISK FORMAT

'/home/oracle/backup/PROD_%U';

x)

CONFIGURE

MAXSETSIZE TO UNLIMITED; # default

y)

CONFIGURE

ENCRYPTION FOR DATABASE OFF; # default

z)

CONFIGURE

ENCRYPTION ALGORITHM 'AES128'; # default

aa)

CONFIGURE

ARCHIVELOG DELETION POLICY TO NONE; # default

bb)

CONFIGURE

SNAPSHOT CONTROLFILE NAME TO

'/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

cc)

dd)

RMAN>

connect catalog catalog_admin/catalog_admin@PROD21521

ee)

ff)

RMAN-00571:

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

gg)

RMAN-00569:

=============== ERROR MESSAGE STACK FOLLOWS ===============

hh)

RMAN-00571:

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

ii)

RMAN-06445:

cannot connect to recovery catalog after NOCATALOG has been used

jj)

这种情况是在连接target库之后，做了其他的非连接catalog库的动作，因此系统默认的是NO CATALOG MODE，系统已经默认使用controlfile作为知识库，再相连接catalog库就报错了

kk)

如果想再次使用catalog库，并将controlfile中的内容同步到catalog库中，则需要重新连接target和catalog，并作同步如下：

ll)

采用如上方法一、二、三中的任何一种方式连接target和catalog后，在rman中执行：

mm)

RMAN>

resync catalog;

nn)

oo)

starting

full resync of recovery catalog

pp)

full

resync complete