There are several ways to do oracle backups. The technology I like is
the storage level backups. NetApps, EMC, IBM and a host of other vendors
can snap a copy of a 1, 2, 3 or more terabyte database in less than a
minute. Consistent backups if the table spaces are put in hot backups
mode. The restore are a lot quicker than RMAN also and you don't loose
any of your options.
Oracle is a good company but hey need to leave the backup technology to
the experts in the field. Oracle did not even use RMAN for their own
backup until the 2001 or 2000 IOUG when they got beat up over it. That
should tell you something. RMAN has gotten a lot better but it still
does not measure up to some of the industry leaders.
Phill
-----Original Message-----
From: henry Wollman
[mailto:oracledba-ezmlmshield-x97347552.[Email address protected]
Sent: Tuesday, March 29, 2005 1:17 PM
To: LazyDBA Discussion
Subject: RE: Any Hard Lessons about RMAN?
You must be using pre 9i RMAN. RMAN simplifies the recovery process so
that it is quicker and easier. If something is wrong with my hot or cold
non-rman backup, I don't have any other option than to use a previous
backup. If I lost a archive log, I have no other option, I cant restore
past the missing archive log. If you have the luxury to use multiple
backup options then you might have multiple restore options. But if you
only backup one way, whether RMAN or something else, you only have one
restore option.
If you call oracle with a problem restoring from a hot (non-RMAN)
backup, they will tell you, sorry, not supported. That won't make you
look very good either.
| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address
protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: Phil Morris
[mailto:oracledba-ezmlmshield-x22507163.[Email address protected]
Sent: Tuesday, March 29, 2005 1:07 PM
To: LazyDBA Discussion
Subject: RE: Any Hard Lessons about RMAN?
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
--------
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