OraFAQ Forum: Server Administration » Archive from redo log

Home » RDBMS Server » Server Administration » Archive from redo log (Oracle 10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Archive from redo log [message #392497]

Wed, 18 March 2009 03:58

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,

Report message to a moderator

Re: Archive from redo log [message #392502 is a reply to message #392497]

Wed, 18 March 2009 04:08

babuknb
Messages: 1736
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

Report message to a moderator

Re: Archive from redo log [message #392516 is a reply to message #392502]

Wed, 18 March 2009 04:44

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Archive from redo log [message #392518 is a reply to message #392497]

Wed, 18 March 2009 04:47

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Archive from redo log [message #392528 is a reply to message #392497]

Wed, 18 March 2009 05:11

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,

Report message to a moderator

Re: Archive from redo log [message #392529 is a reply to message #392528]

Wed, 18 March 2009 05:18

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

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

I think it's return correct value.

Report message to a moderator

Re: Archive from redo log [message #392532 is a reply to message #392497]

Wed, 18 March 2009 05:28

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.

Report message to a moderator

Re: Archive from redo log [message #392536 is a reply to message #392532]

Wed, 18 March 2009 05:40

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Build it from rowid.

Regards
Michel

Report message to a moderator

Re: Archive from redo log [message #392540 is a reply to message #392497]

Wed, 18 March 2009 05:45

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,

Report message to a moderator

Re: Archive from redo log [message #392552 is a reply to message #392497]

Wed, 18 March 2009 06:50

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Any updates please,
Thanks,

Report message to a moderator

Re: Archive from redo log [message #392554 is a reply to message #392497]

Wed, 18 March 2009 06:59

cookiemonster
Messages: 13925
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.

Report message to a moderator

Re: Archive from redo log [message #392557 is a reply to message #392497]

Wed, 18 March 2009 07:07

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?

Report message to a moderator

Re: Archive from redo log [message #392570 is a reply to message #392557]

Wed, 18 March 2009 08:02

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>So any other way i can do that?

1/ Advanced Replication
2/ Streams
3/ Data Guard

Report message to a moderator

Previous Topic:	Error 600 encountered while recovering transaction (24, 20)
Next Topic:	arch extension

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 03:25:17 CDT 2024