Home » Server Options » Data Guard » Force logging (Windows,10.2.0.3)
Force logging [message #468871] Mon, 02 August 2010 06:08 Go to next message
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)
Re: Force logging [message #468898 is a reply to message #468871] Mon, 02 August 2010 08:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59270
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Force logging [message #469037 is a reply to message #468898] Tue, 03 August 2010 01:25 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Even the data i inserted is present
Re: Force logging [message #469048 is a reply to message #469037] Tue, 03 August 2010 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59270
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you do not execute a direct path INSERT.

Regards
Michel
Re: Force logging [message #469062 is a reply to message #469048] Tue, 03 August 2010 02:05 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Can u give some documentation to explain various insert modes and how to find what mode inserts are happening in database
Re: Force logging [message #469066 is a reply to message #469062] Tue, 03 August 2010 02:34 Go to previous message
Michel Cadot
Messages: 59270
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database SQL Reference
Oracle search

Regards
Michel
Previous Topic: log archive dest issue
Next Topic: Best practice for Archive_log destination
Goto Forum:
  


Current Time: Tue Sep 30 05:22:35 CDT 2014

Total time taken to generate the page: 0.19412 seconds