RMAN catalog 的创建和使用.docx

RMAN catalog 的创建和使用.docx

《RMAN catalog 的创建和使用.docx》由会员分享，可在线阅读，更多相关《RMAN catalog 的创建和使用.docx（8页珍藏版）》请在冰点文库上搜索。

RMANcatalog的创建和使用

--==========================

--RMANcatalog的创建和使用

--==========================

一、创建恢复目录

创建恢复目录一般分为三大步骤

（1）创建存放恢复目录的数据库（或使用已存在的数据库）

（2）创建恢复目录的的所有者

（3）创建恢复目录

创建数据库可以参考：

Oralce10g使用DBCA创建数据库

在存储恢复目录的数据库创建表空间用于存储恢复目录schema及恢复目录数据（本文使用已经创建好的数据库catadb来存储恢复目录）

SQL>createtablespacetbs_rmandatafile'/u01/app/oracle/oradata/catadb/tbs_rman01.dbf'--创建rman恢复目录表空间

2size200mautoextendon;

SQL>createuserrmanidentifiedbyrman--创建rmanschema

2temporarytablespacetemp

3defaulttablespacetbs_rman

4quotaunlimitedontbs_rman;

SQL>grantrecovery_catalog_ownertorman;--角色授予

SQL>connrman/rman

SQL>select*fromsession_privs;

PRIVILEGE

----------------------------------------

CREATESESSION

ALTERSESSION

CREATETABLE

CREATECLUSTER

CREATESYNONYM

CREATEVIEW

CREATESEQUENCE

CREATEDATABASELINK

CREATEPROCEDURE

CREATETRIGGER

CREATETYPE

SQL>select*fromsession_roles;

ROLE

------------------------------

RECOVERY_CATALOG_OWNER

RMAN>connectcatalogrman/rman@catadb--连接到恢复目录

connectedtorecoverycatalogdatabase

RMAN>createcatalogtablespacetbs_rman;--创建恢复目录

recoverycatalogcreated

[oracle@oradb~]$rmantargetsys/redhat@orclcatalogrman/rman@catadb--连接到目标数据库及恢复目录

connectedtotargetdatabase:

ORCL（DBID=1260850162）

connectedtorecoverycatalogdatabase

RMAN>registerdatabase;--将目标数据库注册到恢复目录

databaseregisteredinrecoverycatalog

startingfullresyncofrecoverycatalog

fullresynccomplete

二、基于恢复目录的备份

1.查看相关信息

RMAN>listincarnation;

ListofDatabaseIncarnations

DBKeyIncKeyDBNameDBIDSTATUSResetSCNResetTime

-------------------------------------------------------------

18ORCL1260850162PARENT130-JUN-05

12ORCL1260850162CURRENT44607522-OCT-10

----------------------------------------------------------------------------------------------------

RMAN>crosscheckcopy;--校验copy

RMAN>deleteexpiredcopy;--删除过期的copy

2.全备

RMAN>run{

2>allocatechannelch1devicetypedisk;

3>backupascompressedbackupsetdatabaseplusarchivelogdeleteinput

5>format='/u01/app/oracle/bk/rmbk/Whole_%d_%U'

6>tag='Whole_bak';

7>releasechannelch1;}

3.增量备份（0级）

RMAN>run{

2>allocatechannelch1devicetypedisk;

3>allocatechannelch2devicetypedisk;

4>backupascompressedbackupsetincrementallevel0databaseplusarchivelogdeleteinput

7>format='/u01/app/oracle/bk/rmbk/Inc_0_%d_%U'

8>tag='Inc_0';

9>releasechannelch1;

10>releasechannelch2;}

RMAN>listbackupsummary;

4.增量备份（1级）

RMAN>run{

2>allocatechannelch1devicetypedisk;

3>allocatechannelch2devicetypedisk;

4>backupascompressedbackupsetincrementallevel1database

6>format='/u01/app/oracle/bk/rmbk/Inc_1_%d_%U'

7>tag='Inc_1';

8>releasechannelch1;

9>releasechannelch2;}

RMAN>listbackupbyfile;

5.累计增量备份（1级）

RMAN>run{

2>allocatechannelch1devicetypedisk;

3>backupascompressedbackupsetincrementallevel1cumulativedatabase

5>format'/u01/app/oracle/bk/rmbk/Cum_1_%d_%U'

6>tag='Cum_1';

7>releasechannelch1;}

6.备份表空间

RMAN>run{

2>allocatechannelch1devicetypedisk;

3>backupascompressedbackupsettablespaceusers,example

5>format='/u01/app/oracle/bk/rmbk/tbs_%d_%U'

6>tag='tbs';

RMAN>listbackupsettag=tbs;

7.备份数据文件

RMAN>run{

2>allocatechannelch1devicetypedisk;

3>backupascompressedbackupset

4>datafile3

5>format='/u01/app/oracle/bk/rmbk/df_%d_%U'

6>tag='df';

7>releasechannelch1;}

8.备份归档日志

备份归档日志前，建议先使用crosscheck校验一下

crosscheck通常用于检查备份是否被删除，如果删除将会打上删除标签

RMAN>crosscheckarchivelogall;

allocatedchannel:

ORA_DISK_1

channelORA_DISK_1:

sid=148devtype=DISK

validationsucceededforarchivedlog

archivelogfilename=/u01/app/oracle/oradata/orcl/arch/log_1_117_733069427.arcrecid=111stamp=733171369

Crosschecked1objects

RMAN>sql'altersystemswitchlogfile';

sqlstatement:

altersystemswitchlogfile

RMAN>sql'altersystemswitchlogfile';

sqlstatement:

altersystemswitchlogfile

RMAN>listarchivelogall;

ListofArchivedLogCopies

KeyThrdSeqSLowTimeName

--------------------------------

4651117A22-OCT-10/u01/app/oracle/oradata/orcl/arch/log_1_117_733069427.arc

5531118A23-OCT-10/u01/app/oracle/oradata/orcl/arch/log_1_118_733069427.arc

5691119A23-OCT-10/u01/app/oracle/oradata/orcl/arch/log_1_119_733069427.arc

9.基于SCN来备份归档日志

RMAN>run{

2>allocatechannelch1devicetypedisk;

3>backupascompressedbackupsetarchivelogfromscn848043

5>format='/u01/app/oracle/bk/rmbk/arc_%d_%U'

6>tag='arc';

7>releasechannelch1;

8>}

10.镜像备份

RMAN>run{

2>allocatechannelch1devicetypedisk;

3>backupascopydatafile1,4

4>format'/u01/app/oracle/bk/rmbk/df_%d_%U'

5>tag'copybak';

6>releasechannelch1;}

11.其它

RMAN>crosscheckbackupset;

RMAN>changebackupset1

RMAN>validatebackupset

RMAN>validatebackupset635;

12.基于catalog的数据库恢复请参考：

基于catalog的RMAN备份与恢复