Oracle Technology: Snapshot Control File Enqueue

Rman backed up db when: Waiting for snapshot control file Enqueue prompt, rarely see this hint, recorded.

Rman> run{

2> backup Database;

3> Delete noprompt obsolete;

4> backup Archivelog all;

5>}

Starting backup at 2011-09-30 15:31:00

Using channel Ora_disk_1

Channel ora_disk_1:starting full datafile backupset

Channel ora_disk_1:specifying DataFile (s) in Backupset

Input datafile fno=00001 name=g:oracleproduct10.2.0oradataorclsystem01.dbf

Input datafile fno=00003 name=g:oracleproduct10.2.0oradataorclsysaux01.dbf

Input datafile fno=00004 name=g:oracleproduct10.2.0oradataorclusers01.dbf

Input datafile fno=00005 name=g:oracleproduct10.2.0oradataorcltest.dbf

Input datafile fno=00006 name=g:oracleproduct10.2.0oradataorclundotbs02.dbf

Channel ora_disk_1:starting piece 1 at 2011-09-30 15:31:05

Channel ora_disk_1:finished piece 1 at 2011-09-30 15:31:40

Piece handle=g:oracleproduct10.2.0flash_recovery_areaorclbackupset2011_09_30o1_mf_nnndf_tag20110930t153101_ 78bw1sh4_. BKP tag=tag20110930t153101 Comment=none

Channel Ora_disk_1:backup set complete, elapsed time:00:00:36

Channel ora_disk_1:starting full datafile backupset

Channel ora_disk_1:specifying DataFile (s) in Backupset

Waiting for snapshot control file Enqueue

Including control file in Backupset

Including current SPFILE in Backupset

Channel ora_disk_1:starting piece 1 at 2011-09-30 15:32:25

Channel ora_disk_1:finished piece 1 at 2011-09-30 15:32:26

This article URL address: http://www.bianceng.cn/database/Oracle/201410/45566.htm

Piece handle=g:oracleproduct10.2.0flash_recovery_areaorclbackupset2011_09_30o1_mf_ncsnf_tag20110930t153101_ 78bw49qg_. BKP tag=tag20110930t153101 Comment=none

Channel Ora_disk_1:backup set complete, elapsed time:00:00:45

Finished backup at 2011-09-30 15:32:26

RMAN retention policy would be applied to the command

RMAN retention policy are set to recovery windows of 7 days

Using channel Ora_disk_1

No obsolete backups found

Starting backup at 2011-09-30 15:32:30

Current log Archived

Using channel Ora_disk_1

Channel ora_disk_1:starting Archive Log backupset

Channel ora_disk_1:specifying archive log (s) in backup set

Input archive log thread=1 sequence=71 recid=101 stamp=762189937

Input archive log thread=1 sequence=72 recid=102 stamp=763227110

Input archive log thread=1 sequence=73 recid=103 stamp=763227151

Channel ora_disk_1:starting piece 1 at 2011-09-30 15:32:32

Channel ora_disk_1:finished piece 1 at 2011-09-30 15:32:33

Piece handle=g:oracleproduct10.2.0flash_recovery_areaorclbackupset2011_09_30o1_mf_annnn_tag20110930t153231_ 78bw4jpg_. BKP tag=tag20110930t153231 Comment=none

Channel Ora_disk_1:backup set complete, elapsed time:00:00:02

Finished backup at 2011-09-30 15:32:33

Rman>

--===================================

Searched the Doc's explanation is:

Backup fails because of control File Enqueue:scenario

In this scenario, the a backup job fails because RMAN cannot make a snapshot control file. The message stack is as follows:

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR message STACK follows ===============

RMAN-00571: ===========================================================