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