UNIX SHELL SCRIPTS - 1

##########################################################################################
UNIX SHELL SCRIPTS
##########################################################################################
1)
sqlplus -s /nolog <<EOF
connect / as sysdba
set pause off
set heading off
set echo on
set time on
set timing on
set feedback on
set pause off
@/rebuild_indexes.sql
SPOOL OFF
EOF
exit
$ nohup ./rebuild_indexes.sh &


2)
sqlplus -s /nolog <<EOF
connect / as sysdba
conn username/password
set pause off
set heading off
set echo on
set time on
set timing on
set feedback on
set pause off
@rebuild_indexes.sql
SPOOL OFF
EOF
exit
$ nohup ./rebuild_indexes.sh &

3)
sqlplus -s /nolog <<EOF
connect / as sysdba
conn username/password
set pause off
set heading off
set echo on
set time on
set timing on
set feedback on
set pause off
ALTER SESSION SET CURRENT_SCHEMA = <schema name>.
?@rebuild_indexes.sql
SPOOL OFF
EOF
exit
$ nohup ./rebuild_indexes.sh &

##########################################################################################
UNIX COMMANDS
##########################################################################################
1) Check db status on all dbs
for DBNAME in `ps -ef|grep pmon|grep -v grep|grep -v ASM|awk '{print $9}'|cut -d "_"  -f3`
do
export DBNAME
. /haidb.env $DBNAME
sqlplus -s /nolog <<EOF >> db_status_check.log
connect / as sysdba
set pause off
set heading on
set echo on
set feedback on
set pause off
set linesize 200
col HOST_NAME for a20
select NAME,INSTANCE_NAME,LOG_MODE,OPEN_MODE,INSTANCE_NAME,HOST_NAME,STATUS,LOGINS,STARTUP_TIME from gv\$instance, gv\$database;
select NAME,LOG_MODE,OPEN_MODE,GUARD_STATUS,DATABASE_ROLE from gv\$database;
EOF
done

2) To check backup status
for DBNAME in `ps -ef|grep pmon|grep -v grep|grep -v ASM|awk '{print $9}'|cut -d "_"  -f3`
do
export DBNAME
. /haidb.env $DBNAME
sqlplus -s /nolog <<EOF >> db_status_check_March25.log
connect / as sysdba
set pause off
set heading on
set echo on
set feedback on
set pause off
set linesize 200
col HOST_NAME for a20
col TIME_TAKEN_DISPLAY  for a20
set linesize 200
col STATUS format a19
col hrs format 999.99
select NAME,LOG_MODE,OPEN_MODE,GUARD_STATUS,DATABASE_ROLE from gv\$database;
select
SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
to_char(END_TIME,'mm/dd/yy hh24:mi')   end_time,
elapsed_seconds/3600                   hrs
from V\$RMAN_BACKUP_JOB_DETAILS
order by session_key;
EOF
done
3) Only full backup status check
================================
for DBNAME in `ps -ef|grep pmon|grep -v grep|grep -v ASM|awk '{print $9}'|cut -d "_"  -f3`
do
export DBNAME
. /haidb.env $DBNAME
sqlplus -s /nolog <<EOF >> db_full_backup_check_May29.log
connect / as sysdba
set pause off
set heading on
set echo on
set feedback on
set pause off
set linesize 200
col HOST_NAME for a20
col TIME_TAKEN_DISPLAY  for a20
set linesize 200
col STATUS format a19
col hrs format 999.99
col START_TIME for a15
col END_TIME  for a15
col IN_SIZE for a15
col OUT_SIZE  for a15
select NAME,LOG_MODE,OPEN_MODE,GUARD_STATUS,DATABASE_ROLE from gv\$database;
select
SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
to_char(END_TIME,'mm/dd/yy hh24:mi')   end_time,
elapsed_seconds/3600                   hrs,
INPUT_BYTES_DISPLAY in_size,
OUTPUT_BYTES_DISPLAY out_size
from V\$RMAN_BACKUP_JOB_DETAILS
where input_type='DB FULL'
order by session_key;
EOF
done
#######################################################################################
TO CHECK DB STATUS
#######################################################################################
for DBNAME in `ps -ef|grep pmon|grep -v grep|grep -v ASM|awk '{print $9}'|cut -d "_"  -f3`
do
export DBNAME
. /haidb.env $DBNAME
sqlplus -s /nolog <<EOF >> db_status_before_reboot.log
connect / as sysdba
set pause off
set heading on
set echo on
set feedback on
set pause off
set linesize 200
col HOST_NAME for a20
col TIME_TAKEN_DISPLAY  for a20
set linesize 200
col STATUS format a19
col hrs format 999.99
col START_TIME for a15
col END_TIME  for a15
col IN_SIZE for a15
col OUT_SIZE  for a15

set linesize 200
col HOST_NAME for a20
select NAME,INSTANCE_NAME,LOG_MODE,OPEN_MODE,INSTANCE_NAME,HOST_NAME,STATUS,LOGINS,STARTUP_TIME from gv\$instance, gv\$database;
select NAME,LOG_MODE,OPEN_MODE,GUARD_STATUS,DATABASE_ROLE from gv\$database;

EOF
done
set linesize 200
col HOST_NAME for a20
select NAME,INSTANCE_NAME,LOG_MODE,OPEN_MODE,INSTANCE_NAME,HOST_NAME,STATUS,LOGINS,STARTUP_TIME from gv$instance, gv$database;