RMAN登陆及连接target数据库的步骤方法


RMAN登陆及连接target数据库的步骤方法

一、            方法一：

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)     &nbs