1.先查看数据库是否处于归档模式
SQL> select log_mode from v$database;
LOG_MODE
------------------------------------
NOARCHIVELOG
或者:
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 55
Current log sequence 57
2.重新启动数据库
SQL> startup mount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
3.修改数据库的归档模式
SQL> alter database archivelog; noarchivelog是改为非归档模式
Database altered.
4.打开数据库
SQL> alter database open;
Database altered.
5.查询归档模式
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 55
Next log sequence to archive 57
Current log sequence 57
或者:
SQL> select log_mode from v$database;
LOG_MODE
------------------------------------
ARCHIVELOG
6.查询归档模式的路径
SQL> show parameter db_recovery_file_dest (10g以后版本多默认用此参数)
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
db_recovery_file_dest string
/oracle/flash_recovery_area
db_recovery_file_dest_size big integer
2G
或:
SQL> show parameter log_archive_dest
7.查询归档视图中空间的使用情况
SQL> select * from v$recovery_file_dest;
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
--------------- ----------- ---------- ----------------- ---------------
/oracle/flash_r 2147483648 8920576 0 9
ecovery_area