Oracle OMF管理 数据文件,redo文件
SQL> select * from v$logfile;rows will be truncated
GROUP# STATUS TYPE MEMBER
---------- ------- ------- ------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------
3 ONLINE /seconddisk/root/oracle/product/10.2.0/oradata/orcl/redo03.log
2 STALE ONLINE /seconddisk/root/oracle/product/10.2.0/oradata/orcl/redo02.log
1 STALE ONLINE /seconddisk/root/oracle/product/10.2.0/oradata/orcl/redo01.log
4 ONLINE /thirddisk/root/redolog/ORCL/onlinelog/o1_mf_4_54yln8n2_.log
4 ONLINE /fourthdisk/root/redolog/ORCL/onlinelog/o1_mf_4_54ylnfqx_.log
1 INVALID ONLINE /thirddisk/root/redolog/ORCL/onlinelog/redo01a.log
2 INVALID ONLINE /fourthdisk/root/redolog/ORCL/onlinelog/redo02a.log
7 rows selected.
SQL>>
Database> SQL> select * from v$logfile;
rows will be truncated
GROUP# STATUS TYPE MEMBER
---------- ------- ------- ------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------
3 ONLINE /seconddisk/root/oracle/product/10.2.0/oradata/orcl/redo03.log
2 STALE ONLINE /seconddisk/root/oracle/product/10.2.0/oradata/orcl/redo02.log
1 STALE ONLINE /seconddisk/root/oracle/product/10.2.0/oradata/orcl/redo01.log
4 ONLINE /thirddisk/root/redolog/ORCL/onlinelog/o1_mf_4_54yln8n2_.log
4 ONLINE /fourthdisk/root/redolog/ORCL/onlinelog/o1_mf_4_54ylnfqx_.log
1 INVALID ONLINE /thirddisk/root/redolog/ORCL/onlinelog/redo01a.log
2 INVALID ONLINE /fourthdisk/root/redolog/ORCL/onlinelog/redo02a.log
3 INVALID ONLINE /fourthdisk/root/redolog/ORCL/onlinelog/redo03a.log
8 rows selected.
页:
[1]