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