If its Dataguard setup or normal db, following steps mandatory just take backup of following three steps and store it in separate notepad. once server reboot activity completed cross check once which was taken before server reboot.
####################################################################################################
ps -ef|grep pmon
ps -ef|grep pmon|wc -l
ps -ef|grep inh (OR) ps -ef|grep tns
ps -ef|grep inh|wc -l
ps -ef |grep d.bin
hostname
date
uname -a
cat /etc/oratab / cat /var/opt/oracle/oratab
uptime
who -b
df -h / df -gt
####################################################################################################
server reboot time database side need to check the below commands:
(Before server reboot and after server 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 MODE
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
####################################################################################################
ps -ef|grep pmon
ps -ef|grep pmon|wc -l
ps -ef|grep inh (OR) ps -ef|grep tns
ps -ef|grep inh|wc -l
ps -ef |grep d.bin
hostname
date
uname -a
cat /etc/oratab / cat /var/opt/oracle/oratab
uptime
who -b
df -h / df -gt
####################################################################################################
server reboot time database side need to check the below commands:
(Before server reboot and after server 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 MODE
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