![]() Oct 27, 2011. There is no need to recreate a new standby database after a failover operation. * You can take incremental backups based on full backups of a previous incarnation when you use RMAN. * Block media recovery can restore backups from parent incarnation backups and recover the corrupted blocks through. ![]() I sugestion that works. After you startup mount with your backup controlfile, do the following 1) alter database backup controlfile to trace; 2) go to the generated trace and edit it, leaving the comand “create controlfile NORESETLOGS”. Question: I get the ORA-01153 error when I issue this command: stby>alter database recover managed standby database disconnect from session; alter database recover managed standby database disconnect from session * ERROR at line 1: ORA-01153: an incompatible media recovery is active What is the cause of an ORA-01153 error? Answer: The oerr utility shows this for the ORA-01153 error: ORA-01153: an incompatible media recovery is active Cause: Attempted to start an incompatible media recovery or open resetlogs during media recovery or RMAN backup. Media recovery sessions are incompatible if they attempt to recover the same data file. Incomplete media recovery or open resetlogs is incompatible with any media recovery. Backup or restore by RMAN is incompatible with open resetlogs Action: Complete or cancel the other media recovery session or RMAN backup. How to open standby in Read-Write mode with Archive Log GAP’s There was an interesting post in OTN forums, OP is trying to Open Standby database in Read-Write Mode. We are installing an Disaster Recovery Server using Oracle Standby. RECOVER succeeded but OPEN RESETLOGS would. ALTER DATABASE ACTIVATE STANDBY DATABASE. Dec 28, 2011. The main advantage of a graceful switchover is that it avoids the resetlogs operation. This option is implicitly done by the ALTER DATABASE ACTIVATE STANDBY DATABASE command. By avoiding the resetlogs operation, the source database can resume its role as the standby database almost. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2018
Categories |