管理RAC环境中的数据备份和恢复.doc

RAC20100409 13:33 0Tag Oracle Oracle RAC Oracle Oracle RACdatabaseRACdatabaseInstancescluster databasedisk failuredatadiskdatabasediskstablespacesbackupdiskhaltALTER SYSTEM SUSPENDALTER SYSTEM RESUMEtablespacesbackupEM1clusterInstancedatabasemountedopenspfileInstanceSIDInstance* CLUSTER_DATABASEFALSE* LOG_ARCHIVE_DEST_n* LOG_ARCHIVE_FOMAT%t%T%Rthread* LOG_ARCHIVE_STARTTRUE# su C oracle$sqlplus /nologsqlconnect /as sysdbasqlshutdown immediatespfilespfilespfilesqlcreate spfile from pfile;spfilesqlcreate pfile=/oracle/pfile.ora from spfile; /pfile/oracle/oracle/pfile.oracluster_databasefalselog_archive_start=true*.log_archive_start=true*.cluster_database=false*.log_archive_dest=LOCATION=/oracle/archivelog /oracle/archivelog*.log_archive_format=%t_%s.dbfspfilesqlcreate spfile from pfile=/oracle/pfile.ora;(mount)$sqlplus /nologsqlconnect /as sysdbasqlstartup mount$sqlplus /nologsqlconnect /as sysdbasqlstartup mountsqlalter database archivelog; /sqlalter database open; /sqlarchive log list; /cluster_databasetrue$sqlplus /nologsqlconnect /as sysdbasqlshutdown immediatesqlcreate spfile from pfile=/oracle/pfile01.ora; /spfile/oracle/pfile01.oracluster_databasetrue;pfile01.ora$sqlplus /nologsqlconnect /as sysdbasqlcreate spfile from pfile=/oracle/pfile01.ora;sqlstartup /2Oracle ServercatalogRMANnodenameRMANchannelsnodesfilescluster file systemInstancescluster file system schemelogscluster file systemOracleInstancedestinationNFS-read InstancesNFS schemehostInstancelogsschemedestination3RACRACASMcluster file systemNFSRAC InstanceRAC databaseInstancesnoteInstancesDB_RECOVERY_FILE_DESTDB_RECOVERY_FILE_DEST_SIZE4OracleRMANRAC databaseRMANnodenodesRAC InstancesOracle HomeInstancessnapshotcluster fileRMAN CONFIGURE SNAPSHOT CONTROLFILE TO /oracle/db_files/snaps/snap_prod1.cf;nodeInstancesscheme1RMANRMANsnapshotRAC databasesnapshotnodesnapshotRMAN backupnode2control fileRMANBACKUPCOPYcontrol fileRecovery caalogbackupsRMANchannelcontrol filechannelCONNECTchannelchannelbackupnode3RMAN RMANRACnodesfilesRMAN* backup pieces* redo log* data filecontrol file5user-managed user-managed RAC databasecluster databaseRAC database* shutdownInstance* data files* InstanceALTER TABLESPACEBEGIN BACKUPEND BACKUP nodeInstancelog files1user-managedsingle-InstanceshutdownInstancesV$DATAFILEdata filenameV$LOGFILEredo lognamesV$CONTROLFILEnameV$PARAMETERSPFILEnameshutdowndatabaseInstancesOSdata filesonline redo log filescontrol filespfilerestart InstancesInstances2user-managedcluster databaseALTER TABLESPACE BEGIN BACKUPtablespaceOStablespacedata filesALTER TABLESPACE END BACKUPALTER DATABASE BACKUP CONTROLFILE TO file_nameALTER DATABASE BACKUP CONTROLFILE TO TRACE ALTER SYSTEM ARCHIVE LOG CURRENTredo closed threadslogs6channel cluster Instanceschannels InstanceschannelclusterInstancechannelInstancechannelsInstancesmountedopenopenmountedCONFIGURE DEFAULT DEVICE TYPE TO sbt;CONFIGURE DEVICE TYPE sbt PARALLELISM 3;CONFIGURE CHANNEL 1 DEVICE TYPE sbt CONNECT=sys/racRACDB1;CONFIGURE CHANNEL 2 DEVICE TYPE sbt CONNECT=sys/racRACDB2;CONFIGURE CHANNEL 3 DEVICE TYPE sbt CONNECT=sys/racRACDB3;7RAC* Network backup serverserverclustercluster databasenodes* one local drivenodecluster databaseclusternodescluster file systemdatafilesredo logsSPFILEs non-cluster file systemscheme* multiple drivesnodecluster file system schemenodedatafilesredo logsSPFILEsnon-cluster file system schemebackup scriptnodenode 1/arc_dest_1redo logsnode 2/arc_dest_2redo logsnode 3/arc_dest_3redo logs1one local drives CFSschemecluster file system schemenodedatafilesredo logsSPFILEsASMcluster file systemnetwork attached storageNAScluster file system backup schemeclusternodebackupCONFIGURE DEVICE TYPE sbt PARALLELISM 1;CONFIGURE DEFAULT DEVICE TYPE TO sbt;nodenodesredo logsnodeBACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;2multiple drives CFSschemedatabasecluster file system backup schemenodenodechannelCONFIGURE DEVICE TYPE sbt PARALLELISM 3;CONFIGURE DEFAULT DEVICE TYPE TO sbt;CONFIGURE CHANNEL 1 DEVICE TYPE sbt CONNECT user1/passwd1node1;CONFIGURE CHANNEL 2 DEVICE TYPE sbt CONNECT user2/passwd2node2;CONFIGURE CHANNEL 3 DEVICE TYPE sbt CONNECT user3/passwd3node3;DISKclusternodedatafilesarchived redo logsSPFILEsBACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;database10datafiles100redo logsnode 1datafiles137logs 1-33 node 2datafiles 2510logs 34-66 node 3 datafiles 4689redo logs 67-100 3non-cluster file system backup schemenon-cluster file systemnoderedo logsnode 1 node 2node 3redo logsnetwork file systembackupNFS non-cluster file system backup schemenodeCONFIGURE DEVICE TYPE sbt PARALLELISM 3;CONFIGURE DEFAULT DEVICE TYPE TO sbt;CONFIGURE CHANNEL 1 DEVICE TYPE sbt CONNECT usr1/pwd1n1;CONFIGURE CHANNEL 2 DEVICE TYPE sbt CONNECT usr2/pwd2n2;CONFIGURE CHANNEL 3 DEVICE TYPE sbt CONNECT usr3/pwd3n3;databasenodeBACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;8RACdatabasethreadthreadredo logthreadRMANSETdestinationnodenodenodeslog filesRMANnodeRMANAUTOLOCATEnodetapedatabasethreadenabledthreadlog filecontrol filelog filesredo log filesthreaddisablethreadlog file9RACRMANOracle toolssql*plusRACRMANRESTORERECOVEROracle server* restoring data fileschannels* channelsRECOVERY_PARALLELISM01PARALLEL_MAX_SERVERSRECOVER PARALLEL* log filesredodata files* Oraclestartsession* processesInstanceInstances10RACfast-start nodesCPUsFAST_START_PARALLEL_ROLLBACKrollbackInstanceInstanceV$FAST_START_SERVERSV$FAST_START_TRANSACTIONSGV$FAST_START_SERVERSGV$FAST_START_TRANSACTIONSfast-start InstancesRAC database11OCROCRRACCRSclusterdatabaseclusterCRS InstanceOCRCRS3CRS InstanceOCRocrconfig -showbackup/cdata/nodesocrconfig -backuplocOCRocrconfig -exportOCRnoteO