If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > RMAN newbie question

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,572
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.
Don't say, show. Don't promise, prove.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
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?
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,572
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.
Don't say, show. Don't promise, prove.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
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!
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Jun 2004
Posts: 733
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.
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
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
Reply With Quote
Reply

Tags
10gr2, backup database, rman

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On