Title: RE: File Restoration/Recovery
Schema level export can fix the *thinking*
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an
What can I say? Shoot the danged developer!
No, no, no, no, no. The backup is as much use as the proverbial on
a bull. Period.
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Ora
Gary,
I second this user's comments. Is it possible to get a valid backup while the
database is up? Yes, it is but it is just plain silly (at the very least), to plan to
do so. Whether or not this backup is good depends on no activity and if there's no
activity, why not just shut it down and
Gary - send the developer to backup and recovery school.
he is wrong. as Rachel said, *maybe* it will work once. but as a DBA, you
personally can *never* support this in a real environment. you will not be
able to guarantee the same results every time.
Tom Mercadante
Oracle Certified Professio
you are right and the developer is not. cold backups taken with the db open
are worthless. you cannot use them to open it back to a consistent state
babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 10:44 AM
> All...
>
>
Chances are excellent, that you/oracle would not be able to
recover.
Oracle support might bring the super tool with the
swat expert for 5000 bucks an hour...and then
it might still be a mess. They would love you doing this
stuff..
Brian
-Original Message-
Sent: Friday, March 14, 2003
Gary,
I had a similar "engineer" managed DB around here for a while. The problem
was that 'someone' deleted a couple of the datafiles by 'mistake'. (Ever see
that CDW commercial concerning the "full file server"?) Well I got asked the
same question to which I had a very good laugh & told the
As with all backup and recovery plans, you should test, document, and
perhaps automate the process, with particular emphasis on the recovery.
What your associate describes sounds like an very expensive B&R plan.
On Fri, Mar 14, 2003 at 07:44:01AM -0800, Gary Chambers wrote:
> All...
>
> A
no no no no no no
If he is REALLY lucky, and no one is using the database at the instant
he does all the copies (and I mean the OS as well), then MAYBE,
POSSIBLY, if the Tooth Fairy and Easter Bunny are present and bless the
copy, he might have a valid backup.
But I wouldn't bet my job on it.
H
All...
A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires
a nightly backup (by simply copying them to a backup directory) of the
datafiles of an active instance. I explain that it will be a waste of
tape because the files will be corrupt and useless. He counters, "As
long a
10 matches
Mail list logo
