OraFAQ Forum: Server Administration » EXTRACT FROM REDOLOG FILE

Home » RDBMS Server » Server Administration » EXTRACT FROM REDOLOG FILE

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

EXTRACT FROM REDOLOG FILE [message #226921]

Mon, 26 March 2007 23:27

Claud
Messages: 17
Registered: July 2006

Junior Member

I have built an operational Database named "HarODB".
I want to extract ONLY every data that has changed every day (by DML statements) from HarODB Redo log file.
so before i extract the data from redolog file, i MUST shutdown the database and turn to the ARCHIVE LOG MODE!
What is the command to turn HarODB to an archive log mode??
Thanks...

Report message to a moderator

Re: EXTRACT FROM REDOLOG FILE [message #226922 is a reply to message #226921]

Mon, 26 March 2007 23:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>so before i extract the data from redolog file, i MUST shutdown the database and turn to the ARCHIVE LOG MODE!
HUH?
A shovel is a good tool to produce a hole in the ground, but only if the "correct" end of the shovel comes into contract with the Earth.

IMO, you are using the wrong end of the database.

If the DB is not in archive mode all the time, no changes to the DB will have been captured during the day & normal processing.

Report message to a moderator