Home » RDBMS Server » Backup & Recovery » Logfile & Database ! (Oracle 8i, Solaris 5.8)
Logfile & Database ! [message #333583] Sun, 13 July 2008 04:51 Go to next message
Messages: 2
Registered: July 2008
Junior Member
Hello everybody,

I am facing problem. Let me give you some details.

My serve running with Oracle8i, and two harddisk - hd1 and hd2; inside it.

On hd1 there is installation of Solaris OS and Oracle software contains one of control files control1.ctl and three logs file log1.log, log2.log, log3.log.

On hd2 contains datafile, indexfiles etc.. and another copy of control file control2.ctl.

Now due to some problem my system does not get boot and I have to reinstall the oracle software on hd1 and I don't have backup copy of control1.ctl and all three log1.log, log2.log and log3.log.

In above scnerio what will happen is there any chance of dataloss possible ? How to solve this problem. Pl. note that there is no damage to any file on hd2. will I loss the database due to nonavailability of backup of above files?

Can any one guide me step by step to solve this problem.

With Thank !

Prashant Shukla

Re: Logfile & Database ! [message #333587 is a reply to message #333583] Sun, 13 July 2008 05:25 Go to previous messageGo to next message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You should always have 2 members in each log groups.
You don't care of the control file you lost as you have the other one.

Have a look at User-Managed Backup and Recovery Guide
Chapter 6 User-Managed Media Recovery Scenarios

Re: Logfile & Database ! [message #333853 is a reply to message #333587] Mon, 14 July 2008 10:49 Go to previous message
Messages: 2
Registered: July 2008
Junior Member
Dear Michel !

Thank you very much for your guidance.

Regards !

Previous Topic: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS required....
Next Topic: Creating Clone database manually
Goto Forum:

Current Time: Sat Aug 19 17:32:58 CDT 2017

Total time taken to generate the page: 0.05306 seconds