Home » RDBMS Server » Backup & Recovery » ORA-01171: datafile # going offline
ORA-01171: datafile # going offline [message #194671] Sat, 23 September 2006 21:46 Go to next message
Messages: 33
Registered: February 2005

I have small doubt..

Why this following error is coming ..?

87 going offline due to error advancing checkpoint..

What type of precautions need to be taken for this error ...

Re: ORA-01171: datafile # going offline [message #194673 is a reply to message #194671] Sat, 23 September 2006 22:35 Go to previous message
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Some logswitch errors occur sometimes when you try to switch archivelogs and the archivelog has not yet been written out. Archivelogs become logfiles depending on the number of archivewriter_processes specified in the init.ora file. Try increasing the number of processes that write out archivelogfiles. You can specify how many it writes in paraelle, and how many must complete before you start a new archivelog.
Previous Topic: Datafile Free Size
Next Topic: location of the backups sets using RMAN
Goto Forum:

Current Time: Thu Jul 27 20:04:30 CDT 2017

Total time taken to generate the page: 0.07362 seconds