Re: Recovery scenario query
Sean, If they are not being backed up, you won't be able to open the database with them in it if you have to recover. You would have to mount the database, alter the datafiles offline drop (this tells Oracle you don't care what was in them anyway, so ignore errors on them) and then after finishing the recovery and opening the database, you'd have to drop the tablespaces. Now, if there WERE updates to data in those datafiles, the updates would be lost (and the offline during recovery would let recovery go through). If updates to that data were done in the same transaction as updates to data in tables that WERE backed up, the update to the backed up data would be effectively rolled back. You might want to turn on auditing for update/delete on those tables for a short time, to confirm that nothing is being changed. If you trap changes, you can then go to them with proof and tell them to reconsider what the backup policy is. Rachel --- O'Neill, Sean [EMAIL PROTECTED] wrote: We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Recovery scenario query
My take on this is, if you have stuff in your database that is not used get it out. Then you have more space and you are not dealing with the maintenance on things that are not relevant. If they are needed but not updated, put them in a tablespace that is read only, back it up once, onto a permanent tape, and be done with it. Surely you are not backing up by data file but rather by tablespace. So this seems like a rather simple thing to work around to me. However, Rachel's suggestions are the way to go if you are going to keep things the way they are and really can deal with the end result. Whatever you do, do it quick. One of the primary functions of a DBA is to protect the data that they entrust to the database. Right now its not being done. -Original Message- Carmichael Sent: Friday, January 11, 2002 5:31 AM To: Multiple recipients of list ORACLE-L Sean, If they are not being backed up, you won't be able to open the database with them in it if you have to recover. You would have to mount the database, alter the datafiles offline drop (this tells Oracle you don't care what was in them anyway, so ignore errors on them) and then after finishing the recovery and opening the database, you'd have to drop the tablespaces. Now, if there WERE updates to data in those datafiles, the updates would be lost (and the offline during recovery would let recovery go through). If updates to that data were done in the same transaction as updates to data in tables that WERE backed up, the update to the backed up data would be effectively rolled back. You might want to turn on auditing for update/delete on those tables for a short time, to confirm that nothing is being changed. If you trap changes, you can then go to them with proof and tell them to reconsider what the backup policy is. Rachel --- O'Neill, Sean [EMAIL PROTECTED] wrote: We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet
Re: Recovery scenario query
If all of the datafiles you restoring are in 1 tablespace you can do a tablespace restore/recovery. How ever, if there are some datafiles in the tablespace that are not included in the backup, I think you will not be able to do a tablespace restore. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 7:05 AM We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: 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: Recovery scenario query
Personally I would challenge myself with writing a backup script that rotated the data files not being backed up. Then I would make sure that I had all of my archived redo logs available and backed up. This way you could recover anything with a minimum amount of effort. Have you tried zipping your data files after each individual copy? You will get pretty good compression most of the time. You can zip your archived redo logs as well. If your database is in archive log mode then you don't necessarily have to do a cold backup. You could kick a hot one off in the middle of the day. Also, to ensure that the data files are not being updated put the tablespaces in read-only mode. If you get a call complaining of an error then you know better! Good luck :) --Michael -Original Message- Sent: Friday, January 11, 2002 2:40 PM To: Multiple recipients of list ORACLE-L If all of the datafiles you restoring are in 1 tablespace you can do a tablespace restore/recovery. How ever, if there are some datafiles in the tablespace that are not included in the backup, I think you will not be able to do a tablespace restore. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 7:05 AM We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: 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: Jenkins, Michael 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: Recovery scenario query
Instead of writing a fancy backup script, why not learn and use Rman? It does everything that is needed - backup, removal of archivelog files, easily restore to any point in time. a real no-brainer. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 11, 2002 3:02 PM To: Multiple recipients of list ORACLE-L Personally I would challenge myself with writing a backup script that rotated the data files not being backed up. Then I would make sure that I had all of my archived redo logs available and backed up. This way you could recover anything with a minimum amount of effort. Have you tried zipping your data files after each individual copy? You will get pretty good compression most of the time. You can zip your archived redo logs as well. If your database is in archive log mode then you don't necessarily have to do a cold backup. You could kick a hot one off in the middle of the day. Also, to ensure that the data files are not being updated put the tablespaces in read-only mode. If you get a call complaining of an error then you know better! Good luck :) --Michael -Original Message- Sent: Friday, January 11, 2002 2:40 PM To: Multiple recipients of list ORACLE-L If all of the datafiles you restoring are in 1 tablespace you can do a tablespace restore/recovery. How ever, if there are some datafiles in the tablespace that are not included in the backup, I think you will not be able to do a tablespace restore. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 7:05 AM We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: 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: Jenkins, Michael 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
RE: Recovery scenario query
Speaking of Rman, has anyone used it directly interfaced w/ Legato networker? I have to park my trusty scripts and learn Rman w/ Legato. Any gotchas I should be aware of. I know to keep a sep schema for each Oracle version, anything else? Reason for this is that I have a 1tb db of blobs and I need to do incremental backups and I understand Rman is the tool. Thanks for any insight on these products. Gene [EMAIL PROTECTED] 01/11/02 03:20PM Instead of writing a fancy backup script, why not learn and use Rman? It does everything that is needed - backup, removal of archivelog files, easily restore to any point in time. a real no-brainer. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 11, 2002 3:02 PM To: Multiple recipients of list ORACLE-L Personally I would challenge myself with writing a backup script that rotated the data files not being backed up. Then I would make sure that I had all of my archived redo logs available and backed up. This way you could recover anything with a minimum amount of effort. Have you tried zipping your data files after each individual copy? You will get pretty good compression most of the time. You can zip your archived redo logs as well. If your database is in archive log mode then you don't necessarily have to do a cold backup. You could kick a hot one off in the middle of the day. Also, to ensure that the data files are not being updated put the tablespaces in read-only mode. If you get a call complaining of an error then you know better! Good luck :) --Michael -Original Message- Sent: Friday, January 11, 2002 2:40 PM To: Multiple recipients of list ORACLE-L If all of the datafiles you restoring are in 1 tablespace you can do a tablespace restore/recovery. How ever, if there are some datafiles in the tablespace that are not included in the backup, I think you will not be able to do a tablespace restore. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 7:05 AM We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: 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: Jenkins, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
RE: Recovery scenario query
Gene - I'll be interested in the relies you garner. I'm just starting down the RMAN road. Takes awhile to understand just how it works and it isn't easy to work with. Originally we were going to use it with Veritas, but according to knowledgeable people on this list, that is where RMAN gets pretty complex. So I decided to start by using RMAN with disk files and after I get some experience and confidence with that, then revisit the idea of using a media manager like Veritas or Legato. Fortunately, I am responsible for several production databases, so I am starting with the smallest, and I can easily hold the files RMAN creates on disk. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 11, 2002 2:43 PM To: Multiple recipients of list ORACLE-L Speaking of Rman, has anyone used it directly interfaced w/ Legato networker? I have to park my trusty scripts and learn Rman w/ Legato. Any gotchas I should be aware of. I know to keep a sep schema for each Oracle version, anything else? Reason for this is that I have a 1tb db of blobs and I need to do incremental backups and I understand Rman is the tool. Thanks for any insight on these products. Gene [EMAIL PROTECTED] 01/11/02 03:20PM Instead of writing a fancy backup script, why not learn and use Rman? It does everything that is needed - backup, removal of archivelog files, easily restore to any point in time. a real no-brainer. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 11, 2002 3:02 PM To: Multiple recipients of list ORACLE-L Personally I would challenge myself with writing a backup script that rotated the data files not being backed up. Then I would make sure that I had all of my archived redo logs available and backed up. This way you could recover anything with a minimum amount of effort. Have you tried zipping your data files after each individual copy? You will get pretty good compression most of the time. You can zip your archived redo logs as well. If your database is in archive log mode then you don't necessarily have to do a cold backup. You could kick a hot one off in the middle of the day. Also, to ensure that the data files are not being updated put the tablespaces in read-only mode. If you get a call complaining of an error then you know better! Good luck :) --Michael -Original Message- Sent: Friday, January 11, 2002 2:40 PM To: Multiple recipients of list ORACLE-L If all of the datafiles you restoring are in 1 tablespace you can do a tablespace restore/recovery. How ever, if there are some datafiles in the tablespace that are not included in the backup, I think you will not be able to do a tablespace restore. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 7:05 AM We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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:
Re: Recovery scenario query
We use Rman with Legato Netwoker. Once we got Legato Networker set up correctly, it was pretty straight forward from the Rman side of the fence. We use networker to schedule the jobs. That adds some complexity to the setup, but it's pretty well documented. I added some script trickery that I found on metalink to avoid having the username and password for the rman user from being written to the log files. You can also run your jobs manually or from cron if you desire. Now, we had a good deal of difficulty getting Legato Networker to play nice with our Veritas cluster, but that is a story for the Unix admin to tell. The RMAN interface is pretty straight forward if you take the time to read the NetWorker Module for Oracle Administration Guide . Gene Sais wrote: Speaking of Rman, has anyone used it directly interfaced w/ Legato networker? I have to park my trusty scripts and learn Rman w/ Legato. Any gotchas I should be aware of. I know to keep a sep schema for each Oracle version, anything else? Reason for this is that I have a 1tb db of blobs and I need to do incremental backups and I understand Rman is the tool. Thanks for any insight on these products. Gene [EMAIL PROTECTED] 01/11/02 03:20PM Instead of writing a fancy backup script, why not learn and use Rman? It does everything that is needed - backup, removal of archivelog files, easily restore to any point in time. a real no-brainer. Tom Mercadante Oracle Certified Professional _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: Recovery scenario query
Except that you really should have a catalog and a catalog really should be in a separate database and he mentioned that space was tight. -Original Message- Thomas F Sent: Friday, January 11, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Instead of writing a fancy backup script, why not learn and use Rman? It does everything that is needed - backup, removal of archivelog files, easily restore to any point in time. a real no-brainer. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 11, 2002 3:02 PM To: Multiple recipients of list ORACLE-L Personally I would challenge myself with writing a backup script that rotated the data files not being backed up. Then I would make sure that I had all of my archived redo logs available and backed up. This way you could recover anything with a minimum amount of effort. Have you tried zipping your data files after each individual copy? You will get pretty good compression most of the time. You can zip your archived redo logs as well. If your database is in archive log mode then you don't necessarily have to do a cold backup. You could kick a hot one off in the middle of the day. Also, to ensure that the data files are not being updated put the tablespaces in read-only mode. If you get a call complaining of an error then you know better! Good luck :) --Michael -Original Message- Sent: Friday, January 11, 2002 2:40 PM To: Multiple recipients of list ORACLE-L If all of the datafiles you restoring are in 1 tablespace you can do a tablespace restore/recovery. How ever, if there are some datafiles in the tablespace that are not included in the backup, I think you will not be able to do a tablespace restore. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 7:05 AM We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: 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: Jenkins, Michael 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
Re: Recovery scenario query
O'Neill, Sean wrote: We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] Sean, I am afraid that if you do not backup ALL of your databases you are heading for a lot of trouble. Even if datafiles are not updated (and you seem, quite justifiably, to doubt it) I would be surprised if datafile header blocks where not updated at one time or another - eg shutdown or startup (check file dates, it can give a good clue). Which means that Oracle will flatly refuse to open the database when you try to do it with a mix of recently backed-up files and the associated archived redo logs, plus very old 'not updated' datafiles - without the archived redo logs to fill the gap. You will probably be able to open the database by dropping the tablespaces for which you only have old data. In other words, be ready to bid farewell to the data you do not backup (I suggest you export it ASAP). IMHO, your situation may not be as bad as it may look according to the books, but you are doing tight-rope dancing with a safety net full of gaping holes, and even if you manage to avoid the fatal plunge when you have a problem, it will not be easy and may take some time before you have a database looking remotely to what it was before the problem up and running. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Recovery scenario query
Hi, I would want to ensure that the datafiles being exluded have READ ONLY Tablespaces to ensure that they do not change. This would ensure that in the event of a recovery there will not be an SCN issue Martin -Original Message- Sean Sent: 10 January 2002 12:05 To: Multiple recipients of list ORACLE-L We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: Martin Kendall 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: Recovery scenario query
Sean, First of all, datafiles actually belong to a tablespace - not a schema. 1. You could place the tablespace into read-only mode, take a backup of the tablespaces datafile(s), then no additional backups are required for those datafile(s) (and you are assured that no one updates the data). 2. In general, to recover from media failure, you would have to restore the datafile from some backup, and apply all the archived redo logs since the backup. HTH Rob Pegram Oracle DBA --- O'Neill, Sean [EMAIL PROTECTED] wrote: We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram 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: Recovery scenario query
If you don't have enough disk space to backup all the datafiles in one run
.
create alternate backup sets.
On Mondays, Wednesdays,Fridays : Backup the Active tablespaces
On Tuesdays, Thursdays : Backup the Inactive tablespaces
[You could break this down further if you still don't have enough disk
space.. but I
guess you get the idea].
In case you lose the Inactive tablespace on Thursday evening, you need
Tuesday night's
backups + All the Archived Redo Logs from Tuesday night onwards ---
therefore you cannot
delete Archived Logs daily (ie, when you run your Wednesday backup you
cannot delete
all the archive logs -- you must keep those from Tuesday night onwards).
[note the keep those from Tuesday night onwards means keep at least those
generated from the
point-in-time when Tuesday night's backup *BEGAN* not when it _ended_].
Normally, I wouldn't keep only the last two days archive logs. I'd
probably keep at least
a week's archive logs on-disk.
[so ... if you backup the Inactive tablespaces only once a month, you
need the archive logs --
either on disk or from tape -- going back to one month].
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
O'Neill, Sean [EMAIL PROTECTED] 10/01/2002 08:05 PM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
Subject: Recovery scenario query
We perform disk-to-disk offline backups on a nighlty basis. Database is
running in archived log mode. Due to space contraints (don't ask =:-[ ) we
are currently forced to backup only some of the data files. The data files
excluded belong to specific schema owners and are not being updated, or so
I'm informed =:-0. I'm trying to get my head around what the recovery
implications are if some of the data files not backed up have being updated
and a recovery is required?. I expect it depends on what the recovery
scenario is. So whats worst case scenario and what would my options, if
any
be?.
Oracle 7.3.3, 8.0.5, 8.1.7
NT4, W2K
-
Se¨¢n O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]
This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
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).
åy« ±ç
ê ~'jS Ä,PÛiÿü0ÂÚ}ª¢`.¶+ Ñ
é×!Ö¥yÈZ®×«yÛ '(V
+r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq
+ j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨ àØw%¹×)Þríj)â
+I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
