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
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
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货