-
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
A Wise Man Knows How much he doesn't know !!!
-
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|