How to modify an Oracle database as a non-archive mode

Action steps are as follows:

Step 1 Log on to the server with an Oracle user and execute the following command into Sqlplus.

Oracle@smgwrpt:~> sqlplus "/as sysdba"

Step 2 View the current archive mode for 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 2

Next log sequence to archive 2

Current Log Sequence 4

From the above information, the database is currently in archive mode (the screen display information is for informational purposes only).

If the database is not currently in archive mode, you can skip the following action.

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Step 3 Before you modify the database archive mode, you need to close the database.

sql> shutdown Immediate

You cannot use abort or power off to close the database here.

Step 4 Starts the database in the Mount state again.

Sql> Startup Mount

Step 5 After you successfully start the database, modify the database to be not in archive mode.

sql> ALTER DATABASE Noarchivelog;

Database altered.

Learn from the above information that the database archive schema has been modified successfully.

Step 6 enables the database to work properly.

sql> ALTER DATABASE open;

Database altered.

Learn from the above information that the database was enabled successfully.

Step 7 View the current archive mode of the validation database again.

Sql> Archive Log List

Database log mode No Archive mode

Automatic Archival Disabled

Archive Destination Use_db_recovery_file_dest

Oldest online log sequence 3

Current log Sequence 5

From the above information to know that the database is currently in a non-archive mode, the modification succeeded.

This article is from "Richard's notes-accumulate micro Cheng" blog, please be sure to keep this source http://zxf261.blog.51cto.com/701797/762043