Hi, I don't quite understand what you are trying to do. However, you should never recreate the standby database's control file! Create a new standby controlfile (ALTER DATABASE CREATE STANDBY CONTROLFILE.) on the primary site, and copy it across to the standby site's control file locations. ORA-33448: (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.
Question: I am recovering my Oracle database and when I issue the ' alter database open resetlogs' command, I get the below error. ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/data/oracle/NYP/d03/SYSTEM01.dbf' Answer: In this case, you need to start my doing what the error advice recommends. The Oracle documentation notes that you resolve the ORA-01194 error by issuing a ' recover database' command to apply more redo logs to out the database into a consistent state: ORA-01194: file needs more recovery to be consistent Cause: An incomplete recovery session was started, but an insufficient number of logs were applied to make the file consistent.
The reported file was not closed cleanly when it was last opened by the database. It must be recovered to a time when it was not being updated. The most likely cause of this error is forgetting to restore the file from a backup before doing incomplete recovery. Action: Either apply more logs until the file is consistent or restore the file from an older backup and repeat recovery. Get the Complete Oracle SQL Tuning Information The landmark book is filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g performance and you can for 30% off directly from the publisher. Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their. Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page.
Burleson Consulting The Oracle of Database Support Copyright © 1996 - 2017 All rights reserved by Burleson Oracle ® is the registered trademark of Oracle Corporation. Remote Emergency Support provided.