Oracle:Archived redo log
数据库在归档模式下,每次Oracle通过LGWR进程切换联机重做日志时都会生成归档的重做日志。
数据库归档状态:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
[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> |
文件目录中的状态:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
[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]$ |
归档日志的副本目录是通过LOG_ARCHIVE_DEST_n指定的。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 |
SQL> set pagesize 300 SQL> show parameter log_archive_dest_ NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_1 string log_archive_dest_10 string log_archive_dest_11 string log_archive_dest_12 string log_archive_dest_13 string log_archive_dest_14 string log_archive_dest_15 string log_archive_dest_16 string log_archive_dest_17 string log_archive_dest_18 string log_archive_dest_19 string log_archive_dest_2 string log_archive_dest_20 string log_archive_dest_21 string log_archive_dest_22 string log_archive_dest_23 string log_archive_dest_24 string log_archive_dest_25 string log_archive_dest_26 string log_archive_dest_27 string log_archive_dest_28 string log_archive_dest_29 string log_archive_dest_3 string log_archive_dest_30 string log_archive_dest_31 string log_archive_dest_4 string log_archive_dest_5 string log_archive_dest_6 string log_archive_dest_7 string log_archive_dest_8 string log_archive_dest_9 string log_archive_dest_state_1 string enable log_archive_dest_state_10 string enable log_archive_dest_state_11 string enable log_archive_dest_state_12 string enable log_archive_dest_state_13 string enable log_archive_dest_state_14 string enable log_archive_dest_state_15 string enable log_archive_dest_state_16 string enable log_archive_dest_state_17 string enable log_archive_dest_state_18 string enable log_archive_dest_state_19 string enable log_archive_dest_state_2 string enable log_archive_dest_state_20 string enable log_archive_dest_state_21 string enable log_archive_dest_state_22 string enable log_archive_dest_state_23 string enable log_archive_dest_state_24 string enable log_archive_dest_state_25 string enable log_archive_dest_state_26 string enable log_archive_dest_state_27 string enable log_archive_dest_state_28 string enable log_archive_dest_state_29 string enable log_archive_dest_state_3 string enable log_archive_dest_state_30 string enable log_archive_dest_state_31 string enable log_archive_dest_state_4 string enable log_archive_dest_state_5 string enable log_archive_dest_state_6 string enable log_archive_dest_state_7 string enable log_archive_dest_state_8 string enable log_archive_dest_state_9 string enable SQL> |
————————————————————————
Ending。