cancel
Showing results for 
Search instead for 
Did you mean: 

how to use (Verify database) in DB13.

Former Member
0 Kudos

Dear all,

I tried to use (Verify database) in DB13 but it doesnt works. It says that the instance is up. HOw do I use this option in DB13.

Thanx in advance.

Lalit Rana

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello

I don't remember if it's in the init.sap or in the SDBAC table, but you have to set the parameter for your backup to offline_force

Regards

François

Former Member
0 Kudos

Hello Lalit

Please Try This

For Update Stats - brconnect -u system/12345678 -c -f stats -t ALL

For CheckDB - brconnect -u system/12345678 -c -f check

For CleanuP - brconnect -u system/12345678 -c -f cleanup

system - your SAP System

12345678 - Default Password

please specify your operation system ( For Example if your O/S is Windows - 2003 Server then by Cmd level go to the oracle drive and run this command in command mode )

For example - 😧 brconnect -u system/12345678 -c -f stats -t ALL

Try It & See

former_member204746
Active Contributor
0 Kudos

you should not put a password in table SDBAC (table that DB13 uses)

it should be:

brconnect -u /

note that there are no password nor username. you need to setup OPS$ mechanism in order for this to work.

Former Member
0 Kudos

I think SDBAC table will help in resolving my problem. Thanx François.

Amit

Former Member
0 Kudos

Hi Amit,

When you tick the verification checkbox in DB13, check if the brbackup command has changed with any of the following parameters:

brbackup -w use_dbv

(Database backup with subsequent restore to a temporary directory (compress_dir) and check on the Oracle block consistency)

brbackup -w only_dbv

(Online check of block consistency on the database files without backup)

Regards,

Nisch