VerifyDB online on Linux

[Former Member]

Hi!

I would like to execute a verify database job from DB13 for my SAP system on Linux.

By doing so the following error comes up:

SAP system is running or SAP user is connected to database <sid> - database cannot be shut down.

Please shut down SAP system first or use the 'offline_force' option.

Question:

1) Can this job (verifyDB) be executed with running SAP system and Database?

2) If not, what is the right sql commando for the execution of this job?

brbackup -w only_dbv -u / -offline_force

Thank you very much!

[markus_doehr2 · Accepted solution]

> 1) Can this job (verifyDB) be executed with running SAP system and Database?

No, the database (and hence the SAP system) has to be shut down.

> 2) If not, what is the right sql commando for the execution of this job?

> brbackup -w only_dbv -u / -offline_force

This will shut down the database, execute the verify and start the database again. The SAP system can stay up but users won't be able to work.

Markus

[Former Member · Accepted solution]

No, the database (and hence the SAP system) has to be shut down.

Sorry to disagree, but that's not quite right.

Actually the entry for backup_type in init<SID>.sap file will be used.

If it is offline, then yes, the error message from above will come up.

If it is online, then dbverify will run while Oracle and SAP are up and running.

regards

[Former Member · Accepted solution]

Hi!

Many thanks!

Can I change the entry for backup_type in init<SID>.sap file from offline to online on the fly or should I restart afterwards SAP system?

[Former Member · Accepted solution]

No restart necessary.

And keep in mind: with backup_type = online in init<SID>.sap you may still choose between online or offline backup in DB13. But no choice for verifyDB.

PS:

Another way: You may create a copy of init<SID>.sap with a different name. In DB13 you my choose the profile, init<SID>.sap or init<SID>.sap1 or whatever.

Edited by: Joe Bo. on Nov 5, 2009 2:03 PM

[Former Member · Accepted solution]

Hi!

Thank you again!

> And keep in mind: with backup_type = online in init<SID>.sap you may still choose between online or offline backup in DB13. But no choice for verifyDB.

I changed the value of backup_type to online.

Now I would like to plan a verifyDB job from DB13 in online mode as well online backup from db13.

Do I need choise for verifyDB by planing this jbo from DB13?

Thank you!

[Former Member · Accepted solution]

Not sure if I correctly understood your last question.

In DB13 choose verifyDB, and then all the defaults.

From your original question I gather that you already did so. The same now!