RE: Remove datafile from controlfile: recover partial database until time
Date: Wed, 9 Nov 2011 14:11:47 -0500
Message-ID: <C30A2BC684C61749B6FE649A21711DB710E523_at_dtcanexch03.canada.dt.inc>
Datafile is physical, not logical. Not sure what you want to gain.
Maybe you need to drop a tablespace? So the datafiles would be dropped as well.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Laimutis.Nedzinskas_at_seb.lt
Sent: Wednesday, November 09, 2011 1:13 PM
To: Mark W. Farnham
Cc: oracle-l_at_freelists.org
Subject: RE: Remove datafile from controlfile: recover partial database
until time
yes, exactly. dumping(backing in oracle terms) controlfile to trace
gives
me the "create controlfile" command which I can edit to skip datafiles I
do
not need to restore.
My question is if this (removing datafile record from control file) can
be
done by using individual SQL commands.
My understanding is that this is not possible: the whole tablespace can
be
dropped together with datafiles but for that the database has to be
opened.
The problem is RMAN: I do not know how to feed into rman what datafiles
to
skip. RMAN skips at tablespace level only which is fine but the
tablespace
I deal with is a few TBs in size.
If one looks into alert log while RMAN recovers then it is possible to
see
that rman builds a list of datafiles to recover but ok, this interface
is
hidden as far as I understand and the least I want is to use hidden
features unless really necessary. But it looks like RMAN operates at
tablespace level only (?)
Please consider the environment before printing this e-mail
From: "Mark W. Farnham" <mwf_at_rsiz.com>
To: <Laimutis.Nedzinskas_at_seb.lt>, <oracle-l_at_freelists.org>
Date: 2011.11.09 18:33
Subject: RE: Remove datafile from controlfile: recover partial database until time
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Laimutis.Nedzinskas_at_seb.lt
Sent: Wednesday, November 09, 2011 8:33 AM
To: oracle-l_at_freelists.org
Subject: Remove datafile from controlfile: recover partial database
until
time
Hi
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
CONTROLFILE..."
Is there another option ?
"alter database datafile ... offline drop" does not do that. It offlines
the
datafile.
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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 09 2011 - 13:11:47 CST