noarchivelog mode in oracle

[former_member759680]

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

______________________________________________________________________________

[Former Member · Accepted solution]

Shutdown immediate;

startup mount;

alter databse noarchivelog;

Alter database open;

then You can shutdown & startup

to check --> archive log list;

Br -Sreeram

[fidel_vales]

Hi,

A little aside note.

Remember that Production systems are not supported in NOARCHIVELOG mode.

Remember that you cannot perform online backups.

Remember that you can only perform crash recovery and in case of any other type is needed you will lose data.

[former_member759680]

Thanks to both of you!

[Former Member]

Hi,

Try to use Brtools - 1. Instance Management - 3. Alter Database Instance - c- continue - 4. Set noarchivelog mode - 3. Force -

Database instance DBE will be remounted now with mode 'IMMEDIATE'

Now your database will be shut down and restart with noarchive log mode