Skip to Content
0
Dec 05, 2008 at 04:44 AM

noarchivelog mode in oracle

604 Views

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

______________________________________________________________________________