-
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.
-
V$datafile_header - Fuzzy status
V$backup - status Active
"What is past is PROLOGUE"
-
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
;
-
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|