| Recover Database [message #385908] |
Wed, 11 February 2009 19:17  |
kumarvk
Messages: 214
Registered: July 2004
|
Senior Member |
|
|
Hi Experts,
Actually everynight I take full backup after proper shutdown including all archive files and next day morning it is started.
There was a mistake on 10 Feb 09 afternoon around 12.30pm by one of the users. I need to find out what was the mistake.
I have a everyday backup including arch in my tape drive. I want to do the following method can anyone tell me is right. If wrong can you please guide me.
Step 1: I will copy the database as of 09 Feb 09 night including arch in my testing database.
Step 2: Then I will copy the arch files alone from 10 Feb 09 until 1pm.
Step 3: Using SVRMGR, I use the following command.
Connect Internal/test@devl;
Startup Nomount;
recover DATABASE USING BACKUP CONTROLFILES UNTIL CANCEL;
Will this help me?
My production database global name is PROD and testing global name is DEVL.
Can anyone guide me on this? Thanks very much in advance.
|
|
|
|
| Re: Recover Database [message #385909 is a reply to message #385908] |
Wed, 11 February 2009 19:32  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
> (Oracle, 8.1.7,0.0 / Server Manager 3.1.7.0.0 / Windows Server 2003)
Supported combination? I don't think so.
V8.1.7 was retired & obsoleted long before Windows 2003 was released.
About how big the PROD database?
>I need to find out what was the mistake.
How do you plan on doing this?
What is the real goal?
Is the goal to the DB to the state just prior to the "mistake"?
What happens to changes made between mistake & now?
>Connect Internal/test@devl;
You restored PROD; not DEVL so not connecting to restored DB.
>recover DATABASE USING BACKUP CONTROLFILES UNTIL CANCEL;
What "BACKUP CONTROLFILE"?
Good Luck; because I suspect you'll need it!
You could be in for a long weekend.
[Updated on: Wed, 11 February 2009 19:33] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
