1、查看归档模式
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 39
Current log sequence 41
SQL> show parameter recovery;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /home/oracle/app/oracle/flash_
recovery_area
db_recovery_file_dest_size big integer 20G
recovery_parallelism integer 0
在指定了使用闪回恢复区作为归档日志的位置后, 不使用的参数:
LOG_ARCHIVE_DEST
LOG_ARCHIVE_DUPLEX_DEST
而是使用 这个参数: LOG_ARCHIVE_DEST_n 参数 ,数据库将在这个位置下保存 归档重做日志文件。
在上面的结果中看到归档模式没有打开,归档日志的默认存放位置是 DB_RECOVERY_FILE_DEST的位置。
2、闪回恢复区的两个关键参数
指定位置和大小,可以更改。
SQL> show parameter recovery;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /home/oracle/app/oracle/flash_
recovery_area
db_recovery_file_dest_size big integer 20G
recovery_parallelism integer 0
SQL> show parameter db_create
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string *指明控制文件 & redo 文件的位置
db_create_online_log_dest_1 string *指明控制文件 & redo 文件的位置
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
SQL>
因为使用了DB_RECOVERY_FILE_DEST的位置,上述值没有设置,均为空
指明control file位置的参数:
SQL> show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /home/oracle/app/oracle/oradat
a/test/control01.ctl, /home/or
acle/app/oracle/flash_recovery
_area/test/control02.ctl
SQL>
指明redo文件位置的参数:
SQL> show parameter LOG_ARCHIVE_DEST
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_11 string
4、查看闪回恢复区的使用情况
位置,大小限制,已经使用的空间,可以删除回收的空间,总的文件数目
SQL> select * from v$recovery_file_dest;
NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/home/oracle/app/oracle/flash_recovery_area
2.1475E+10 0 0 0
SQL>
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
CONTROL FILE 0 0
0
REDO LOG 0 0
0
ARCHIVED LOG 0 0
0
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
BACKUP PIECE 0 0
0
IMAGE COPY 0 0
0
FLASHBACK LOG 0 0
0
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
FOREIGN ARCHIVED LOG 0 0
0
7 rows selected.
SQL>
5、更改为归档模式
先shutdown,startup mount ,alter archivelog ,open database
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1.0796E+11 bytes
Fixed Size 2218032 bytes
Variable Size 5.8519E+10 bytes
Database Buffers 4.9392E+10 bytes
Redo Buffers 50499584 bytes
Database mounted.
SQL> alter database archivelog
2 ;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 39
Next log sequence to archive 41
Current log sequence 41
SQL>