Detailed steps for Oracle to change from archive mode to non-archive Mode

To change the non-archive mode of the Oracle database, you need to restart the database and modify it in mount mode. Step 1 closes the database in shutdownimmediate mode and Step 2 starts the database.

To change the non-archive mode of the Oracle database, you need to restart the database and modify it in mount mode. Step 1 closes the database in shutdown immediate Mode and Step 2 starts the database.

Detailed steps for Oracle to change from archive mode to non-archive Mode

[Date:] Source: Linux Author: mengzhaoliang [Font:]

To change the non-archive mode of an Oracle database, restart the database and modify it in mount mode.

1. Shut down the database in shutdown immediate Mode

2. Start the instance to the mount status.

3. Change the non-running mode and open the database

Procedure:

1. log on to the database to view the archiving status of the database.

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 2923

Next log sequence to archive 2925

Current log sequence 2925

2. Shut down the database

SQL> shutdown immediate;

3. Start the database to the mount status.

SQL> startup mount;

4. Start the archive Mode

SQL> alter database noarchivelog; (non-archive mode: alter database noarchivelog)

If an error is reported:

SQL> alter database noarchivelog;

Alter database noarchivelog

*

ERROR at line 1:

ORA-38774: cannot disable media recovery-flashback database is enabled

Close flashback first

SQL> alter database flashback off;

Database altered.

Change to non-archive Mode

SQL> alter database noarchivelog;

Database altered.

5 open the database

SQL> alter database open;

0

Sys, system, scott, hr users in Oracle

Migrate Oracle 10g R2 data in AIX to Oracle 11g R2 in the HP Cluster