資源描述：
《一個完整的Oracle rman備份恢復參考示例.doc》由會員上傳分享，免費在線閱讀，更多相關內(nèi)容在行業(yè)資料-天天文庫。
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
