RE: Using RMAN
Debi, I run a weekly restore validate to make sure the tapes are available and working properly. Actually two runs a weekend - one for the database, and one for the archivelog backup. gives me a warm fuzzy every Monday morning. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, May 31, 2002 3:17 PM To: Multiple recipients of list ORACLE-L At 10:11 AM 5/31/2002 -0800, DENNIS WILLIAMS wrote: Pat - I think you've pretty well covered the pros/cons from what I understand. I haven't implemented in production, so hopefully some people with some experience of living with RMAN will respond. How about it guys? I have been using RMAN in production for three years, although only recently began backing up my archived logs with it as well. I do take exports as well, to make simple table recovery easier. We use Veritas NetBackup for tape. I keep an RMAN catalog database separate from the production database. It is now on the same server, although originally I had it on a development server but decided that was too risky. Immediately after a backup, I export the RMAN catalog database, then take an OS backup to tape of that dmp file. Our weekly cold backups were over 8 hours and with RMAN, the equivalent (level 0 consistent) takes about 2 and a half hours. Daily incrementals take an hour or less. I regularly create/refresh development and test databases from production with RMAN. These clones (what a great test of your backups!) generally take about 2 hours, and now that I have the archived logs, I can have a copy of production right to the minute. I don't have to worry about changing backups when adding datafiles. I monitor my log_archive_dest directory and when it gets to about 50% full I kick off a RMAN backup that puts a copy on two different tapes before deleting the input (archived logs on disk). My current issue is with tapes (and that is always an issue no matter what method you use), but I came across an RMAN command, restore validate, that I wonder if it will verify that my tape is ok. Twice I have tried to do a certain restore and the tape has been bad. I had to pick an earlier date and use archived logs... I cannot imagine NOT using RMAN! Debi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Debi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using RMAN
Soma - RMAN will only know about the disk backup since you aren't using a media manager like Legato or Veritas. When it needs to recover, RMAN will look to that spot on the disk and expect the correct file to be there. If for some reason the version on disk is unusable and RMAN needs an older version, RMAN will complain that the correct file isn't there, then you will have to load the version RMAN wants from tape before RMAN can continue. At least this is the way I understand RMAN will work. I haven't tried it, so if someone the list has better information, I would appreciate their response. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 16, 2002 5:21 PM To: Multiple recipients of list ORACLE-L Hi Currently we are using Unix scripts to do backups.We keep last 2 days of backups on the disk and also take the backups on tape daily. We are planning to use RMAN for backups and would like to maintain the the same policy of 2 days backup on disk and daily tape backups. Is it possible to implement this using RMAN? Which backup will RMAN remember (while restore) the disk backup or the tape backup? If we try to use the incremental strategy ,then how would RMAN remember the last incremental level 0 backup ? It will not be present on disk since we only keep the last 2 days backup on it. How do i use RMAN to do restore/recovery in this case? I heard that taking backups on tape is faster than on disk when using RMAN? Is it true? Could RMAN users share their backup/recovery strategies ,please. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Using RMAN
If you are using a recovery catalog then rman keeps track of everything there. He knows if you've been naughty, he know if you've been nice, he knowsOOOPS I got carried away. But when you do a restore using rman he will tell you what backup sets you will need. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 6:20 PM Hi Currently we are using Unix scripts to do backups.We keep last 2 days of backups on the disk and also take the backups on tape daily. We are planning to use RMAN for backups and would like to maintain the the same policy of 2 days backup on disk and daily tape backups. Is it possible to implement this using RMAN? Which backup will RMAN remember (while restore) the disk backup or the tape backup? If we try to use the incremental strategy ,then how would RMAN remember the last incremental level 0 backup ? It will not be present on disk since we only keep the last 2 days backup on it. How do i use RMAN to do restore/recovery in this case? I heard that taking backups on tape is faster than on disk when using RMAN? Is it true? Could RMAN users share their backup/recovery strategies ,please. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Using RMAN
See currently we are using Unix scripts to do our hot backups .We take the backup on disk and everynight after the disk backup we copy the backup on tape using Veritas Net Backup. Presently we keep 2 days worth of backups on the disk and 3 days of archive logs.That means at any point in time i have the last 2 days backup on disk (just for fatster recovery so that we can aviod going to tapes in case of a failure). Now if we start using RMAN ,we would be taking hot backups (mostly using increamental strategy) using RMAN.So for e.g. we start on say sunday taking an incremental level 0 backup on disk.RMAN only remmbers the disk backup ...right Note that we will also be copying the backups on tape but that will be independent of RMAN since it is not done using RMAN. Say the next 3 days of the week ,we do increamental level 1 backups .On the 3 rd day (i.e. Wednesday) i would have only Monday's and Tuesdays' backup on disk (which are the inceemental llevel 1 backups since the whole ideas is to keep last 2 days backup om disk). So if we have a failure on Wednesday then RMAN would look for the incremental level 0 backup of Sunday on the disk but that backup is not present on the disk now. I hope i have cleared it up enough. Now my question is can we maintain the same policy of keeping 2 days backup on disk by using RMAN. What kind of backup strategies do RMAN users follow? Are RMAN backups usually taken on tape directly ? Is it faster to take backups on tape rather on disk while using RMAN? Could RMAN users share their backup/recovery strategies ,please. TIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 5:55 AM If you are using a recovery catalog then rman keeps track of everything there. He knows if you've been naughty, he know if you've been nice, he knowsOOOPS I got carried away. But when you do a restore using rman he will tell you what backup sets you will need. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 6:20 PM Hi Currently we are using Unix scripts to do backups.We keep last 2 days of backups on the disk and also take the backups on tape daily. We are planning to use RMAN for backups and would like to maintain the the same policy of 2 days backup on disk and daily tape backups. Is it possible to implement this using RMAN? Which backup will RMAN remember (while restore) the disk backup or the tape backup? If we try to use the incremental strategy ,then how would RMAN remember the last incremental level 0 backup ? It will not be present on disk since we only keep the last 2 days backup on it. How do i use RMAN to do restore/recovery in this case? I heard that taking backups on tape is faster than on disk when using RMAN? Is it true? Could RMAN users share their backup/recovery strategies ,please. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Using RMAN
I have gone through this process. We used to backup to disk using scripts as described in Velpuri's book. We now use RMAN to backup to disk. Your backups will be faster and smaller in size, because RMAN will skip unused blocks and it also allows you to specify mutilple channels. I can backup a 70 Gb database in about 60 to 90 minutes. Here is a sample script: run { allocate channel ch1 type disk format '/bkup9/oracle/%d/full_s%s_p%p_%t'; allocate channel ch2 type disk format '/bkup3/oracle/%d/full_s%s_p%p_%t'; set limit channel ch1 kbytes=100; # Limit sets to 1 Gb. set limit channel ch2 kbytes=100; backup full database tag='daily_full_backup'; allocate channel ch3 type disk format '/bkup3/oracle/%d/arc_s%s_p%p_%t'; set limit channel ch3 kbytes=100; backup (archivelog until time 'sysdate-1/24' delete input channel ch3 ); } I do archivelog backups with a separate command, because RMAN can be a bit touchy when it comes to archivelogs. If none exist for the time specified, then the backup will fail. This way my database backup will be successful if there is a problem with the archivelog backup. I would skip the incremental stuff. Just do full backups unless you are talking huge databases. To tell RMAN what backup files are available on disk, prior to a restore, run this command: # Check which backups are available on disk. allocate channel for maintenance type disk; crosscheck backup; release channel; or this one if you are in noarchivelog mode: # Check which backups are available on disk. allocate channel for maintenance type disk; crosscheck backup of database; crosscheck backup of controlfile; release channel; Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 01/17/02 12:45PM See currently we are using Unix scripts to do our hot backups .We take the backup on disk and everynight after the disk backup we copy the backup on tape using Veritas Net Backup. Presently we keep 2 days worth of backups on the disk and 3 days of archive logs.That means at any point in time i have the last 2 days backup on disk (just for fatster recovery so that we can aviod going to tapes in case of a failure). Now if we start using RMAN ,we would be taking hot backups (mostly using increamental strategy) using RMAN.So for e.g. we start on say sunday taking an incremental level 0 backup on disk.RMAN only remmbers the disk backup ...right Note that we will also be copying the backups on tape but that will be independent of RMAN since it is not done using RMAN. Say the next 3 days of the week ,we do increamental level 1 backups .On the 3 rd day (i.e. Wednesday) i would have only Monday's and Tuesdays' backup on disk (which are the inceemental llevel 1 backups since the whole ideas is to keep last 2 days backup om disk). So if we have a failure on Wednesday then RMAN would look for the incremental level 0 backup of Sunday on the disk but that backup is not present on the disk now. I hope i have cleared it up enough. Now my question is can we maintain the same policy of keeping 2 days backup on disk by using RMAN. What kind of backup strategies do RMAN users follow? Are RMAN backups usually taken on tape directly ? Is it faster to take backups on tape rather on disk while using RMAN? Could RMAN users share their backup/recovery strategies ,please. TIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 5:55 AM If you are using a recovery catalog then rman keeps track of everything there. He knows if you've been naughty, he know if you've been nice, he knowsOOOPS I got carried away. But when you do a restore using rman he will tell you what backup sets you will need. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 6:20 PM Hi Currently we are using Unix scripts to do backups.We keep last 2 days of backups on the disk and also take the backups on tape daily. We are planning to use RMAN for backups and would like to maintain the the same policy of 2 days backup on disk and daily tape backups. Is it possible to implement this using RMAN? Which backup will RMAN remember (while restore) the disk backup or the tape backup? If we try to use the incremental strategy ,then how would RMAN remember the last incremental level 0 backup ? It will not be present on disk since we only keep the last 2 days backup on it. How do i use RMAN to do restore/recovery in this case? I heard that taking backups on tape is faster than on disk when using RMAN? Is it true? Could RMAN users share their backup/recovery strategies ,please. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
Re: Using RMAN
We use rman to backup all of our databases. But most importantly, we use it for production. Production databases are in archivelog mode. We do a level 1 backup at the end of the work day and prior to nitely batch processing. We do a level 0 backup early in the morning after batch and before users get on. We but a full days worth of backups, including the archivelog backups, on a tape in the morning. There is one tape for each day of the week, Mon-Fri. We delete archivlogs from the archive log destination after backing them up. Production is backed up while it is open. Test and developement databases are not in archivelog mode so we have to back them up while they are not available to users. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 12:45 PM See currently we are using Unix scripts to do our hot backups .We take the backup on disk and everynight after the disk backup we copy the backup on tape using Veritas Net Backup. Presently we keep 2 days worth of backups on the disk and 3 days of archive logs.That means at any point in time i have the last 2 days backup on disk (just for fatster recovery so that we can aviod going to tapes in case of a failure). Now if we start using RMAN ,we would be taking hot backups (mostly using increamental strategy) using RMAN.So for e.g. we start on say sunday taking an incremental level 0 backup on disk.RMAN only remmbers the disk backup ...right Note that we will also be copying the backups on tape but that will be independent of RMAN since it is not done using RMAN. Say the next 3 days of the week ,we do increamental level 1 backups .On the 3 rd day (i.e. Wednesday) i would have only Monday's and Tuesdays' backup on disk (which are the inceemental llevel 1 backups since the whole ideas is to keep last 2 days backup om disk). So if we have a failure on Wednesday then RMAN would look for the incremental level 0 backup of Sunday on the disk but that backup is not present on the disk now. I hope i have cleared it up enough. Now my question is can we maintain the same policy of keeping 2 days backup on disk by using RMAN. What kind of backup strategies do RMAN users follow? Are RMAN backups usually taken on tape directly ? Is it faster to take backups on tape rather on disk while using RMAN? Could RMAN users share their backup/recovery strategies ,please. TIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 5:55 AM If you are using a recovery catalog then rman keeps track of everything there. He knows if you've been naughty, he know if you've been nice, he knowsOOOPS I got carried away. But when you do a restore using rman he will tell you what backup sets you will need. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 6:20 PM Hi Currently we are using Unix scripts to do backups.We keep last 2 days of backups on the disk and also take the backups on tape daily. We are planning to use RMAN for backups and would like to maintain the the same policy of 2 days backup on disk and daily tape backups. Is it possible to implement this using RMAN? Which backup will RMAN remember (while restore) the disk backup or the tape backup? If we try to use the incremental strategy ,then how would RMAN remember the last incremental level 0 backup ? It will not be present on disk since we only keep the last 2 days backup on it. How do i use RMAN to do restore/recovery in this case? I heard that taking backups on tape is faster than on disk when using RMAN? Is it true? Could RMAN users share their backup/recovery strategies ,please. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
Re: Using RMAN
Ruth, I have a couple of questions 1. As I understand from your email ,you do incremental level 0 backups in the morning and level 1 backups in the evening and night everyday using RMAN...right. You mentioned that you also take the backups (i.e level 0 and 2 level 1's for a day )on tape every morning. Do you use RMAN to take the tape backups? If not then RMAN doesn't remember the tape backup . If you had a failure in the evening then you would just restore the level 0 and then apply the subsequent level 1 backup and the archived logs ,...right? My question is how big is your production database? How much time does it take to do 1. level 0 backup 2 level 1 backups Also how resource intensive are the incremenatal level 0 and level 1 backups like in terms of CPU,I/O etc since you do it in the middle of the day. Could you please tell me more about the tape backups that you do?Like what media magmt sortware are you using .We will be using Veritas Netbackup here. Thanks Sona - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 11:55 AM We use rman to backup all of our databases. But most importantly, we use it for production. Production databases are in archivelog mode. We do a level 1 backup at the end of the work day and prior to nitely batch processing. We do a level 0 backup early in the morning after batch and before users get on. We but a full days worth of backups, including the archivelog backups, on a tape in the morning. There is one tape for each day of the week, Mon-Fri. We delete archivlogs from the archive log destination after backing them up. Production is backed up while it is open. Test and developement databases are not in archivelog mode so we have to back them up while they are not available to users. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 12:45 PM See currently we are using Unix scripts to do our hot backups .We take the backup on disk and everynight after the disk backup we copy the backup on tape using Veritas Net Backup. Presently we keep 2 days worth of backups on the disk and 3 days of archive logs.That means at any point in time i have the last 2 days backup on disk (just for fatster recovery so that we can aviod going to tapes in case of a failure). Now if we start using RMAN ,we would be taking hot backups (mostly using increamental strategy) using RMAN.So for e.g. we start on say sunday taking an incremental level 0 backup on disk.RMAN only remmbers the disk backup ...right Note that we will also be copying the backups on tape but that will be independent of RMAN since it is not done using RMAN. Say the next 3 days of the week ,we do increamental level 1 backups .On the 3 rd day (i.e. Wednesday) i would have only Monday's and Tuesdays' backup on disk (which are the inceemental llevel 1 backups since the whole ideas is to keep last 2 days backup om disk). So if we have a failure on Wednesday then RMAN would look for the incremental level 0 backup of Sunday on the disk but that backup is not present on the disk now. I hope i have cleared it up enough. Now my question is can we maintain the same policy of keeping 2 days backup on disk by using RMAN. What kind of backup strategies do RMAN users follow? Are RMAN backups usually taken on tape directly ? Is it faster to take backups on tape rather on disk while using RMAN? Could RMAN users share their backup/recovery strategies ,please. TIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 5:55 AM If you are using a recovery catalog then rman keeps track of everything there. He knows if you've been naughty, he know if you've been nice, he knowsOOOPS I got carried away. But when you do a restore using rman he will tell you what backup sets you will need. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 6:20 PM Hi Currently we are using Unix scripts to do backups.We keep last 2 days of backups on the disk and also take the backups on tape daily. We are planning to use RMAN for backups and would like to maintain the the same policy of 2 days backup on disk and daily tape backups. Is it possible to implement this using RMAN? Which backup will RMAN remember (while restore) the disk backup or the tape backup? If we try to use the incremental strategy ,then how would RMAN remember the last incremental level 0 backup ? It will not be present on disk since we only keep the last 2 days backup on it. How do i use RMAN to do restore/recovery in this case? I heard that taking backups on tape is faster than on disk when using
Re: Using RMAN
Hi, I am not sure... what your exactly plan to do... But, You can configure RMAN to backup on DISK and use some TAPE MANAGEMENT UTILITY or SYSTEM UTILITY (If it is there) to backup from your DISK. Also that utility can delete after successful backup from DISK to TAPE depending on configuration and requirement. Now, in case of RESTORE... RMAN will try and restore from DISK, but if that is not there then you can restore back from TAPE to DISK and use RMAN to recover. Sounds logical ?? With all this in place.. also plan for backup of RMAN Repository. Can you please update me on the methodology you adopt. Have fun.. Nikunj PS: This is just to give an idea... you may have to workout some extra steps... and perform a test before implementing in REAL WORLD. Make a FREE long distance call from your PC!http://www.eboom.com/free/ - Original Message - From: Sona To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 16, 2002 03:20 PM Subject: Using RMAN Hi Currently we are using Unix scripts to do backups.We keep last 2 days of backups on the disk and also take the backups on tape daily. We are planning to use RMAN for backups and would like to maintain the the same policy of 2 days backup on disk and daily tape backups. Is it possible to implement this using RMAN? Which backup will RMAN remember (while restore) the disk backup or the tape backup? If we try to use the incremental strategy ,then how would RMAN remember the last incremental level 0 backup ? It will not be present on disk since we only keep the last 2 days backup on it. How do i use RMAN to do restore/recovery in this case? I heard that taking backups on tape is faster than on disk when using RMAN? Is it true? Could RMAN users share their backup/recovery strategies ,please. TIA