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

ORA-00600: internal error code, arguments: [kccsbck_first], [1], []
Set Column Size in SQLplus
Find the Location of Oracle SPFILE
How to Limit Oracle Query Result
© 2017 ITsiti. All Rights Reserved
Powered by KEEM