Saturday, October 20, 2012

Server reboot steps - Data guard

Server reboot steps :
--------------------
-->If its DG setep or normal db, following steps mandatroy just take backup of follwoing three steps and store it in separate notepad. once server reboot
   activity completed croos check once which was taken before server reboot.
##########################################################
step 1:  ps -ef|grep pmon 
            ps -ef|grep pmon|wc -l
step 2 : ps -ef|grep inh (OR) ps -ef|grep tns
            ps -ef|grep inh|wc -l
step 3 : df -h 
#############################################################
server reboot time database side need to  check the below commands:
(Before server reboot and after serevr boot, if its is DG database)
-------------------------------------------------------------------
SQL> select name,db_unique_name,database_role,controlfile_type,CREATED from v$database;
SQL >select sequence#,first_time,next_time,completion_time,applied from v$archived_log where applied <> 'YES' and DEST_ID !=0 and status!='D'and completion_time <(sysdate-1/48) Order By 1;
no rows selected----->in sync
SQL >select process, status ,sequence# from v$managed_standby;
MRP0---->process should reflect
===============================
Data Guard Db Startup Procedure
===============================
sqlplus “/ as sysdba”
startup nomount;
alter database mount standby database;
recover managed standby database disconnect from session; ----------->To put it in MRM MOD
exit;
=================================
Data Guard Db  Shutdown Procedure
=================================
Login as oracle
source the environment
sqlplus “/ as sysdba”
alter database recover managed standby database cancel; ------> to cancel MRM mode
shutdown immediate;
exit

No comments:

Post a Comment