Archive from redo log [message #392497] |
Wed, 18 March 2009 03:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
1. How can i read the DML's in the redo log?
I need the statements from the redo log like we get through LOGMINOR in SQL_REDO column.
2. How to create the archive log file from Redo logs through a command?
Means i want to clean the Redo log and want to create archive log so that i can use those archive log in LOGMINOR.
Thanks,
|
|
|
|
|
Re: Archive from redo log [message #392518 is a reply to message #392497] |
Wed, 18 March 2009 04:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Please find 1 statement from v$logmnr_contents view.
Here i can see the ROWID = 'AAAQEnAAqAABh1qAAt';
Cant i see exact id for that?
update "TEST"
set "SYSCHANGED" = TO_DATE('18-MAR-09', 'DD-MON-RR'), "FAILED" = '1', "BOUNCE_MSG_T" = 'HARD'
where "SYSCHANGED" = TO_DATE('18-MAR-09', 'DD-MON-RR')
and "FAILED" = '0'
and "BOUNCE_MSG_T" IS NULL and ROWID = 'AAAQEnAAqAABh1qAAt';
Actully the statement should be ID= 1212;
Because i need to execute those statements on the other database.
Thanks,
[Updated on: Wed, 18 March 2009 05:27] by Moderator Report message to a moderator
|
|
|
|
|
|
Re: Archive from redo log [message #392532 is a reply to message #392497] |
Wed, 18 March 2009 05:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
In my database query is running well and showing the result.
But the thing is i need query with ID=1212 instead of ROWID='AAAQEnAAqAABh1qAAt'
Please help to create that query.
|
|
|
|
|
|
Re: Archive from redo log [message #392554 is a reply to message #392497] |
Wed, 18 March 2009 06:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
It'd probably help if you explained in plain English what you are trying to achieve.
Because it appears that Logminer is doing what it's designed to do and you want it to do more than it's designed to do.
|
|
|
Re: Archive from redo log [message #392557 is a reply to message #392497] |
Wed, 18 March 2009 07:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
You are right.
But my requirenment is that only.
I have 2 servers both are same so the transaction in archives which are generated at 1 server that i want to apply in othere server.
I have only 1 option i.e. logminor.
So any other way i can do that?
|
|
|
|