| Protecting Unrecoverable Changes [message #191420] |
Wed, 06 September 2006 05:23  |
RivetJoint
Messages: 7
Registered: September 2006
Location: UK
|
Junior Member |
|
|
Hello.
I have a production E-Business Suite database.
The database is in archivelog mode.
It is backed up once a day using Rman (database plus archivelogs).
What worries me is that infrequently unrecoverable changes are being made to the database. I have to assume these are part of E-Business Suite's internal processes and are required. I know these are happening by querying v$datafile.
My concern is that if I ever need to restore the database the objects, which are unknown to me, which had non-logged actions applied to them will not be restored correctly.
How should I think about solving this problem? More frequent full backups? Incremental backups?
|
|
|
|
|
|
|
|
| Re: Protecting Unrecoverable Changes [message #191487 is a reply to message #191420] |
Wed, 06 September 2006 09:43  |
email.sandeepnaik
Messages: 121
Registered: August 2006
|
Senior Member |
|
|
nope.
All DML operations with nologging caluse will also generate redo and hence higher archivelog and may be increased resource consumption on server.
If this feature is enabled Oracle does a force logging even if nologging or unrecoverable loads are done.
This feauter can be enabled at TWO level:
- Database level(CREATE DATBASE ,ALTER DATABASE ..FORCE LOGGING)
- Tablespace level(CREATE TABLESPACE,ALTER TABLESPACE ..FORCE LOGGING)
Sandeep
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
