#backup status

[oracleappsdbasstuff]

RMAN Backup Status

#RMAN, #backup #RMANbackup, #oracleebs #oracleapps #oracledba #oracledatabase #rman #Backup #oracle @oracle @oraclebs

RMAN Historical backup details: select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,’mm-dd-yyyy hh24:mi:ss’) as RMAN_Bkup_start_time, to_char(END_TIME,’mm-dd-yyyy hh24:mi:ss’) as RMAN_Bkup_end_time, elapsed_seconds/3600 Hours from V$RMAN_BACKUP_JOB_DETAILS order by session_key; Running status of the RMAN Backup : SQL> SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND…

[prashantjayaram]

PowerShell - SQL Databases Backup Status Report of Multiple Servers

PowerShell – SQL Databases Backup Status Report of Multiple Servers

  This post is a requirement from one of my blog reader. There are plenty of scripts available to get the backup status of the databases across multiple server. The  requirement is to read a server name and application names from an input file. The server name is used for building a connection and to get the required backup details but where as an app name is used for making an heading in a HTML…