DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: automatic backup problem

  1. #1
    Join Date
    Jul 2007
    Posts
    32

    automatic backup problem

    hi guys,

    oracle version 10.2.0
    windowsNT

    I am taking RMAN backups automaticaly using os scheduler.

    Am using batch file to connect RMAN and call X.rcv file to run the script.Now my problem is, i need to create a folder in the current date and make daily incremental backups in that particular folder.......

    i created the folder namin current date in batch file but i dont know how to pass it to the .rcv file...

    .rcv file content is

    run
    {
    allocate channel c1 device type disk format='C:/backup/....currentdate foldername........../db_%U'
    .
    .
    .
    }
    exit;


    Any guidance plz.....

    TIA,

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    What format are you using for "current date"?

    RMAN allows %D (day DD) %M (month MM) %Y (year YYYY) to specify a format.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width