Home » RDBMS Server » Server Administration » EXTRACT FROM REDOLOG FILE
icon5.gif  EXTRACT FROM REDOLOG FILE [message #226921] Mon, 26 March 2007 23:27 Go to next message
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...
Re: EXTRACT FROM REDOLOG FILE [message #226922 is a reply to message #226921] Mon, 26 March 2007 23:34 Go to previous messageGo to next message
BlackSwan
Messages: 25035
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.
icon5.gif  Re: EXTRACT FROM ONLINE REDOLOG FILE [message #228104 is a reply to message #226922] Sat, 31 March 2007 13:37 Go to previous messageGo to next message
Claud
Messages: 17
Registered: July 2006
Junior Member
How to Extract data From the Online Redolog File??
Re: EXTRACT FROM REDOLOG FILE [message #228118 is a reply to message #226921] Sat, 31 March 2007 21:53 Go to previous message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14220/utility.htm#i10918
Previous Topic: how to remove a entire schema
Next Topic: problem in tablespace
Goto Forum:
  


Current Time: Sat Dec 03 20:16:26 CST 2016

Total time taken to generate the page: 0.20755 seconds