Steps when the database state is down:
1. Login to sqlplus
-sqlplus /nolog
-connect / as sysdba
2. The db must be mounted EXCLUSIVE and not open for operation
–startup mount;
3. Check the log mode status of the database
–select log_mode from v$database;
4. Setting it to noarchivelog mode
–alter database noarchivelog;
5. Setting db open for user operation
–alter database open;
6. Reverting back to archivelog mode
–alter database archivelog;
thank you so much
Thankx a lot
It’s very straightforward to find out any matter on web
as compared to books, as I found this article at this web page.
I am regular reader, how are you everybody?
This paragraph posted at this site is in fact pleasant.