I partially agree with Mladen.
RMAN definitely doesn't identify Table HWMs -- it doesn't know logical
structures such as Tables and Segments and Tablespaces [although it
can assist you in Tablespace Recovery when it reads the Data Dictionary].
RMAN knows physical structures such as DataFiles,
What it doesn't write are the blocks that are not allocated to any
extent. RMAN doesn't go into the logical structures, like tables and
indexes,
it looks into the tablespace header and reads the information from the
bitmap information there. It cannot go into tables/indexes because it
should also
This is accurate and far more correct than my quickly written statement was.
I actually say this almost word for word in the book. This is why even a
table truncate will not reduce RMAN space usage. Sorry, I'll endevor in the
future to be more susinct! :-)
RF
-Original Message-
To:
This matches the data I have collected, with the following addition:
RMAN will backup any blocks that have ever had data in them, even if the
extent has been deallocated or the object dropped.
Keith
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
I apologize, I shouldn't be trying to teach the master.
-Original Message-
Sent: Friday, April 04, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
This is accurate and far more correct than my quickly written statement was.
I actually say this almost word for word in the book.
Teach me? Hell, there is more stuff in the world I don't know than I know
of! I've been wrong before and I'll be wrong again and and I hate this,
I FORGET STUFF. Easy stuff, simple stuff stuff I kick myself all over
creation because I forgot it.
Me the master, na Thats where
[EMAIL PROTECTED] wrote:
Teach me? Hell, there is more stuff in the world I don't know than I know
of! I've been wrong before and I'll be wrong again and and I hate this,
I FORGET STUFF. Easy stuff, simple stuff stuff I kick myself all over
creation because I forgot it.
yup, simple stuff
...getting old...
Noo
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 4/4/2003 3:48 PM
[EMAIL PROTECTED] wrote:
Teach me? Hell, there is more stuff in the world I don't know than I
know
of! I've been wrong before and I'll be wrong again
Our RMAN backup is backing up much more than the actual data blocks when
doing a full backup. I know that it backs up all blocks that have ever been
used, but I'm trying to figure out exactly what that means. My first
thought was that it backs up all blocks below the HWM, but I analyzed the
tables
Keith
Here is my understanding (don't rely on this one). When Oracle allocates
tablespace, the disk blocks are cleared. My interpretation is that when RMAN
encounters a clear block, it doesn't write it to the backup piece. I don't
think it spends a lot of time trying to figure out above HWM and
Actually this is how RMAN works. It writes all blocks up to the HWM of a
given table,
even empty ones. So, if your HWM is artifically high, you will encounter
backups
that are larger than they need to be.
Oracle9i RMAN Backup and Recovery On bookshelves now!
RF
-Original Message-
Keith
Like I said, don't rely on my interpretation. Believe Robert -- he wrote
the book! And yes, buy the book. Great book, highly recommended.
http://www.amazon.com/exec/obidos/tg/detail/-/0072226625/qid=1049405966/sr=8
-1/ref=sr_8_1/002-7783294-4962413?v=glances=booksn=507846
Dennis
I should have stated that this is Oracle 8.0.5, if that makes a difference.
After posting the questions, I went to Metalink and found some conflicting
informaiton, but the consensus seemed to be that it was unrelated to the HWM
of the tables. For example, after dropping a table, all the blocks
13 matches
Mail list logo