RMAN is a handy tool.. :)
On Tue, Mar 8, 2016 at 12:30 PM, sumit Tyagi <dba.tyagisumit@xxxxxxxxx>
wrote:
Hi Chris ,
It was just a Dev box so not much data . I am able to get the tablespace
back . As archivelog was having the information of new tablespace oracle is
able to restore and recover it .
1. Restored controlfile from last night full backup .
2. Restore database .
3. Recover database
--
BR
Sumit
On Tue, Mar 8, 2016 at 11:57 PM, sumit Tyagi <dba.tyagisumit@xxxxxxxxx>
wrote:
Hi Andrew ,
Thank you it worked :)
On Tue, Mar 8, 2016 at 10:58 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>
wrote:
If it was a full backup from the previous night, a control file should
have been part of it. Restore that control file, and roll forward with the
archive logs.
On Tue, Mar 8, 2016 at 10:10 AM, Ruel, Chris <Chris.Ruel@xxxxxxx> wrote:
How much data are you talking about?
With no backup of the affected TS, no backup of the controlfile, or a
copy of the current controlfile your best bet might be to:
1. Re-create the tablespace
2. Re-create objects (I would like to think you have the code to
at least re-create the objects, although, that should be in the archive
logs as well)
3. Use LogMiner to get the transactions against the objects from
the archive logs
4. Re-run the committed transactions you get from LogMiner
Could be a lot of tedious work depending on number of objects. Might
contact Oracle to see if there is a way to get a datafile back into the
controlfile to roll it forward. Something like the following link:
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV224
Problem is, for that link to work you either need a current controlfile
or a backup. That’s why I say contact Oracle in case they have some trick
up their sleeve…unless someone else on this list has an idea I am not
thinking of.
Good luck,
Chris..
_____________________________________________________________________
Chris Ruel * Oracle Database Administrator * Lincoln Financial Group
cruel@xxxxxxx * Desk:317.759.2172 * Cell 317.523.8482
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *sumit Tyagi
*Sent:* Tuesday, March 08, 2016 10:56 AM
*To:* Oracle L
*Subject:* RMAN Scenario
1. RMAN {backup database plus archivelog }
2. Created one new tablespace with name TEST .
3. No auto backup available for control file .
4. Data inserted into table associated with TEST tbs
5. Datafiles got removed from os level for TEST tbs . Also current
control file got deleted .
6. How to get back the data . We don't have that particular tbs in rman
backup which was taken last night .Also current control file is missing .
All archives and redo are present .
--
*--*
*BR*
*Sumit Tyagi*
*+91-7829543355 <%2B91-7829543355>*
Notice of Confidentiality: **This E-mail and any of its attachments may
contain
Lincoln National Corporation proprietary information, which is
privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation
family of
companies. This E-mail is intended solely for the use of the individual
or entity to
which it is addressed. If you are not the intended recipient of this
E-mail, you are
hereby notified that any dissemination, distribution, copying, or
action taken in
relation to the contents of and attachments to this E-mail is strictly
prohibited
and may be unlawful. If you have received this E-mail in error, please
notify the
sender immediately and permanently delete the original and any copy of
this E-mail
and any printout. Thank You.**
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
--
*--*
*BR*
*Sumit Tyagi*
*+91-7829543355 <%2B91-7829543355>*
--
*--*
*BR*
*Sumit Tyagi*
*+91-7829543355 <%2B91-7829543355>*
