RE: Remove datafile from controlfile: recover partial database until time

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <Laimutis.Nedzinskas@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 9 Nov 2011 11:33:00 -0500

Backing up the controlfile to trace gives you an ascii version you can edit
and use to create a controlfile for the partial clone recovery with the
syntax all conveniently in place. Is that what you're talking about?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Laimutis.Nedzinskas@xxxxxx
Sent: Wednesday, November 09, 2011 8:33 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Remove datafile from controlfile: recover partial database until


Is it possible to remove datafile entry from control file while database is
mounted ?

I managed to achieve that by using recreating control file with "CREATE
Is there another option ?
"alter database datafile ... offline drop" does not do that. It offlines the

If anyone is interested why I need that I can tell:

I develop a procedure to partially recover only some datafiles of database.
It all works fine with "alter database datafile ... offline drop"  except
that sqlplus RECOVER UNTIL TIME has to be used instead of RMAN. RMAN does
not allow such recovery. It works with SKIP TABLESPACES option but my task
is more than that: I know which datafiles I have to restore exactly.
However if controlfile is recreated from scratch and the unneeded files are
omitted then RMAN recover works fine. RMAN recover has a few nice options
like auto restoring of required archive logs and deleting them on a fly. Of
course one can guess why I need all that: out of multy TB database only a
few tabless needs to be restored :-] Sure, the storage space is an issue :-]

Thank you in advance. Laimis N


Please consider the environment before printing this e-mail



Other related posts: