RE: Senior Oracle DBA now Learning Informix by Request
Next question.
How long has RMAN been around and trustworthy?
I can't quote how long onbar has been around (somebody out here probably
knows), but I know we trusted onbar much sooner than our oracle dba
trusted rman.
Is RMAN advised to be housed in a separate oracle instance? Or is it
trusted to be with the instance it backs up?
What did you do before RMAN when informix people were either using onbar
or ontape? From the little I know, and I certainly admit I know
little. (DA, you are one of the few and best Oracle people who have
helped me so no slams intended here)....
... it seems prior to rman people had to make their own scripts to do
backups or take the DB down cold for backup.
I didn't know cold backups existed before I started using Oracle.
Never did them on any version of informix I have worked with.
Norma Jean Sebastian
ERP Support Administration
GIS- Enterprise Technical Services
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of DA Morgan
Sent: Thursday, December 14, 2006 2:24 PM
To: informix-list@iiug.org
Subject: Re: Senior Oracle DBA now Learning Informix by Request
Darren_Jacobs@carmax.com wrote:
> Will this backup 1 databases or all databases in an instance?
>
> informix backups are a single command as well depending on which
utility.
>
> ontape -s -L 0> or
> onbar -b -L 0>
> Both of these options backup the entire instance.
>
> BTW,
> Currently a company is running 1250 instances/DBA or 10,000 instances
for 8
> DBA's (source - Ambuj Goyal, General Manager of IBM at User Forum in
DC
> this past weekend). Your example of 100 db's/DBA is a far cry. Plus,
the
> 1250 instances could contain 1 or many databases.
>
> Just my thougths.
>
>
>
>
> DA Morgan
> <damorgan@psoug.o
> rg>
To
> Sent by: informix-list@iiug.org
> informix-list-bou
cc
> nces@iiug.org
>
Subject
> Re: Senior Oracle DBA now
Learning
> 12/14/2006 01:05 Informix by Request
> PM
>
>
>
>
>
>
>
>
>
> Obnoxio The Clown wrote:
>> Mark Townsend said:
>>> So I stand by my statement "It's never been proven that Informix is
>>> easier to own or operate than Oracle."
>> Spoken like a man who knows he's beaten, or when you're losing,
change
> the
>> argument. ;o)
>
> Then lets do this based on the scientific method.
>
> One of a DBA's major responsibilities is to perform backups of the
> database.
>
> Here is the complete command required to backup an Oracle database.
> What is the "easier" way to do it in Informix worthy of all the
fanfare?
>
> RMAN> BACKUP DATABASE;
> --
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
It is a pleasure to see that someone can post commands/code rather than
talk.
Oracle:
RMAN> BACKUP DATABASE;
Informix:
ontape -s -L 0or
onbar -b -L 0
The reality, as can be clearly seen, is that they are different ...
and equally easy to implement.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================
Sebastian, Norma J. wrote: > Next question. > > How long has RMAN been around and trustworthy? For every currently supported version of Oracle. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org
Sebastian, Norma J. wrote:
> Next question.
>
> How long has RMAN been around and trustworthy?
RMAN first shipped with Oracle8 in 1997. It took a few releases to
become widely used in the Oracle community. People were initially happy
with their scripts
>
> Is RMAN advised to be housed in a separate oracle instance? Or is it
> trusted to be with the instance it backs up?
You mean the RMAN catalog. RMAN is just the tooling. It's horses for
courses:
Backing up multiple instances - have a separate Oracle RMAN catalog.
Backing up a single instance (or just a few) - have the catalog local
(or in fact, have no catalog at all)
>
> What did you do before RMAN when informix people were either using onbar
> or ontape? From the little I know, and I certainly admit I know
> little. (DA, you are one of the few and best Oracle people who have
> helped me so no slams intended here)....
> ... it seems prior to rman people had to make their own scripts to do
> backups or take the DB down cold for backup.
Scripted backups at the OS level, with some database commands issued via
a SQL command line to either shutdown the database, or throw it into hot
backup mode. Hot backup has been supported in Oracle since at least
Oracle 5, long before RMAN came on the scene. RMAN is just the tooling.
>
> I didn't know cold backups existed before I started using Oracle.
> Never did them on any version of informix I have worked with.
Every database supports cold backups, as the backup is orthogonal to the
database itself. Just like early versions of Oracle, early versions of
the Informix engine (pre IDS) did not support hot backups. I think you
will find that Oracle added hot backup capability to the database before
Informix did to their engines (but I may be wrong). Hot backup and RMAN
are not co-requirements, RMAN is just the tooling
Oracle certainly solved the problem of checkpointing and recovery log
tailing long before Informix did. (Informix still has some issues in
this area even in the latest engine).
>
> Norma Jean Sebastian
> ERP Support Administration
> GIS- Enterprise Technical Services
>
>