Glad to hear it worked out for you.
Kenny
On Jul 31, 2015, at 5:29 PM, Sandra Becker <sbecker6925@xxxxxxxxx> wrote:
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@xxxxxxxx
<mailto:abbas.appsdba@xxxxxxxx>> 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 <http://www.oraclebuffer.com/>
From: oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>]
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@xxxxxxxxx
<mailto:sbecker6925@xxxxxxxxx>> 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