Code Description for Oracle manual archiving Mode

Today, we will share with you the specific operation modes of the Oracle manual archiving mode. This article mainly introduces the actual operation steps of the Oracle manual archiving mode in the way of its actual application code, the following describes the specific content of the article. I hope you will gain some benefits after browsing it.

A friend of mine did the experiment yesterday. As a result, the database cannot be automatically archived and can only be archived manually. A group of people discussed the problem and found no cause in many places. Finally, he found the problem and solved the problem.

After the archive mode is enabled, you can set manual archiving. The archive log list command does not reflect the current archiving mode. You need to query log_mode in v $ database. For standby databases, setting manual Oracle archiving is invalid.

 
 

  
  
SYS@dev01> alter database archivelog;  
  
  
Database altered.  
  
  
SYS@dev01> archive log list;  
  
  
Database log mode Archive Mode  
  
  
Automatic archival Enabled  
  
  
Archive destination /u03/archive/dev01  
  
  
Oldest online log sequence 48  
  
  
Next log sequence to archive 50  
  
  
Current log sequence 50  
  
  
SYS@dev01> select log_mode from v$database;  
  
  
LOG_MODE  
  
  
ARCHIVELOG  
  
  
SYS@dev01> alter database archivelog manual;  
  
  
Database altered.  
  
  
SYS@dev01> archive log list;  
  
  
Database log mode Archive Mode  
  
  
Automatic archival Enabled  
  
  
Archive destination /u03/archive/dev01  
  
  
Oldest online log sequence 48  
  
  
Next log sequence to archive 50  
  
  
Current log sequence 50  
  
  
SYS@dev01> select log_mode from v$database;  
  
  
LOG_MODE  
  
  
MANUAL  
  
  
SYS@dev01> alter database noarchivelog;  
  
  
Database altered.  
  
  
SYS@dev01> archive log list;  
  
  
Database log mode No Archive Mode  
  
  
Automatic archival Disabled  
  
  
Archive destination /u03/archive/dev01  
  
  
Oldest online log sequence 48  
  
  
Current log sequence 50  
  
  
SYS@dev01> select log_mode from v$database;  
  
  
LOG_MODE  
  
  
NOARCHIVELOG  
  
  
SYS@dev01> 
 
 

The above content is an introduction to the manual archiving mode of Oracle. I hope you will get some benefits.