#13. You issue the following queries to obtain information about the redo log files: SQL> SELECT GROUP#, TYPE, member FROM v$logfile; GROUP# TYPE MEMBER
------ ------- --------------------------------------
1 ONLINE /databases/DB01/ORADATA/u02/log1a.rdo
1 ONLINE /databases/DB01/ORADATA/u03/log1b.rdo
2 ONLINE /databases/DB01/ORADATA/u02/log2a.rdo
2 ONLINE /databases/DB01/ORADATA/u03/log2b.rdo
3 ONLINE /databases/DB01/ORADATA/u02/log3a.rdo
3 ONLINE /databases/DB01/ORADATA/u03/log3b.rdo SQL> SELECT GROUP#, SEQUENCE#, status FROM v$log; GROUP# SEQUENCE# STATUS
------ --------- ---------
1 250 INACTIVE
2 251 CURRENT
3 249 INACTIVE
You immediately issue this command: ALTER DATABASE DROP LOGFILE MEMBER '/databases/DB01/ORADATA/u03/log2b.rdo';
Why does the command fail?
Show comments for this question (1)
Add comments
Link to this question
|
gen. 0.094
Forum
Master braindump