1:在数据库处于打开状态
查看数据归档状态:
C:\Users\Administrator>sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 23 12:10:31 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect /as sysdba;
Connected.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2
从这个可以看出Archive destination USE_DB_RECOVERY_FILE_DEST 归档日志的存放闪回区。
查看闪回区大小
SQL> show parameter db_re
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Oracle解决归档日志 .rar
(6.7 KB, 下载次数: 29)
|