- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: CommVault Failure to backup
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2005 03:17 AM
тАО03-16-2005 03:17 AM
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
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2005 06:39 AM
тАО03-16-2005 06:39 AM
Solutionfrom 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
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2005 10:48 PM
тАО03-16-2005 10:48 PM
Re: CommVault Failure to backup
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2005 12:16 AM
тАО03-17-2005 12:16 AM
Re: CommVault Failure to backup
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2005 12:23 AM
тАО03-17-2005 12:23 AM
Re: CommVault Failure to backup
You might want to look at this note on metalink also: NoteID 145619.1
Good luck
/M
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2005 01:07 AM
тАО03-17-2005 01:07 AM
Re: CommVault Failure to backup
Thanks I Set a new snapshot controlfile name through RMAN and this has resolved the issue.
Thanks,
Pat
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-17-2005 01:08 AM
тАО03-17-2005 01:08 AM