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
rtjk
Messages: 33
Registered: February 2005
Member
hai,


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 ...

bye
jay..
Re: ORA-01171: datafile # going offline [message #194673 is a reply to message #194671] Sat, 23 September 2006 22:35 Go to previous message
nmacdannald
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: Fri Dec 09 11:33:16 CST 2016

Total time taken to generate the page: 0.30616 seconds