Re: Recover from hot backup taken when database is not in backup mode
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: itakamran@xxxxxxxxxxxx
- Date: Mon, 28 Mar 2011 04:11:53 -0300
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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *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".
>
>
Other related posts:
