You are right they can be recovered, it takes a LONG!!!! Time but they
can be recovered. My biggest beef with RMAN is if anything goes wrong
there is no other way to recover the database. Also if you call Oracle
about a problem with RMAN it takes days to get them to fix it. I don't
know about the rest of you but I have never had days to recover a
database. If it takes more than a few minutes you have the CIO or a Sr
VP standing behind you tapping his toe.
I guess the best answer I have is that I like products that make me look
good RMAN does not fit that mold. It is all about options, the more
options a DBA has to getting the datbase by up the better off they are.
RMAN limits my options to ONE.
-----Original Message-----
From: Tiwana Akhtar
[mailto:oracledba-ezmlmshield-x65839310.[Email address protected]
Sent: Tuesday, March 29, 2005 12:48 PM
To: LazyDBA Discussion
Subject: RE: Any Hard Lessons about RMAN?
I would disagree on that, the backup information is also stored in
controlfile, so even if you loose your repository you can restore the
database using the current controlfile i did it many times.
In case you loose your controlfile too then its a little bigger problem
you have to run a pl/sql block (described in the RMAN manual) to get
controlfile out of backuppeice and then restore datafiles etc.
HTH
________________________________
From: Patterson Joel [mailto:oracledba-ezmlmshield-x18802750.[Email
address protected]
Sent: Tue 3/29/2005 1:41 PM
To: LazyDBA Discussion
Subject: RE: Any Hard Lessons about RMAN?
Somebody told me once, if you loose the repository, (assuming you are
using one), that all your databases are hostage as there would be no way
to recover any of the databases until first you recovery the repository
database. (Repository database is always backed up using the
controlfile option and not the repository option).
-----Original Message-----
From: MCCCLAYTON
[mailto:oracledba-ezmlmshield-x9227856.[Email address protected]
Sent: Tuesday, March 29, 2005 1:09 PM
To: LazyDBA Discussion
Subject: Any Hard Lessons about RMAN?
I may be using RMAN in my near future and was wondering, with Oracle 9i
(on Sun 4800), if there are any REAL WORLD issues I should keep in mind
when using RMAN. What are the DBA Horrors that have been a hard lesson
learned?
Mark
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page