How do I find out if Database is in Archive or Non Archive mode?
Thanks in Advance.
Printable View
How do I find out if Database is in Archive or Non Archive mode?
Thanks in Advance.
Hi,
SELECT * FROM V$DATABASE. just TYPE this sql command to get the archivelog information or type ARCHIVE LOG LIST in the sql prompt.
KARTHI
Hi,
Use "archive log list" command in svrmgrl or sqlplus.
Baliga