Re: Recover from hot backup taken when database is not in backup mode
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: sandeep.b@xxxxxxxxxxxxx
- Date: Mon, 28 Mar 2011 17:21:43 +0530
are you sure you want it as a test environmetn for development work..or want
to use it for preparing standby, clone etc..
if its purely for development test environment then prepare a control file
and try incomplete recovery..
latter change dbid, name etc..
otherwise take fresh hot backup by putting database in backup mode etc..
thanks..subodh
On 28 March 2011 10:34, Sandeep Kumar B <sandeep.b@xxxxxxxxxxxxx> wrote:
> 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".
>
>
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
Other related posts: