Oracle Database Backup

[dilip_mc]

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.

[dbasan]

V$datafile_header - Fuzzy status

V$backup - status Active

[JMac]

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
;

[sanjaypathak]

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

[davey23uk]

simple - rman hot backup