BRBACKUP/DBVerify restarts DB

[Former Member]

Hi all,

I run DBVerify using the following BRBACKUP command :

brbackup -u / -c force -w only_dbv -p initSID.sap -m ALL

backup_type is set to 'online' in the initSID.sap

So DB is open when I run DBVerify.

The execution is OK but the problem is, if I want to stop the instance while DBVerify is running, the brbackup process is not killed and it starts itself the database.

The following messages appear in the dbv log :

BR0395I Verifying /oracle/SID/sapdata1/id1_73/id1.data73 using DBVERIFY...              
BR0268E Asynchronous execution of program interrupted, exit status: 9                   
BR0267E Asynchronous execution of program failed                                        
BR0396I Verification of /oracle/SID/sapdata5/id1_82/id1.data82 using DBVERIFY successful
BR0280I BRBACKUP time stamp: 2010-09-08 01.15.27                                        
BR0063I 76 of 132 files processed - 2323963.859 MB of 3129504.266 MB done               
BR0204I Percentage done: 74.26%, estimated end time: 0:17                               
BR0001I *************************************_____________                              
BR0280I BRBACKUP time stamp: 2010-09-08 01.15.27                                        
BR0261E BRBACKUP cancelled by signal 13                                                 
BR0280I BRBACKUP time stamp: 2010-09-08 01.15.28                                        
BR0301W SQL error -12612 at location BrDbDisconnect-1, SQL statement:                   
'COMMIT RELEASE'                                                                        
ORA-12612: TNS:connection is busy                                                       
BR0327W Disconnect from database instance SID failed                                    
BR0280I BRBACKUP time stamp: 2010-09-08 01.15.30                                        
BR0304I Starting and opening database instance SID ...                                  
BR0280I BRBACKUP time stamp: 2010-09-08 01.16.41                                        
BR0305I Start and open of database instance SID successful

Is that the normal behavior of brbackup/dbverify (with the options I use)

Is there any way that brbackup/dbverify does not start the database ?

Regards,

[volker_borowski2]

Hi,

yes, this is normal behavior of brbackup.

It tries to leave the DB as it found it upon startup.

When the DB was online, it tries to start it up in the end.

The wrong behavior is to shut it down while brbackup is still running.

Why do you do it that way and do not stop brbackup before stop of the instance?

If you use brtools 7.1, you could try to abort a running brbackup with "brbackup -g stop"

Volker

[Former Member]

Thanks for help !

>

>
> Why do you do it that way and do not stop brbackup before stop of the instance?
> 
> Volker

I'll set up that .

[Former Member]

what's the value for below parameter.

sqlnet.expire_time ( sqlnet.ora )

connect_timeout.listener ( listener.ora )

try to set to 0 and restart your DB and re-run dbverify.

[Former Member]

>

> what's the value for below parameter.
> 
> sqlnet.expire_time ( sqlnet.ora )
> connect_timeout.listener ( listener.ora )
> 
> try to set to 0 and restart your DB and re-run dbverify.

SQLNET.EXPIRE_TIME = 10

CONNECT_TIMEOUT_LISTENER = 10

But when I have stop the instance, I have stop the listener too.

Regards,