When setting backup with intellisnap with Oracle appear "Unable to proceed with rman based snap to tape as catalog has not been specified by the user."
Solved
Error backup Intellisnap for Oracle
+2Best answer by Piyush Nagar
Hi ,
ASM supports only Rman based backup copy as mentioned in documentation. Rman backup copy using proxy requires a dedicated db instance on proxy with the same name as Production/source db. Recovery Catalog with source database registered is must and mandatory requirement. Recovery catalog should be accessible from source and proxy machine.
Using dedicated proxy during rman backup copy --> because we mount database on proxy using snapshot control file and unmount once backup completes, there is no way to register/catalog backuppieces/Full and incremental backups without having recovery catalog. You can create a separate dedicated instance for recovery catalog with source oracle database registered that also serves long term retention of backup pieces in recovery catalog.
Possible Combinations with rman based backup copy you can get :
- Using source as proxy without catalog (sRMANDATAFILECOPY default) -->Only Full backup possible: http://documentation.commvault.com/commvault/v11/article?p=35461_1.htm
- Using source as proxy with catalog (sRMANDATAFILECOPY default) --> Only Full backup possible: http://documentation.commvault.com/commvault/v11/article?p=35461_1.htm
- Using different proxy <catalog is must> . Rman Full and incremental backup copy is supported
Thanks
Piyush
+23- Vaulter
- 4996 replies
Hey
Regarding your error, the DB needs to be registered with a catalog DB and then the connect string for that catalog needs to be configured in the relevant instance properties in the Commvault GUI (source client and proxy). The requirements are here: http://documentation.commvault.com/commvault/v11/article?p=35450.htm
"A recovery catalog database must be used and accessible from RMAN on both the source and proxy client."
Let me know if you have any questions about the documentation.
https://www.linkedin.com/in/michael-struening
1 person likes this
+2In the client and proxy is setting the same Connect String only, because the DB does not has a catalog Connect.
+23- Vaulter
- 4996 replies
Did this answer your question or do you still have an issue?
Thanks!
+13- Vaulter
- 300 replies
Hi
As Mike suggested, the RMAN catalog is a mandatory requirement to be able to do RMAN based tape copy. This is needed because we need to update the RMAN catalog used by the source Oracle instance when the RMAN backup is done during tape copy.
If you don’t have the RMAN catalog available, can you consider using the File System based backup copy?
Thanks,
Sunil
1 person likes this
+2Hi Sunil,
I have the client with Oracle ASM database, the proxy is the same SO with Oracle database and I put the connect string only. I tried setting with File System based backup copy but in the documentation say:
The disadvantages include:
- Oracle ASM databases are not supported for File System backup copy.
https://documentation.commvault.com/commvault/v11/article?p=35454.htm
So, are there another way for this backup-copy with intellisnap and a proxy server?
- Vaulter
- 1 reply
- Answer
Hi ,
ASM supports only Rman based backup copy as mentioned in documentation. Rman backup copy using proxy requires a dedicated db instance on proxy with the same name as Production/source db. Recovery Catalog with source database registered is must and mandatory requirement. Recovery catalog should be accessible from source and proxy machine.
Using dedicated proxy during rman backup copy --> because we mount database on proxy using snapshot control file and unmount once backup completes, there is no way to register/catalog backuppieces/Full and incremental backups without having recovery catalog. You can create a separate dedicated instance for recovery catalog with source oracle database registered that also serves long term retention of backup pieces in recovery catalog.
Possible Combinations with rman based backup copy you can get :
- Using source as proxy without catalog (sRMANDATAFILECOPY default) -->Only Full backup possible: http://documentation.commvault.com/commvault/v11/article?p=35461_1.htm
- Using source as proxy with catalog (sRMANDATAFILECOPY default) --> Only Full backup possible: http://documentation.commvault.com/commvault/v11/article?p=35461_1.htm
- Using different proxy <catalog is must> . Rman Full and incremental backup copy is supported
Thanks
Piyush
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.