Oracle归档模式、参数意义、设置

1、查看是否归档模式

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive
Oldest online log sequence 41
Next log sequence to archive 43
Current log sequence 43
SQL>

2、修改归档模式、非归档模式（mont模式下修改）

SQL> startup mount;
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive
Oldest online log sequence 41
Next log sequence to archive 43
Current log sequence 43
SQL>
SQL> alter database noarchivelog;

Database altered.

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/archive
Oldest online log sequence 41
Current log sequence 43
SQL>

3、归档目录。

如果不设置归档目录默认的放在参数

db_recovery_file_dest下面，目录默认大小2G

SQL> show parameter db_recover

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/flash_recovery
_area
db_recovery_file_dest_size big integer 2G
SQL>
SQL>

如果要指定归档目录需要修改如下参数：

log_archive_dest_1 string

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_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
log_archive_dest_9 string

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/60144/viewspace-1033396/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/60144/viewspace-1033396/