CKPT wrote:I also have a scheduled tasks which executes the backup sometimes and doesn't some other times.
Are you sure about time format ? if not you can schedule in windows scheduled tasks with sysdates.
setting - control panel - shceduled tasks - add scheduled tasks.
Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. C:\Documents and Settings\Administrator>set oracle_sid=dev C:\Documents and Settings\Administrator>sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 10 14:57:56 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select * from v$rman_ouput; select * from v$rman_ouput * ERROR at line 1: ORA-00942: table or view does not exist SQL>
channel ORA_DISK_1: validation complete, elapsed time: 00:00:16so the dbms_scheduler job executes successfully right.
Finished restore at 10-AUG-10
piece handle=D:\ORACLE_BACKUP_DATA\DEV\ARCHL9LL02RU_1_1_2455006062_20100810.ARC tag=ARCBKP comment=NONE
CKPT wrote:CKPT, the table consists of 2541 rows.
sorry not ouput --> output
select * from v$rman_output;and also post the contents of this file DevDB_outfile.txt ?
Edited by: CKPT on Aug 10, 2010 12:28 PM
Is there some other way to find out?
select * from v$rman_output where output like '10-AUG%'
467 467 726666049 2010-08-10T11:40:42 8/10/2010 11:40:49 AM 8/10/2010 11:46:03 AM 6872172032 6568348672 1 0 9 DISK 0 NO COMPLETED DB FULL NO 314 1.04625566868811 21885898.1910828 20918307.8726115 6.40G 6.12G 20.87M 19.95M 00:05:14
select * from v$rman_backup_job_details where start_time like '%10%AUG%';