Skip to main content

DR DRILL / SWITCH OVER

 Dr drill / switc over switch back

In every company it will be taken for every 3 months (quarterly)


               Production


At the time of any crash in production data the standby will switch over as production database.


Alter database commit to switchover to physical standby with session;


Select switchover _ status from v$database;


Output: to stand

If output: failed destination 

(any archives missing)


Take full db backup


Current mode : read/write


End of redo (with the help of win scp send this to stand by in one location or path)











After stand by changing to primary use below command to actice 


[Alter database activate standby database]



                 Stand by







Alter database commit to switchover to primary;



Select switchover _ status from v$database;


Output: to prod

If output: failed destination





Current mode : to stand (mount)


End of redo 






Alter database commit to switch over to primary


Shut immediate

Start up in mount mode

Check control type file

Current read/write


Stand by changed to primary 


Comments

Post a Comment

Popular posts from this blog

Oracle database single instance architecture

Oracle database single instance architecture  Maine database runs on a single machine we referred to this architecture as the Oracle database single instance architecture this setup involves having one Oracle database instance running on the mission serving its clients   The term Oracle database instance simply refers to the combination of memory structure and database process that collectively represent the database service.  However this Architectire has a significant availability risk.  If anything goes wrong with the mission that database becomes UN available.
Post a Comment
Read more

Table spaces

 Tablespace consists of one or more data files.  A data file belongs to only one tablespace. Segments, Extents, and Blocks • Segments exist within a tablespace • Segments are made up of a collection of extents • An extents is a collection of logically contiguous data blocks - Cannot span multiple data files • Data blocks are mapped to disk blocks SYSTEM and SYSAUX Tablespaces • The SYSTEM and SYSAUX tablespaces are mandatory tablespaces. • They are created at the time of database creation. • They must be online. • The SYSTEM tablespace is used for core functionality (for example, data dictionary tables). • The auxiliary SYSAUX tablespace is used for additional database components.
Post a Comment
Read more