一个完整的Oracle rman备份恢复参考示例.doc

《一个完整的Oracle rman备份恢复参考示例.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、1、建rman库作为repository$morecreaterman_db1.shsetechoonspoolmakedb1.logcreatedatabasermandatafile'/export/home/oracle/oradata/rman_data/system.dbf'size50mautoextendonnext640Klogfile'/export/home/oracle/oradata/rman_data/redo0101.log'SIZE10M,'/export/home/oracle/orad

2、ata/rman_data/redo0201.log'SIZE10Mmaxdatafiles30maxinstances8maxlogfiles64charactersetUS7ASCIInationalcharactersetUS7ASCII;disconnectspooloffexit@/export/home/oracle/8.1.6/rdbms/admin/catalog.sql;REM**********ALTERSYSTEMTABLESPACE*********ALTERTABLESPACESYSTEMDE

3、FAULTSTORAGE(INITIAL64KNEXT64KMINEXTENTS1MAXEXTENTSUNLIMITEDPCTINCREASE50);ALTERTABLESPACESYSTEMMINIMUMEXTENT64K;REM**********TABLESPACEFORROLLBACK**********CREATETABLESPACERBSDATAFILE'/export/home/oracle/oradata/rman_data/rbs.dbf'size50mAUTOEXTENDONNEXT512KMINI

4、MUMEXTENT512KDEFAULTSTORAGE(INITIAL512KNEXT512KMINEXTENTS10MAXEXTENTSUNLIMITEDPCTINCREASE0);REM**********TABLESPACEFORTEMPORARY**********CREATETABLESPACETEMPDATAFILE'/export/home/oracle/oradata/rman_data/temp.dbf'size50mAUTOEXTENDONNEXT64KMINIMUMEXTENT64KDEFAULT

5、STORAGE(INITIAL64KNEXT64KMINEXTENTS1MAXEXTENTSUNLIMITEDPCTINCREASE0)TEMPORARY;REM****Creatingfourrollbacksegments****************CREATEPUBLICROLLBACKSEGMENTRBS_0TABLESPACERBSSTORAGE(OPTIMAL64000K);ALTERROLLBACKSEGMENT"RBS_0"ONLINE;REM****SYSandSYSTEMusers*******

6、*********alterusersystemporarytablespaceTEMP;alterusersystemtemporarytablespaceTEMP;disconnectspooloffexit$morecreaterman_db3.shspoolcrdb3.log@/export/home/oracle/8.1.6/rdbms/admin/catproc.sql@/export/home/oracle/8.1.6/rdbms/admin/caths.sql@/export/home/oracle/8

7、.1.6/rdbms/admin/otrcsvr.sqlconnectsystem/manager@/export/home/oracle/8.1.6/sqlplus/admin/pupbld.sqldisconnectspooloffexit2、建repository存放的表空间和rman用户$morecreaterman_db4.shconnectinternalcreatetablespacerman_tsdatafile'/export/home/oracle/oradata/rman_data/rman_ts

8、.dbf'size20Mdefaultstorage(initial100Knext100Kpctincrease0);createuserrman_hainanidentifiedbyrman_hainantemporarytablespaceTEMPdefaulttablespacerman_tsquotaunlimitedo