Solved

Error backup Intellisnap for Oracle

  • 8 March 2021
  • 8 replies
  • 327 views

Badge +2

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."

icon

Best answer by Piyush Nagar 17 March 2021, 10:21

View original

8 replies

Userlevel 7
Badge +23

Hey @Diana !  Thanks for joining!

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.

Badge +2

In the client and proxy is setting the same Connect String only, because the DB does not has a catalog Connect.

 

Userlevel 7
Badge +23

@Diana , I see you Marked an Answer as correct, though you then Flagged it.

Did this answer your question or do you still have an issue?

Thanks!

Badge +2

Yes, I have the issue yet.

Userlevel 5
Badge +13

Hi @Diana ,

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

Badge +2

Thank you for you answer. 

 

 

Badge +2

Hi 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?

Badge

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 :

 

  1. Using source as proxy without catalog (sRMANDATAFILECOPY default) -->Only Full backup possible: http://documentation.commvault.com/commvault/v11/article?p=35461_1.htm
  2. Using source as proxy with catalog  (sRMANDATAFILECOPY default) --> Only Full backup possible: http://documentation.commvault.com/commvault/v11/article?p=35461_1.htm
  3. Using different proxy <catalog is must> . Rman Full and incremental backup copy is supported

Thanks

Piyush

Reply