cancel
Showing results for 
Search instead for 
Did you mean: 

CommVault Failure to backup

SOLVED
Go to solution
pat phillips
Occasional Advisor

CommVault Failure to backup

Dear all I have tried to backup a present client which has failed. I have done a manual backup to disk from rman with the present syntax.

run {
allocate channel d1 type disk maxpiecesize=2000M;
backup database plus archivelog;
}

But from the application I get an error saying that cannot make a snapshot controlfile. Can anyone help.

Rman Log
--------
Rman Script:
[run {
allocate channel ch1 type 'sbt_tape'
PARMS="ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine= -jm 45 -a 2:1998 -cl 424 -ins 381 -at 22 -j 231666 -bal 1 -bap 0 -rap 0 -rcp 0 -mav 0 -ms 1 -data -vm TRACE 0;
backup
incremental level = 0
filesperset = 32
database
include current controlfile ;
}
exit;
]
Rman Log:[

Recovery Manager: Release 9.2.0.5.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN>
connected to target database: EPG (DBID=3770740658)
using target database controlfile instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10>
allocated channel: ch1
channel ch1: sid=23 devtype=SBT_TAPE
channel ch1: CommVault Systems for Oracle: Version 5.0.0(Build38)

Starting backup at 16-MAR-05
channel ch1: starting incremental level 0 datafile backupset
channel ch1: specifying datafile(s) in backupset
including current SPFILE in backupset
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
waiting for snapshot controlfile enqueue
cannot make a snapshot controlfile
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 03/16/2005 09:36:32
ORA-00230: operation disallowed: snapshot controlfile enqueue unavailable

Regards,
Pat

6 REPLIES
Duncan Edmonstone
Honored Contributor
Solution

Re: CommVault Failure to backup

Pat,

from the rman manual:
--------------------------------------------
When RMAN needs to resynchronize from a read-consistent version of the control file, it creates a temporary snapshot control file. The default name for the snapshot control file is port-specific. Use the set snapshot controlfile name command to change the name of the snapshot control file; subsequent snapshot control files that RMAN creates use the name specified in the command.

For example, start RMAN and then enter:

set snapshot controlfile name to '/oracle/dba/prod/snap_prod.ctl';


You can also set the snapshot control file name to a raw device. This operation is important for OPS databases in which more than one instance in the cluster use RMAN because server sessions on each node must be able to create a snapshot control file with the same name and location. For example, enter:

set snapshot controlfile name to '/dev/vgd_1_0/rlvt5';


If one RMAN job is already backing up the control file while another needs to create a new snapshot control file, you may see the following message:

RMAN-08512: waiting for snapshot controlfile enqueue


Under normal circumstances, a job that must wait for the control file enqueue will wait for a brief interval and will then successfully retrieve the enqueue. Recovery Manager makes up to five attempts to get the enqueue and then fails the job. The conflict is usually caused when two jobs are both backing up the control file, and the job that starts backing up the control file first waits for service from the media manager.

See Also: For an overview of RMAN resynchronization using the snapshot control file, see "Resynchronization of the Recovery Catalog". For set command syntax, see "set".

--------------------------------------------

So:

1) Make sure there are no other RMAN backups still running or hung (might want to bounce the target DB completely to sort this)

2) Set a new snapshot controlfile name through RMAN.

HTH

Duncan

HTH

Duncan
pat phillips
Occasional Advisor

Re: CommVault Failure to backup

Hi Duncan

Thanks for the help here I have shutdown the database and resterted but still the same issue. You say to Set a new snapshot controlfile name through RMAN.

How do I do this.

Regards,
Pat

Re: CommVault Failure to backup

Hi,

You log on to both the catalog DB and target DB

rman target user/pass@tns_for_target catalog user/pass@tns_for_catalog

Then you issue:
show all; -- which will show you this (among other things): 'CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/some/path/to/snapcf_SID.f' (usually $ORACLE_HOME/dbs/snapcf_SID.f). To change the location just copy and paste the 'CONFIGURE ....." and specify where you want to put the snapshot controlfile.

hth
/M

Re: CommVault Failure to backup

Pat,
You might want to look at this note on metalink also: NoteID 145619.1

Good luck
/M
pat phillips
Occasional Advisor

Re: CommVault Failure to backup

Hi -

Thanks I Set a new snapshot controlfile name through RMAN and this has resolved the issue.

Thanks,
Pat
pat phillips
Occasional Advisor

Re: CommVault Failure to backup

Thanks forthe help