Backing Up Control Files with RMAN
You can back up the control file when the database is mounted or open. RMAN uses a
snapshot control file to ensure a read-consistent version. If CONFIGURE CONTROLFILE
AUTOBACKUP is ON (by default it is OFF), then RMAN automatically backs up the
control file and server parameter file after every backup and after database structural
changes. The control file autobackup contains metadata about the previous backup,
which is crucial for disaster recovery.
If the autobackup feature is not set, then you must manually back up the control file in
one of the following ways:
■ Run BACKUP CURRENT CONTROLFILE
■ Include a backup of the control file within any backup by using the INCLUDE
CURRENT CONTROLFILE option of the BACKUP command
■ Back up datafile 1, because RMAN automatically includes the control file and
SPFILE in backups of datafile 1
A manual backup of the control file is not the same as a control file autobackup. In
manual backups, only RMAN repository data for backups within the current RMAN
session is in the control file backup, and a manually backed-up control file cannot be
automatically restored.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-1005245/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Backing Up Server Parameter Files with RMANServer
- Backing Up Individual Tablespaces with RMAN
- Backing up the tailAI
- Backing Up Logs with BACKUP … PLUS ARCHIVELOGHive
- ORA-19599 When Backing up an Archivelog that is CorruptHive
- Overview of Control Files (66)View
- Multiplexed Control Files (68)
- ''Sbt Error = 7011, Errno = 959'' Error When Backing Up To TapeError
- Oracle OCP 1Z0-053 Q577(Rman Recover lost control files)Oracle
- ORACLE 控制檔案(Control Files)概述Oracle
- 【翻譯】控制檔案管理(Managing Control Files)
- How to config (no)archivelog mode and manage archive log files by RMANHive
- netbakcup備份時遇到 status 6: the backup failed to back up the requested files 問題解決AI
- 搭建備庫時報錯“ORA-00203: using the wrong control files”
- 關於在spfile檔案上修改control_files引數的問題
- RMAN備份時出現ORA-19809: limit exceeded for recovery filesMIT
- Initialization Parameter Files and Server Parameter Files (287)Server
- 042-Your database is having two control files, three redo log file groups with two members in each gDatabase
- Oracle FilesOracle
- wake up
- Level Up
- Java NIO filesJava
- Upload Files
- Paths和Files
- 4.3.2.2.2 Oracle Managed FilesOracle
- JavaScript files 屬性JavaScript
- Reset and Checkout Files in GitGit
- Manipulating Files With Tcl
- Oracle Server Parameter FilesOracleServer
- PHP文字操作_FILESPHP
- Oracle 11gR2 RMAN 配置控制檔案自動備份(control file autobackup)Oracle
- Incremental checkpoint up to RBAREM
- Gross up by wage typeROS
- E. Level Up
- DataTransfer.files 屬性
- Special Characters in Initialization Parameter Files
- session_max_open_filesSession
- oracle-managed files (35)Oracle