Oracle DataGuard Tips

# Data Gard Issue (Find DB name from primary)
show parameter log_archive_config
archive log list
SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
select * from v$dataguard_config;
SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM GV$DATABASE;

set pages 1000
set lines 120
column DEST_NAME format a20
column DESTINATION format a35
column ARCHIVER format a10
column TARGET format a15
column status format a10
column error format a15
select DEST_ID,DEST_NAME,DESTINATION,TARGET,STATUS,ERROR from v$archive_dest
where DESTINATION is NOT NULL;

set linesize 250
column sequence# format 999999999
column name format a100
column applied format a3
column thread# format 9
SELECT thread#,SEQUENCE#,name,APPLIED FROM V$ARCHIVED_LOG where next_time > (sysdate-5/7) order by first_time asc;

How to set Crontab Entry for different-2 scenario

# How to set cron
00 0,4,8,12,16,20 * * * sh /u001/scripts/GPASP_Job_email.sh > /u001/log/GPASP_Job_email.log 2>&1

#How to set a cron to run only and only once in his whole life for specific time.

At command in Unix