Re: Recovery wants backup piece no longer available

From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Fri, 31 Jul 2015 15:29:42 -0600
Message-ID: <CAJzM94BTRhdV_wDiv=qczx3YKA09q01NMS9BB9f-om402QraVw_at_mail.gmail.com>

Thank you everyone for your suggestions and links. I used the underscore parameter and got the database to open. Unfortunately, the UNDO tablespace was corrupt so it kept crashing. Oracle support still hasn't responded to that post in my ticket. I searched and found a really good article on removing a corrupt UNDO tablespace. Followed the steps and was able to export my read-only tablespaces.

Sandy

On Fri, Jul 24, 2015 at 2:02 PM, Abu Fazal Abbas <abbas.appsdba_at_yahoo.in> wrote:

> Hi Sandy,
>
>
>
> You may try setting the hidden parameter *_ALLOW_RESETLOGS_CORRUPTION=TRUE
> *to open up the TEST database. Ideally we should not use these parameters
> without consulting Oracle Support. However, since you are dealing with the
> test database, I am recommending this solution as I don't see any another
> options available for you to open up the database (since there is no
> archivelogs avaiable nor the Level 1 backup).
>
>
>
> Once the database is opened, immediately take export of the data that you
> are interested in. There is no guarantee that the database would function
> normally once this parameter is set.
>
>
>
> Hope this helps.
>
>
>
>
>
> *Thanks and Regards,*
>
>
>
> Abbas
>
>
>
> *Abu Fazal Mohammed Abbas*
>
> Website: www.oraclebuffer.com
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Sandra Becker
> *Sent:* Saturday, July 25, 2015 1:11 AM
> *To:* oracle-l
> *Subject:* Re: Recovery wants backup piece no longer available
>
>
>
> Sorry, when the fire alarm went off, I hit the wrong keys and it sent
> before I was ready.
>
> I have only one backup, a Level0, of those missing tablespaces. They were
> set to READ-ONLY several days prior to the LEVEL0 backup. I successfully
> restored the tablespaces plus SYSTEM, SYSAUX, and UNDO. When I try to
> recover, it prompts for a LEVEL1 backup taken 6 days earlier. That backup
> not only expired in Netbackup, but the tapes have been overwritten. I
> can't open the database because it wants to do recovery on the SYSTEM
> tablespace. I also do not have archivelog backups from that time. We
> don't keep them longer than 5 weeks and it's been 10.
>
> Any suggestions on how I can get this test database open and export the
> data from the READ-ONLY tablespaces? I opened a ticket with Oracle Support
> over 2 hours ago, but they haven't picked it up yet.
>
> Sandy
>
>
>
> On Fri, Jul 24, 2015 at 1:34 PM, Sandra Becker <sbecker6925_at_gmail.com>
> wrote:
>
> Oracle 11.2.0.2
>
> Over 2 months ago three READ-ONLY tablespaces were inadvertently dropped.
> I am now tasked with recovering just those three tablespaces into a test
> database where we can extract the data we want and get it back into
> production. Customers are complaining because they can't reconcile POs,
> and rightly so. One tablespace contains a single day's POs so we're
> missing only three days of data.
>
> I have only one backup, a LEVEL0
>
>
> --
>
> Sandy
> GHX
>
>
>
>
> --
>
> Sandy
> GHX
>

-- 
Sandy
GHX

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

Received on Fri Jul 31 2015 - 23:29:42 CEST