Re: Startup without redo logs?

From: Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk>
Date: Sat, 21 Jul 2001 21:35:10 GMT
Message-ID: <F43E6BAE5BB5D411A44C00805FBE740DC3E925@apps.leeds.lfs.co.uk>

-----Original Message-----

From: jkyf0131_at_hotmail.com (JK Yao) [mailto:jkyf0131_at_hotmail.com] Posted At: Friday, July 13, 2001 2:39 AM Posted To: server
Conversation: Startup without redo logs? Subject: Re: Startup without redo logs?

Before you recreate the database, should you drop or delete the database first? Otherwise how to recreate the database while it already exists?

Please clarify, thanks a lot.

Cheers,
JK

Because there is no 'drop database' command, this might be difficult ! However, to rebuild a broken one, simply build yourself a control file trace
script and massage it to use the datafile names etc from the broken database then create a new controlfile and open the database resetlogs. This will (!) fix the broken db, and create new redo logs in the process.

If the db is so broken that you can't build a controlfile trace, do it on another database to get the meat and change the file names, etc as appropriate. Have a look at this for details, it discusses moving a database, but the principles are the same : http://www.jlcomp.demon.co.uk/faq/db_move.html

Norman.

Norman Dunbar		EMail:	NDunbar_at_LynxFinancialSystems.co.uk
Database/Unix administrator	Phone:	0113 289 6265
Lynx Financial Systems Ltd.	Fax:	0113 201 7265
			URL:	http://www.LynxFinancialSystems.com


------------------------------------------------------------------------

Received on Sat Jul 21 2001 - 16:35:10 CDT