1) Shutdown the database using Shutdown normal/immediate
2) Mount the database using startup mount
3) Issue: Alter database noarchivelog;
4) Issue: Alter database open;
Now you are in noarchivelog mode.
Optionally, you can remove all LOG_ARCHIVE_* parameters from your intialization file.
No comments:
Post a Comment