By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,469 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

blockig error

P: 1
how to unblock the CF
below error what was the solution.



GES: Potential blocker (pid=282) on resource CF-00000000-00000000;
enqueue info in file /exlibris/app/oracle/admin/meta4/bdump/meta4_arc0_22455.trc
Killing enqueue blocker (pid=282) on resource CF-00000000-00000000
by killing session 189.549GES: Potential blocker (pid=8833) on resource CF-00000000-00000000;


8) Trace meta4_arc0_22455.trc shows:

Unable to get enqueue on resource CF-00000000-00000000 (ges mode req=3 held=6)
Possible local blocker ospid=282 sid=189 sser=549 time_held=1027 secs (ges mode req=6 held=4)
Killing blocker (pid=282) on resource CF-00000000-00000000
DUMP LOCAL BLOCKER: initiate state dump for KILL
last wait for 'control file sequential read' blocking sess=0x0 seq=407 wait_time=15 seconds since wait started=1033
file#=0, block#=11, blocks=1
Dumping Session Wait History
REQUEUE CONTROL FILE ENQUEUE REQUEST AFTER KILLING THE FIRST BLOCKER
BLOCKER: inst=1, session id=189, serial=549, held=1027sec
REQUESTER: mode=S, type=0, timeout=900, new timeout=450




SELECT SESSION_ID,LOCK_TYPE,LAST_CONVERT,MODE_HELD,BLOCKI NG_OTHERS FROM DBA_LOCK;
**** Hit return to continue ****

SESSION_ID LOCK_TYPE LAST_CONVERT MODE_HELD BLOCKING_OTHERS
---------- -------------------------- ------------ --------------- ---------------
426 Control File 214 None Not Blocking
444 Redo Thread 97079 Exclusive Not Blocking
189 Control File 220 S/Row-X (SSX) Blocking
189 Control File 220 Share Not Blocking
189 Control File 220 Exclusive Not Blocking
190 Control File 96 None Not Blocking
212 SH 37 Exclusive Not Blocking
212 DML 37 Exclusive Not Blocking
212 Transaction 37 Exclusive Not Blocking
212 DML 37 Row-X (SX) Not Blocking
212 WF 39 Exclusive Not Blocking
**** Hit return to continue ****

SESSION_ID LOCK_TYPE LAST_CONVERT MODE_HELD BLOCKING_OTHERS
---------- -------------------------- ------------ --------------- ---------------
212 Control File 37 None Not Blocking
218 Temp Segment 97077 Row-X (SX) Not Blocking
219 RS 97079 Row-S (SS) Not Blocking
219 XR 97085 Null Not Blocking
219 Control File 97082 Row-S (SS) Blocking
219 KT 97077 Share Not Blocking
220 Media Recovery 97079 Share Not Blocking
220 Media Recovery 97079 Share Not Blocking
220 Media Recovery 97079 Share Not Blocking
220 Media Recovery 97079 Share Not Blocking
220 Media Recovery 97079 Share Not Blocking
**** Hit return to continue ****

SESSION_ID LOCK_TYPE LAST_CONVERT MODE_HELD BLOCKING_OTHERS
---------- -------------------------- ------------ --------------- ---------------
220 Media Recovery 97079 Share Not Blocking
220 Media Recovery 97079 Share Not Blocking
220 Media Recovery 97079 Share Not Blocking
220 PW 97076 Row-X (SX) Not Blocking
220 Media Recovery 97079 Share


rman target / nocatalog
Recovery Manager: Release 10.2.0.3.0 - Production on Fri Oct 12 08:38:59 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: META4 (DBID=633370153)
using target database control file instead of recovery catalog


RMAN> backup database;
Starting backup at 12-OCT-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=188 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00009 name=/metalib/oradata/meta4/meta4_ts0_02.dbf
input datafile fno=00011 name=/metalib/oradata/meta4/meta4_ts1_03.dbf
input datafile fno=00010 name=/metalib/oradata/meta4/meta4_ts1_02.dbf
input datafile fno=00007 name=/metalib/oradata/meta4/meta4_ts0_01.dbf
input datafile fno=00008 name=/metalib/oradata/meta4/meta4_ts1_01.dbf
input datafile fno=00012 name=/metalib/oradata/meta4/meta4_rman01.dbf
input datafile fno=00001 name=/metalib/oradata/meta4/meta4_system01.dbf
input datafile fno=00003 name=/metalib/oradata/meta4/meta4_sysaux01.dbf
input datafile fno=00002 name=/metalib/oradata/meta4/meta4_undotbs01.dbf
input datafile fno=00004 name=/metalib/oradata/meta4/meta4_users01.dbf
input datafile fno=00005 name=/metalib/oradata/meta4/meta4_tslob01.dbf
input datafile fno=00006 name=/metalib/oradata/meta4/meta4_log01.dbf
channel ORA_DISK_1: starting piece 1 at 12-OCT-07
channel ORA_DISK_1: finished piece 1 at 12-OCT-07
piece handle=/exl_backup/meta4/meta4_db_df20071012_s22_s1.bak tag=TAG20071012T084331 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:36
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
RMAN-00571: ================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ================================================== =========
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/12/2007 09:11:44
ORA-03114: not connected to ORACLE
ORA-03113: end-of-file on communication channel
##################################
Oct 15 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.