Oracle Data Guard RFS not starting on standby – trouble shooting data guard background processes

Oracle Data Guard RFS not starting on standby – trouble shooting data guard background processes – or archivelog not being sent / transported to standby: Everything was basic setup correctly but archivelog was not playing to the standby.  Standby creation went fine. I did make a change to the log_archive_dest_3 that was being used for…

List full date and time of RMAN backups – controlled by NLS_DATE_FORMAT

RMAN may not display dates and times of backups the way that you want it.  The format of the date time displayed is controlled by the environment variable NLS_DATE_FORMAT.  Make sure it is set before invoking rman, for example: export NLS_DATE_FORMAT=DD_MON_YYYY_HH24:MI:SS rman target / list backup; … BS Key Type LV Size Device Type Elapsed…

Show Oracle FRA Fast Recovery Area Usage and other things

Show Oracle FRA Fast Recovery Area Usage fraUsage.sql –Show Oracle FRA Fast Recovery Area Usage set wrap on column name format a40 set line 200 select * from v$flash_recovery_area_usage; select name, trunc(space_limit/1024/1024,0) space_limit_GB, trunc(space_used/1024/1024,0) space_used_GB, trunc(((space_used/space_limit)*100),0) “Total%Used” from v$recovery_file_dest; exit Here is another I use all the time to show status – I setup an…

Automated purge of Oracle Data Guard Standby and Snapshot Archivelogs from a DB standby

See my previous post on how to toggle a Data Guard snapshot standby between snapshot and physical recovery here. It is a prerequisite to use the FRA if you are doing Oracle Data Guard Snapshots (available 11g and forward).  The FRA handles some of the purging, but it is not well documented by Oracle what…