RAC Backup and Recovery using RMAN [ID 243760.1]

《RAC Backup and Recovery using RMAN [ID 243760.1]》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、؞᭩ᰦ䰤28-OCT-2011㊫රBULLETIN⣦ᘱPUBLISHEAppliesto:OracleServer-StandardEditionOracleServer-PersonalEditionOracleServer-EnterpriseEdition-Version:9.0.1.0andlater[Release:9.0.1andlater]Informationinthisdocumentappliestoanyplatform.PurposeThepurposeofthisdocumentistogiveaquickguideabouthowto

2、performBackupandRecoveryonRACdatabases.Wewillfollowthispoints:1.Verifythedatabasemodeandarchivedestination.2.Verifyconnectivityusingsqlnetfortargetandcatalog.3.DetermineyourbackupDevice.4.UnderstandhowtocreateanRMANpersistentconfigurationforaRACenv.5.Createbackupstodiskusingthenewper

3、sistentconfigurationparameters.6.BackupsetMaintenanceusingtheconfiguredretentionpolicy.7.RestoreandRecovera.Completeb.Incomplete8.Reviewandunderstandtheimpactofresetlogsonthecatalog.9.RMANSampleCommands.ScopeandApplicationñThisdiscussionisfora2-nodeOracleRACCluster.ñThelogsarebeingar

4、chivedtotheirrespectivenode.ñWeareallocatingchannelstoeachnodetoenabletheautolocatefeatureofRMANinaRACenv.RMAN:RACBackupandRecoveryusingRMAN1.Verifythedatabasesareinarchivelogmodeandarchivedestination.a.NODE1:thread1SQL>archiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnable

5、dArchivedestination/u02/app/oracle/product/9.2.0/dbs/archOldestonlinelogsequence20Nextlogsequencetoarchive21Currentlogsequence21b.NODE2:thread2SQL>archiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination/u02/app/oracle/product/9.2.0/dbs/archOldestonlinelogs

6、equence8Nextlogsequencetoarchive9Currentlogsequence92.Verifyconnectivitytothetargetnodesandcatalogifused.$setenvTNS_ADMIN$ORACLE_HOME/network/admin$sqlplus/nologSQL>connectsys/pwd@node1assysdbaSQL>connectsys/pwd@node2assysdbaSQL>connectrman/rman@rcat3.Setyourtestingareas.TestingHOMEf

7、orlogs:/u02/home/usupport/rmanBackupsHOMELocation:/rman/V9204.ConnectusingRMANtoverifyandsetthecontrolfilepersistentconfiguration.Thecontrolfilesaresharedbetweentheinstancessoconfiguringthecontrolfileonnode1alsosetsitforallnodesintheRACcluster.*AlwaysnotethetargetDBIDconnectedtotarge

8、tdatabase:V9