Oracle Database Physical standby Starting and Shutting down

Starting Up a Physical Standby Database
========================================

1.Start and mount the physical standby database:
————————————————-

SQL> STARTUP MOUNT;

2.Start Redo Apply or real-time apply:
————————————–

To start Redo Apply, issue the following statement:
—————————————————

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

To start real-time apply, issue the following statement:
——————————————————–

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE;

Note: On the primary database, query the RECOVERY_MODE column in the V$ARCHIVE_DEST_STATUS view,
which displays the standby database’s operation as MANAGED_RECOVERY for Redo Apply
and MANAGED REAL TIME APPLY for real-time apply.

Shutting Down a Physical Standby Database
==========================================

1.Issue the following query to find out if the standby database is performing Redo Apply or real-time apply.
If the MRP0 or MRP process exists, then the standby database is applying redo.

SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;

2.If Redo Apply is running, cancel it as shown in the following example:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

3.Shut down the standby database.

SQL> SHUTDOWN IMMEDIATE;

Advertisements

About shanojkumar

• Oracle Certified Professional with over 15 years of IT experience in database administration and support. • Certifications: OCP (12c, 11g & 10g), Oracle Database 11g Performance Tuning Certified Expert (OCE), ITIL V3 Certified and LPIC-1(Linux). • Oracle Certified Expert in oracle database performance tuning has solved over 100 database performance problems. • Quality oriented IT professional with notable success in Banking, Airlines, Retails, FMGC, Telecommunication and Media projects. • Maintaining an online technical blog - contributed more than 54+ articles based on ‘Database Administration’ real life scenarios on: https://shanojkumar.wordpress.com/ – 258,429 visitors all over the world. • Instructor of one of the most appreciated courses (Oracle Dataguard 12c) on Udemy with an average rating of 5 star. • Supervised a team of database administrators and technical infrastructure team members. Created documentation on best practices for database performance tuning and Oracle application installation practices.
This entry was posted in Oracle and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s