Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What happen if I resize a datafile during RMAN backup?

Re: What happen if I resize a datafile during RMAN backup?

From: <dominica_at_gmail.com>
Date: 8 Sep 2005 17:50:34 -0700
Message-ID: <1126227034.069609.89110@z14g2000cwz.googlegroups.com>


Actually, all the datafiles are autoextend on. But my db is a very fast OLTP( oracle 8.1.7.4).

Normally RMAN backup is fine, until one of the datafile (say AA) is 100% full and
AA try to do autoextend "on" during the RMAN backup.

And then RMAN backup will come back with error. I think RMAN remember the size of my original file and then after AA autoextend on to grow even just a little bit.

Then RMAN fail at the end with an error message.

I could capture (or find my error to show you).

So I normally don't let any tablespace to be 100% full.

I usually calculate to make sure I have space for next 2 months.

Thanks,

Dominica Received on Thu Sep 08 2005 - 19:50:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US