RE: oracle not available ???

From: <Jared.Still_at_radisys.com>
Date: Wed, 02 Jan 2002 08:21:42 -0800
Message-ID: <F001.003E50D0.20020102075037@fatcity.com>

If the database was shutdown cleanly, the online logs are not required or desired.

If the database was not shutdown cleanly, you will not be able to open the database without them.

Jared

                                                                                       
                            
                    DBarbour_at_austin.isd                                                
                            
                    .tenet.edu                To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>  
                    Sent by:                  cc:                                      
                            
                    root_at_fatcity.com          Subject:     RE: oracle not available 
???                            
                                                                                       
                            
                                                                                       
                            
                    01/01/02 07:30 PM                                                  
                            
                    Please respond to                                                  
                            
                    ORACLE-L

Nagaraj,

Yes, you may indeed have a problem. You say you backed up the datafiles. Did you get the redo logs and controlfile? How did your DB go down? Did it crash, or were you able to shut it down? If you're not in archivelog mode, are the redo logs that were current at the time of the most recent backup available?

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

"Nagaraj Panyam" <nagarajp_at_intelligroup.co.in> Sent by: root_at_fatcity.com
01/01/2002 11:55 AM PST
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
bcc:

Hi list

I have a database recovery problem.

The scenario is like this

My database is not in archive mode.
I have taken a cold back up on two different times. 6 data files in the morning and 6 in the evening. In between the database was started and again Was shutdown before taking back up in the evening.

I want to recover the database completely but I don't mind losing the data of the period between the back ups.

Can any one have solution.

Thanks in advance

NAGARAJ
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nagaraj Panyam
INET: nagarajp_at_intelligroup.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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).

Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: DBarbour_at_austin.isd.tenet.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists
-------------------------------------------------------------------- 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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message