OraFAQ Forum: Data Guard » Force logging

Home » Server Options » Data Guard » Force logging (Windows,10.2.0.3)

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

Force logging [message #468871]

Mon, 02 August 2010 06:08

sekar52
Messages: 141
Registered: May 2010
Location: Mumbai

Senior Member

Hi I created a table in nologging mode and inserted some values into it and committed the transaction.I switched the logfiles manually and shutdown the database.I deleted the datafile oslevel restarted the database and recreated the datafile and recovered it.But the table which is created in nologging mode is also present.Why is it present???It must not be recovered from archive logs as the redo for the table is not logged..Please explain....(Note:Database is not in force logging mode)

Report message to a moderator

Re: Force logging [message #468898 is a reply to message #468871]

Mon, 02 August 2010 08:06

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

Senior Member
Account Moderator

Dictionary data modification are ALWAYS logged even if you specify NOLOGGING.
The tabel is there but the data are not (if you inserted in direct mode which is the only case where you can do it without logging).

Regards
Michel

Report message to a moderator