Hello Guru,
we encountered issue in starting up the database. It cannot open the database. Below are the only errors we got when starting the DB. The issue arise only after we reboot the server after the schedule offline backup. After that when we trying to start the db "alter database open" hangs and only resulting to ORA-01155. We tried to shutdown normally as the process is hanging but its also not working, only our last resource is to use "shutdown abort".
No other found in the database alert log. also tried to reboot the machine several time and it didnt turn out. Any idea on the issue?
oracle version: 11g
Mon May 01 23:46:45 2011
alter database mount
Mon May 01 23:46:49 2011
Successful mount of redo thread 1, with mount id 173145456
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Mon May 01 23:50:27 2011
alter database open
Errors in file /oracle/DEV/saptrace/diag/rdbms/dev/DEV/trace/DEV_m000_475160.trc:
ORA-01155: the database is being opened, closed, mounted or dismounted
mcphoenix
Hello Mcphoenix,
could you please post the following information:
1) Content of the file "/oracle/DEV/saptrace/diag/rdbms/dev/DEV/trace/DEV_m000_475160.trc".
2) Start your database and run the following SELECTs (even the startup failed):
SQL> set linesize 900 SQL> SELECT NAME, OPEN_MODE, CONTROLFILE_TYPE, CURRENT_SCN FROM V$DATABASE; SQL> SELECT FILE#, STATUS, CHECKPOINT_CHANGE# FROM V$DATAFILE; SQL> SELECT FILE_ID, ONLINE_STATUS FROM DBA_DATA_FILES;
Please post the SQL output also in "" tags.
Regards
Stefan
Hi,
Can you please explain how you proceed to stop your database before starting the offline backup?. And the tool / procedure that you made the backup (Backup Agent? Cold copy?).
Please check if you do not have any .TRC files inside backtrace / userdump folders generated during your backup windows.
Kind regards,
Add a comment