on backups in a DW environment.
Our DW is somewhat small at the moment but projected
to grow. I seem to be having a hard time trying to
convince the sys admin that I don't want archive
logging turned on. To me, it does'nt make much
sense.
He's proposed using EMC BCV's which I've
] wrote:
Have a question on backups in a DW environment.
Our DW is somewhat small at the moment but projected
to grow. I seem to be having a hard time trying to
convince the sys admin that I don't want archive
logging turned on. To me, it does'nt make much sense.
On the contrary
in a DW environment.
Our DW is somewhat small at the moment but projected
to grow. I seem to be having a hard time trying to
convince the sys admin that I don't want archive
logging turned on. To me, it does'nt make much sense.
On the contrary, not using archivelog mode is what
GBs.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 09, 2004 10:04 PM
Mohammed,
Comments inline...
on 1/9/04 2:24 PM, mkb at [EMAIL PROTECTED] wrote:
Have a question on backups in a DW environment
to compensate him for what he is not, and
a sense of humor was provided to console him for what he is. --Unknown
-Original Message-
Sent: Friday, January 09, 2004 4:25 PM
To: Multiple recipients of list ORACLE-L
Have a question on backups in a DW environment.
Our DW is somewhat small
To: Multiple recipients of list ORACLE-L
Have a question on backups in a DW environment.
Our DW is somewhat small at the moment but projected
to grow. I seem to be having a hard time trying to
convince the sys admin that I don't want archive
logging turned on. To me, it does'nt make much
Would it be incorrect to assume that you never do inserts
into newly loaded partitions, or updates that could increase
the length of rows?
1 pctfree could be problematic in that case.
Btw, if you're sure that rows won't grow, it use even pctfree 0 instead of
1. One thing you have to have in
On 2004.01.10 16:49, DENNIS WILLIAMS wrote:
Gene - As a part of putting the database back in archivelog mode, I hope you
take another backup.
Actually, taking backup should be a part of every major intervention on the database.
Changing the database mode from noarchivelog to archivelog most
Yeah, I configured RMAN on a system. Then the users didn't want me to turn
off cold backups. My response was that a DBA wouldn't say there was such a
thing as too many backups, so we do both.
Specifically with noarchivelog/archivelog, if you try to recover using a
backup from before you turned
Have a question on backups in a DW environment.
Our DW is somewhat small at the moment but projected
to grow. I seem to be having a hard time trying to
convince the sys admin that I don't want archive
logging turned on. To me, it does'nt make much sense.
He's proposed using EMC BCV's which
ORACLE-L
Have a question on backups in a DW environment.
Our DW is somewhat small at the moment but projected
to grow. I seem to be having a hard time trying to
convince the sys admin that I don't want archive
logging turned on. To me, it does'nt make much sense.
He's proposed using EMC BCV's which
Well, recovery might be just a wee bit faster then re-loading few gigs of data
using SQL. Also, developers on that DW might lose any work that they haven't done
the night before. This is a production database, which means that it absolutely
must be in archive log mode. One of the big reasons is
don't use archive logging.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, January 09, 2004 3:25 PM
To: Multiple recipients of list ORACLE-L
Have a question on backups in a DW environment.
Our DW is somewhat small at the moment
09, 2004 4:25 PM
To: Multiple recipients of list ORACLE-L
Have a question on backups in a DW environment.
Our DW is somewhat small at the moment but projected
to grow. I seem to be having a hard time trying to
convince the sys admin that I don't want archive
logging turned on. To me, it does'nt
, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, January 09, 2004 3:25 PM
To: Multiple recipients of list ORACLE-L
Have a question on backups in a DW environment.
Our DW is somewhat small at the moment but projected
to grow. I seem to be having a hard time trying
Yes but...
The developers use Cognos tools for all their
development. Nobody writes any PL/SQL, triggers etc.
So again, all that the developers might lose is data
that they loaded which can be easily recovered by
re-running the ETL process.
What I'm trying to say is that the environment from
I put all databases in archive mode, i.e. dev, test, and production.
I can use test db's to test backup/recovery scenario's. The only time they
are not in archive mode is when I am doing a major load
(import,sqlload,etc). After I am done loading data, I put them back into
archive mode. What
was given to man to compensate him for
what he is not,
and
a sense of humor was provided to console him for
what he is.
--Unknown
-Original Message-
Sent: Friday, January 09, 2004 4:25 PM
To: Multiple recipients of list ORACLE-L
Have a question on backups in a DW environment
, January 09, 2004 4:25 PM
To: Multiple recipients of list ORACLE-L
Have a question on backups in a DW environment.
Our DW is somewhat small at the moment but projected
to grow. I seem to be having a hard time trying to
convince the sys admin that I don't want archive
logging turned
for
what he is not,
and
a sense of humor was provided to console him for
what he is.
--Unknown
-Original Message-
Sent: Friday, January 09, 2004 4:25 PM
To: Multiple recipients of list ORACLE-L
Have a question on backups in a DW environment.
Our DW
he is not,
and
a sense of humor was provided to console him for
what he is.
--Unknown
-Original Message-
Sent: Friday, January 09, 2004 4:25 PM
To: Multiple recipients of list ORACLE-L
Have a question on backups in a DW environment.
Our DW is somewhat
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Backups in a DW Environment
I never heard about the required license from veritas and legato. Can
someone else confirm that this is necessary? They actually charge you more
money to do use another
Subject: Re: Backups in a DW
Environment
The license is for the
software that interfaces Veritas NetBackup to RMAN. RMAN has an API and NBU has an API. The
intersection of the 2 will set you
back about $1500 US IIRC.Jared
"Ryan" [EMAIL
Mohammed,
Comments inline...
on 1/9/04 2:24 PM, mkb at [EMAIL PROTECTED] wrote:
Have a question on backups in a DW environment.
Our DW is somewhat small at the moment but projected
to grow. I seem to be having a hard time trying to
convince the sys admin that I don't want archive
of humor was provided to console him for
what he is.
--Unknown
-Original Message-
Sent: Friday, January 09, 2004 4:25 PM
To: Multiple recipients of list ORACLE-L
Have a question on backups in a DW environment.
Our DW is somewhat small
25 matches
Mail list logo