Subject: NEED TO SEE FILE NAMES OF ONLINE LOGS DURING MEDIA RECOVERY Type: PATCH Status: ARCHIVED Content Type: TEXT/PLAIN Creation Date: 13-FEB-1998 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NEED TO SEE FILE NAMES OF ONLINE LOGS DURING MEDIA RECOVERY ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Initial Broken version: Feature was never implemented. Initial version in which fix will appear: 7.3.4 External Description: When doing media recovery, Oracle provides information about what logs it is working on so long as they are archived logs. Once it gets to the online redo logs, it stops giving status information about what it is working on. Impact: When working on media recovery problems, there is no information given when online redo logs are being recovered. In difficult recovery situations where a redo log may be corrupted, especially when there are many of them (e.g., under multi-node OPS installations), it would be helpful to know which log is causing the problem. How to determine rediscovery: N/A. There is no information given regarding the recovery of online redo logs when performing media recovery. Internal Description: The routine kcrfro is called to open a logfile for redo reading. If a logfile name is not passed into the routine, then the controlfile is scanned to find the appropriate online redo log and then open it. One the correct online redo log is found, information will now be printed in the alert log stating the recovery of an online redo logfile. Other information printed out includes the log number, the sequence number, the log member number, the number of errors that this log member has previously encountered, and the file name. Resolution: Added code to print out additional information in the alert log regarding recovery of online redo logs. Testing Done: Performed manual media recovery testing to see the new information printed out in the alert log. Files changed: kcrfr.c Procedures changed (pertinent): kcrfro Integration: Changed will be checked into 7.3.4 and merged into 8.0.4.