start database in NOARCHIVELOG mode

[Former Member]

Hi,

I would like to know if there is a way to set some oracle paramete so that each time database is restarted, it comes up in NOARCHIEVELOG mode.

Regards,

Andrija

[Former Member · Accepted solution]

this will work for sure, but this is not what I need. This is is something that have to be executed each time we startup Oracle. What I would need is a way to make Oracle always start up in NOARCHIVELOG mode.

[former_member204746 · Accepted solution]

try this:

sqlplus "/ as sysdba"

alter database backup controlfile to trace as 'C:\trace.sql'

exit

edit c:\trace.sql, only keep the first section (up to CHARACTER SET WE8DEC with semi-comma)

delete empty lines, empty lines start with "--".

then edit ARCHIVELOG to NOARCHIVELOG.

then:

sqlplus "/ as sysdba"

shutdown immediate;

@c:\trace.sql

if you get "controlfile created":

alter database open;

shutdown immediate;

startup;

exit

good luck

[fidel_vales · Accepted solution]

Hi,

I'm afraid that what you want does not "exist".

the db will start always in the mode it was when shutdown.

then you need is a "startup" script to change always the mode to -noarchivelog.

Note the following:

1) Running a database in noarchivelog mode is a recipe for disaster

2) you will not be able to recover the database from media error

3) running a production DB in noarchivelog mode is not supported by SAP

[Former Member]

your answer is completelly wrong.

Please check description of log_archive_start parameter in documentation:

LOG_ARCHIVE_START

Parameter type

Boolean

Default value

false

Parameter class

Static

Range of values

true | false

Real Application Clusters

Multiple instances can have different values.

LOG_ARCHIVE_START is applicable only when you use the redo log in ARCHIVELOG mode. It indicates whether archiving should be automatic or manual when the instance starts up.

Values:

true

Indicates that archiving is automatic

false

Indicates that the database administrator will archive filled redo log files manually

The SQL*Plus statements ARCHIVE LOG START or ARCHIVE LOG STOP override this parameter.

In ARCHIVELOG mode, if all online redo log files fill without being archived, Oracle issues an error and suspends instance operations until the necessary archiving is performed. This delay is more likely if you use manual archiving. You can reduce its likelihood by increasing the number of online redo log files.

To use ARCHIVELOG mode while creating a database, set this parameter to true. Normally, a database is created in NOARCHIVELOG mode and then altered to ARCHIVELOG mode after creation.

[former_member204746]

completely wrong... hmmm... not really but not what you expected.

try this then:

startup mount

alter database noarchivelog;

alter database open;

[former_member204746]

set log_archive_start to FALSE (in initSID.ora or SPFILE)