
	Home > Ask the Oracle Experts > Database Backup and Recovery Questions & Answers > Redo log file problems

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

Redo log file problems

EXPERT RESPONSE FROM: Brian Peasland

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Oracle tips, scripts, and expert advice

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 10 March 2008
My database was abruptly shut down (I don't know why). While we were opening the database it was showing the error in log files, so we tried to add a new redo log file for the existing group. It was added, and we are not able to switch the database because we are at mount stage, and even when we use the command to clear the logfile with "alter database clear unarchived logfile group 4," it is not clearing the group and the database is not switching. At mount stage, the database is in hang position. The database will open if we drop that redolog file offline, but we will lose some data. To overcome from these types of errors, what precautions should we take at this moment?

EXPERT RESPONSE
The first thing to do in the future is to make sure that the online redo logs are multiplexed. If one redo log file becomes corrupt, Oracle can use the other one. The multiplexed online redo log files should be on separate disk devices.

If you are still unable to open your database, you can try to open the database with the RESETLOGS option. This will clear out all online redo log files. You may experience loss of some transactions, so this should be a last option. But this may also be your only option, too.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Database Backup and Recovery
	How to recover a control file
	The USING BACKUP CONTROLFILE clause in Oracle commands
	Backup and recoveries of Oracle RAC 10gR2
	Backup and recovery of Oracle 10g with forgotten admin password
	How to use the OPatch Utility in Oracle
	How to get history of modified data from Oracle databases
	Export dump with files larger than 2 GB
	What is Unix shell scripting?
	Performing a backup with table locks
	How to move data faster with a database link

Oracle database administration (DBA)

Why am I getting an Oracle error when issuing the RECOVER DATABASE command?

Can I add multiple datafiles and make use of all the temporary datafiles at the same time?

Checkpoint vs. commit process

What's the best tape backup strategy for 10g RAC?

Can I resize the SYSTEM tablespace?

How does an INSERT/UPDATE statement behave when executed compared to a SELECT statement?

How to recover a control file

The USING BACKUP CONTROLFILE clause in Oracle commands

Backup and recovery of Oracle 10g with forgotten admin password

How to use the OPatch Utility in Oracle

Oracle database administration (DBA) Research

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy