Right now doing a project to capture the following on Oralce on data level:
1) What is the type of action :BEFORE / AFTER
2) What is the action: BELETE, INSERT/UPDATE
3) Who did that.
4) When he/she did that.
5) What is the data changed.
6) Is the column has been changed (column type, column length increase/decreased, column added/dropped)
7) Who change the column from 6) ?
someone tell me that log miner can check all them out if we are on archive log mode, right?
If 6 happened, the archive log and log miner still can keep tracking of what was happened, right?
And can we restore any data using this information from log miner so that accidently deleted data can be restore individually?
What is the limit on the archive log mode?
when I tried to verify if archive log mode has bene enabled. I need to do:
archive log list
from SQL developer, I am using 4.0.2.xxx x64 version and the return is:
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 49
Current log sequence 50
So it is not been turned on, right?
To enable it, the oracle server needs to restart, right? What is the command to turn the archive log mode on?
What is the command from SQL developer can I restart that server?
someone talk about CDC in 11g/10g:
, which expect to contain all information above, am I right?
anyone can suggest what is the limit on CDC mode?
I want to the requirement without any programming preferrably.