Rman backup standby database
近日接手一套新500GB的 9i dataguard架構的DBServer、HP380
由於IO瓶頸、導致在做rman backup時使用者反映產線‘卡死’,選擇在standbydb上備份測量。
方案實施步驟:
一 、備份standbydb
RMAN> run{
delete obsolete;
allocate channel db01 device type disk format '/data2/rmanbackup/database_%T_%U.bak';
allocate channel db02 device type disk format '/data2/rmanbackup/database_%T_%U.bak';
allocate channel db03 device type disk format '/data2/rmanbackup/database_%T_%U.bak';
allocate channel db04 device type disk format '/data2/rmanbackup/database_%T_%U.bak';
BACKUP DATABASE filesperset 5;
release channel db01;
release channel db02;
release channel db03;
release channel db04;
}
二、copy standby controlfile
# cp /u01/app/oracle/oradata/ygzhou/control01.ctl /data2/rmanbackup/control01.ctl
三、利用standby backupset/standby controlfile restore database
RMAN> restore controlfile from '/ data2/rmanbackup/control01.ctl';
RMAN> run{
restore database;
}
四、switchower or failover this standbydb to primarydb
注意:1、standby備份、primarydb的控制檔案不存在該備份資訊,所以利用primarydb 的控制檔案用常規的方式無法恢復database;
2、由於在rman backup過程中DB中會有大量的dml或者ddl (drop語句可能導致備份失敗) 出現,導致controlfile中的scn號與datafile中的scn不匹配;此後需求利用到archivelog來保證資料安全 (archivelog的重要性....)。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24867586/viewspace-746824/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- rman backup database force 功能Database
- rman 建 Standby Database 筆記Database筆記
- How to use rman backup a noarchivelog databaseHiveDatabase
- 理解RMAN backup database plus archivelog命令DatabaseHive
- 使用rman建立standby database的過程Database
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- RMAN backup validate database on databases in noarchivelog modeDatabaseHive
- rman backup as copy database format '/tmp/%U.dbf'DatabaseORM
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- Using RMAN Incremental Backups to Refresh a Standby DatabaseREMDatabase
- 11g rman新特性 duplicate target database for standby from active databaseDatabase
- 同事總結的 : 用RMAN建立Physical Standby DatabaseDatabase
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- RMAN10g: backup copy of database (Doc ID 266980.1)Database
- Using RMAN Incremental Backups to Roll Forward a Physical Standby DatabaseREMForwardDatabase
- standby databaseDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- 透過RMAN備份standby database成功恢復還原Database
- Creating a Physical Standby using RMAN DUPLICATE FROM ACTIVE DATABASEDatabase
- 11g RMAN新特性 active database duplication createing standbyDatabase
- standby database to primary database.Database
- Physical Standby Database 切換到 Snapshot Standby DatabaseDatabase
- rman backup database 出現 ORA-01422錯誤Database
- Standby Database ---09Database
- Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1]GUIIDEDatabase
- oracle full database backupOracleDatabase
- Cold Database backup scriptDatabase
- Oracle 11g RMAN備份-RMAN的backup database plus archivelog命令背後的操作OracleDatabaseHive
- Create RAC Standby Database for RAC Primary DatabaseDatabase
- standby database No RFS 程式Database
- Standby Database for reportDatabase
- rman backup script(引用)
- DP rman backup scripts
- Creating a Standby Database using RMAN (Recovery Manager) [ID 118409.1]Database
- rman 建立ftp standbyFTP
- Cold backup and restore the entire databaseRESTDatabase
- Standby Database的工作原理Database
- 建立 Logical Standby DatabaseDatabase