Oracle Backup & Recovery
Backup Status
RMAN
To give the backup history from the controlfile for a single database...
Assumes the database is local and you are logged in as 'oracle'rman target /
list backup summary;
OEM
There are several useful OEM screens giving backup information relevant to a single database.
If you want to report on multiple databases see otherr options below.Targets - Databases - select instance
Availability - Backup & Recovery - Backup reports
Targets - Databases - select instance
Oracle Database - Home
High Availability >
Click date in Last Backup field
If you click on the date in the report above, you get to this screen...
OMS
If you are managing your databases with Oracle Enterprise Manager Cloud Control you can query backup status across all managed databases using a query lke this (run when connected to the OMS database)...
SET LINESIZE 200 PAGESIZE 40
COLUMN database_name FORMAT a10
COLUMN target_type FORMAT a15
COLUMN host FORMAT a15
COLUMN status FORMAT a25
COLUMN timetaken FORMAT a10
COLUMN input FORMAT a10
COLUMN output FORMAT a10
COLUMN output_sec FORMAT a10
SELECT database_name,
target_type,
SUBSTR(host,1,15) host,
status,
input_type,
output_device_type,
TO_CHAR(start_time,'YYYY-MM-DD HH24:MI:SS') start_time,
TO_CHAR(end_time,'YYYY-MM-DD HH24:MI:SS') end_time,
CEIL(SYSDATE-end_time) age,
TIME_TAKEN_DISPLAY timetaken,
INPUT_BYTES_DISPLAY input,
OUTPUT_BYTES_DISPLAY output,
OUTPUT_BYTES_PER_SEC_DISPLAY output_sec
FROM sysman.mgmt$ha_backup
WHERE database_name IN (SELECT target_name
FROM sysman.mgmt$target)
ORDER BY database_name
/
The MGMT$HA_BACKUP view should not be used for backup reports. This view is used internally by Enterprise Manager for metric collections and to display backup information summary on the target's home page. If you need to generate backup reports, please use V$RMAN_BACKUP_JOB_DETAILS.
In my testing, MGMT$HA_BACKUP does sometimes give incorrect information (e.g. it can look like a backup hasn't run for days when it actaully has been running normally)
Java
java -cp ${CLASSPATH} -Doracle.net.tns_admin=${TNS_ADMIN} -Doracle.net.wallet_location=${WALLPATH} DBABackupCheck
This relies on a config file containing a connection string for each database in this format...
jdbc:oracle:thin:/@TNS_ALIAS