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).
