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

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Mon, 28 Mar 2011 07:48:47 +0200
Message-ID: <4814386347E41145AAE79139EAA398981500889EE5_at_ws03-exch07.iconos.be>

Do you need to recover the production db or do you need to clone it to test/dev? In the first case, I would suggest opening a service request with Oracle support, but you are probably out of luck (maybe they can open the db temporary to allow you to unload the data as much as possible). In the second case, restart with a fresh, correctly taken, backup.

And oh yeah, after that, tell your client he needs more dba consultancy

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer

---
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sandeep Kumar B
Sent: maandag 28 maart 2011 7:04
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 - 00:48:47 CDT