archivelogmode oracle,请问如何进入Archivelog Mode模式？

我的一点订正

initSID.ora中的参数设置

LOG_ARCHIVE_START＝true

数据库应该在MOUNT状态下进行模式转换。

因为这是数据库的运行状态。

如果你不打开controlefile如何记录归档信息。

metalink的步骤如下

To Prepare to Switch Database Archiving Mode

============================================

1. Shut down the database instance.

SVRMGRL>  shutdown

An open database must be closed and dismounted and any associated

instances shut down before the database's archiving mode can be switched.

Archiving cannot be disabled if any datafiles need media recovery.

2. Backup the database.

This backup can be used with the archive logs that you will generate.

3. Perform any operating system specific steps (optional).

4. Start up a new instance and mount, but do not open the database.

SVRMGRL> startup mount

NOTE: If you are using the Oracle Parallel Server, you must mount the

database exclusively using one instance to switch the database's

archiving mode.

5. Switch the database's archiving mode.

SVRMGRL> alter database archivelog;

6. Open the database.

SVRMGRL> alter database open;

7. Verify your database is now in archivelog mode.

SVRMGRL> archive log list;

Database log mode               Archive Mode

Automatic archival              Enabled

Archive destination             for example: $ORACLE_HOME/dbs/arch

Oldest on-line log sequence     275

Next log sequence               277

Current log sequence            278

8. Archive all your redo logs at this point.

SVRMGRL> archive log all;

9. Ensure these newly created Archive log files are added to the backup

process.

See the Oracle7 Parallel Server Concepts & Administration guide for more

information about switching the archiving mode when using the Oracle Parallel

Server.