Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Redo Log File Multiplexing

root> su - oracle

oracle> export ORACLE_SID=ssss

oracle> sqlplus / as sysdba

SQL> startup

SQL> select members from V$logfile;

SQL> desc V$logfile;

SQL> select group#,member from V$logfile;

SQL> desc V$log;

SQL> select group#,bytes,status from V$log;

SQL> select group#,members from V$log;

SQL> select a.group#,a.members,b.member,a.status from V$log a,V$logfile b where a.group#=b.group#;

                save redo.sql

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Flag Counter