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