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
Printable View
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
You clear logfiles when you have lost a redo log file or whenQuote:
Originally posted by virajvk
I have query why u normally need to flush the redo logfiles ?
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.