Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2013
    Posts
    4

    RMAN newbie question

    I am new to Oralce and I've recently turned on ARCHIVELOGMODE for our Oracle database so that I can perform hot backups. Ive also setup CRONTAB on our linux server to run the following script so that RMAN backs up. I left out all the other linux stuff for simplicity.

    run {
    DELETE NOPROMPT BACKUP;
    BACKUP DEVICE TYPE DISK TAG '%TAG' DATABASE;
    BACKUP DEVICE TYPE DISK TAG '%TAG' ARCHIVELOG ALL NOT BACKED UP DELETE ALL INPUT;
    }

    I do a full backup nightly. Before the full backup is done RMAN deletes the prior night's backup due to a limitation of hard drive space. By that time our backup server has copied the backup files into tape anyway. It backups up using the conrol file. It also backs up the archive logs and deletes them afterwards, again do to space constraints.

    My question is as follows:

    Is this a good backup strategy to have?

    Is there any other command that I may be missing from my script that would be useful?

    Any other suggestions?

    Your help will be much appreciated, thank you in advanced.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,622
    If you have NOT successfully actually restored the DB to online state, you have more work to complete.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  3. #3
    Join Date
    Jan 2013
    Posts
    4
    Quote Originally Posted by anacedent View Post
    If you have NOT successfully actually restored the DB to online state, you have more work to complete.
    I havent actaully tried a full recovery. Any suggestions on what I should expect with the current backup scheme?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,622
    If you are told that all is OK, but can't restore when required, then who pays the price?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  5. #5
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    You should be aware, that there are times, where you do not have a backup with this strategy (if i.e. the DB crashes during backup)
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  6. #6
    Join Date
    Jan 2013
    Posts
    4
    Quote Originally Posted by magicwand View Post
    You should be aware, that there are times, where you do not have a backup with this strategy (if i.e. the DB crashes during backup)
    If the database crashes during backup than I would simply restore an older set of backup files from tape and recover the database from that point.

    What I want to know is if this is not a good backup strategy What do you recommend I do? Thanks!

  7. #7
    Join Date
    Jun 2004
    Posts
    746
    In my opinion no - it's not a good strategy to have only one backup copy on disk. It's a terrible idea to delete that one copy before making the next backup and then hope & pray that an untested backup to tape will be enough to restore the database if it all goes wrong.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  8. #8
    Join Date
    Jan 2013
    Posts
    2
    Hi,

    I would also recommend having a look at level 1 backups instead of doing a full backup every night. The strategy that I use is a level 0 weekly and a level 1 every other night. I also back up the archivelogs which have been created twice a day.

    Ultimately, the backup strategy has to adhere to what the business requirements are. If the business cannot afford to lose 1 single transaction you might use something like data guard maximum protection mode. If the business says that for a particular database you need to be able to restore within 2 hours, and it be operational again, you need to plan around this. Depending on what they want will dictate how much effort, time and how much the strategy costs to implement.
    Another example would be that restoring a full backup is quicker than restoring a full backup + 3 day's worth of level 1s. It all depends on what you are trying to achieve.

    Rob

Tags for this Thread

Posting Permissions

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