Wednesday, April 8, 2020

ORA-00230: operation disallowed: snapshot control file enqueue unavailable

User might encounter below error, in case if RMAN backup is already running and user might have triggered another backup. The second backup must wait control file enqueuer to create a snapshot of the controlfile.

RMAN-03002: failure of backup command at 04/10/2020 16:40:33
ORA-00230: operation disallowed: snapshot control file enqueue unavailable

You can run below command to find out the backup that is running and causing the wait

SELECT S.SID, USERNAME , PROGRAM, MODULE,
ACTION, LOGON_TIME FROM V$SESSION s, V$ENQUEUE_LOCK l
WHERE l.SID = s.SID AND l.TYPE = 'CF' AND l.ID1 = 0 AND l.ID2 = 2;

To avoid this error make sure that backups are not overlapping each other.

Regards,
Satishbabu Gunukula, Oracle ACE
http://oracleracexpert.com

2 comments:




  1. The agency follows a strict selection procedure and each and every female interested in joining us need to meet the essential conditions and fulfill the eligibility criteria.Escorts in AgraEscorts in Agrawe have and There is a long list of elite customers who has blind faith in us. It is because of the uncompromising terms and conditions that we strictly follow to ensure highest level of privacy. Check our other Services...
    Female Escorts in Agra
    Female Escorts in Agra
    Russian Escorts in Agra
    Escorts in Agra
    Female Escorts in Agra

    ReplyDelete
  2. Packers And Movers Bangalore Local Household Shifting Service, Get Free Best Price Quotes Local Packers and Movers in Bangalore List , Compare Charges, Save Money And Time.
    Packers And Movers in Bangalore

    ReplyDelete