How to Locate Oracle Mirror & Orig Log Files



Share this article :

You can find the location of mirror and orig log files by executing below command,

SQL> select member from v$logfile;

MEMBER
--------------------------------------------

D:\ORACLE\DEV\ORIGLOGA\LOG_G11M1.DBF
E:\ORACLE\DEV\MIRRLOGA\LOG_G11M2.DBF
D:\ORACLE\DEV\ORIGLOGB\LOG_G12M1.DBF
E:\ORACLE\DEV\MIRRLOGB\LOG_G12M2.DBF
D:\ORACLE\DEV\ORIGLOGA\LOG_G13M1.DBF
E:\ORACLE\DEV\MIRRLOGA\LOG_G13M2.DBF
D:\ORACLE\DEV\ORIGLOGB\LOG_G14M1.DBF
E:\ORACLE\DEV\MIRRLOGB\LOG_G14M2.DBF

8 rows selected.

Related posts

Oracle Environment Variables
V$ARCHIVED_LOG: Archived Log Information from Control File
Start Oracle Database in Mount Mode
Check if any Oracle Data Files Needed for Recovery
© 2017 ITsiti. All Rights Reserved
Powered by KEEM