最近查找系统日志,用archive log list命令查找:
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /auditarch
Oldest online log sequence 2402
Next log sequence to archive 2405
Current log sequence 2405
系统日志是启动自动归档的,可是到/auditarch目前下面查找不到归档日志文件,怎么回事啊?
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /auditarch
Oldest online log sequence 2402
Next log sequence to archive 2405
Current log sequence 2405
系统日志是启动自动归档的,可是到/auditarch目前下面查找不到归档日志文件,怎么回事啊?
如果为空,归档开启的话,是放在oracle_home/flash_recovery_area/目录下的。
这里面显示的路径去找找!!
SQL> show parameter log_archive_dest_1;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string LOCATION=/auditarch
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string 显示的的路径也是 auditarch
5db#[/auditarch]ll
total 0
drwxr-xr-x 2 oracle dba 96 Aug 17 17:49 lost+found
查一下看看呢
看看alert日志文件有没有什么提示
查找的文件下面就有对应的路径啊