Home » RDBMS Server » Backup & Recovery » Recover Oracle database (without RMAN) - Server/Oracle database has crashed (Oracle 9i, Window Server)
Recover Oracle database (without RMAN) - Server/Oracle database has crashed [message #441443] Mon, 01 February 2010 03:43 Go to next message
momer79
Messages: 12
Registered: January 2010
Junior Member
Hi,

We have two window server, live-server and temp_backup-server. temp server will be used if the live server is down due to hardware failure or oracle database is down.

Oracle backup is taken twice a day and stored on both internal and external devices.

How can i restore the database with minimum data lose? Which files i need from latest backup to copy on temp server and to restore the database?

I need to perform it without RMAN.

Thanks
Re: Recover Oracle database (without RMAN) - Server/Oracle database has crashed [message #441444 is a reply to message #441443] Mon, 01 February 2010 03:49 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
/forum/fa/1622/0/

sriram Smile
Re: Recover Oracle database (without RMAN) - Server/Oracle database has crashed [message #441452 is a reply to message #441443] Mon, 01 February 2010 04:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
I need to perform it without RMAN.

If backup is made with RMAN, you can't.
If backup is not made with RMAN, it depends on how you made the backups and if you are in ARCHIVEDLOG or NOARCHIVEDLOG mode and so on.

User-Managed Backup and Recovery Guide
Chapter 6 User-Managed Media Recovery Scenarios

Regards
Michel
Re: Recover Oracle database (without RMAN) - Server/Oracle database has crashed [message #441456 is a reply to message #441443] Mon, 01 February 2010 04:40 Go to previous messageGo to next message
momer79
Messages: 12
Registered: January 2010
Junior Member
Database is in Archive-log mode.

We take backup through running scripts and instance has already been setup on the temporary server.

Re: Recover Oracle database (without RMAN) - Server/Oracle database has crashed [message #441461 is a reply to message #441456] Mon, 01 February 2010 04:43 Go to previous message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Read the document in the link.

Regards
Michel
Previous Topic: Deletion of Datafile
Next Topic: how to take backup and restore database
Goto Forum:
  


Current Time: Tue Dec 10 02:10:11 CST 2024