Ops Center dbbackup

[cs3472]

Hi all,

Inorder to backup dbbackup.bat what are all the changes should be made in the dbbackup.bat script?

Also how to configure the backup of dbbackup.bat file?

Thanks in advance.

[Will_Restore · Accepted solution]

Have you seen this technote?

http://www.symantec.com/business/support/index?page=content&id=TECH129948

Running the command requires directory name (where the backup files will be sent) and optional logfile name.  I don't see the need to modify the script.

[cs3472]

Thanks wr... 

Sorry for taking long time... I have already seen this TN before implementing the dbbackup file.... 

The below TN tells that

 "The backup script creates vxpmdb.db, symcOpscache.db, and vxpmdb.log (if it exists) in the backup directory that you specified."

http://www.symantec.com/business/support/index?page=content&id=HOWTO42869

But these files are not present when I am backing up my dbbackup. They were missing.

Any suggestions?

Thanks for the help

[Will_Restore]

Please post the full command you used and the output.

[cs3472]

This is the command which I ran..

C:\Program Files\Symantec\OpsCenter\server\bin>dbbackup.bat "F:\SAP"

PFA the screenshot of the output

[watsons]

There is a space between the main command path. 

You should run it as, after you create the folder F:\SAP :

"C:\Program Files\Symantec\OpsCenter\server\bin>dbbackup.bat" F:\SAP

[Will_Restore]

and if you really want the files to go to SAP Report directory

"C:\Program Files\Symantec\OpsCenter\server\bin\dbbackup.bat"  "F:\SAP Report"

[cs3472]

Thanks watsons & wr

PFA the files that are being captured when I execute the above command as said.

I dont see the file symcOpscache.db being captured. 

Also want to make sure with the file size of the vxpmdb.db. 

[Will_Restore]

Does it exist in production directory?

C:\Program Files\Symantec\OpsCenter\Server\DB\Data\

[cs3472]

Hi wr,

No... It does not exist in the directory.

[Will_Restore]

That is why it's not in the backup directory.  It doesn't exist. 

OK, let's make sure it's not somewhere else...

cd \

dir /s  symcOpscache.db 

Maybe it was moved to another location.  Also look at filepath listed in:

 C:\Program Files\Symantec\OpsCenter\server\db\conf\databases.conf

[cs3472]

I dont see the file name symcOpscache.db listed in the database.conf file. Also the when I searched for the file, it showed file not found.

[Will_Restore]

File not found. 

Only hope then is to restore from filesystem backup.   See this technote:

http://www.symantec.com/business/support/index?page=content&id=TECH160970

[cs3472]

Unfortunately I am not able to restore database files from the last known good backup.

The last successful backup doesnt contain the file which we need here.

Is there any alternate way to get the file?

[Will_Restore]

I suppose the only thing left to do is reinstall OpsCenter

[cs3472]

 Ooppssss!!! Not sure how far that is possible in my case...

But thank you so much wr for the suggestions which you gave... 

Will see if there is any way to get it this done and let you know.. 

Cheers