Re: RMAN Scenario

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_at_gmail.com>
wrote:



> Hi Andrew ,

>

> Thank you it worked  :)

>

> On Tue, Mar 8, 2016 at 10:58 PM, Andrew Kerber <andrew.kerber_at_gmail.com>

> 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_at_lfg.com> 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_at_lfg.com * Desk:317.759.2172 * Cell 317.523.8482

>>>

>>>

>>>

>>> *From:* oracle-l-bounce_at_freelists.org [mailto:

>>> oracle-l-bounce_at_freelists.org] *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*

>




-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

--
http://www.freelists.org/webpage/oracle-l