Home » RDBMS Server » Backup & Recovery » No errors displayed in Alert log
No errors displayed in Alert log [message #277579] Tue, 30 October 2007 11:59 Go to next message
sroy
Messages: 38
Registered: July 2005
Member
Removed one of the datafiles from the system on purpose while the database is open. Expecting to see the error messages in the alert log. No sign of the error messages until shutdown and startup. Why is it so? I tried alter system checkpoints several time with no result whatsoever. Please help me to understand. Thanks.
Re: No errors displayed in Alert log [message #277586 is a reply to message #277579] Tue, 30 October 2007 12:58 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Operating system is likely some Unix variant.
This is normal & expected behavior.
The file is really, really not deleted until after the last open file handle is closed.

[Updated on: Tue, 30 October 2007 12:59] by Moderator

Report message to a moderator

Re: No errors displayed in Alert log [message #277776 is a reply to message #277579] Wed, 31 October 2007 08:34 Go to previous messageGo to next message
sroy
Messages: 38
Registered: July 2005
Member
What's the other option to detect the missing file? Will the RMAN backup be able to catch it while backing up weekly/daily?
Re: No errors displayed in Alert log [message #277777 is a reply to message #277776] Wed, 31 October 2007 08:38 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As rman is an external program, it will not see the removed file, just like you, and so raise an error.

Regards
Michel
Previous Topic: finding dbid
Next Topic: refresg using rman
Goto Forum:
  


Current Time: Wed Dec 07 22:20:02 CST 2016

Total time taken to generate the page: 0.14011 seconds