Re: Recover from hot backup taken when database is not in backup mode

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Mon, 28 Mar 2011 04:11:53 -0300
Message-ID: <AANLkTinWO+Hn1TLoUEm8ynKPwZh5--GJ=P=1h=jm7K8x_at_mail.gmail.com>

It is possible to open the database in inconsistent mode using some hidden parameters, but I'de recommend you talk to Oracle about that (open a SR). And it is a messy business and it doesn't always work, and afterwards you either end up with a database without transaction consistency or you have to export the database and import into a new one and there's some weird behaviour with the undo (you may get a 1555 even if you are not running a consistent export). So, don't do this unless you are ready to spend a lot of time messing around with hidden parameters, Oracle Support and export...

However, if this is for a data refresh purposes, just put the database in backup mode and take a backup then for that refresh.

Oh, and by the way, I'd make a point of recommending the customer to move to RMAN backups ASAP.
Alan.-

On Mon, Mar 28, 2011 at 2:51 AM, Kamran Agayev (ICT/SNO) < itakamran_at_azercell.com> wrote:

> What don’t you use RMAN for backup and recovery?
>
>
>
> If the primary db is running and not corrupted yet, take RMAN backup and
> clone it using DUPLICATE DATABASE command and DON’T use the corrupted
> backups
>
>
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Sandeep Kumar B
> *Sent:* Monday, 28 March 2011 10:04 AM
>
> *To:* Oracle-L Freelists
> *Subject:* Recover from hot backup taken when database is not in backup
> mode
>
>
>
> Hi all,
>
>
>
> I've a tricky situation in one of my client environment.
>
> My client was taken an hot backup without putting the database in backup
> mode and in that backup he was not included archivelogs also.
>
> Now we are facing the problem like system tablespace needs recovery while
> cloing it to test environment.
>
> Can anybody suggest on this.
>
>
>
>
>
> Thanks,
>
> Sandeep
>
> DBA
>
>
>
>
>
> DISCLAIMER:“The information in this email (and any attachments) is legally privileged and confidential. If you are not the intended recipient, you must not use or disseminate the information. If you have received this email in error, please immediately notify the sender by "Reply" command and permanently delete the original and any copies or printouts thereof. Although this email and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by Four Soft Limited or its subsidiaries or affiliates either jointly or severally for any loss or damage arising in any way from its use or incompleteness or any delay in its receipt".
>
>

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

Received on Mon Mar 28 2011 - 02:11:53 CDT