Home » RDBMS Server » Server Administration » Archive from redo log (Oracle 10.2.0.1)
Archive from redo log [message #392497] Wed, 18 March 2009 03:58 Go to next message
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 #392502 is a reply to message #392497] Wed, 18 March 2009 04:08 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>> How can i read the DML's in the redo log?

LOGMINOR

>> How to create the archive log file from Redo logs through a command?

ALTER SYSTEM SWITCH LOGFILE;


Babu
Re: Archive from redo log [message #392516 is a reply to message #392502] Wed, 18 March 2009 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The second point is, for current:
alter system archive log current;

or, for inactive ones:
alter system archive log all;

Regards
Michel
Re: Archive from redo log [message #392518 is a reply to message #392497] Wed, 18 March 2009 04:47 Go to previous messageGo to next message
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 #392526 is a reply to message #392518] Wed, 18 March 2009 04:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
FORMAT YOUR QUERY.
This is NOT only use code tags but also indenting.

Regards
Michel

Re: Archive from redo log [message #392528 is a reply to message #392497] Wed, 18 March 2009 05:11 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Please tell me how i can format it.
I tried it but still not working.

Thanks,
Re: Archive from redo log [message #392529 is a reply to message #392528] Wed, 18 March 2009 05:18 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>Here i can see the ROWID = 'AAAQEnAAqAABh1qAAt';

I think it's return correct value.
Re: Archive from redo log [message #392532 is a reply to message #392497] Wed, 18 March 2009 05:28 Go to previous messageGo to next message
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 #392536 is a reply to message #392532] Wed, 18 March 2009 05:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Build it from rowid.

Regards
Michel
Re: Archive from redo log [message #392540 is a reply to message #392497] Wed, 18 March 2009 05:45 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Actually i also have other tables then how i can consider perticular column name and search that?

I could have other statements. Sad

update "TEST2" set "LEADCOUNTSTDFAILED" = '234' where "LEADCOUNTSTDFAILED" = '233' and ROWID = 'AAAQDRAAKAAAUSdAAs';


Thanks,
Re: Archive from redo log [message #392552 is a reply to message #392497] Wed, 18 March 2009 06:50 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Any updates please,
Thanks,
Re: Archive from redo log [message #392554 is a reply to message #392497] Wed, 18 March 2009 06:59 Go to previous messageGo to next message
cookiemonster
Messages: 12403
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 messageGo to next message
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?
Re: Archive from redo log [message #392570 is a reply to message #392557] Wed, 18 March 2009 08:02 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>So any other way i can do that?

1/ Advanced Replication
2/ Streams
3/ Data Guard
Previous Topic: Error 600 encountered while recovering transaction (24, 20)
Next Topic: arch extension
Goto Forum:
  


Current Time: Sat Dec 03 03:54:08 CST 2016

Total time taken to generate the page: 0.11446 seconds