RE: Redo Logs Problem

Sure. Check v$backup. STATUS will give you part of your answer, but TIME will be the real key. Match it to the alert log and/or to the time you normally run your backup and you should discover what happened. Typically this is caused by a failed backup. Some backup scripts check this before they start.  

Kurt    

 -----Original Message-----
Sent: Friday, August 01, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L

This may have already been asked, but is it possible there is a datafile in backup mode even though a backup is not running?

-----Original Message-----
Sent: Friday, August 01, 2003 10:24 AM
To: Multiple recipients of list ORACLE-L

>> This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client).

Clients lie.

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

        -----Original Message-----

        Hi Listers,   

One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client).         

Can anyone please help me and let me know all the reasons that could be responsible for this behavior. Any Help from u will be appreciated.         

Regards   

Munish Bajaj

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wiegand, Kurt
  INET: Kurt.Wiegand_at_CWUSA.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).