Friday , October 20 2017
Home / Oracle DBA / How to switch on primary database to physical standby database

How to switch on primary database to physical standby database

After configuration data guard then data is switching  into primary database  to standby database :

STANDBY DATABASE:

<STEP 1> : you can check standby database is mount state or not

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

PRIMARY DATABASE:

<STEP 1> Now going on let me check ROLE,CONTROL FILE CHECKS:

STANDBY DATABASE :

How to check standby data base is configure on MRM mode (or) NOT;-

standby database is currently IDLE  MODE  ,Let’s Configuring standby database in MRM MODE:
NOTE: The constructed archivelogs will be picked by MRP (manage recovery process) and apply’s 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 satandby database

PRIMARY DATA BASE:

now let’s create a one talespace at primary database side

STAND BY DATABASE:

Lets check tablespace are switch or not

here  table space is not switching then go to primary database then apply the switching.

PRIMARY DATABSE:

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

STAND BY DATABASE:

 

Comments

comments

Check Also

Moving a database from Normal File System to ASM storage

Default storage for oracle database is File System, where database files resides on local storage. …

Leave a Reply

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