DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle Database Backup

  1. #1
    Join Date
    Mar 2006
    Posts
    3

    Oracle Database Backup

    How do I check that a database backup (hot) doen or not?
    I mean from which table/view I can see the database backup status.

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    V$datafile_header - Fuzzy status

    V$backup - status Active
    "What is past is PROLOGUE"

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    I use this regularly:

    COL TSPACE FORMAT A25 HEADING "Tablespace"
    COL STAT FORMAT A12 HEADING " Status"
    COL TIM FORMAT A18 HEADING "Last Hot-backup|StartTime"

    SET LINESIZE 100
    SET PAGESIZE 20

    SELECT
    A.TABLESPACE_NAME TSPACE
    ,DECODE(B.STATUS
    ,'ACTIVE','** BACKUP **'
    ,'NOT ACTIVE',' NORMAL'
    ) STAT
    ,TO_CHAR(B.TIME,'DD-Mon-YY HH24:MI:SS') TIM
    FROM
    (
    SELECT TABLESPACE_NAME, MIN(FILE_ID) FILE_ID
    FROM DBA_DATA_FILES
    GROUP BY TABLESPACE_NAME
    ) A
    ,V$BACKUP B
    WHERE
    B.FILE#=A.FILE_ID
    ORDER BY
    B.TIME
    -- A.TABLESPACE_NAME
    ;

  4. #4
    Join Date
    Mar 2006
    Location
    I am from Mumbai , but Presently In Nigeria
    Posts
    1
    What is the best way of taking backup, can i write a script in d2k to take backup automatically , presently i am using dos backup .

    regds/sanjay

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    simple - rman hot backup

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