Title: Re: RMAN Incremental
Michael,
Another good treatment of the use of partitioning in DW to reduce backups is a paper by Jeff Maresh posted online at “http://www.EvDBT.com/papers.htm”, entitled “Managing the Data Lifecycle”.
-Tim
on 10/24/03 4:34 PM, Michael Kline at [EMAIL PROTECTED
7:34
PM
Subject: RMAN Incremental
I'm working at a
Data Warehouse and they are looking for backup possibilities...
This is almost a
TB, a baby, and it may be that RMAN with incremental could be a good
solution.
If say for
instance there is a single table
Michal,
Are you using partitioning, and if so, are there
tablespaces you can set to read only?
If so, then you only need to back up the read only
tablespaces often enough that your backup software
retention time doesn't cause the RO TBS's to all be
aged out.
This could eliminate a lot of backup
I'm working at a
Data Warehouse and they are looking for backup possibilities...
This is almost a
TB, a baby, and it may be that RMAN with incremental could be a good
solution.
If say for instance
there is a single tablespace of some 100 gig and they add 200,000,000 records to
one of
Title: RE: RMAN Incremental backups.
Can someone explain why incremental backups are only valid in archivelog mode? I don't think this is correct and the manual states that consistent incremental backups are possible. I took the quote below from the Oracle 8i Recovery Manager Users
achel
Carmichael To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject: Re: RMAN Incremen
the documentation told you: no they are not
just because the incremental backup completed does not mean that it is
usable.
Either leave the database in archivelog mode to do incremental backups
or keep it in noarchivelog mode (and why you would not want to do that
is a whole other discussion) an
Prasad,
Incremental backups are only valid if your database is in ARCHIVELOG mode.
Think about it - to be able to recover using incremental backups, you *Need*
the archivelog files to apply changes. These are not being created when you
are running in NOARCHIVELOG mode.
Secondly, flipping betwee
Hi All,
I am new to RMAN. I am reading RMAN documentation and doing some testing on
our development box.
I have couple of questions.
1. Our database is in NOARCHIVE LOG mode and I would like to do Incremental
backups.
Since db is in noarchive log mode, I put the database in mount state
