Veritas like RMAN?
I found no signs of RMAN being used in any way shape or form... I've been told they are doing "hot" backups using Veritas... HOWEVER, the alert log shows no signs what so ever of "alter tablespace xyz begin/end backup"... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place. Is Veritas capable of this? If so, why is there a Veritas interface to RMAN??? Confusion, confusion... Michael Alan Kline, Sr.PrincipalConsultantBusiness to Business Solutions, LLCPhone: 804-744-1545 Cell: 804-314-6262ICQ: 1009605, 975313Email: [EMAIL PROTECTED] Web: www.b2bsol.com
RE: Veritas like RMAN?
Michael Don't discount the possibility that they are just using Veritas to back up everything on the Oracle server. Not correct, but I've seen people that know nothing about Oracle do that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 11:39 AM To: Multiple recipients of list ORACLE-L I found no signs of RMAN being used in any way shape or form... I've been told they are doing hot backups using Veritas... HOWEVER, the alert log shows no signs what so ever of alter tablespace xyz begin/end backup... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place. Is Veritas capable of this? If so, why is there a Veritas interface to RMAN??? Confusion, confusion... Michael Alan Kline, Sr. Principal Consultant Business to Business Solutions, LLC Phone: 804-744-1545 Cell: 804-314-6262 ICQ: 1009605, 975313 Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Web: http://www.b2bsol.com/ www.b2bsol.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Veritas like RMAN?
you don't have backups. Oracle will only support recovery from hot backups taken when the tablespaces are not flagged as in backup mode if you do the backup via RMAN. Technically, if you are very very lucky, the moon is in the seventh house and Jupiter has aligned with Mars, you *MIGHT* be able to use the hot backup taken without RMAN. If and only if there is absolutely NO activity whatsoever in the database from the time the backup starts until when it finishes. Even then, recovery is still not supported. --- Michael Kline [EMAIL PROTECTED] wrote: I found no signs of RMAN being used in any way shape or form... I've been told they are doing hot backups using Veritas... HOWEVER, the alert log shows no signs what so ever of alter tablespace xyz begin/end backup... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place. Is Veritas capable of this? If so, why is there a Veritas interface to RMAN??? Confusion, confusion... Michael Alan Kline, Sr. Principal Consultant Business to Business Solutions, LLC Phone: 804-744-1545 Cell: 804-314-6262 ICQ: 1009605, 975313 Email: [EMAIL PROTECTED] Web: www.b2bsol.com __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Veritas like RMAN?
Can they point to backup sets from which you can test recovery? As someone else mentioned, that's the crucial issue. There are a couple of possibilities: Veritas can do volume mirroring, for example. I haven't used this at the Veritas level but we do something similar on our Hitachi SAN (to generate a development image, not backup). The SAN mirror instructions say that we have to put the DB in hot backup mode and quiesce the database during the split, which seems a bit like belt and suspenders to me (how can you get a split block if the database is quiesced?) but that's what we do. I'd guess Veritas mirroring would require at least one of the two steps, both of which should show up in the alert log. From: Michael Kline [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Subject: Veritas like RMAN? I found no signs of RMAN being used in any way shape or form... I've been told they are doing hot backups using Veritas... HOWEVER, the alert log shows no signs what so ever of alter tablespace xyz begin/end backup... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place. Is Veritas capable of this? If so, why is there a Veritas interface to RMAN??? Confusion, confusion... LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Veritas like RMAN?
I was afraid of that -- Performing Remote Agent backup Media Name: Media created 7/18/2003 08:00:06 PM Backup of \\FAILSAFE\V$ Backup set #11 on storage media #1 Backup set description: DailyBackup Backup Type: FULL - Back Up Files - Reset Archive Bit Backup started on 7/19/2003 at 12:59:44 AM. Backup completed on 7/19/2003 at 1:11:05 AM. Backed up 31 files in 4 directories. Processed 5,785,060,909 bytes in 11 minutes and 21 seconds. Throughput rate: 486.1 MB/min -- This doesn't give me a warm feeling. Alert log shows NOTHING. This is a manufacturing site where the click of a bar code reader is moving materials from one location to another and that may or may not occur at any time. I'm not positive that one could say that this would never happen. Every time I've been in there looking around random jobs are coming into dbms_jobs in what appears to be all hours of the night. They have an export, but I think that's it. If they take a backup on Sunday, I think everything is shutdown. It MIGHT be good if the moon is right. Maks. -Original Message- Rachel Carmichael Sent: Wednesday, July 23, 2003 12:59 PM To: Multiple recipients of list ORACLE-L you don't have backups. Oracle will only support recovery from hot backups taken when the tablespaces are not flagged as in backup mode if you do the backup via RMAN. Technically, if you are very very lucky, the moon is in the seventh house and Jupiter has aligned with Mars, you *MIGHT* be able to use the hot backup taken without RMAN. If and only if there is absolutely NO activity whatsoever in the database from the time the backup starts until when it finishes. Even then, recovery is still not supported. --- Michael Kline [EMAIL PROTECTED] wrote: I found no signs of RMAN being used in any way shape or form... I've been told they are doing hot backups using Veritas... HOWEVER, the alert log shows no signs what so ever of alter tablespace xyz begin/end backup... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place. Is Veritas capable of this? If so, why is there a Veritas interface to RMAN??? Confusion, confusion... Michael Alan Kline, Sr. Principal Consultant Business to Business Solutions, LLC Phone: 804-744-1545 Cell: 804-314-6262 ICQ: 1009605, 975313 Email: [EMAIL PROTECTED] Web: www.b2bsol.com __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Veritas like RMAN?
They are using RAID5, not mirroring, and the database, for all the bigger it is needs some SERIOUS tuning. There are procs that are taking over 1 million disk i/o's to post a move in inventory.. Again, NOTHING in the alert log, just runs and runs, no alter tablespace, just redo log changes. And no bursts of redo log changes during backup time telling me nothing is being held... Then again, if I don't see the tablespace go into begin backup, why would it. Scary... And of course, you need to be kind to the customer. They are not sure they need us. Well, perhaps they are, but not sure why. Maks. -Original Message- Sarnowski, Chris Sent: Wednesday, July 23, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Can they point to backup sets from which you can test recovery? As someone else mentioned, that's the crucial issue. There are a couple of possibilities: Veritas can do volume mirroring, for example. I haven't used this at the Veritas level but we do something similar on our Hitachi SAN (to generate a development image, not backup). The SAN mirror instructions say that we have to put the DB in hot backup mode and quiesce the database during the split, which seems a bit like belt and suspenders to me (how can you get a split block if the database is quiesced?) but that's what we do. I'd guess Veritas mirroring would require at least one of the two steps, both of which should show up in the alert log. From: Michael Kline [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Subject: Veritas like RMAN? I found no signs of RMAN being used in any way shape or form... I've been told they are doing hot backups using Veritas... HOWEVER, the alert log shows no signs what so ever of alter tablespace xyz begin/end backup... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place. Is Veritas capable of this? If so, why is there a Veritas interface to RMAN??? Confusion, confusion... LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Veritas like RMAN?
If there is no evidence in the alert log, and no backups/file copies/incarnations are registered in rman, my bet is that the database isn't backed up.-Original Message-From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 23, 2003 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Veritas like RMAN?Michael Don't discount the possibility that they are just using Veritas to backup everything on the Oracle server. Not correct, but I've seen people thatknow nothing about Oracle do that.Dennis WilliamsDBA, 80%OCP, 100% DBALifetouch, Inc.[EMAIL PROTECTED]-Original Message-Sent: Wednesday, July 23, 2003 11:39 AMTo: Multiple recipients of list ORACLE-LI found no signs of RMAN being used inany way shape or form...I've been told they are doing "hot" backupsusing Veritas... HOWEVER, the alert log showsno signs what so ever of "alter tablespacexyz begin/end backup"...Can it do a good backup backing up liveDB files and leaving no signs what soever that backup took place.Is Veritas capable of this?If so, why is there a Veritas interfaceto RMAN???Confusion, confusion...Michael Alan Kline, Sr.Principal ConsultantBusiness to Business Solutions, LLCPhone: 804-744-1545 Cell: 804-314-6262ICQ: 1009605, 975313Email: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Web:http://www.b2bsol.com/ www.b2bsol.com--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Veritas like RMAN?
Michael But you do have a good reason why the client should hire you. ;-) Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 12:39 PM To: Multiple recipients of list ORACLE-L I was afraid of that -- Performing Remote Agent backup Media Name: Media created 7/18/2003 08:00:06 PM Backup of \\FAILSAFE\V$ Backup set #11 on storage media #1 Backup set description: DailyBackup Backup Type: FULL - Back Up Files - Reset Archive Bit Backup started on 7/19/2003 at 12:59:44 AM. Backup completed on 7/19/2003 at 1:11:05 AM. Backed up 31 files in 4 directories. Processed 5,785,060,909 bytes in 11 minutes and 21 seconds. Throughput rate: 486.1 MB/min -- This doesn't give me a warm feeling. Alert log shows NOTHING. This is a manufacturing site where the click of a bar code reader is moving materials from one location to another and that may or may not occur at any time. I'm not positive that one could say that this would never happen. Every time I've been in there looking around random jobs are coming into dbms_jobs in what appears to be all hours of the night. They have an export, but I think that's it. If they take a backup on Sunday, I think everything is shutdown. It MIGHT be good if the moon is right. Maks. -Original Message- Rachel Carmichael Sent: Wednesday, July 23, 2003 12:59 PM To: Multiple recipients of list ORACLE-L you don't have backups. Oracle will only support recovery from hot backups taken when the tablespaces are not flagged as in backup mode if you do the backup via RMAN. Technically, if you are very very lucky, the moon is in the seventh house and Jupiter has aligned with Mars, you *MIGHT* be able to use the hot backup taken without RMAN. If and only if there is absolutely NO activity whatsoever in the database from the time the backup starts until when it finishes. Even then, recovery is still not supported. --- Michael Kline [EMAIL PROTECTED] wrote: I found no signs of RMAN being used in any way shape or form... I've been told they are doing hot backups using Veritas... HOWEVER, the alert log shows no signs what so ever of alter tablespace xyz begin/end backup... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place. Is Veritas capable of this? If so, why is there a Veritas interface to RMAN??? Confusion, confusion... Michael Alan Kline, Sr. Principal Consultant Business to Business Solutions, LLC Phone: 804-744-1545 Cell: 804-314-6262 ICQ: 1009605, 975313 Email: [EMAIL PROTECTED] Web: www.b2bsol.com __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Veritas like RMAN?
Rachel - I am confused, now mind you it doesn't take much :).Can you clarify on a statement you made? Oracle will not support hot backups unless done w/ RMAD? I currently do hot backups w/ scripts using IBM's flashcopy. Is the Oracle Tablespace hot backup mode no longer supported? Thanks,Gene [EMAIL PROTECTED] 07/23/03 03:04PM Michael But you do have a good reason why the client should hire you. ;-)Dennis WilliamsDBA, 80%OCP, 100% DBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Wednesday, July 23, 2003 12:39 PMTo: Multiple recipients of list ORACLE-LI was afraid of that--Performing Remote Agent backupMedia Name: "Media created 7/18/2003 08:00:06 PM"Backup of "\\FAILSAFE\V$ "Backup set #11 on storage media #1Backup set description: "DailyBackup"Backup Type: FULL - Back Up Files - Reset Archive BitBackup started on 7/19/2003 at 12:59:44 AM.Backup completed on 7/19/2003 at 1:11:05 AM.Backed up 31 files in 4 directories.Processed 5,785,060,909 bytes in 11 minutes and 21 seconds.Throughput rate: 486.1 MB/min--This doesn't give me a "warm" feeling. Alert log shows NOTHING.This is a manufacturing site where the click of a bar codereader is moving materials from one location to another andthat may or may not occur at any time. I'm not positive thatone could say that this would never happen. Every time I'vebeen in there looking around random jobs are coming intodbms_jobs in what appears to be all hours of the night.They have an export, but I think that's it. If they takea backup on Sunday, I think everything is shutdown. ItMIGHT be good if the moon is right.Maks.-Original Message-Rachel CarmichaelSent: Wednesday, July 23, 2003 12:59 PMTo: Multiple recipients of list ORACLE-Lyou don't have backups. Oracle will only support recovery from hotbackups taken when the tablespaces are not flagged as in backup mode ifyou do the backup via RMAN.Technically, if you are very very lucky, the moon is in the seventhhouse and Jupiter has aligned with Mars, you *MIGHT* be able to use thehot backup taken without RMAN. If and only if there is absolutely NOactivity whatsoever in the database from the time the backup startsuntil when it finishes. Even then, recovery is still not supported.--- Michael Kline [EMAIL PROTECTED] wrote: I found no signs of RMAN being used in any way shape or form... I've been told they are doing "hot" backups using Veritas... HOWEVER, the alert log shows no signs what so ever of "alter tablespace xyz begin/end backup"... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place. Is Veritas capable of this? If so, why is there a Veritas interface to RMAN??? Confusion, confusion... Michael Alan Kline, Sr. Principal Consultant Business to Business Solutions, LLC Phone: 804-744-1545 Cell: 804-314-6262 ICQ: 1009605, 975313 Email: [EMAIL PROTECTED] Web: www.b2bsol.com __Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design softwarehttp://sitebuilder.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Rachel Carmichael INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Michael Kline INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line
RE: Veritas like RMAN?
Thanks for the clarification.You got me nervous :) [EMAIL PROTECTED] 07/23/03 04:09PM that's not quite what I said.I said Oracle will not support hot backups done without putting thetablespace into "backup mode" unless that hot backup is done with RMAN.at least that's what I thought I was saying.you can still do the good old-fashioned "alter tablespace beginbackup"/backup the datafiles/"alter tablespace end backup" sort of hotbackupor you can use RMAN and not have to do the begin/end backup--- Gene Sais [EMAIL PROTECTED] wrote: Rachel - I am confused, now mind you it doesn't take much :). Can you clarify on a statement you made? Oracle will not support hot backups unless done w/ RMAD? I currently do hot backups w/ scripts using IBM's flashcopy. Is the Oracle Tablespace hot backup mode no longer supported? Thanks, Gene [EMAIL PROTECTED] 07/23/03 03:04PM Michael But you do have a good reason why the client should hire you. ;-) Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 12:39 PM To: Multiple recipients of list ORACLE-L I was afraid of that -- Performing Remote Agent backup Media Name: "Media created 7/18/2003 08:00:06 PM" Backup of "\\FAILSAFE\V$ " Backup set #11 on storage media #1 Backup set description: "DailyBackup" Backup Type: FULL - Back Up Files - Reset Archive Bit Backup started on 7/19/2003 at 12:59:44 AM. Backup completed on 7/19/2003 at 1:11:05 AM. Backed up 31 files in 4 directories. Processed 5,785,060,909 bytes in 11 minutes and 21 seconds. Throughput rate: 486.1 MB/min-- This doesn't give me a "warm" feeling. Alert log shows NOTHING. This is a manufacturing site where the click of a bar code reader is moving materials from one location to another and that may or may not occur at any time. I'm not positive that one could say that this would never happen. Every time I've been in there looking around random jobs are coming into dbms_jobs in what appears to be all hours of the night. They have an export, but I think that's it. If they take a backup on Sunday, I think everything is shutdown. It MIGHT be good if the moon is right. Maks. -Original Message- Rachel Carmichael Sent: Wednesday, July 23, 2003 12:59 PM To: Multiple recipients of list ORACLE-L you don't have backups. Oracle will only support recovery from hot backups taken when the tablespaces are not flagged as in backup mode if you do the backup via RMAN. Technically, if you are very very lucky, the moon is in the seventh house and Jupiter has aligned with Mars, you *MIGHT* be able to use the hot backup taken without RMAN. If and only if there is absolutely NO activity whatsoever in the database from the time the backup starts until when it finishes. Even then, recovery is still not supported. --- Michael Kline [EMAIL PROTECTED] wrote: I found no signs of RMAN being used in any way shape or form...I've been told they are doing "hot" backups using Veritas... HOWEVER, the alert log shows no signs what so ever of "alter tablespace xyz begin/end backup"... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place.Is Veritas capable of this? If so, why is there a Veritas interface to RMAN???Confusion, confusion... Michael Alan Kline, Sr. Principal Consultant Business to Business Solutions, LLC Phone: 804-744-1545 Cell: 804-314-6262 ICQ: 1009605, 975313 Email: [EMAIL PROTECTED] Web: www.b2bsol.com __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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.net -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
RE: Veritas like RMAN?
True, true... :-) That's what the Health Assessment is all about though. Sort of a 10-30 page report of: where you are the problems you have now most likely what you will be having the risk you have what to do how we can help... Myself, I trend and of the databases I watch, they pretty much never go down. Other than power, some programmer wondering what it might be like to load 10 million records without telling anyone, someone dropping a table, etc., I've got databases that have pretty much been smooth sailing for 3-5 years now. I tell them when they'll be needing more disks often months in advance. Find trends that simply can not continue unless they want to upgrade, etc. Find that ugly sql some programmer was hoping no one would notice, etc. They can't hardly touch the database with out me knowing about it. I'm also tracking tables that will run out of extents in perhaps 35 weeks from now at current trends. One of my sayings clients seem to like is No more database surprises... I just ran figures for this client and with two disk cabinets configure in RAID, 100% of the I/O is off cabinet 1 and about 3% is off cabinet 2. (rounding errors) There will be a lot that can be done. :-) Maks. -Original Message- DENNIS WILLIAMS Sent: Wednesday, July 23, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Michael But you do have a good reason why the client should hire you. ;-) Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 12:39 PM To: Multiple recipients of list ORACLE-L I was afraid of that -- Performing Remote Agent backup Media Name: Media created 7/18/2003 08:00:06 PM Backup of \\FAILSAFE\V$ Backup set #11 on storage media #1 Backup set description: DailyBackup Backup Type: FULL - Back Up Files - Reset Archive Bit Backup started on 7/19/2003 at 12:59:44 AM. Backup completed on 7/19/2003 at 1:11:05 AM. Backed up 31 files in 4 directories. Processed 5,785,060,909 bytes in 11 minutes and 21 seconds. Throughput rate: 486.1 MB/min -- This doesn't give me a warm feeling. Alert log shows NOTHING. This is a manufacturing site where the click of a bar code reader is moving materials from one location to another and that may or may not occur at any time. I'm not positive that one could say that this would never happen. Every time I've been in there looking around random jobs are coming into dbms_jobs in what appears to be all hours of the night. They have an export, but I think that's it. If they take a backup on Sunday, I think everything is shutdown. It MIGHT be good if the moon is right. Maks. -Original Message- Rachel Carmichael Sent: Wednesday, July 23, 2003 12:59 PM To: Multiple recipients of list ORACLE-L you don't have backups. Oracle will only support recovery from hot backups taken when the tablespaces are not flagged as in backup mode if you do the backup via RMAN. Technically, if you are very very lucky, the moon is in the seventh house and Jupiter has aligned with Mars, you *MIGHT* be able to use the hot backup taken without RMAN. If and only if there is absolutely NO activity whatsoever in the database from the time the backup starts until when it finishes. Even then, recovery is still not supported. --- Michael Kline [EMAIL PROTECTED] wrote: I found no signs of RMAN being used in any way shape or form... I've been told they are doing hot backups using Veritas... HOWEVER, the alert log shows no signs what so ever of alter tablespace xyz begin/end backup... Can it do a good backup backing up live DB files and leaving no signs what so ever that backup took place. Is Veritas capable of this? If so, why is there a Veritas interface to RMAN??? Confusion, confusion... Michael Alan Kline, Sr. Principal Consultant Business to Business Solutions, LLC Phone: 804-744-1545 Cell: 804-314-6262 ICQ: 1009605, 975313 Email: [EMAIL PROTECTED] Web: www.b2bsol.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).