SQL> select * from v$logfile;
         3         ONLINE
/opt/oracle/oracle/oradata/ora92/redo03.log         2         ONLINE
/opt/oracle/oracle/oradata/ora92/redo02.log         1         ONLINE
/opt/oracle/oracle/oradata/ora92/redo01.log
Elapsed: 00:00:00.01
SQL> select * from v$controlfile;/opt/oracle/oracle/oradata/ora92/control01.ctl
/opt/oracle/oracle/oradata/ora92/control02.ctl
/opt/oracle/oracle/oradata/ora92/control03.ctl
Elapsed: 00:00:00.01
SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /opt/oracle/oracle/dbs/arch
Oldest online log sequence     2041
Current log sequence           2043
SQL> select * from v$datafile;初始参数文件:$ORACLE_HOME/dbs