Oracle 12c Archive Mode change

1.shutdown Normal or shutdown immediate close the database

Sql*plus:release 12.1.0.1.0 Production on Monday December 15 15:49:47 2014

Copyright (c) 1982, Oracle. All rights reserved.

Connect to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0-64bit Production

with the partitioning, OLAP, Advanced Analytics and Real application testing opt ions

sql> shutdown immediate;

The database is closed.

The database has been uninstalled.

The ORACLE routine has been closed.

2. Start the Oracle database to Mount state

sql> startup Mount;

The ORACLE routine has been started.

Total System Global area 2572144640 bytes

Fixed Size 2405952 bytes

Variable Size 687868352 bytes

Database buffers 1879048192 bytes

Redo buffers 2822144 bytes

The database is loaded.

3. Enable or stop the archive mode

If you want to enable archive mode, use the ALTER DATABASE Archivelog command here.

If you want to turn off archive mode, use the ALTER DATABASE Noarchivelog command here.

sql> ALTER DATABASE Archivelog;

The database has changed.

sql> ALTER DATABASE open;

The database has changed.

sql> archive log list;

Database log Mode archive mode

Auto-Archive Enabled

Archive End Use_db_recovery_file_dest

Oldest online log sequence 16

Next Archive log sequence 18

Current log Sequence 18

The above is a description of how to open or close the archive mode of an Oracle 12c database, and hopefully it will help you.

This article is from the "Xianyunyehe" blog, make sure to keep this source http://228110.blog.51cto.com/218110/1590129

Oracle 12c Archive Mode change