SAPMMC not getting up

[Former Member]

Hello Experts,

I had run dbvarify offline backup and after that system is not getting up...can somebody suggest me some guidance in order to solve the problem.

My system is ECC 5 on Windows & oracle 9.2.

Thanks in advance.

[Former Member]

I think backup still not completed , pls check from OSlevel (root user)

ps -ef|grep brbackup.

the above command will show offline backup is running or not .

kill -9 pid no ... to kill the current backup .

then try to start DB manually ,

sqlplus /nolog

connect /as sysdba

startup

it might be help.

[Former Member]

If backup has not completed then why you want to kill the backup? and why you need root access to perform ps -eaf command.

Database won't comeup if you kill the backup, you have to also end the backup manually.

[Former Member]

Thank you all for ur reply.

I think it is right that backup still not completed and need to end it maually.

Can you hint me how I can do it in windows environmen.

Awaiting

[Former Member]

Hi,

I think it is right that backup still not completed and need to end it maually.
Can you hint me how I can do it in windows environmen.

I would suggest, let the backup complete...

If still you need to bring up the system, follow below steps.

1. End all "brbackup" process using Task Manager...

2. Open command prompt and Login to Oracle..

C:\sqlplus / as sysdba:

SQL> startup mount;

SQL> alter database end backup;

SQL> alter database open;

SQL> exit

if still SAP is not coming up, just STOP and START SAP using SAPMMC.

Regards.

Rajesh Narkhede

[Former Member]

How frequently you schedule offline backup verify?

[Former Member]

After recovering some datafiles it is getting up with MMC but when i try to connect sap it gives error as "Database interface failed during read.........................*********"

Can you guide me what would be the issue ?

[Former Member]

Your database wont come online if you have not fully recover.

[Former Member]

I suggest you follow below steps.

Frist check the database alert log file (alert_<SID>.log (folder : /oracle/<SID>/saptrace/background) is there are any errors?

from SQL command prompt try to start the database.

Start the listener.

Try to connect database using R3trans -d (you must get return code 0) if not then there will be trans.log file create under same location from where you ran R3trans -d)

then Start SAP.

[Former Member]

Please consult the log files of the failed startup and provide us with some further information otherwise we can't tell you anything.