datafile online/offline

hi folks,

I have some basic doubts......

1. How to find out whether a datafile is online or offline.
status column of dba_data_files only lists whether
availability.

2. How to flush or clear online redo log files.

regards
sonia

1. select a.file_name, b.status
from dba_data_files a, v$datafile b
where a.file_id=b.file#;

2. You can not flush or clear online redo log files but you can switch or archive them.

Alter system switch logfile;
Alter system archive log current;


Sanjay

In fact you can clear them...

alter database clear logfile;

Sanjay

Hi soniya

I have query why u normally need to flush the redo logfiles ?

Any syntax is
alter database clear logfile group 1 ;


bye
viraj

Quote:

---

Originally posted by virajvk
I have query why u normally need to flush the redo logfiles ?

---

You clear logfiles when you have lost a redo log file or when
that file is corrupted. Then, this file is neglected and reinitialized. What Oracle does is the following: it recreates the file even if it did not exist (physically) and fills it with zeroes.