Hello,
When I try to set my database in noarchivelog mode, it asks me to mount it and make sure its not open in any instance.
I have mounted it and this is the only oracle instance on the server, still it doesn't go in noarchivelog mode.
Please advise.
___________________________________________________________________________
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted
SQL> ALTER DATABASE NOARCHIVELOG;
ALTER DATABASE NOARCHIVELOG
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any
instance
______________________________________________________________________________