Q
Problem solve Get help with specific problems with your technologies, process and projects.

Insert process running during hot backup mode

Scenario: BCV backup is taken by putting tablespaces into hot backup mode, but during this period of time an insert process is run using the nologging option. Can I open the database at the point in time just after the BCV backup finishes and be able to query the table that the insert was running against?

We are using Oracle 8.1.7 currently. Scenario: BCV backup is taken by putting tablespaces into hot backup mode, but during this period of time an insert process is run using the nologging option. The process spans the period of time when the tablespaces are taken out of hot backup mode. Can I open the database at the point in time just after the BCV backup finishes and be able to query the table that the insert was running against?
Any tablespace that goes into hot backup mode and is subsequently used for recovery would need redo logs applied. If your processes were doing direct insert without logging then this data would not be available.

Remember only certain operations make use of the nologging option. Some of these are a direct load with SQL*Loader or a direct load insert. The direct load insert is a special form of the insert statement that uses the /*+ append */ hint.

That means that ordinary inserts, updates and deletes always generate redo, no matter if the underlying table or index is specifed with nologging or not.

Nologging can be overridden at tablespace level using alter tablespace ... force logging.

Nologging has no effect if the database is in force logging mode (which can be controlled with alter database force [no] logging mode).

Dig Deeper on Oracle SOA

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close