Here comes the nice guy approach again.... geesh!
Explain (to me in not the group) what you call a hot backup?
It may be that you are getting a cold backup, which is to say that you
shut down the database and you backup program gets all the system files.
If that's the case, the steps are pretty straight forward...
1 - shutdown the database (assuming there is only one)
2 - restore the entire oracle folder from 8/1 - overwrite all
(since you are new to this, I'm having you do more than is necessary)
3 - bounce the server (restart)
It should come up as it was on 8/1
(I do this weekly even though I have hot backups....)
Once it does, PLEASE put that thing in archive mode. We can discuss hot
backups versus cold after you get to this point.
Jeffrey C. Ferrel
DMS III
State of Nevada
775.687.9327
[Email address protected]
-----Original Message-----
From: srinivasulu
[mailto:oracledba-ezmlmshield-x90782547.[Email address protected]
Sent: Monday, August 06, 2007 9:50 PM
To: LazyDBA Discussion
Subject: RE: Recover Hotbackup of database not in archivelog mode.
Hi Ungaro,
You are saying database is not in archive mode. Then how come you have a
hot
backup.
Thats impossible.
Your backup set is useless if the database is not in noarchive mode.
Srinivasulu Adiraju | DBA POOL|Tech Mahindra
Email: [Email address protected]
-----Original Message-----
From: Ungaro Matt
[mailto:oracledba-ezmlmshield-x21579806.[Email address protected]
Sent: Tuesday, August 07, 2007 1:56 AM
To: LazyDBA Discussion
Subject: Recover Hotbackup of database not in archivelog mode.
I have a hotbackup of a database that I need to recover. The database
was
not in archivelog mode, and I need to recover a backup copy from 8/1.
It's
now 8/6, so redo logs will not be an option. Forgive my lack of
specificity,
I'm rather new to this, and am in a sticky situation. Any information
that
is required to help with this, please ask and I will provide. Thanks in
advance for any assistance that can be provided.
Matt
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
========================================================================
====================================================
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.
========================================================================
====================================================
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page