System refresh with Commvault

[Former Member]

Hallo,

we want to perform a SAP refresh, e.g. restore instance ABC from host1 to instance DEF on host2.

The backup was taken using Commvault software and the backint interface.

Looking at the Commvault documentation there seems to be a procedure in place for performing the above with Oracle only (not using backint).

However, the documentation does not mention anything for SAP (backint). All what's covered is the restore to the same SID on different hosts.

For other backup tools (eg. Networker, Dataprotector) I only had to execute the following command to restore:

brrestore -d util_file -b behhulnv.anf -m all -c force -u /

However, with Commvault this commands throws the following error:

(...)

Success in getting Job id=837 Token=<837:2:1>

Success in init with JM

getJobListByInstanceId=34 retCode=1

Cannot get the list of Jobs

Cannot figure out the job type legacy or Snap?

(...)

Any ideas?

Thanks and regards,

Thomas.

[Former Member]

Many, many thanks Thomas.

You may have just saved my bacon !!

I'm going to try it out today on one of our systems.

I hope you didn't mind me asking you some questions. Hopefully there wont

be anymore !!

Thanks again

Andy

[former_member188883]

Hi,

For restoration could you please look into the link below.

http://documentation.commvault.com/hds/release_8_0_0/books_online_1/english_us/features/restore/rest...

Note: During backup / restore backint will act as a trigger point to brbackup/brrestore utilities.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hallo Deepak,

thanks a lot for your answer.

I am aware of the documentation. It states:

(...)

Ensure that the following information is the same on both the source and destination clients:

- ORACLE_SID name

(...)

I am refreshing a Q&A system from a production system, hence the SID changes.

Regards,

Thomas.

[Former Member]

Solved by adding the entries below to the util file. each of them has to be in two lines:

numstreams

1

CvInstanceName

Instance001

CvClientName

<hostname target>

srcCrossClient

<hostname source>

Regards,

Thomas.

[Former Member]

Hi Thomas,

A bit of a long shot but I hope you are still there.

I am also trying to do a refresh in Commvault from PRD to QA. I would very much appreciate

any help. In particular this util file. I don't see one in our $ORACLE/dbs directory.

Do I need to manually create one

Hope you can reply

Thanks

Andy

[Former Member]

Hallo Andy,

I assume you use brtools which will interface to Commvault using backint.

Then you will need a utl-file in the dbs-directory.

My earlier thread shows what need to go into the utl-file.

Some more details can be found here:

http://documentation.commvault.com/dell/release_7_0_0/books_online_1/english_us/features/backup/sap....
Regards,

Thomas.

[Former Member]

Hi Thomas,

Thank you very much for the reply. I really appreciate it.

This util-file in the dbs directory does this only need to be present during the refresh??

Does it then have to be removed for the normal backups to take place??

I don't suppose you have any notes you have made on this that you could send me? I'm

really struggling with this. Our the guys are saying that this procedure cant be done and

I am saying it can and trying to do it myself.

It definitely can be done from one host to another using a different SID ???

Many thanks again

Andy

[Former Member]

Hi Thomas,

Sorry to bother you again.

I forgot to ask the most important question !!!

Does this .utl file reside in the dbs directory on the QA server or the dbs directory on the PROD server??

Or even both??

Thanks

Andy

[Former Member]

Hallo Andy,

Regarding your questions:

This util-file in the dbs directory does this only need to be present during the refresh??

Does it then have to be removed for the normal backups to take place??

The utl-file is defined in the sap-file (eg. initQAS.sap) using the following entry:

     util_par_file = /oracle/QAS/112_64/dbs/initQAS.utl

However, you don't have to use a util when running a backup. We use it for backups as well but this is not a requirement. Hence you might not find the utl-file on your servers.

You will have to use it for the restore! Otherwise your SAP server will not know which backup to restore from (because your production server has a different hostname).

Hence the really important bits in initQAS.utl are:

     CvClientName

     <hostname target> #Your QAS server hostname

     srcCrossClient

     <hostname source> #Your PRD server hostname

It definitely can be done from one host to another using a different SID ???

Yes, we restore production (SID: PRD) to all sort of other instances (SIDs: QAS, TRG, etc.).

Does this .utl file reside in the dbs directory on the QA server or the dbs directory on the PROD server??

For the restore you have to have it in the dbs-directory of the QAS server and you have to have the utl_par_file-reference in your init<SID>.sap file.

Regards,

Thomas.

[Former Member]

Many, many thanks Thomas.

You may have just saved my bacon !!

I'm going to try it out today on one of our systems.

I hope you didn't mind me asking you some questions. Hopefully there wont

be anymore !!

Thanks again

Andy

[Former Member]

Hi Thomas,

Very sorry to bother you again, but I am having problems with the refresh.

I have created the initPIQ.utl file which has:

numstreams

4

CvInstanceName

Instance001

CvClientName

sap-q-pi01-l

srcCrossClient

sap-p-pi01-l

srccrossdbname

PIP

So basically my test system is PIQ and the Production is PIP

I have the line :

util_par_file = /oracle/PIQ/11203/dbs/initPIQ.utl      in the initPIQ.sap file

I then try to restore in commvault by right clicking the production client:

But I am getting the error in the log:

3498 4beb8720 01/29 10:42:26 460603 ::ExecuteBrRestore() - getInstanceId for InstanceName=[PIP] destClientId=[288] AppType=61 Failed

3498 4beb8720 01/29 10:42:26 460603 ::ExecuteBrRestore() - Instance=[PIP] - May not have been configured.

Is there anything on the commvault that I may have overlooked??

Thanks again

Andy

[Former Member]

Hallo,

I don't use parameter "srccrossdbname" but the main difference is that I restore PIP by  running brrestore from the command line on PIQ.

You will need to copy backPIP.log and the backup log file (e.g. b...anf") across to PIQ.

Rename backPIP.log to backPIQ.log and execute brrestore as orapiq, e.g.

     brrestore -b b.....anf -m full

Regards,

Thomas.

[Former Member]

Ah I see, so you don't actually run from the Commvault GUI.

You always run from the command line then??

Was there a reason for this? I would have thought you could use the GUI did you

try and fail like me?

Thanks

Andy

[Former Member]

Hi Thomas,

Nearly there now.....

Ran form the command line and it ran for a little while so I thought I had cracked it...

Then an error saying

iPath=[/oracle/PIQ/sapdata1/sr3_7] qPath=[/oracle/PIQ/sapdata1/sr3_7] pPath=[/oracle/PIQ/sapdata1/sr3_7]

Out of place restores to different destination directories is not supported.

This looks like a new datafile that was added onto production PIP a while back.

So I created the directory myself but it sill fell over

did you have any problems like this?

Again I'm really sorry to bother you I hope you don't mind me asking

Thanks

Andy