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

Thread: RMAN shell script - db in archive log mode

  1. #1
    Join Date
    Dec 2007
    Posts
    82

    RMAN shell script - db in archive log mode

    Hi,
    DB: oracle 10g .
    OS: RHAL /LINUX
    I need to take full backup copy every day in midnight. all dbf file, sp file, control files, archive logs into a locaiton /backup directory in understandable format what each file belongs to and its kind. ( I need to do backup as copy database plus archive log all) including spfile and control file. can one provide me suitable script please. thanks
    I have something like directory structure:
    /backup/dbffiles
    /backup/controlfiles
    /backup/spfiles
    /backup/archivelog
    there should be only one latest set of backup copy including all the files all the time.
    thanks in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well what have you come up with so far

  3. #3
    Join Date
    Dec 2007
    Posts
    82
    rman
    {
    backup AS COPY format ‘/backup/dbffiles/%U’ database;
    backup AS COPY format ‘/backup/archivelogs/arch_%U’ archivelog all delete input;;
    backup AS COPY format ‘/backup/controlfile/ctl_%U’ current controlfile;
    backup AS COPY format ‘/backup/spfile/spfile_%U’ current spfile;
    }

    is the way to do or any changes u suggest ?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    did it do what you want?

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