Re: recovery during refresh

From: <hemantchitale_at_charteredsemi.com>
Date: Tue, 18 Dec 2001 22:53:06 -0800
Message-ID: <F001.003DFA52.20011218222519@fatcity.com>

Presumably all required transactions to be recovered were in the online logs ? You cannot
copy the online logs "online" (when they are active !).

Check if those indexes were created NOLOGGING when the backup was running
-- that could

explain why the indexes could not be recovered.

If you cannot shutdown production for a backup, you should not be using the online logs
and control files from there. In fact, your online backup could also include a backup of the
control file (through an ALTER DATABASE BACKUP CONTROLFILE ..) and then use that control file to do a RECOVER UNTIL CANCEL USING BACKUP CONTROLFILE. Then you do an ALTER DATABASE OPEN RESETLOGS and later change the SID name and database name (recreating the controlfile is what I do).

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd

"Tatireddy, Shrinivas (MED, Keane)" <Shrinivas.Tatireddy_at_med.ge.com> 19/12/2001 01:35 PM
Sent by: root_at_fatcity.com

Please respond to ORACLE-L

Hi lists,

I need to refresh a test database from production. (test1 from prod1 db)

I took the hotbackup files and online redo logs. I created the controlfile using these files. After that I performed recovery.

Here I applied online logs instead of archive logs. (There are 7 grous of online redo logs each contains 3 members). When I tried to open the db, it asked that datafile needs recovery.

I applied online redo log instead of archive log. The next day I observed that indexes got corrupted (This msg is from another dba group who are working with this new test database)

My doubt is : applying online redo logs instead of archive logs lead to this index corruption?

can anybody come across such any situation. Now I need to do refresh again in another way applying archive logs.

Thnx and regards,

Srinivas
--

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

Author: Tatireddy, Shrinivas (MED, Keane) INET: Shrinivas.Tatireddy_at_med.ge.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

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: hemantchitale_at_charteredsemi.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