OraFAQ Forum: Backup & Recovery » No errors displayed in Alert log

Home » RDBMS Server » Backup & Recovery » No errors displayed in Alert log

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

No errors displayed in Alert log [message #277579]

Tue, 30 October 2007 11:59

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.

Report message to a moderator

Re: No errors displayed in Alert log [message #277586 is a reply to message #277579]

Tue, 30 October 2007 12:58

BlackSwan
Messages: 26766
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

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?

Report message to a moderator

Re: No errors displayed in Alert log [message #277777 is a reply to message #277776]

Wed, 31 October 2007 08:38

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	finding dbid
Next Topic:	refresg using rman

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 20 15:28:14 CDT 2025