Home / Oracle DBA / How to switch on primary database to physical standby database

How to switch on primary database to physical standby database

After configuring dataguard, perform following operations to check whether the switching from primary database to standby database is happening or not.

STANDBY DATABASE:

<STEP 1> : Check below query to know whether standby database is mounted or not.

< STEP 2> let me check ROLE,CONTROL FILE CHECKS:

PRIMARY DATABASE:

<STEP 1> Now check same query in primary database as well ROLE,CONTROL FILE CHECKS:

STANDBY DATABASE :

Follow below query to check standby data base is configured on MRM mode or NOT.

You can see that standby database is currently mounted on IDLE  MODE. Let’s Configure it on MRM MODE.

NOTE: The constructed archivelogs will be picked by MRP (manage recovery process) and applies the data to the physical standby if it runs in MRM ( manage recovery mode) mode. Physical standby database may run either in MRM mode (or) Read only mode.

Now check switching on primary database to standby database

PRIMARY DATA BASE:

Now let’s create one tablespace in primary database.

STAND BY DATABASE:

Lets check whether the tablespace created in primary database is switched to the standby or not.

You can see that the tablespace is not switched. Go to primary database and apply the switching.

PRIMARY DATABASE:

Now going on here you can switch tablespace then check on satandby database

STAND BY DATABASE:

 

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

Your email address will not be published. Required fields are marked *

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe