OraFAQ Forum: Backup & Recovery » Recover Oracle database (without RMAN)

Home » RDBMS Server » Backup & Recovery » Recover Oracle database (without RMAN) - Server/Oracle database has crashed (Oracle 9i, Window Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Recover Oracle database (without RMAN) - Server/Oracle database has crashed [message #441443]

Mon, 01 February 2010 03:43

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

Report message to a moderator

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

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

sriram

Report message to a moderator

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

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator