Re: RMAN Scenario

On Tue, Mar 8, 2016 at 12:30 PM, sumit Tyagi <dba.tyagisumit_at_gmail.com> 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_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 <%2B91-7829543355>*
>>
>
>
>
> --
>
> *--*
> *BR*
> *Sumit Tyagi*
> *+91-7829543355 <%2B91-7829543355>*
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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