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;
No comments:
Post a Comment
leave your message if you need help ...