Oracle技术:snapshot control file enqueue

rman备份db时出现了:waiting for snapshot control file enqueue提示,很少看到这个提示,记录一下。

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 current 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

本文URL地址: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 will be applied to the command

RMAN retention policy is set to recovery window 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>

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

搜了一下doc的解释是:

Backup Fails Because of Control File Enqueue: Scenario

In this scenario, 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: ===========================================================

时间: 2024-09-23 19:12:00

Oracle技术:snapshot control file enqueue的相关文章

【ORACLE】ORA-00245: control file backup operation failed

从oracle 11.2.0.2.0开始,控制文件的快照文件必须能够被所有节点的数据实例访问到,并且必须放在共享的位置.否则,使用RMAN进行备份控制文件的时候会报如下错误: ORA-00245: control file backup operation failed. 当使用备份脚本备份的时候,这个错误可能会导致备份工作中断. 公司同事也正好遇到这个问题.  METALINK 中的两篇文档: RAC BACKUP FAILS WITH ORA-00245: CONTROL FILE BACK

通过Snapshot Control File 恢复控制文件

大家好! 今天AningDBA和大家分享的是通过rman 快照控制文件恢复控制文件的方法: 我今天测试使用的oracle版本是10.2.01 由于版本问题,实验结果可能会存在差异.   1.1.  查看Snapshot Control File位置 RMAN> SHOW SNAPSHOT CONTROLFILE NAME;   using target database control file instead of recovery catalog RMAN configuration par

Oracle 快照控制文件(snapshot control file)

      听说过Oracle 控制文件,还有快照控制文件这个说法呢?没错,尽管快照控制文件很少被提及,但确实是存在,只不过在使用RMAN时这个快照控制文件被使用.回顾一下 Oracle 控制文件,我们知道控制文件是Oracle体系结构中的重要组成部分之一,记录了当前数据库的结构信息,同时也包含数据文件及日志文件的信息以及相关的状态,归档信息,也记录了系统当前SCN的值等等.那快照控制文件也就是控制文件的一个副本,本文介绍了什么是快照控制文件以及何时被使用.   1.快照控制文件     快照控

oracle报错RMAN active duplicate hanging on restore control file

12.1.0.2之后,duplicate target database for standby from active database的时候,总是hang死在restore controlfile的情况.这个由于Bug 19664695引起.(Bug22468652和Bug 20721271最终都可以归结到Bug 19664695上去.) 解决方法是在ORACLE_HOME和GRID_HOME的sqlnet.ora文件中都设置DISABLE_OOB=on .详情可参考 RMAN active

Oracle技术:如何将ASM迁移至文件系统

--创建pfile文件 SQL> create  pfile ='/tmp/pfile' from spfile; File created. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining options --修改pfile中关于asm中的内容 contro

【DataGuarad】ORA-01671: cannot make a standby control file

oracle@rac3:/home/oracle>rman target sys/yang402@yangdb auxiliary sys/yang402@yangdb2 Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 15 18:37:27 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. connecte

ORA-00205: error in identifying control file, check alert log for more info

境:oracle10gR2   solaris10 操作:在没有创建pfile的情况下,直接执行了以下命令 1 SQL>create pfile from spfile; 2 SQL>shutdown immediate 3 SQL>startup 4 ORA-00205: error in identifying control file, check alert log for more info 查看alter_TEST.log文件 Tue Jul 03 13:37:49 CST

创建控制文件副本出现错误ORA-00205: error in identifying control file

测试环境:OEL6.5+Oracle 11g R2     在做多路复用控制文件的实验时,创建控制文件总是会报错误:ORA-00205: error in identifying control file, check alert log for more info 下面是当时的操作过程: 点击(此处)折叠或打开 SYS@ORCL> show parameter control_files; NAME                 TYPE     VALUE ----------------

Oracle技术嘉年华第一天归来

   今天参加了Oracle技术嘉年华,也写一些体会简单说说,不一定都是技术相关.    首先对于我来说,能够参加这个峰会是极大的荣幸,特别感谢盖总对我的信任,所以自己也是高度重视,准备了不少的素材,吸取了在之前演讲中的一些缺点和不足,首先把ppt量降了下来,这样演讲就不会有太多的时间包袱,另一方面加入了更多的素材,可能有些案例,一句话就能说明意思,就不用一一贴出一些日志或者操作步骤来,对于一些需要额外补充道的案例直接给出图形比较效果,可能更加简明扼要.还有就是在公司内部消化了一下,竟然发现了很