Restore DB2 DR server

[Former Member]

Hi Everyone,

I have restored full backup in DR server from PRD. I have message successfully completed.When i am trying start sap. R3trans is failed to connect. it is

DB2 -Database,OS- Linux.I am getting below error.

SQL1026N  The database manager is already active.

Activate database failed

R3trans connect failed

DBstartup failed

Regards,

Chandu

[former_member182657]

Hi Chandu,

Please share trans.log file for analysis.

Regards,

Gaurav

[Former Member]

Hi Everyone,

In trans.log it showing

Error in DB6connect

Dbsl connect Db6 ( sql connect ); A connection to or activiation of database "SID" cannot

be made because of ROLL-Forward pending SQLSTATE=57019

ERROR in DB6connect

ERROR=>Dbsl connect to SID as 'sapsid' failed

no connect posssible: "DBMS = DB6     -----DB2DBFT = 'SID'"

regards,

chandu

[former_member182657]

Hi,

Please follow SAP Note  938522 - DB6: Migration to Version 9 of DB2

with SCN link

and link Db2 Roll-Forward Pending SQLSTATE=57019 Solution. How to Restore Database from online backup ~ Onlin...

Regards,

Gaurav

[former_member185239]

Hi Chandu,

You need to performed roll farwarding.

Run the beloc command and check whether the status.

db2 rollforward db <DBSID> query status

With Regards

Ashutosh Chaturvedi

[former_member185239]

Hi Chandu,

Which method are you using restore

326691 - DB6: 'BACKUP' & 'REDIRECTED RESTORE' of a DB2 UDB EEE DB

You can performed the rollforward by the below command

Rollforward database <DBSID> to end of logs

db2 get snapshot for database on <DBSID>| grep -i rollforward

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Everyone,

When i am executing command db2 rollforward db sep query status.I am getting

 Rollforward Status
 Input database alias = test 
Number of nodes have returned status = 1
 Node number = 0 
Rollforward status = DB working
 Next log file to be read = S0000097.log
Log files processed = -
Last committed transaction = 2014-05-13-16.37.14.000000 

I checked in DR sever log is not available and checked in Prd server logs are available from S0000127 .How to solve it.

Regards,

Chandu


[former_member188883]

Hi Chandu,

You need to have all the log files starting from S0000097.log onwards.

If these files are not available at PRD then check your backups whether these logs files are backed up.

If available restore the same to DR site and then perform recovery.

Hope this helps.

Regards,

Deepak Kori

[JPReyes]

Depends what sort of backup are you using...

If you used and online backup that include logs you need to do the restore using the logtarget <path> switch...

then you can use db2 rollforward db <DBSID> to end of logs and stop overflow log path "(<path>)"

That should leave the database in a consistent state.

Regards, Juan

[Former Member]

Hi everyone,

I got S0000097.log from PRD and copied to dr server log_dir.Executed - db2 rollforward db SID end of logs and stop, db2 rollforward db sid complete.I got succesfull rollforward message.but still unable to start sap.

SQL1026N  The database manager is already active.

Activate database failed

R3trans connect failed

DBstartup failed

Regards,

Chandu

[Former Member]

HI Everyone,

We can solve this by taking offline fullbackup of  PRD and restore in DR server ?

Regards,

chandu

[former_member185239]

Hi chandu,

can you paste db2diag.log

With Regards

Ashutosh Chaturvedi

[former_member182657]

Hi,

Give full restart to system & retry again ,if issue persists please share startdb.log

Regards,

Gaurav

[Former Member]

Hi Gaurav,

I have restarted and tried to start sap.i'm getting same issue.I have checked in startdb.log. it is empty

Regards,

Chandu