- Waiting for snapshot control file enqueue how to#
- Waiting for snapshot control file enqueue archive#
however, from Oracle 11gR2 Start, The feature of controlling automatic backup and delayed creation of files is introduced.
Waiting for snapshot control file enqueue archive#
The premise is that the database is in archive mode, also CONTROLFILE AUTOBACKUP Set to ON. If the structure of the database changes, that Oracle Will automatically back up the control file to the specified directory, And record the relevant information in the alarm log. stay Oracle 10g in, The automatic backup feature of control files is introduced. It should be noted that, from Oracle 11g Start ,rman The automatic backup of control files is delayed. When the database is in archive mode and “CONFIGURE CONTROLFILE AUTOBACKUP ON ” when, If the structure of the database changes （ For example, adding or deleting table spaces ）, The control file will also be backed up automatically. RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/ctl_%f.bak' Īnd then through rman While doing any backup operation, Will automatically back up the control files. RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON ③ Set up RMAN Automatic backup of control files ： SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE īACKUP CURRENT CONTROLFILE FORMAT '/home/oracle/oracle_bk/orclasm/ctl_%d_%T_%s_%p.bak' īACKUP AS COPY CURRENT CONTROLFILE FORMAT '/home/oracle/ctl.bak' īACKUP DATABASE INCLUDE CURRENT CONTROLFILE SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/home/bk/a.ctl' - Get the script to create the control file, Back up to text file format SQL> ALTER DATABASE BACKUP CONTROLFILE TO '/tmp/control.ctl' - Hot backup control file ① Backup control files can be done online ：
Waiting for snapshot control file enqueue how to#
The real question 1、 How to back up control files ？ There are several ways to back up control files ？Īnswer ： There are many ways to back up control files. The average Input/Output time of the physical storage on the disk.Īverage read time to the physical storage on the disk.Īverage Synchronous Single-Block Read LatencyĪverage write time to the physical storage on the disk.【RMAN】Oracle How to back up control files in ？ There are several ways to back up control files ？ Multiplexed Online Log Files Average Count Total number of I/O write requests for the disk Total I/O time for write requests for the disk Total number of failed I/O write requests for the disk Total number of bytes written to the disk Universal Device ID portion of the name returned by discovery Global state of the disk with respect to the disk group Total number of I/O read requests for the disk Total I/O time for read requests for the disk Total number of failed I/O read requests for the disk The name of the manufacturer and the name of the product Operating system pathname portion of the name returned by discovery Per-instance status of the disk relative to group mounts Global status about which kinds of I/O requests are allowed to the diskĭate and time when the disk was was first mounted by the first instance Name of the library that discovered the disk Per-instance status of the disk as seen by discoveryĭisk label portion of the name returned by discovery Number of the disk group containing the disk
Name of the failure group containing the disk Number assigned to the disk withing its group Original destination from which the archive log was generatedĪ 32-bit number consisting of a disk group number in the high-order 8 bits and a disk number in the low-order 24 bitsĭate and time when the disk was added to the disk group Indicates whether an RMAN DELETE command has physically deleted the archived log file from disk, as well as logically removing it from the control file of the target database and from the recovery catalog (YES) or not (NO) If the file has been backed up more than 15 times, the value remains 15 Indicates the number of times this file has been backed up.
0 kommentar(er)
