在哪看oracle归档日志,oracle查看归档日志路径

oracle查看归档日志路径

第一种办法是去默认目录$ORACLE_BASE/flash_recovery_area查看，在oracle10g、oracle11g系列的版本里面

[oracle@pldb236 ~]$ ll $ORACLE_BASE/flash_recovery_area

total 8

drwxr-x---. 6 oracle oinstall 4096 Mar 14 18:33 stuorcl

drwxr-x---. 2 oracle oinstall 4096 Aug 11  2015 stuorcl

[oracle@pldb236 ~]$ ll /oracle/app/oracle/flash_recovery_area/stuorcl/

total 16

drwxr-x---. 5 oracle oinstall 4096 Mar 14 18:33 archivelog

drwxr-x---. 3 oracle oinstall 4096 Mar 14 18:33 backupset

drwxr-x---. 2 oracle oinstall 4096 Mar 15 14:53 flashback

drwxr-x---. 2 oracle oinstall 4096 Oct 16 23:55 onlinelog

[oracle@pldb236 ~]$ ll /oracle/app/oracle/flash_recovery_area/stuorcl/archivelog/

total 12

drwxr-x---. 2 oracle oinstall 4096 Oct 15 00:10 2016_10_15

drwxr-x---. 2 oracle oinstall 4096 Mar 10 23:59 2017_03_10

drwxr-x---. 2 oracle oinstall 4096 Mar 14 23:36 2017_03_14

[oracle@pldb236 ~]$

去rman窗口show all查找

如果第一种办法找不到，第二种办法是rman窗口去找，因为rman备份会有一个默认的归档

[oracle@pldb236 ~]$ rlwrap rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Mar 15 15:55:53 2017

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: stuorcl (DBID=3391761643)

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name stuorcl are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 240 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data2/backup/data/controlfiles/%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_stuorcl.f'; # default

RMAN>

设置归档日志路径

alter system set log_archive_dest_1='location=/home/oradata/archlogs';