1 2 Previous Next 28 Replies Latest reply: Aug 10, 2010 2:49 AM by user645399 Go to original post RSS
      • 15. Re: dbms_scheduler
        CKPT
        can you post the script of
        D:\Oracle_Backup_data\Details\script\Dev\DevDBBackup.bat

        Thanks
        • 16. Re: dbms_scheduler
          user645399
          CKPT wrote:
          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.
          I also have a scheduled tasks which executes the backup sometimes and doesn't some other times.

          Nith
          • 17. Re: dbms_scheduler
            user645399
            CKPT,

            Here is the content of those files:

            DevDBBackup.bat
            --------------------------------
            set ORACLE_SID=Dev

            sqlplus/nolog @Dev_Backup.sql

            Dev_Backup.sql
            ----------------------------

            connect sys/password as sysdba;

            alter system switch logfile;

            alter system archive log current;

            $Rman target sys/password CMDFILE DevDB.rcv LOG DevDB_outfile.txt;

            DevDB.rcv
            ---------------------

            RUN {

            backup database format='D:\Oracle_Backup_data\Dev\%U_%I_%T.bkp' tag= "everyday_full_bkup"
            plus archivelog format='D:\Oracle_Backup_data\Dev\Arch%U_%I_%T.arc' tag=arcbkp;
            backup current controlfile;
            restore database validate;
            crosscheck backup;
            crosscheck archivelog all;
            }

            exit
            • 18. Re: dbms_scheduler
              CKPT
              can you post log file details
              DevDB_outfile.txt ?
              and also do check in
              select * from v$rman_ouput
              • 19. Re: dbms_scheduler
                user645399
                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>
                • 20. Re: dbms_scheduler
                  CKPT
                  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
                  • 21. Re: dbms_scheduler
                    user645399
                    CKPT,

                    The time this file was modified is 11.40pm which is the time I manually clicked on the bat file.

                    DevDB_outfile.txt
                    -----------------------------


                    Recovery Manager: Release 10.2.0.1.0 - Production on Tue Aug 10 11:40:42 2010

                    Copyright (c) 1982, 2005, Oracle. All rights reserved.

                    connected to target database: DEV (DBID=2455006062)

                    RMAN> RUN {
                    2>
                    3> backup database format='D:\Oracle_Backup_data\Dev\%U_%I_%T.bkp' tag= "everyday_full_bkup"
                    4> plus archivelog format='D:\Oracle_Backup_data\Dev\Arch%U_%I_%T.arc' tag=arcbkp;
                    5> backup current controlfile;
                    6> restore database validate;
                    7> crosscheck backup;
                    8> crosscheck archivelog all;
                    9> }
                    10>
                    11> exit

                    Starting backup at 10-AUG-10
                    current log archived
                    using target database control file instead of recovery catalog
                    allocated channel: ORA_DISK_1
                    channel ORA_DISK_1: sid=166 devtype=DISK
                    channel ORA_DISK_1: starting archive log backupset
                    channel ORA_DISK_1: specifying archive log(s) in backup set
                    input archive log thread=1 sequence=293 recid=296 stamp=722847663
                    input archive log thread=1 sequence=294 recid=297 stamp=722876698
                    input archive log thread=1 sequence=295 recid=298 stamp=722901698
                    input archive log thread=1 sequence=296 recid=299 stamp=722934119
                    input archive log thread=1 sequence=297 recid=300 stamp=722949419
                    input archive log thread=1 sequence=298 recid=301 stamp=722949420
                    input archive log thread=1 sequence=299 recid=302 stamp=722949432
                    input archive log thread=1 sequence=300 recid=303 stamp=722949820
                    input archive log thread=1 sequence=301 recid=304 stamp=722988054
                    input archive log thread=1 sequence=302 recid=305 stamp=723006001
                    input archive log thread=1 sequence=303 recid=306 stamp=723006001
                    input archive log thread=1 sequence=304 recid=307 stamp=723006008
                    input archive log thread=1 sequence=305 recid=308 stamp=723006426
                    input archive log thread=1 sequence=306 recid=309 stamp=723046869
                    input archive log thread=1 sequence=307 recid=310 stamp=723075397
                    input archive log thread=1 sequence=308 recid=311 stamp=723217950
                    input archive log thread=1 sequence=309 recid=312 stamp=723247267
                    input archive log thread=1 sequence=310 recid=313 stamp=723279854
                    input archive log thread=1 sequence=311 recid=314 stamp=723308371
                    input archive log thread=1 sequence=312 recid=315 stamp=723308372
                    input archive log thread=1 sequence=313 recid=316 stamp=723308384
                    input archive log thread=1 sequence=314 recid=317 stamp=723308768
                    input archive log thread=1 sequence=315 recid=318 stamp=723357977
                    input archive log thread=1 sequence=316 recid=319 stamp=723380895
                    input archive log thread=1 sequence=317 recid=320 stamp=723380895
                    input archive log thread=1 sequence=318 recid=321 stamp=723380905
                    input archive log thread=1 sequence=319 recid=322 stamp=723381288
                    input archive log thread=1 sequence=320 recid=323 stamp=723438001
                    input archive log thread=1 sequence=321 recid=324 stamp=723438002
                    input archive log thread=1 sequence=322 recid=325 stamp=723438005
                    input archive log thread=1 sequence=323 recid=326 stamp=723438407
                    input archive log thread=1 sequence=324 recid=327 stamp=723492024
                    input archive log thread=1 sequence=325 recid=328 stamp=723577328
                    input archive log thread=1 sequence=326 recid=329 stamp=723593308
                    input archive log thread=1 sequence=327 recid=330 stamp=723628840
                    input archive log thread=1 sequence=328 recid=331 stamp=723635504
                    input archive log thread=1 sequence=329 recid=332 stamp=723635504
                    input archive log thread=1 sequence=330 recid=333 stamp=723635514
                    input archive log thread=1 sequence=331 recid=334 stamp=723635867
                    input archive log thread=1 sequence=332 recid=335 stamp=723679787
                    input archive log thread=1 sequence=333 recid=336 stamp=723719833
                    input archive log thread=1 sequence=334 recid=337 stamp=723719834
                    input archive log thread=1 sequence=335 recid=338 stamp=723719846
                    input archive log thread=1 sequence=336 recid=339 stamp=723720200
                    input archive log thread=1 sequence=337 recid=340 stamp=723765654
                    input archive log thread=1 sequence=338 recid=341 stamp=723783602
                    input archive log thread=1 sequence=339 recid=342 stamp=723783603
                    input archive log thread=1 sequence=340 recid=343 stamp=723783617
                    input archive log thread=1 sequence=341 recid=344 stamp=723784002
                    input archive log thread=1 sequence=342 recid=345 stamp=723838290
                    input archive log thread=1 sequence=343 recid=346 stamp=723852740
                    channel ORA_DISK_1: starting piece 1 at 10-AUG-10
                    channel ORA_DISK_1: finished piece 1 at 10-AUG-10
                    piece handle=D:\ORACLE_BACKUP_DATA\DEV\ARCHL8LL02QE_1_1_2455006062_20100810.ARC tag=ARCBKP comment=NONE
                    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:48
                    channel ORA_DISK_1: starting archive log backupset
                    channel ORA_DISK_1: specifying archive log(s) in backup set
                    input archive log thread=1 sequence=249 recid=252 stamp=721869637
                    input archive log thread=1 sequence=250 recid=253 stamp=721882821
                    input archive log thread=1 sequence=251 recid=254 stamp=721882821
                    input archive log thread=1 sequence=252 recid=255 stamp=721882827
                    input archive log thread=1 sequence=253 recid=256 stamp=721883180
                    input archive log thread=1 sequence=254 recid=257 stamp=721932862
                    input archive log thread=1 sequence=255 recid=258 stamp=721952454
                    input archive log thread=1 sequence=256 recid=259 stamp=722002954
                    input archive log thread=1 sequence=257 recid=260 stamp=722037634
                    input archive log thread=1 sequence=258 recid=261 stamp=722038912
                    input archive log thread=1 sequence=259 recid=262 stamp=722085154
                    input archive log thread=1 sequence=260 recid=263 stamp=722142052
                    input archive log thread=1 sequence=261 recid=264 stamp=722211829
                    input archive log thread=1 sequence=262 recid=265 stamp=722228401
                    input archive log thread=1 sequence=263 recid=266 stamp=722228402
                    input archive log thread=1 sequence=264 recid=267 stamp=722228405
                    input archive log thread=1 sequence=265 recid=268 stamp=722228761
                    input archive log thread=1 sequence=266 recid=269 stamp=722296846
                    input archive log thread=1 sequence=267 recid=270 stamp=722315917
                    input archive log thread=1 sequence=268 recid=271 stamp=722337946
                    input archive log thread=1 sequence=269 recid=272 stamp=722337946
                    input archive log thread=1 sequence=270 recid=273 stamp=722337958
                    input archive log thread=1 sequence=271 recid=274 stamp=722338314
                    input archive log thread=1 sequence=272 recid=275 stamp=722383232
                    input archive log thread=1 sequence=273 recid=276 stamp=722417176
                    input archive log thread=1 sequence=274 recid=277 stamp=722426138
                    input archive log thread=1 sequence=275 recid=278 stamp=722426139
                    input archive log thread=1 sequence=276 recid=279 stamp=722426152
                    input archive log thread=1 sequence=277 recid=280 stamp=722426508
                    input archive log thread=1 sequence=278 recid=281 stamp=722469625
                    input archive log thread=1 sequence=279 recid=282 stamp=722487602
                    input archive log thread=1 sequence=280 recid=283 stamp=722487603
                    input archive log thread=1 sequence=281 recid=284 stamp=722487613
                    input archive log thread=1 sequence=282 recid=285 stamp=722487999
                    input archive log thread=1 sequence=283 recid=286 stamp=722531172
                    input archive log thread=1 sequence=284 recid=287 stamp=722556079
                    input archive log thread=1 sequence=285 recid=288 stamp=722590082
                    input archive log thread=1 sequence=286 recid=289 stamp=722642443
                    input archive log thread=1 sequence=287 recid=290 stamp=722660401
                    input archive log thread=1 sequence=288 recid=291 stamp=722660401
                    input archive log thread=1 sequence=289 recid=292 stamp=722660406
                    input archive log thread=1 sequence=290 recid=293 stamp=722660782
                    input archive log thread=1 sequence=291 recid=294 stamp=722690426
                    input archive log thread=1 sequence=292 recid=295 stamp=722763008
                    channel ORA_DISK_1: starting piece 1 at 10-AUG-10
                    channel ORA_DISK_1: finished piece 1 at 10-AUG-10
                    piece handle=D:\ORACLE_BACKUP_DATA\DEV\ARCHL9LL02RU_1_1_2455006062_20100810.ARC tag=ARCBKP comment=NONE
                    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:48
                    channel ORA_DISK_1: starting archive log backupset
                    channel ORA_DISK_1: specifying archive log(s) in backup set
                    input archive log thread=1 sequence=408 recid=411 stamp=724757421
                    input archive log thread=1 sequence=409 recid=412 stamp=724757422
                    input archive log thread=1 sequence=410 recid=413 stamp=724757431
                    input archive log thread=1 sequence=411 recid=414 stamp=724757754
                    input archive log thread=1 sequence=412 recid=415 stamp=724802443
                    input archive log thread=1 sequence=413 recid=416 stamp=724835884
                    input archive log thread=1 sequence=414 recid=417 stamp=724842904
                    input archive log thread=1 sequence=415 recid=418 stamp=724842904
                    input archive log thread=1 sequence=416 recid=419 stamp=724842916
                    input archive log thread=1 sequence=417 recid=420 stamp=724843350
                    input archive log thread=1 sequence=418 recid=421 stamp=724903246
                    input archive log thread=1 sequence=419 recid=422 stamp=724935394
                    input archive log thread=1 sequence=420 recid=423 stamp=724935394
                    input archive log thread=1 sequence=421 recid=424 stamp=724935403
                    input archive log thread=1 sequence=422 recid=425 stamp=724935824
                    input archive log thread=1 sequence=423 recid=426 stamp=724982460
                    input archive log thread=1 sequence=424 recid=427 stamp=724993200
                    input archive log thread=1 sequence=425 recid=428 stamp=724993202
                    input archive log thread=1 sequence=426 recid=429 stamp=724993206
                    input archive log thread=1 sequence=427 recid=430 stamp=724993551
                    input archive log thread=1 sequence=428 recid=431 stamp=725050862
                    input archive log thread=1 sequence=429 recid=432 stamp=725095328
                    input archive log thread=1 sequence=430 recid=433 stamp=725118048
                    input archive log thread=1 sequence=431 recid=434 stamp=725118049
                    input archive log thread=1 sequence=432 recid=435 stamp=725118059
                    input archive log thread=1 sequence=433 recid=436 stamp=725118383
                    input archive log thread=1 sequence=434 recid=437 stamp=725151649
                    input archive log thread=1 sequence=435 recid=438 stamp=725202133
                    input archive log thread=1 sequence=436 recid=439 stamp=725268260
                    input archive log thread=1 sequence=437 recid=440 stamp=725338802
                    input archive log thread=1 sequence=438 recid=441 stamp=725338802
                    input archive log thread=1 sequence=439 recid=442 stamp=725338808
                    input archive log thread=1 sequence=440 recid=443 stamp=725339152
                    input archive log thread=1 sequence=441 recid=444 stamp=725367618
                    input archive log thread=1 sequence=442 recid=445 stamp=725407272
                    input archive log thread=1 sequence=443 recid=446 stamp=725449069
                    input archive log thread=1 sequence=444 recid=447 stamp=725449079
                    input archive log thread=1 sequence=445 recid=448 stamp=725451539
                    input archive log thread=1 sequence=446 recid=449 stamp=725451541
                    input archive log thread=1 sequence=447 recid=450 stamp=725451552
                    input archive log thread=1 sequence=448 recid=451 stamp=725451980
                    input archive log thread=1 sequence=449 recid=452 stamp=725480170
                    input archive log thread=1 sequence=450 recid=453 stamp=725480776
                    input archive log thread=1 sequence=451 recid=454 stamp=725481386
                    input archive log thread=1 sequence=452 recid=455 stamp=725481993
                    input archive log thread=1 sequence=453 recid=456 stamp=725482604
                    input archive log thread=1 sequence=454 recid=457 stamp=725483204
                    input archive log thread=1 sequence=455 recid=458 stamp=725483488
                    input archive log thread=1 sequence=456 recid=459 stamp=725483503
                    channel ORA_DISK_1: starting piece 1 at 10-AUG-10
                    channel ORA_DISK_1: finished piece 1 at 10-AUG-10
                    piece handle=D:\ORACLE_BACKUP_DATA\DEV\ARCHLALL02TE_1_1_2455006062_20100810.ARC tag=ARCBKP comment=NONE
                    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:48
                    channel ORA_DISK_1: starting archive log backupset
                    channel ORA_DISK_1: specifying archive log(s) in backup set
                    input archive log thread=1 sequence=344 recid=347 stamp=723870001
                    input archive log thread=1 sequence=345 recid=348 stamp=723870001
                    input archive log thread=1 sequence=346 recid=349 stamp=723870008
                    input archive log thread=1 sequence=347 recid=350 stamp=723870384
                    input archive log thread=1 sequence=348 recid=351 stamp=723897655
                    input archive log thread=1 sequence=349 recid=352 stamp=723898042
                    input archive log thread=1 sequence=350 recid=353 stamp=723938460
                    input archive log thread=1 sequence=351 recid=354 stamp=723956402
                    input archive log thread=1 sequence=352 recid=355 stamp=723956403
                    input archive log thread=1 sequence=353 recid=356 stamp=723956410
                    input archive log thread=1 sequence=354 recid=357 stamp=723956780
                    input archive log thread=1 sequence=355 recid=358 stamp=724023250
                    input archive log thread=1 sequence=356 recid=359 stamp=724071608
                    input archive log thread=1 sequence=357 recid=360 stamp=724132863
                    input archive log thread=1 sequence=358 recid=361 stamp=724151928
                    input archive log thread=1 sequence=359 recid=362 stamp=724151928
                    input archive log thread=1 sequence=360 recid=363 stamp=724151939
                    input archive log thread=1 sequence=361 recid=364 stamp=724152282
                    input archive log thread=1 sequence=362 recid=365 stamp=724190415
                    input archive log thread=1 sequence=363 recid=366 stamp=724201229
                    input archive log thread=1 sequence=364 recid=367 stamp=724238828
                    input archive log thread=1 sequence=365 recid=368 stamp=724238829
                    input archive log thread=1 sequence=366 recid=369 stamp=724238840
                    input archive log thread=1 sequence=367 recid=370 stamp=724239197
                    input archive log thread=1 sequence=368 recid=371 stamp=724243303
                    input archive log thread=1 sequence=369 recid=372 stamp=724243304
                    input archive log thread=1 sequence=370 recid=373 stamp=724243313
                    input archive log thread=1 sequence=371 recid=374 stamp=724243647
                    input archive log thread=1 sequence=372 recid=375 stamp=724263602
                    input archive log thread=1 sequence=373 recid=376 stamp=724263602
                    input archive log thread=1 sequence=374 recid=377 stamp=724263612
                    input archive log thread=1 sequence=375 recid=378 stamp=724263936
                    input archive log thread=1 sequence=376 recid=379 stamp=724288929
                    input archive log thread=1 sequence=377 recid=380 stamp=724302001
                    input archive log thread=1 sequence=378 recid=381 stamp=724302002
                    input archive log thread=1 sequence=379 recid=382 stamp=724302008
                    input archive log thread=1 sequence=380 recid=383 stamp=724302383
                    input archive log thread=1 sequence=381 recid=384 stamp=724337981
                    input archive log thread=1 sequence=382 recid=385 stamp=724337982
                    input archive log thread=1 sequence=383 recid=386 stamp=724337991
                    input archive log thread=1 sequence=384 recid=387 stamp=724338325
                    input archive log thread=1 sequence=385 recid=388 stamp=724370466
                    input archive log thread=1 sequence=386 recid=390 stamp=724414873
                    input archive log thread=1 sequence=387 recid=389 stamp=724414872
                    input archive log thread=1 sequence=388 recid=391 stamp=724414889
                    input archive log thread=1 sequence=389 recid=392 stamp=724415212
                    input archive log thread=1 sequence=390 recid=393 stamp=724427958
                    input archive log thread=1 sequence=391 recid=394 stamp=724427958
                    input archive log thread=1 sequence=392 recid=395 stamp=724427969
                    input archive log thread=1 sequence=393 recid=396 stamp=724428380
                    input archive log thread=1 sequence=394 recid=397 stamp=724472637
                    input archive log thread=1 sequence=395 recid=398 stamp=724497354
                    input archive log thread=1 sequence=396 recid=399 stamp=724497354
                    input archive log thread=1 sequence=397 recid=400 stamp=724497365
                    input archive log thread=1 sequence=398 recid=401 stamp=724497802
                    input archive log thread=1 sequence=399 recid=402 stamp=724541767
                    input archive log thread=1 sequence=400 recid=403 stamp=724583782
                    input archive log thread=1 sequence=401 recid=404 stamp=724629924
                    input archive log thread=1 sequence=402 recid=405 stamp=724647601
                    input archive log thread=1 sequence=403 recid=406 stamp=724647602
                    input archive log thread=1 sequence=404 recid=407 stamp=724647608
                    input archive log thread=1 sequence=405 recid=408 stamp=724647976
                    input archive log thread=1 sequence=406 recid=409 stamp=724701637
                    input archive log thread=1 sequence=407 recid=410 stamp=724755641
                    channel ORA_DISK_1: starting piece 1 at 10-AUG-10
                    channel ORA_DISK_1: finished piece 1 at 10-AUG-10
                    piece handle=D:\ORACLE_BACKUP_DATA\DEV\ARCHLBLL02UV_1_1_2455006062_20100810.ARC tag=ARCBKP comment=NONE
                    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:38
                    channel ORA_DISK_1: starting archive log backupset
                    channel ORA_DISK_1: specifying archive log(s) in backup set
                    input archive log thread=1 sequence=457 recid=460 stamp=725483523
                    input archive log thread=1 sequence=458 recid=461 stamp=725493669
                    input archive log thread=1 sequence=459 recid=462 stamp=725515319
                    input archive log thread=1 sequence=460 recid=463 stamp=725564195
                    input archive log thread=1 sequence=461 recid=464 stamp=725581742
                    input archive log thread=1 sequence=462 recid=465 stamp=725626766
                    input archive log thread=1 sequence=463 recid=466 stamp=725626766
                    input archive log thread=1 sequence=464 recid=467 stamp=725626779
                    input archive log thread=1 sequence=465 recid=468 stamp=725627114
                    input archive log thread=1 sequence=466 recid=469 stamp=725666432
                    input archive log thread=1 sequence=467 recid=470 stamp=725674668
                    input archive log thread=1 sequence=468 recid=471 stamp=725684401
                    input archive log thread=1 sequence=469 recid=472 stamp=725684402
                    input archive log thread=1 sequence=470 recid=473 stamp=725684415
                    input archive log thread=1 sequence=471 recid=474 stamp=725684773
                    input archive log thread=1 sequence=472 recid=475 stamp=725709301
                    input archive log thread=1 sequence=473 recid=476 stamp=725709302
                    input archive log thread=1 sequence=474 recid=477 stamp=725709313
                    input archive log thread=1 sequence=475 recid=478 stamp=725709657
                    input archive log thread=1 sequence=476 recid=479 stamp=725752852
                    input archive log thread=1 sequence=477 recid=480 stamp=725770802
                    input archive log thread=1 sequence=478 recid=481 stamp=725770802
                    input archive log thread=1 sequence=479 recid=482 stamp=725770809
                    input archive log thread=1 sequence=480 recid=483 stamp=725771153
                    input archive log thread=1 sequence=481 recid=484 stamp=725799520
                    input archive log thread=1 sequence=482 recid=485 stamp=725799520
                    input archive log thread=1 sequence=483 recid=486 stamp=725799530
                    input archive log thread=1 sequence=484 recid=487 stamp=725799888
                    input archive log thread=1 sequence=485 recid=488 stamp=725800362
                    input archive log thread=1 sequence=486 recid=489 stamp=725800362
                    input archive log thread=1 sequence=487 recid=490 stamp=725800374
                    input archive log thread=1 sequence=488 recid=491 stamp=725800707
                    input archive log thread=1 sequence=489 recid=492 stamp=725805305
                    input archive log thread=1 sequence=490 recid=493 stamp=725806803
                    input archive log thread=1 sequence=491 recid=494 stamp=725807951
                    input archive log thread=1 sequence=492 recid=495 stamp=725807952
                    input archive log thread=1 sequence=493 recid=496 stamp=725807961
                    input archive log thread=1 sequence=494 recid=497 stamp=725808364
                    input archive log thread=1 sequence=495 recid=498 stamp=725841136
                    input archive log thread=1 sequence=496 recid=499 stamp=725841143
                    input archive log thread=1 sequence=497 recid=500 stamp=725875211
                    input archive log thread=1 sequence=498 recid=501 stamp=725918428
                    input archive log thread=1 sequence=499 recid=502 stamp=725927615
                    input archive log thread=1 sequence=500 recid=503 stamp=725940064
                    input archive log thread=1 sequence=501 recid=504 stamp=725967972
                    input archive log thread=1 sequence=502 recid=505 stamp=725967972
                    input archive log thread=1 sequence=503 recid=506 stamp=725967984
                    input archive log thread=1 sequence=504 recid=507 stamp=725968389
                    input archive log thread=1 sequence=505 recid=518 stamp=726404882
                    input archive log thread=1 sequence=506 recid=525 stamp=726404883
                    input archive log thread=1 sequence=507 recid=519 stamp=726404882
                    input archive log thread=1 sequence=508 recid=520 stamp=726404882
                    input archive log thread=1 sequence=509 recid=521 stamp=726404882
                    input archive log thread=1 sequence=510 recid=522 stamp=726404882
                    input archive log thread=1 sequence=511 recid=523 stamp=726404882
                    input archive log thread=1 sequence=512 recid=524 stamp=726404882
                    input archive log thread=1 sequence=513 recid=527 stamp=726404883
                    input archive log thread=1 sequence=514 recid=526 stamp=726404883
                    input archive log thread=1 sequence=516 recid=517 stamp=726404871
                    input archive log thread=1 sequence=517 recid=528 stamp=726404892
                    channel ORA_DISK_1: starting piece 1 at 10-AUG-10
                    channel ORA_DISK_1: finished piece 1 at 10-AUG-10
                    piece handle=D:\ORACLE_BACKUP_DATA\DEV\ARCHLCLL0305_1_1_2455006062_20100810.ARC tag=ARCBKP comment=NONE
                    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:38
                    channel ORA_DISK_1: starting archive log backupset
                    channel ORA_DISK_1: specifying archive log(s) in backup set
                    input archive log thread=1 sequence=1 recid=529 stamp=726405054
                    input archive log thread=1 sequence=2 recid=530 stamp=726405954
                    input archive log thread=1 sequence=3 recid=531 stamp=726406674
                    input archive log thread=1 sequence=4 recid=532 stamp=726406679
                    input archive log thread=1 sequence=5 recid=533 stamp=726406686
                    input archive log thread=1 sequence=6 recid=534 stamp=726407860
                    input archive log thread=1 sequence=7 recid=535 stamp=726407860
                    input archive log thread=1 sequence=8 recid=536 stamp=726407872
                    input archive log thread=1 sequence=9 recid=537 stamp=726408377
                    input archive log thread=1 sequence=10 recid=538 stamp=726454857
                    input archive log thread=1 sequence=11 recid=539 stamp=726462000
                    input archive log thread=1 sequence=12 recid=540 stamp=726462001
                    input archive log thread=1 sequence=13 recid=541 stamp=726462006
                    input archive log thread=1 sequence=14 recid=542 stamp=726462426
                    input archive log thread=1 sequence=15 recid=543 stamp=726493123
                    input archive log thread=1 sequence=16 recid=544 stamp=726493133
                    input archive log thread=1 sequence=17 recid=545 stamp=726534005
                    input archive log thread=1 sequence=18 recid=546 stamp=726573217
                    input archive log thread=1 sequence=19 recid=547 stamp=726573217
                    input archive log thread=1 sequence=20 recid=548 stamp=726573228
                    input archive log thread=1 sequence=21 recid=549 stamp=726573628
                    input archive log thread=1 sequence=22 recid=550 stamp=726592070
                    input archive log thread=1 sequence=23 recid=551 stamp=726613242
                    input archive log thread=1 sequence=24 recid=552 stamp=726616849
                    input archive log thread=1 sequence=25 recid=553 stamp=726617414
                    input archive log thread=1 sequence=26 recid=554 stamp=726617421
                    input archive log thread=1 sequence=27 recid=555 stamp=726617427
                    input archive log thread=1 sequence=28 recid=556 stamp=726645182
                    input archive log thread=1 sequence=29 recid=557 stamp=726666042
                    input archive log thread=1 sequence=30 recid=558 stamp=726666042
                    input archive log thread=1 sequence=31 recid=559 stamp=726666054
                    channel ORA_DISK_1: starting piece 1 at 10-AUG-10
                    channel ORA_DISK_1: finished piece 1 at 10-AUG-10
                    piece handle=D:\ORACLE_BACKUP_DATA\DEV\ARCHLDLL031B_1_1_2455006062_20100810.ARC tag=ARCBKP comment=NONE
                    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:27
                    Finished backup at 10-AUG-10
                    Starting backup at 10-AUG-10
                    using channel ORA_DISK_1
                    channel ORA_DISK_1: starting full datafile backupset
                    channel ORA_DISK_1: specifying datafile(s) in backupset
                    input datafile fno=00001 name=D:\ORACLE\DATA\DEV\SYSTEM01.DBF
                    input datafile fno=00003 name=D:\ORACLE\DATA\DEV\SYSAUX01.DBF
                    input datafile fno=00002 name=D:\ORACLE\DATA\DEV\UNDOTBS01.DBF
                    input datafile fno=00007 name=D:\ORACLE\DATA\DEV\MEDIUMDATA_01.ORA
                    input datafile fno=00010 name=D:\ORACLE\DATA\DEV\SMALLINDEXES_01.ORA
                    input datafile fno=00005 name=D:\ORACLE\DATA\DEV\LARGEDATA_01.ORA
                    input datafile fno=00006 name=D:\ORACLE\DATA\DEV\LARGEINDEXES_01.ORA
                    input datafile fno=00008 name=D:\ORACLE\DATA\DEV\MEDIUMINDEXES_01.ORA
                    input datafile fno=00013 name=D:\ORACLE\DATA\DEV\XXSMALLTABS_01.ORA
                    input datafile fno=00009 name=D:\ORACLE\DATA\DEV\SMALLDATA_01.ORA
                    input datafile fno=00011 name=D:\ORACLE\DATA\DEV\XSMALLDATA_01.ORA
                    input datafile fno=00012 name=D:\ORACLE\DATA\DEV\XSMALLINDEXES_01.ORA
                    input datafile fno=00004 name=D:\ORACLE\DATA\DEV\USERS01.DBF
                    channel ORA_DISK_1: starting piece 1 at 10-AUG-10
                    channel ORA_DISK_1: finished piece 1 at 10-AUG-10
                    piece handle=D:\ORACLE_BACKUP_DATA\DEV\LELL0327_1_1_2455006062_20100810.BKP tag=EVERYDAY_FULL_BKUP comment=NONE
                    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:46
                    channel ORA_DISK_1: starting full datafile backupset
                    channel ORA_DISK_1: specifying datafile(s) in backupset
                    including current control file in backupset
                    channel ORA_DISK_1: starting piece 1 at 10-AUG-10
                    channel ORA_DISK_1: finished piece 1 at 10-AUG-10
                    piece handle=D:\ORACLE_BACKUP_DATA\DEV\LFLL033L_1_1_2455006062_20100810.BKP tag=EVERYDAY_FULL_BKUP comment=NONE
                    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
                    Finished backup at 10-AUG-10
                    Starting backup at 10-AUG-10
                    current log archived
                    using channel ORA_DISK_1
                    channel ORA_DISK_1: starting archive log backupset
                    channel ORA_DISK_1: specifying archive log(s) in backup set
                    input archive log thread=1 sequence=32 recid=560 stamp=726666359
                    channel ORA_DISK_1: starting piece 1 at 10-AUG-10
                    channel ORA_DISK_1: finished piece 1 at 10-AUG-10
                    piece handle=D:\ORACLE_BACKUP_DATA\DEV\ARCHLGLL033N_1_1_2455006062_20100810.ARC tag=ARCBKP comment=NONE
                    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
                    Finished backup at 10-AUG-10

                    Starting backup at 10-AUG-10
                    using channel ORA_DISK_1
                    channel ORA_DISK_1: starting full datafile backupset
                    channel ORA_DISK_1: specifying datafile(s) in backupset
                    including current control file in backupset
                    channel ORA_DISK_1: starting piece 1 at 10-AUG-10
                    channel ORA_DISK_1: finished piece 1 at 10-AUG-10
                    piece handle=D:\ORACLE\10G\DATABASE\LHLL033P_1_1 tag=TAG20100810T114601 comment=NONE
                    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
                    Finished backup at 10-AUG-10

                    Starting restore at 10-AUG-10
                    using channel ORA_DISK_1

                    channel ORA_DISK_1: starting validation of datafile backupset
                    channel ORA_DISK_1: reading from backup piece D:\ORACLE_BACKUP_DATA\DEV\LELL0327_1_1_2455006062_20100810.BKP
                    channel ORA_DISK_1: restored backup piece 1
                    piece handle=D:\ORACLE_BACKUP_DATA\DEV\LELL0327_1_1_2455006062_20100810.BKP tag=EVERYDAY_FULL_BKUP
                    channel ORA_DISK_1: validation complete, elapsed time: 00:00:16
                    Finished restore at 10-AUG-10

                    using channel ORA_DISK_1
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\G8LJB94E_1_1_2455006062_20100721.BKP recid=519 stamp=724935823
                    crosschecked backup piece: found to be 'AVAILABLE'
                    backup piece handle=D:\ORACLE\10G\DATABASE\GALJB94J_1_1 recid=521 stamp=724935828
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\GHLJD1EV_1_1_2455006062_20100722.BKP recid=528 stamp=724993504
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\GILJD1GC_1_1_2455006062_20100722.BKP recid=529 stamp=724993549
                    crosschecked backup piece: found to be 'AVAILABLE'
                    backup piece handle=D:\ORACLE\10G\DATABASE\GKLJD1GI_1_1 recid=531 stamp=724993555
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\GRLJGRBV_1_1_2455006062_20100723.BKP recid=538 stamp=725118336
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\GSLJGRDD_1_1_2455006062_20100723.BKP recid=539 stamp=725118382
                    crosschecked backup piece: found to be 'AVAILABLE'
                    backup piece handle=D:\ORACLE\10G\DATABASE\GULJGRDI_1_1 recid=541 stamp=725118387
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\H5LJNIV0_1_1_2455006062_20100726.BKP recid=548 stamp=725339106
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\H6LJNJ0E_1_1_2455006062_20100726.BKP recid=549 stamp=725339151
                    crosschecked backup piece: found to be 'AVAILABLE'
                    backup piece handle=D:\ORACLE\10G\DATABASE\H8LJNJ0J_1_1 recid=551 stamp=725339156
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\HFLJR14S_1_1_2455006062_20100727.BKP recid=558 stamp=725451933
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\HGLJR16A_1_1_2455006062_20100727.BKP recid=559 stamp=725451978
                    crosschecked backup piece: found to be 'AVAILABLE'
                    backup piece handle=D:\ORACLE\10G\DATABASE\HILJR16F_1_1 recid=561 stamp=725451984
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\HPLK0C5Q_1_1_2455006062_20100729.BKP recid=568 stamp=725627067
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\HQLK0C78_1_1_2455006062_20100729.BKP recid=569 stamp=725627112
                    crosschecked backup piece: found to be 'AVAILABLE'
                    backup piece handle=D:\ORACLE\10G\DATABASE\HSLK0C7D_1_1 recid=571 stamp=725627118
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\I3LK24FL_1_1_2455006062_20100730.BKP recid=578 stamp=725684727
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\I4LK24H3_1_1_2455006062_20100730.BKP recid=579 stamp=725684772
                    crosschecked backup piece: found to be 'AVAILABLE'
                    backup piece handle=D:\ORACLE\10G\DATABASE\I6LK24H9_1_1 recid=581 stamp=725684777
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\IDLK2SP9_1_1_2455006062_20100730.BKP recid=588 stamp=725709610
                    crosschecked backup piece: found to be 'EXPIRED'
                    backup piece handle=D:\ORACLE_BACKUP_DATA\DEV\IELK2SQN_1_1_2455006062_20100730.BKP recid=589 stamp=725709656
                    crosschecked backup piece: found to be 'AVAILABLE'
                    • 22. Re: dbms_scheduler
                      user645399
                      This is the last part of the file:

                      released channel: ORA_DISK_1
                      allocated channel: ORA_DISK_1
                      channel ORA_DISK_1: sid=166 devtype=DISK
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00001_0726405007.001 recid=529 stamp=726405054
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00002_0726405007.001 recid=530 stamp=726405954
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00003_0726405007.001 recid=531 stamp=726406674
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00004_0726405007.001 recid=532 stamp=726406679
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00005_0726405007.001 recid=533 stamp=726406686
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00006_0726405007.001 recid=534 stamp=726407860
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00007_0726405007.001 recid=535 stamp=726407860
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00008_0726405007.001 recid=536 stamp=726407872
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00009_0726405007.001 recid=537 stamp=726408377
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00010_0726405007.001 recid=538 stamp=726454857
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00011_0726405007.001 recid=539 stamp=726462000
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00012_0726405007.001 recid=540 stamp=726462001
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00013_0726405007.001 recid=541 stamp=726462006
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00014_0726405007.001 recid=542 stamp=726462426
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00015_0726405007.001 recid=543 stamp=726493123
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00016_0726405007.001 recid=544 stamp=726493133
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00017_0726405007.001 recid=545 stamp=726534005
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00018_0726405007.001 recid=546 stamp=726573217
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00019_0726405007.001 recid=547 stamp=726573217
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00020_0726405007.001 recid=548 stamp=726573228
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00021_0726405007.001 recid=549 stamp=726573628
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00022_0726405007.001 recid=550 stamp=726592070
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00023_0726405007.001 recid=551 stamp=726613242
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00024_0726405007.001 recid=552 stamp=726616849
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00025_0726405007.001 recid=553 stamp=726617414
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00026_0726405007.001 recid=554 stamp=726617421
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00027_0726405007.001 recid=555 stamp=726617427
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00028_0726405007.001 recid=556 stamp=726645182
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00029_0726405007.001 recid=557 stamp=726666042
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00030_0726405007.001 recid=558 stamp=726666042
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00031_0726405007.001 recid=559 stamp=726666054
                      validation succeeded for archived log
                      archive log filename=D:\ORACLE\ADMIN\DEV\ARCH\ARC00032_0726405007.001 recid=560 stamp=726666359
                      Crosschecked 32 objects

                      Recovery Manager complete.
                      • 23. Re: dbms_scheduler
                        CKPT
                        Hi,

                        channel ORA_DISK_1: validation complete, elapsed time: 00:00:16
                        Finished restore at 10-AUG-10
                        piece handle=D:\ORACLE_BACKUP_DATA\DEV\ARCHL9LL02RU_1_1_2455006062_20100810.ARC tag=ARCBKP comment=NONE
                        so the dbms_scheduler job executes successfully right.

                        Thanks

                        Edited by: CKPT on Aug 10, 2010 12:35 PM
                        • 24. Re: dbms_scheduler
                          user645399
                          CKPT wrote:
                          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
                          CKPT, the table consists of 2541 rows.

                          So, I tried this and found none:
                          select * from v$rman_output
                          where output like '10-AUG%'
                          Is there some other way to find out?

                          Nith
                          • 25. Re: dbms_scheduler
                            user645399
                            This file is lastly modified at 11.40 am today ,when I did the backup manually by clicking on the dat file.

                            Not when the scheduler ran. The scheduler was tested around 2pm.

                            You get the picture?

                            Nith

                            Edited by: user645399 on Aug 10, 2010 3:12 PM
                            • 26. Re: dbms_scheduler
                              CKPT
                              can you try
                              select * from v$rman_bakcup_job_details where start_time like '%10%AUG%';
                              Thanks

                              Edited by: CKPT on Aug 10, 2010 12:48 PM
                              • 27. Re: dbms_scheduler
                                user645399
                                select * from v$rman_backup_job_details where start_time 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
                                • 28. Re: dbms_scheduler
                                  user645399
                                  Why when I execute the bat files using a windows scheduler or dbms scheduler alone, I have problem?

                                  Nith
                                  1 2 Previous Next