SAP System re-build

[Former Member]

Hello,

We installed SAP system with Oracle and windows combination. Triggered brbackup and FS backup.

Unfortunately server is crashed due to harddisk failure. We want to rebuild the system with FS and backup which we took using brbackup.

Please suggest here how to proceed and if any document that will guide.

Best Regards,

Sri

[Former Member]

Hello Everyone,

Thanks for your quick response.

I have DB backup which was took by brtools and FS backup for /usr/sap/<SID> only.

My question is

1) FS restore is done and registered the SAP<SID> services

2) DB software installtion is done from there i am not sure how to proceed

Suggest me the steps to restore the backup took by BRtools .

Regards,

Sri

[former_member188883]

Hi Sridhar,

Copy the backupSID.log file as well as backup file with .aft or .afn extension to sapbackup folder

Login with sidadm

execute

brrestore -m full -b <path of backup file with.aft /,afn extension>

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Installed Oracle Server software using sapserver.cmd, then copied backupSID.log and .afd files to sapbackup as mentioned above.

Restore was asking the additional folders sapdata2, sapdata3, sapdata4 to create, but in source there was only sapdata1 folder.

Now the sqlplus connection is failing with below error

SQL> connect sys as sysdba

Enter password:

ERROR:

ORA-12560: TNS:protocol adapter error

Please suggest me how to proceed to resolve the TNS protocol adapter error.

LISTENER is configured using netca but still getting the issue.

Regards,

Sri

[former_member188883]

Hi Sridhar,

Restore was asking the additional folders sapdata2, sapdata3, sapdata4 to create, but in source there was only sapdata1 folder.

If source system has sapdata1, backup log also should have only sapdata1. Please check in backup log how many sapdata folders are backed up.

If possible create these folders and proceed with restore.

sqlplus will not work at the moment as listener may not be running. you need to start listener service.

from services.msc

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Restore was completed with warnings , now the problem i am facing is TNS protocol adapter error.

LISTENER is running fine, not sure what was the wrong here.

Suggest me .

Best Regards,

Sri

[Reagan]

Sorry I don't understand your issue.

If you have restored the database and then start the database.

If the database is already started then check the status of the database.

You need to provide more details with the error message and relevant trace files for others to help you.

Regards

RB

[Former Member]

Hello RB,

When i am trying to logging into database using the below command getting the TNS protocol adapter error:

C:\Documents and Settings\***adm>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 24 15:16:32 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect sys as sysdba

Enter password:

ERROR:

ORA-12560: TNS:protocol adapter error

suggest here.

Regards,

Sri

[Reagan]

What happens when you run this:

sqlplus "/as sysdba"

Regards

RB

[Former Member]

When i run sqlplus "/as sysdba" getting the below error:

C:\Documents and Settings\***adm>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 24 15:53:38 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name: SAPSR3

Enter password:

ERROR:

ORA-12560: TNS:protocol adapter error

[daniel_macias]

Hi SRIDHAR M,

Check environment variables of the user that connects to the database.

ORACLE_SID is correct?

Regards,

Dani

[Former Member]

Hi Dani,

Below are the environment variables set it for sidadm

DBMS_TYPE

ora

dbs_ora_schema    SAPSR3

dbs_ora_tnsname    XXX

ORACLE_HOME	D:\oracle\XXX\102
ORACLE_SID	XXX

SAPDATA_HOME    D:\oracle\XXX

TNS_ADMIN

D:\usr\sap\XXX\SYS\profile\oracle

Regards,

Sri

[daniel_macias]

Hi SRIDHAR M,

Check database services, PATH environment variable and try to execute tnsping XXX.  Also you can check '/oracle/XXX/10204/network/admin' files (listener.ora, tnsnames.ora), if has correct parameters.

Regards,

Dani