This discussion is archived
2 Replies Latest reply: Nov 26, 2012 11:51 AM by efierro RSS

how to keep archivelog number of 15 in rman redundancy 2 days

975800 Newbie
Currently Being Moderated
hi.. all

i'm oracle engeener in korea.

i have a question....

my company using to rman backup eveyday and using script. (cron)

sciprt detail is

run {
backup database;
backup archivelog all;
...
...
delete obsolete redundancy 2;
...
...
}
------------------------------------------------------------------------
IN RMAN
CONFIGURATION RMAN .... REDUNDANCY 2;
CONFIGURATION ...
CONFIGURATION ...
CONFIGURATION delete archivelog policy to none;
#################################

my issue is

i wnat have a archivelog 15 numbers after start sciprt, but archivelog're deleted that reason redundancy 2 in rman policy.

so i change to script and rman configure, change to method, backup archivelog all ... keep ~ until 'sysdate-15' in rman script. ... but this method failed
i change to sciprt and rman configure, change to methed, from redundany 2 to windows 2. but faild

all methed're archivelog deleted in configuration rman policy.

how can i reramin to archivelog 15 numbers in oracle that rman policy is backup and delete options.

help me....ㅜㅜ

ps)
english is very difficulte... in my life
  • 1. Re: how to keep archivelog number of 15 in rman redundancy 2 days
    mseberg Guru
    Currently Being Moderated
    Hello;

    This would work for that
    echo "Starting RMAN..."
    $ORACLE_HOME/bin/rman target / catalog <catalog_user>/<password>@<catalog_db> << EOF
    
    run 
    { 
    allocate channel d1 type disk;
    allocate channel d2 type disk;
    allocate channel d3 type disk;
    backup full as compressed backupset   
    database plus archivelog;
    release channel d1;
    release channel d2;
    release channel d3;
    
    }
    
    
    
    
    delete noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-15';
    
    
    DELETE noprompt BACKUP COMPLETED BEFORE 'SYSDATE-3' DEVICE TYPE DISK;
    
    
    exit
    
    
    EOF
    
    echo `date`
    #
    echo
    echo 'RMAN Full Complete'
    Best Regards

    mseberg
  • 2. Re: how to keep archivelog number of 15 in rman redundancy 2 days
    efierro Newbie
    Currently Being Moderated
    Post the entire rman scripts, dots don't help.
    Don't do delete obsolete..., that tells rman to delete all backups that are not required to go back a certain period of time (window) or backups older than the number of retained ones (redundancy).
    You can manage your deletions with until 'sysdate-N' as someone recommended above.

Legend

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