log_archive__dest_n – Adamhuan's Data Center

Oracle：Archived redo log

数据库在归档模式下，每次Oracle通过LGWR进程切换联机重做日志时都会生成归档的重做日志。
数据库归档状态：

[ora11g@rhel5u10 trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 7 20:14:08 2014

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     3
Next log sequence to archive   5
Current log sequence           5
SQL> 
SQL> show parameter DB_RECOVERY_FILE_DEST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/fast_recovery_
                                                 area
db_recovery_file_dest_size           big integer 4122M
SQL>

[ora11g@rhel5u10 trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 7 20:14:08 2014

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 3

Next log sequence to archive 5

Current log sequence 5

SQL>

SQL> show parameter DB_RECOVERY_FILE_DEST

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest string /u01/app/oracle/fast_recovery_

area

db_recovery_file_dest_size big integer 4122M

SQL>

文件目录中的状态：

[ora11g@rhel5u10 trace]$ cd /u01/app/oracle/fast_recovery_area/
[ora11g@rhel5u10 fast_recovery_area]$ ll
total 8
drwxr-x--- 2 ora11g oinstall 4096 Oct  6 23:02 orcl11g
drwxr-x--- 4 ora11g oinstall 4096 Oct  6 23:18 ORCL11G
[ora11g@rhel5u10 fast_recovery_area]$ tree *
orcl11g
`-- control02.ctl
ORCL11G
|-- archivelog
|   |-- 2014_10_06
|   |   `-- o1_mf_1_3_b371fmt1_.arc
|   `-- 2014_10_07
|       `-- o1_mf_1_4_b39b7477_.arc
`-- onlinelog

4 directories, 3 files
[ora11g@rhel5u10 fast_recovery_area]$ cd orcl11g/
[ora11g@rhel5u10 orcl11g]$ ll
total 9536
-rw-r----- 1 ora11g oinstall 9748480 Oct  7 20:23 control02.ctl
[ora11g@rhel5u10 orcl11g]$ du -sh *
9.4M    control02.ctl
[ora11g@rhel5u10 orcl11g]$ cd ../ORCL11G/
[ora11g@rhel5u10 ORCL11G]$ du -sh *
66M     archivelog
4.0K    onlinelog
[ora11g@rhel5u10 ORCL11G]$ cd archivelog/
[ora11g@rhel5u10 archivelog]$ ll
total 8
drwxr-x--- 2 ora11g oinstall 4096 Oct  6 23:18 2014_10_06
drwxr-x--- 2 ora11g oinstall 4096 Oct  7 20:00 2014_10_07
[ora11g@rhel5u10 archivelog]$ du -sh 2014_10_06/o1_mf_1_3_b371fmt1_.arc 
43M     2014_10_06/o1_mf_1_3_b371fmt1_.arc
[ora11g@rhel5u10 archivelog]$ du -sh 2014_10_07/o1_mf_1_4_b39b7477_.arc 
24M     2014_10_07/o1_mf_1_4_b39b7477_.arc
[ora11g@rhel5u10 archivelog]$

[ora11g@rhel5u10 trace]$ cd /u01/app/oracle/fast_recovery_area/

[ora11g@rhel5u10 fast_recovery_area]$ ll

total 8

drwxr-x--- 2 ora11g oinstall 4096 Oct 6 23:02 orcl11g

drwxr-x--- 4 ora11g oinstall 4096 Oct 6 23:18 ORCL11G

[ora11g@rhel5u10 fast_recovery_area]$ tree *

orcl11g

`-- control02.ctl

ORCL11G

|-- archivelog

| |-- 2014_10_06

| | `-- o1_mf_1_3_b371fmt1_.arc

| `-- 2014_10_07

| `-- o1_mf_1_4_b39b7477_.arc

`-- onlinelog

4 directories, 3 files

[ora11g@rhel5u10 fast_recovery_area]$ cd orcl11g/

[ora11g@rhel5u10 orcl11g]$ ll

total 9536

-rw-r----- 1 ora11g oinstall 9748480 Oct 7 20:23 control02.ctl

[ora11g@rhel5u10 orcl11g]$ du -sh *

9.4M control02.ctl

[ora11g@rhel5u10 orcl11g]$ cd ../ORCL11G/

[ora11g@rhel5u10 ORCL11G]$ du -sh *

66M archivelog

4.0K onlinelog

[ora11g@rhel5u10 ORCL11G]$ cd archivelog/

[ora11g@rhel5u10 archivelog]$ ll

total 8

drwxr-x--- 2 ora11g oinstall 4096 Oct 6 23:18 2014_10_06

drwxr-x--- 2 ora11g oinstall 4096 Oct 7 20:00 2014_10_07

[ora11g@rhel5u10 archivelog]$ du -sh 2014_10_06/o1_mf_1_3_b371fmt1_.arc

43M 2014_10_06/o1_mf_1_3_b371fmt1_.arc

[ora11g@rhel5u10 archivelog]$ du -sh 2014_10_07/o1_mf_1_4_b39b7477_.arc

24M 2014_10_07/o1_mf_1_4_b39b7477_.arc

[ora11g@rhel5u10 archivelog]$

归档日志的副本[……]

Posted on: 2014年10月8日 2014年10月8日
Author: Adamhuan
Categories: Oracle Database
Tags: archived log, DB_RECOVERY_FILE_DEST, log_archive__dest_n
Leave a comment: Oracle：Archived redo log