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)" <[EMAIL PROTECTED]> 19/12/2001 01:35 PM Sent by: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
