Oracle Database archive mode switching

In the development and testing environments of Oracle databases, the log mode and automatic archiving mode of databases are generally not set, which is conducive to the adjustment of system applications and does not require

In the development and testing environments of Oracle databases, the log mode and automatic archiving mode of databases are generally not set, which is conducive to the adjustment of system applications and does not require

In the development and testing environments of Oracle databases, the log mode and automatic archiving mode of databases are generally not set, which is conducive to the adjustment of system applications, the generation of a large number of archive log files will consume a lot of disk space. However, when the system goes online and becomes a production environment, it is very important to set it to log mode and automatically archive it, because this is an important measure to ensure the security of the system and effectively prevent disasters. In this way, the log files between the regular backup database and the two backup intervals can effectively restore the data at any point in time during this period, data loss can be recovered in many cases or minimized. Although the log mode and automatic archiving settings of the Oracle database are not complex, some of the concepts and operations are confusing. Based on my experience, the analysis is as follows, the environment used is UNIX (HPUX, SOLARIES, AIX, TRU64UNIX) and Oracle8.

First, to enable the OARCLE database to automatically Archive logs, you need to do two things: first, set the database log mode (the database log Mode can be Archive Mode and No Archive mode ), in addition, you can set the Automatic archive mode (for Enabled and Disabled ). 2. How to view the current log and automatic archiving Mode settings of the database:

You can use the archive log list command to view logs.

For example:

The database system running in log automatic archiving mode displays the following results (generally in the production environment)

SVRMGR> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination/backup/archivelog

Oldest online log sequence 2131

Next log sequence to archive 2133

Current log sequence 2133

The following figure shows the results of the database system that does not start the Database Log mode or automatically archive (usually the test environment)

SVRMGR> archive log list

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination/u01/app/Oracle/product/8.0.5/dbs/arch

Oldest online log sequence 194

Current log sequence 196