Re: Recovery wants backup piece no longer available

First, you should try to get your ticket severity elevated to meet your current requirements.

Second, before attempting anything else ensure that you can recover what you have to your current point in case you destroy your current restore.

If you want to attempt an alternative approach you can try setting "_allow_resetlogs_corruption"=true and open resetlogs the database. If you’re able to get it open then you can try to perform a transportable tablespace export of the read only tablespaces. I’d personally attempt exp as opposed to expdp since exp seems to be pretty much read only to the database when executing and requires less dictionary information/manipulation to run. The transportable tablespace export should only take a few minutes. If this works you can use the dump file and the files from the read only tablespaces to import into another database.

Just a shot but just might work.

In the future you might want to consider taking transportable tablespace exports of any read only tablespaces just so you have them around in case you need them.

Kenny

> On Jul 24, 2015, at 3:40 PM, Sandra Becker <sbecker6925_at_gmail.com> wrote:
>
> 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 <mailto: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

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