Disaster Recovery

[Ramma]

Hi,

We have a test server where SAP has crashed too many people have messed up with this server. All we have is an old tape backup and a lot of archive logs (from day1 !!!) that were moved to a safer location. Is it possible to recover?? If so what are the steps??

Regards,
Ramma.

[Golfi]

What do you mean that people haved "messed up with this server"? If people hosed it over a period of time, you probably don't want to recover it, but maybe look at refreshing (system copy) from a healthier system.

If this is causing problems, I would also suggest your backup strategy (and/or monitoring) needs a review.

[Ramma]

This system was used for training and lot of users have made config changes and stuff that they will love to get back. Some trainees have tried to use BRTOOLS and messed up the system now. Even though system copy is possible it won't have all the config changes done by the users. If there is a way to recover all the files from the tape and then apply the archive logs to a point of time (say two weeks ago) the system should be fine.

[Portal]

Do you have a valid backup?

Then, restore from this tape and apply redologs. I suggest you read http:/servuice.sap.com/dbaora and look for recovery documents from SAP.

[Golfi]

Originally Posted by Portal

Do you have a valid backup?

Then, restore from this tape and apply redologs. I suggest you read http:/servuice.sap.com/dbaora and look for recovery documents from SAP.

Portal makes a good suggestion, but it's at times like this you need a more experience Basis guy.

Try http:/service.sap.com/dbaora - it will work better than Portal's suggestion

[Portal]

Even better, try http://service.sap.com/dbaora (there was also a "/" missing!)

[Ramma]

Thanks a lot for the replies gurus.... will look into both the options and report back.

[Ramma]

Hi,

I did a system refresh with my PRD backup on this test system. Everything went on well until I tried to start SAP

The dev_wo shows the following error... looks like a password issue.. how to overcome this??
Do I have to run the ORADBUSR.SQL ??? The User/Password in Prd was different from the test.

C Logon as OPS$-user to get SAPDPE's password
C Connecting as /@DPE on connection 0 (nls_hdl 0) ... (dbsl 640 070208)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 WE8DEC 1 04679608 092AB2A8 092AAD10
C Attaching to DB Server DPE (con_hdl=0,svchp=092AAC64,srvhp=0467DC24)
C Starting user session (con_hdl=0,svchp=092AAC64,srvhp=0467DC24,usrhp=046 86838)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
[dboci.c 4508]
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 11410]
C Try to connect with default password
C Connecting as SAPDPE/<pwd>@DPE on connection 0 (nls_hdl 0) ... (dbsl 640 070208)
C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
C 0 WE8DEC 1 04679608 092AB2A8 092AAD10
C Starting user session (con_hdl=0,svchp=092AAC64,srvhp=0467DC24,usrhp=046 86838)
C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
[dboci.c 4508]
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 11410]
B ***LOG BY2=> sql error 1017 performing CON [dbsh#3 @ 1204] [dbsh 1204 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#3 @ 1204] [dbsh 1204 ]
B ***LOG BY2=> sql error 1017 performing CON [dblink#3 @ 428] [dblink 0428 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#3 @ 428] [dblink 0428 ]
M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1282]
M in_ThErrHandle: 1
M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9696]
M

[Golfi]

Ramma wrote:
Do I have to run the ORADBUSR.SQL

Yes.

Regards,
Golfi.

[Ramma]

Hi

I ran Oradbusr.sql followed by sapdba_role.sql.
the contents of the sapdba_role.log is attached

Connected.

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.


old 1: grant ALL on &User..SDBAH to sapdba
new 1: grant ALL on SAPR3.SDBAH to sapdba
grant ALL on SAPR3.SDBAH to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..SDBAD to sapdba
new 1: grant ALL on SAPR3.SDBAD to sapdba
grant ALL on SAPR3.SDBAD to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBAML to sapdba
new 1: grant ALL on SAPR3.DBAML to sapdba
grant ALL on SAPR3.DBAML to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBARCL to sapdba
new 1: grant ALL on SAPR3.DBARCL to sapdba
grant ALL on SAPR3.DBARCL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBAFID to sapdba
new 1: grant ALL on SAPR3.DBAFID to sapdba
grant ALL on SAPR3.DBAFID to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBAEXTL to sapdba
new 1: grant ALL on SAPR3.DBAEXTL to sapdba
grant ALL on SAPR3.DBAEXTL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBAREOL to sapdba
new 1: grant ALL on SAPR3.DBAREOL to sapdba
grant ALL on SAPR3.DBAREOL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBABARL to sapdba
new 1: grant ALL on SAPR3.DBABARL to sapdba
grant ALL on SAPR3.DBABARL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBADFL to sapdba
new 1: grant ALL on SAPR3.DBADFL to sapdba
grant ALL on SAPR3.DBADFL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBAOPTL to sapdba
new 1: grant ALL on SAPR3.DBAOPTL to sapdba
grant ALL on SAPR3.DBAOPTL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBASPAL to sapdba
new 1: grant ALL on SAPR3.DBASPAL to sapdba
grant ALL on SAPR3.DBASPAL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBABD to sapdba
new 1: grant ALL on SAPR3.DBABD to sapdba
grant ALL on SAPR3.DBABD to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBABL to sapdba
new 1: grant ALL on SAPR3.DBABL to sapdba
grant ALL on SAPR3.DBABL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBATL to sapdba
new 1: grant ALL on SAPR3.DBATL to sapdba
grant ALL on SAPR3.DBATL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBAOBJL to sapdba
new 1: grant ALL on SAPR3.DBAOBJL to sapdba
grant ALL on SAPR3.DBAOBJL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBAPHAL to sapdba
new 1: grant ALL on SAPR3.DBAPHAL to sapdba
grant ALL on SAPR3.DBAPHAL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBAGRP to sapdba
new 1: grant ALL on SAPR3.DBAGRP to sapdba
grant ALL on SAPR3.DBAGRP to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBAERR to sapdba
new 1: grant ALL on SAPR3.DBAERR to sapdba
grant ALL on SAPR3.DBAERR to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBATRIAL to sapdba
new 1: grant ALL on SAPR3.DBATRIAL to sapdba
grant ALL on SAPR3.DBATRIAL to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBSTATC to sapdba
new 1: grant ALL on SAPR3.DBSTATC to sapdba
grant ALL on SAPR3.DBSTATC to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBSTATTORA to sapdba
new 1: grant ALL on SAPR3.DBSTATTORA to sapdba
grant ALL on SAPR3.DBSTATTORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBSTATIORA to sapdba
new 1: grant ALL on SAPR3.DBSTATIORA to sapdba
grant ALL on SAPR3.DBSTATIORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBSTATHORA to sapdba
new 1: grant ALL on SAPR3.DBSTATHORA to sapdba
grant ALL on SAPR3.DBSTATHORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBSTAIHORA to sapdba
new 1: grant ALL on SAPR3.DBSTAIHORA to sapdba
grant ALL on SAPR3.DBSTAIHORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBMSGORA to sapdba
new 1: grant ALL on SAPR3.DBMSGORA to sapdba
grant ALL on SAPR3.DBMSGORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..DBCHECKORA to sapdba
new 1: grant ALL on SAPR3.DBCHECKORA to sapdba
grant ALL on SAPR3.DBCHECKORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant ALL on &User..MLICHECK to sapdba
new 1: grant ALL on SAPR3.MLICHECK to sapdba
grant ALL on SAPR3.MLICHECK to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..TGORA to sapdba
new 1: grant SELECT on SAPR3.TGORA to sapdba
grant SELECT on SAPR3.TGORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..IGORA to sapdba
new 1: grant SELECT on SAPR3.IGORA to sapdba
grant SELECT on SAPR3.IGORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..TSORA to sapdba
new 1: grant SELECT on SAPR3.TSORA to sapdba
grant SELECT on SAPR3.TSORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..TAORA to sapdba
new 1: grant SELECT on SAPR3.TAORA to sapdba
grant SELECT on SAPR3.TAORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..IAORA to sapdba
new 1: grant SELECT on SAPR3.IAORA to sapdba
grant SELECT on SAPR3.IAORA to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..SVERS to sapdba
new 1: grant SELECT on SAPR3.SVERS to sapdba
grant SELECT on SAPR3.SVERS to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..DD02L to sapdba
new 1: grant SELECT on SAPR3.DD02L to sapdba
grant SELECT on SAPR3.DD02L to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..DD09L to sapdba
new 1: grant SELECT on SAPR3.DD09L to sapdba
grant SELECT on SAPR3.DD09L to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..DDNTT to sapdba
new 1: grant SELECT on SAPR3.DDNTT to sapdba
grant SELECT on SAPR3.DDNTT to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..DDART to sapdba
new 1: grant SELECT on SAPR3.DDART to sapdba
grant SELECT on SAPR3.DDART to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..DARTT to sapdba
new 1: grant SELECT on SAPR3.DARTT to sapdba
grant SELECT on SAPR3.DARTT to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..DBCHK to sapdba
new 1: grant SELECT on SAPR3.DBCHK to sapdba
grant SELECT on SAPR3.DBCHK to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 1: grant SELECT on &User..DBDIFF to sapdba
new 1: grant SELECT on SAPR3.DBDIFF to sapdba
grant SELECT on SAPR3.DBDIFF to sapdba
*
ERROR at line 1:
ORA-00942: table or view does not exist


old 12: Statement := 'grant SELECT on &User..RSNSPACE to sapdba';
new 12: Statement := 'grant SELECT on SAPR3.RSNSPACE to sapdba';
old 21: Statement := 'grant SELECT on &User..RSPSPACE to sapdba';
new 21: Statement := 'grant SELECT on SAPR3.RSPSPACE to sapdba';

PL/SQL procedure successfully completed.