Home » RDBMS Server » Backup & Recovery » Recover Database (Oracle, 8.1.7,0.0 / Server Manager 3.1.7.0.0 / Windows Server 2003)
Recover Database [message #385908] Wed, 11 February 2009 19:17 Go to next message
kumarvk
Messages: 211
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 Go to previous message
BlackSwan
Messages: 25033
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

Previous Topic: back up from oracle 10g client
Next Topic: How to reset Used Flash Recovery Area Size (GB) ?
Goto Forum:
  


Current Time: Fri Dec 02 16:56:08 CST 2016

Total time taken to generate the page: 0.31813 seconds