Exports & Backup Status?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Exports & Backup Status?

  1. #1
    Join Date
    Nov 2001
    Location
    New Brunswick, NJ
    Posts
    67

    Smile

    Hi All,

    Is there a place where Oracle keeps status information about exports and backups?

    I would like to create a procedure which will trigger out of DBMS_JOB to run an archive process after my exports or backups have completed.

    Thanks,

    P

  2. #2
    Join Date
    Sep 2002
    Posts
    5

    Wink

    v$backup:- it is used to determine which files are in backup mode. when an
    alter tablespace begin backup command
    is issued the status changes to active

    v$datafile_header:- it is used to get information about datafiles that are in backup mode can also be derived by quering. when an alter tablespace begin backup commands is issued. the value in the fuzzy column for the tablespace datafile changes to " yes " to indicate that the corresponding files are in backup mode.
    Ajmal Chishti

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width