| INSERT without archive [message #394158] |
Wed, 25 March 2009 21:15  |
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
|
Senior Member |
|
|
I have 1 script which includes INSERT statement.
But i done want to generate archive log for those statements.
INSERT INTO bk_contents_ins
SELECT REPLACE(REPLACE( sql_redo, ',NULL);', ');' ),'"MSG_T","")','"MSG_T")')
FROM bk_contents
WHERE row_id =i.row_id
AND UPPER(SQL_REDO) LIKE 'INSERT INTO ;
How can i do that?
Thanks,
[Updated on: Wed, 25 March 2009 21:18] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: INSERT without archive [message #394291 is a reply to message #394191] |
Thu, 26 March 2009 07:01  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
If you insert data without generating Redo logs, then when you come to do a recovery, there will be no redo data available for those tables, and the data in them will not be recovered.
A Full backup back up all committed data as of that point in time, and so will include the data you've just added.
It is rare that not generating redo saves enough time to be worth the extra hassle - why do you think that you want to avoid generating Redo for these transactions?
Is it possible that you're getting Undo and Redo data confused?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
