Ask the Expert

How to use the TIME column to check Oracle database backup mode

Is there a script that can be used as an alert that tells if the database has been in backup mode for a specified period of time? (Ex. 1 hr, 2 hr. etc.)

    Requires Free Membership to View

The V$BACKUP view contains a column called TIME. This column denotes the date/time the file was placed in backup mode. To see the longest amount of time the Oracle database has been in BACKUP mode for any tablespaces, use the following query:

SELECT TO_CHAR(MAX(time),'MM/DD HH24:MI:SS') AS backup_time FROM v$backup;

This was first published in July 2009

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: