Home » RDBMS Server » Server Administration » databse got close
databse got close [message #234273] Mon, 30 April 2007 12:30 Go to next message
IT Guru
Messages: 59
Registered: January 2007
I am fundamental 1 student.
Was trying all different configuration to see all available type of status in V$logfile.
I have created new redo log group & then deleted it file from OS.
After manually tried to switch to that group. From group 1 to group 4 [ switch logfile]
Found I database was close & I was disconnected.
[Wasn’t database suppose to be hault, till I clear redo log group? Why it got shutdown? Same thing happen when I open current redo group file from os made some changes & saved the file. Database got close instead of getting haulted.

When reconnected & start database.
Started in mount stage.
I found my last redo log file[ of group 1] was having status STALE in V$logfile.
Where as that file which I had deleted was having status blank which indicated currently in use.
New status type found in V$log.
Group was having status INVALIDATED which is not there in my oracle university book.
I deleted group 4, who’s redo file already deleted at OS level.
I did not clear group which was in INVALIDATED stage.
& reopen database. Got open in normal read-write mode.

& just shutdown the database & reopen it.

[EDIT] Removed [code] tags.

[Updated on: Mon, 30 April 2007 15:33] by Moderator

Report message to a moderator

Re: databse got close [message #234275 is a reply to message #234273] Mon, 30 April 2007 12:40 Go to previous message
Michel Cadot
Messages: 63910
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the question is?

Btw, when you use code tags, split your lines at at most 80 characters. Not everybody can display or read 200 character lines.

Previous Topic: SQL Server, connection to oracle error
Next Topic: LONG to CLOB
Goto Forum:

Current Time: Fri Oct 21 12:23:31 CDT 2016

Total time taken to generate the page: 0.09735 seconds