| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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-----
From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of
DENNIS WILLIAMS
Sent: Wednesday, July 23, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L
Subject: 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.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, July 23, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L
I was afraid of that....
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.
 |
 |