歸檔路徑與FRA實驗過程
歸檔路徑與FRA
使用 FRA（Flash Recovery Area）時，如果顯示的指定了歸檔的路徑的話，那麼就不會再在 FRA 中生成歸檔了。
當然，如果指定 其他歸檔路徑的同時，也指定了FRA時，就不會有任何疑問了。
show parameter命令顯示的歸檔路徑可能不太準確，查詢 v$archive_dest 就比較好了！
[oracle@RAC1 ~]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 25 19:12:58 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
IDEL > conn / as sysdba
Connected.
SYS:149@HONGYE2 > show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oracle/flash_recovery_area
db_recovery_file_dest_size big integer 2G
recovery_parallelism integer 0
SYS:149@HONGYE2 > show parameter archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
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_2 string enable
log_archive_dest_state_3 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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean TRUE
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string ?/dbs/arch
SYS:149@HONGYE2 > !
[oracle@RAC1 ~]$ ls -l /oracle/flash_recovery_area/HONGYE2/archivelog/2011_01_25
total 9580
-rw-r----- 1 oracle oinstall 9793536 Jan 25 19:53 o1_mf_1_2_6mxgfskx_.arc
[oracle@RAC1 ~]$ exit
SYS:149@HONGYE2 > alter system set log_archive_dest_9='LOCATION=/oracle';
System altered.
SYS:149@HONGYE2 > show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9 string LOCATION=/oracle
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean TRUE
log_archive_trace integer 0
SYS:149@HONGYE2 > alter system archive log current;
System altered.
SYS:149@HONGYE2 > !
[oracle@RAC1 ~]$ cd /oracle/
[oracle@RAC1 oracle]$ ls -l
total 31220
-rw-r----- 1 oracle oinstall 3584 Jan 25 19:54 1_3_736892552.dbf
drwxr-x--- 5 oracle oinstall 4096 Dec 4 17:19 admin
-rw-r----- 1 oracle oinstall 7061504 Dec 4 16:35 control01.ctl
-rw-r----- 1 oracle oinstall 7061504 Dec 4 16:35 control02.ctl
-rw-r----- 1 oracle oinstall 7061504 Dec 4 16:35 control03.ctl
drwxr-x--- 3 oracle oinstall 4096 Dec 4 18:12 flash_recovery_area
drwx------ 2 oracle oinstall 16384 Oct 10 21:50 lost+found
drwxr-xr-x 3 oracle oinstall 4096 Dec 4 17:19 oradata
drwxrwx--- 6 oracle oinstall 4096 Oct 12 14:02 oraInventory
drwxr-xr-x 3 oracle oinstall 4096 Oct 10 16:25 product
drwxr-xr-x 2 oracle oinstall 4096 Dec 4 16:23 recovery
-rw-r--r-- 1 oracle oinstall 186312 Jan 25 19:07 rman.out
-rw-r----- 1 oracle oinstall 10493952 Jan 24 15:04 test.dbf
[oracle@RAC1 oracle]$ ls -l /oracle/flash_recovery_area/HONGYE2/archivelog/2011_01_25
total 9580
-rw-r----- 1 oracle oinstall 9793536 Jan 25 19:53 o1_mf_1_2_6mxgfskx_.arc
[oracle@RAC1 oracle]$ exit
exit
SYS:149@HONGYE2 > alter system set log_archive_dest_8='LOCATION=USE_DB_RECOVERY_FILE_DEST';
System altered.
SYS:149@HONGYE2 > show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 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 LOCATION=USE_DB_RECOVERY_FILE_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
DEST
log_archive_dest_9 string LOCATION=/oracle
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean TRUE
log_archive_trace integer 0
SYS:149@HONGYE2 > ALTER system archive log current;
System altered.
SYS:149@HONGYE2 > !
[oracle@RAC1 ~]$ cd /oracle/
[oracle@RAC1 oracle]$ ls -l
total 31224
-rw-r----- 1 oracle oinstall 3584 Jan 25 19:54 1_3_736892552.dbf
-rw-r----- 1 oracle oinstall 1536 Jan 25 19:57 1_4_736892552.dbf
drwxr-x--- 5 oracle oinstall 4096 Dec 4 17:19 admin
-rw-r----- 1 oracle oinstall 7061504 Dec 4 16:35 control01.ctl
-rw-r----- 1 oracle oinstall 7061504 Dec 4 16:35 control02.ctl
-rw-r----- 1 oracle oinstall 7061504 Dec 4 16:35 control03.ctl
drwxr-x--- 3 oracle oinstall 4096 Dec 4 18:12 flash_recovery_area
drwx------ 2 oracle oinstall 16384 Oct 10 21:50 lost+found
drwxr-xr-x 3 oracle oinstall 4096 Dec 4 17:19 oradata
drwxrwx--- 6 oracle oinstall 4096 Oct 12 14:02 oraInventory
drwxr-xr-x 3 oracle oinstall 4096 Oct 10 16:25 product
drwxr-xr-x 2 oracle oinstall 4096 Dec 4 16:23 recovery
-rw-r--r-- 1 oracle oinstall 186312 Jan 25 19:07 rman.out
-rw-r----- 1 oracle oinstall 10493952 Jan 24 15:04 test.dbf
[oracle@RAC1 oracle]$ ls -l /oracle/flash_recovery_area/HONGYE2/archivelog/2011_01_25
total 9584
-rw-r----- 1 oracle oinstall 9793536 Jan 25 19:53 o1_mf_1_2_6mxgfskx_.arc
-rw-r----- 1 oracle oinstall 1536 Jan 25 19:57 o1_mf_1_4_6mxgnt4z_.arc
[oracle@RAC1 oracle]$ exit
exit
SYS:149@HONGYE2 >
使用 FRA（Flash Recovery Area）時，如果顯示的指定了歸檔的路徑的話，那麼就不會再在 FRA 中生成歸檔了。
當然，如果指定 其他歸檔路徑的同時，也指定了FRA時，就不會有任何疑問了。
show parameter命令顯示的歸檔路徑可能不太準確，查詢 v$archive_dest 就比較好了！
[oracle@RAC1 ~]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 25 19:12:58 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
IDEL > conn / as sysdba
Connected.
SYS:149@HONGYE2 > show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oracle/flash_recovery_area
db_recovery_file_dest_size big integer 2G
recovery_parallelism integer 0
SYS:149@HONGYE2 > show parameter archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
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_2 string enable
log_archive_dest_state_3 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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean TRUE
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string ?/dbs/arch
SYS:149@HONGYE2 > !
[oracle@RAC1 ~]$ ls -l /oracle/flash_recovery_area/HONGYE2/archivelog/2011_01_25
total 9580
-rw-r----- 1 oracle oinstall 9793536 Jan 25 19:53 o1_mf_1_2_6mxgfskx_.arc
[oracle@RAC1 ~]$ exit
SYS:149@HONGYE2 > alter system set log_archive_dest_9='LOCATION=/oracle';
System altered.
SYS:149@HONGYE2 > show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_9 string LOCATION=/oracle
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean TRUE
log_archive_trace integer 0
SYS:149@HONGYE2 > alter system archive log current;
System altered.
SYS:149@HONGYE2 > !
[oracle@RAC1 ~]$ cd /oracle/
[oracle@RAC1 oracle]$ ls -l
total 31220
-rw-r----- 1 oracle oinstall 3584 Jan 25 19:54 1_3_736892552.dbf
drwxr-x--- 5 oracle oinstall 4096 Dec 4 17:19 admin
-rw-r----- 1 oracle oinstall 7061504 Dec 4 16:35 control01.ctl
-rw-r----- 1 oracle oinstall 7061504 Dec 4 16:35 control02.ctl
-rw-r----- 1 oracle oinstall 7061504 Dec 4 16:35 control03.ctl
drwxr-x--- 3 oracle oinstall 4096 Dec 4 18:12 flash_recovery_area
drwx------ 2 oracle oinstall 16384 Oct 10 21:50 lost+found
drwxr-xr-x 3 oracle oinstall 4096 Dec 4 17:19 oradata
drwxrwx--- 6 oracle oinstall 4096 Oct 12 14:02 oraInventory
drwxr-xr-x 3 oracle oinstall 4096 Oct 10 16:25 product
drwxr-xr-x 2 oracle oinstall 4096 Dec 4 16:23 recovery
-rw-r--r-- 1 oracle oinstall 186312 Jan 25 19:07 rman.out
-rw-r----- 1 oracle oinstall 10493952 Jan 24 15:04 test.dbf
[oracle@RAC1 oracle]$ ls -l /oracle/flash_recovery_area/HONGYE2/archivelog/2011_01_25
total 9580
-rw-r----- 1 oracle oinstall 9793536 Jan 25 19:53 o1_mf_1_2_6mxgfskx_.arc
[oracle@RAC1 oracle]$ exit
exit
SYS:149@HONGYE2 > alter system set log_archive_dest_8='LOCATION=USE_DB_RECOVERY_FILE_DEST';
System altered.
SYS:149@HONGYE2 > show parameter log_archive
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 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 LOCATION=USE_DB_RECOVERY_FILE_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
DEST
log_archive_dest_9 string LOCATION=/oracle
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean TRUE
log_archive_trace integer 0
SYS:149@HONGYE2 > ALTER system archive log current;
System altered.
SYS:149@HONGYE2 > !
[oracle@RAC1 ~]$ cd /oracle/
[oracle@RAC1 oracle]$ ls -l
total 31224
-rw-r----- 1 oracle oinstall 3584 Jan 25 19:54 1_3_736892552.dbf
-rw-r----- 1 oracle oinstall 1536 Jan 25 19:57 1_4_736892552.dbf
drwxr-x--- 5 oracle oinstall 4096 Dec 4 17:19 admin
-rw-r----- 1 oracle oinstall 7061504 Dec 4 16:35 control01.ctl
-rw-r----- 1 oracle oinstall 7061504 Dec 4 16:35 control02.ctl
-rw-r----- 1 oracle oinstall 7061504 Dec 4 16:35 control03.ctl
drwxr-x--- 3 oracle oinstall 4096 Dec 4 18:12 flash_recovery_area
drwx------ 2 oracle oinstall 16384 Oct 10 21:50 lost+found
drwxr-xr-x 3 oracle oinstall 4096 Dec 4 17:19 oradata
drwxrwx--- 6 oracle oinstall 4096 Oct 12 14:02 oraInventory
drwxr-xr-x 3 oracle oinstall 4096 Oct 10 16:25 product
drwxr-xr-x 2 oracle oinstall 4096 Dec 4 16:23 recovery
-rw-r--r-- 1 oracle oinstall 186312 Jan 25 19:07 rman.out
-rw-r----- 1 oracle oinstall 10493952 Jan 24 15:04 test.dbf
[oracle@RAC1 oracle]$ ls -l /oracle/flash_recovery_area/HONGYE2/archivelog/2011_01_25
total 9584
-rw-r----- 1 oracle oinstall 9793536 Jan 25 19:53 o1_mf_1_2_6mxgfskx_.arc
-rw-r----- 1 oracle oinstall 1536 Jan 25 19:57 o1_mf_1_4_6mxgnt4z_.arc
[oracle@RAC1 oracle]$ exit
exit
SYS:149@HONGYE2 >
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24465008/viewspace-688038/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【實驗】【Archived Log】歸檔日誌格式和歸檔路徑之change趣談Hive
- 歸檔日誌多歸檔路徑 duplex
- 更改ORACLE歸檔路徑及歸檔模式Oracle模式
- 改變歸檔檔案路徑
- 修改歸檔日誌路徑
- 更改archive log 歸檔路徑和歸檔檔名稱Hive
- dataguard歸檔路徑的問題
- 更改oracle10g的歸檔模式和歸檔路徑Oracle模式
- oracle單機改變歸檔路徑Oracle
- oracle資料庫更改歸檔路徑Oracle資料庫
- [Archive]更改ORACLE預設歸檔路徑HiveOracle
- 修改db2的歸檔路徑DB2
- Oracle實驗8--Merge與歸檔Oracle
- MYSQL學習與實驗（八）——儲存過程實驗MySql儲存過程
- standby庫歸檔日誌路徑小節
- 【archive_dest】歸檔的路徑問題Hive
- ORA-00257 (線上更改歸檔路徑,刪除歸檔日誌)
- 【Oracle】歸檔日誌管理-設定歸檔日誌路徑以及歸檔日誌冗餘Oracle
- 非歸檔模式下的資料檔案路徑修改模式
- oracle歸檔日誌儲存路徑的設定Oracle
- 【基本操作】快速恢復區存在時修改歸檔路徑
- 10g修改歸檔日誌路徑的問題
- 多路徑重用歸檔日誌
- 檔案路徑及副檔名校驗正規表示式
- 【RMAN】改變FRA到新路徑，需要做哪些工作
- canvas 路徑與子路徑Canvas
- go掃描指定路徑下，檔案過多Go
- 《計算機網路實驗課程》——Wireshark實驗計算機網路
- 【rac】實驗一：啟動關閉歸檔
- css檔案與資源路徑相關CSS
- 缺少log_archive_config導致歸檔路徑被禁用Hive
- Rman在run命令塊裡臨時設定歸檔目錄，歸檔日誌能否恢復主要看預設的歸檔路徑
- 歸檔模式下資料庫全恢復的過程模式資料庫
- 檔案絕對路徑和相對路徑
- HTML絕對路徑與相對路徑HTML
- Golang os 包與設定配置檔案路徑Golang
- 歸檔路徑更改後，如何對資料庫進行恢復(轉)資料庫
- Linux檔案的路徑定位-相對路徑和絕對路徑Linux