Re: RMAN restore into nearly full file system
- From: Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 24 Aug 2010 10:00:39 -0700 (PDT)
Hi All,
Thank you all very much for the comments and suggestions.
Just to clarify - the file system in question had ONLY 5 data files. There
were
no tempfiles (so no sparse files), controlfiles, redo logs or anything else on
the file system. The data files were not autoextensible and had not been
re-sized since backed up.
I did not delete the original files before I restored over them (I'll try this
next time I get the opportunity to set up a test - original problem resolved by
SET NEWNAME) but I'm curious as to why this might make a difference versus just
overwriting them (the database was definitely down so no processes were holding
the files open).
Thank you!
Charlotte
----- Original Message ----
From: "Dunbar, Norman (Capgemini)"
norman.dunbar.capgemini@xxxxxxxxxxxxxxxxxxxxxxxxx
I seem to remember that sparse TEMPFILES were introduced at 9i. I
remember also, in a past life, having problems with these as our
"standards" at the time was "everything on one big bucket" on an EVA.
When the TEMPFILES were created they appear to be at full size, but in
effect are not. But they can grow into the space already "allocated" for
them as and when required.
....
If you are doing a full restore, I'd be tempted to wipe out the
destination disc space of any files that may be sitting around before I
start.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
