Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    Unanswered: rman archive backup to tape and disk

    hi ,
    I need to do archive backup using rman to tape and disk.The requirement is like this...
    The conventional RMAN way is:
    a)Archive logs are written to /archlog directory
    b)Backup ALL archive logs to tape
    c)Delete ALL archive logs in / archlog directory

    Current requirement is:
    a)Archive logs are written to /archlog directory

    b)Backup ALL archive logs except the last one which is currently active.
    Eg.If there are 5 files in the current directory (the 5th file should
    not be backup-ed to tape)

    c)Those 4 files which are backed-up to tape, should be moved to another
    directory called /archlog/bckp

    d)At the end of the RMAN backup archiving log job, 4 archiving logs will be
    in tape, the same 4 archiving logs will be in /archlog/bckp directory &
    1 archive log will still be in /archlog directory.
    I hope now I am clear in explaining my problem.

    Please help me in this regard.

    Thanks & Regards,
    Sridhar

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    you should be log switching at least once an hour (if not more).
    with your current log switching you will lose almost 1/5 of your business as
    unrecoverable (5-6 hours of business).

    regardless, what is the significance of 4???
    let rman organize all of this. it knows what archivelogs have been backed up
    and what remains to be backed up. Then you just set your retention period.

    also, are you familiar with duplicate archive destinations?
    you don't have to copy anything anywhere. Oracle will do that for you.

    why reinvent the wheel?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    got the solution.

    hi ,
    I was aware of multiple archive destinations and/or duplex backup option available.
    But the requirement is such that I have to backup archives to tape first and..
    The ***same archives files***(not one less not one more) that are backed up to tape should be ****moved***(not backup) to another disk location.
    Anyways...I managed to find the solution in the following way....


    ******************************************

    pass=`cat /EXPORT/logindet`

    seq=`sqlplus -s $pass << END
    set pagesize 0 feedback off verify off heading off echo off
    select min(sequence#)-1 from v\\$log ;
    exit;
    END`

    rman << EOF
    connect target system/system@dev;
    connect catalog rman/rman@oms;
    run {
    allocate channel 'dev_1' type 'sbt_tape'
    parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ers,OB2BARLIST =ERSDEV_TEST
    _RMAN)';
    change archivelog all crosscheck ;
    backup archivelog until sequence $seq;
    release channel dev_1;
    }
    EOF

    sqlplus -s xxx/password@dev << END

    set pagesize 0 feedback off verify off heading off echo off

    spool move_to_disk.sh
    select 'mv '||name ||' /archlog/archlog_bkup' from v\$archived_log
    where sequence# < $seq;
    spool off;
    exit;
    END
    ******************************************

    Get back to me if any queries regarding this..

    Thanks & Regards,
    Sridhar

  4. #4
    Join Date
    May 2006
    Posts
    132
    As The_Duck indicated, you are setting yourself up for NOT being able to recover the transactions stored in that archivelog you are intentionally NOT backing up. Why are you intentionally avoiding the backing up of the newest archivelog?

    I understand conforming to requirements, but I would think the requirement to fully recover should take precedence over this requirement.

  5. #5
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89
    ya..I do understand ..this is a very pecular case which I encounter with ...thanks all for their remarks.

    sridhar

Posting Permissions

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