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

    Thanks
  • 16. Re: dbms_scheduler
    user645399 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    can you post log file details
    DevDB_outfile.txt ?
    and also do check in
    select * from v$rman_ouput
  • 19. Re: dbms_scheduler
    user645399 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Why when I execute the bat files using a windows scheduler or dbms scheduler alone, I have problem?

    Nith
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points