Oracle archiving Mode

Oracle is successfully installed on Redhat 5. The archive mode is not enabled during database creation.

SQL> select name, open_mode, log_mode from v $ database;

NAME OPEN_MODE LOG_MODE
-----------------------------------------
SZPDCORA READ WRITE NOARCHIVELOG

 

SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 6
Current log sequence 8

It is not enabled.

To change the archive mode, follow these steps:

SQL> shutdown immediate
SQL> startup nomount
SQL> alter database mount;
SQL> alter database archivelog;
SQL> alter database open;

Database altered.

Let's look at the archive mode.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 6
Next log sequence to archive 8
Current log sequence 8
SQL> select name, open_mode, log_mode from v $ database;

You can see that the default archive log storage path is in the flash back area ($ ORACLE_BASE/flash_recovery_area ). ORACLE has a limit on this path, that is, it only has 2 GB space by default. It is not only the default path for archiving logs, but also the default address for backup files and flash back logs, in this way, the space used by the archive log lock cannot reach 2 GB. If the path size is not set, many systems have encountered problems where the archiving logs are full and cannot be archived.
If there is not enough space, either change the size of the flash back area or switch the archive log to another directory.

SQL> show parameter db_recovery

NAME TYPE VALUE
-----------------------------------------------------------------------------
Db_recovery_file_dest string/u01/app/oracle/flash_recovery
_ Area
Db_recovery_file_dest_size large integer 3852 M

1 2 Next Page