`

Enable the real-time apply in 10G

 
阅读更多

If you want the redo data to be applied as it is received without waiting for the current standby redo log file to be archived, enable the real-time apply.

To start real-time apply:
SQL> alter database recover managed standby database using current logfile disconnect;

But Maybe you will encourter the error like this:

SQL> startup mount;
ORACLE instance started.

Total System Global Area 196681728 bytes
Fixed Size 1298836 bytes
Variable Size 104861292 bytes
Database Buffers 83886080 bytes
Redo Buffers 6635520 bytes
Database mounted.
SQL> alter database recover managed standby database using current logfile disconnect;
alter database recover managed standby database using current logfile disconnect;

*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
Use the following command to close the process first.
SQL> alter database recover managed standby database cancel
2 ;

Database altered.
You can view if the recover process is kicked off.
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS
2 FROM V$MANAGED_STANDBY;

PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0
ARCH CLOSING 1 59 1 246
ARCH CONNECTED 0 0 0 0
ARCH CONNECTED 0 0 0 0
MRP0 WAIT_FOR_LOG 1 60 0 0
RFS IDLE 1 60 827 6
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0

9 rows selected.
分享到:
评论

相关推荐

    Go_Design+Patterns+for+Real-World+Projects-Packt+Publishing(2017).pdf

    With all of this the module will enable you to understand and apply design patterns in an idiomatic way that will produce concise, readable, and maintainable software. Module 3, Go Programming ...

    Oracle NoSQL Database_2013.12

    Oracle NoSQL Database: Real-Time Big Data Management for the Enterprise Maqsood Alam , Aalok Muley , Chaitanya Kadaru , Ashok Joshi Book Description Publication Date: December 4, 2013 | ISBN-10: ...

    SignalR Blueprints(PACKT,2015)

    The focus on quality combined with clear, real-world examples will enable you to successfully create your own maintainable software in no time. The book starts by covering the need for SignalR before...

    Pro Apache Phoenix(Apress,2016)

    Learn the basics and best practices that are being adopted in Phoenix to enable a high write and read throughput in a big data space. This book includes real-world cases such as Internet of Things ...

    Level of Detail for 3D Graphics

    Level of detail (LOD) techniques are increasingly used by professional real-time developers to strike the balance between breathtaking virtual worlds and smooth, flowing animation. Level of Detail for...

    unigui0.83.5.820

    - 0000677: Hiding or showing controls doesn't apply alignment/anchoring correctly - 0000675: Setting position of a UniTrackbar at run time - 0000671: UniDBListBox: Dataset is not set to edit mode ...

    Learning Python Application Development(PACKT,2016)

    Detect recurring problems in the code and apply design patterns. Improve code efficiency by identifying performance bottlenecks and fixing them. Develop simple GUI applications using Python.

    ASP.NET MVC Framework Unleashed(Stephen Walther)

    From controllers and actions to views and models, Walther demonstrates how to apply each ASP.NET MVC Framework feature in real-world projects. In Part II, you'll walk step-by-step through building ...

    php.ini-development

    The following are all the settings which are different in either the production ; or development versions of the INIs with respect to PHP's default behavior. ; Please see the actual settings later in...

    .Learning.iPhone.Game.Development.with.Cocos2D.3.0

    If you are just starting with game programming, Cocos2D will enable you to make your first game in no time. Even if you are a seasoned game developer, you will still be able to benefit from what ...

    opensc-0.12.0.tar.gz

    2007-09-10; Andreas Jellinghaus * Drop AC_LIB_LINKFLAGS for libltdl and aclocal/lib* files. * New configure option to disable building nsplugin. * Support Siemens CardOS initialized cards (signing ...

    BUS Hound

    check box in the settings Window. <br>Date <br>Date the phase occurred in year/month/day format. <br>Time <br>Time the phase occurred in hour:minute:second.millisecond format. The hour ...

    au3反编译源码

    Tidy\ is run after deobfucating to apply indent to the source code samples\ Useful 'protected' example scripts; use myAut2Exe to reveal its the sources src_AutToExe_VB6.vbp VB6-ProjectFile !Source...

    Android Design Patterns and Best Practices

    We will teach you about different Android development patterns that will enable you to write clean code and make your app stand out from the crowd. The book starts by introducing the Android ...

Global site tag (gtag.js) - Google Analytics