Home » RDBMS Server » Server Administration » User script
User script [message #319318] Fri, 09 May 2008 15:43 Go to next message
Daxesh
Messages: 61
Registered: July 2004
Member
Hello,
Is there a way to find out what type of changes made in the database by particular user? When that change was made.
Any input would be appreciated.
Thanks..

[Updated on: Fri, 09 May 2008 15:49]

Report message to a moderator

Re: User script [message #319320 is a reply to message #319318] Fri, 09 May 2008 15:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use Log Miner to analyze the logs.

Regards
Michel

Report message to a moderator

Re: User script [message #319321 is a reply to message #319318] Fri, 09 May 2008 15:50 Go to previous messageGo to next message
Daxesh
Messages: 61
Registered: July 2004
Member
Can you tell me which log file should I read and where can I find that log file?
Thanks for your reply.. Any help would be appreciate..

Report message to a moderator

Re: User script [message #319322 is a reply to message #319321] Fri, 09 May 2008 15:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Redo logs and archived logs.
v$log view
archive_log_dest% parameters

Regards
Michel

Report message to a moderator

Re: User script [message #319596 is a reply to message #319318] Mon, 12 May 2008 06:07 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Also you can do value-based auditing. This you can achieve by writting triggers and store inofrmation needed to audit in a table.

Regards,

MSMallya

Report message to a moderator

Re: User script [message #319660 is a reply to message #319318] Mon, 12 May 2008 09:00 Go to previous messageGo to next message
Daxesh
Messages: 61
Registered: July 2004
Member
Do you have any script on this and willing to share with me?

Thanks..

Report message to a moderator

Re: User script [message #319667 is a reply to message #319322] Mon, 12 May 2008 09:32 Go to previous messageGo to next message
Daxesh
Messages: 61
Registered: July 2004
Member
Do you have any script to read v$log and archive_log_dest?
Thanks..

Report message to a moderator

Re: User script [message #319677 is a reply to message #319667] Mon, 12 May 2008 10:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Did you make any search after our posts?

Regards
Michel

Report message to a moderator

Re: User script [message #319682 is a reply to message #319318] Mon, 12 May 2008 10:53 Go to previous messageGo to next message
Daxesh
Messages: 61
Registered: July 2004
Member
Yes but I could not find it. That's why I was asking that do you have any script?

Thanks..

Report message to a moderator

Re: User script [message #319684 is a reply to message #319682] Mon, 12 May 2008 10:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Daxesh wrote on Mon, 12 May 2008 08:53
Yes but I could not find it. That's why I was asking that do you have any script?

Thanks..

Are you claiming is that NONE of the Results 1 - 10 of about 307,000 for oracle v$log from GOOGLE answered your question?

How sad!

You can lead some folks to knowledge, but you can not make them think.

Report message to a moderator

Re: User script [message #319688 is a reply to message #319682] Mon, 12 May 2008 11:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Yes but I could not find it.

So I can't help you, you'll have not the skills to understand my answer.

Regards
Michel

Report message to a moderator

Re: User script [message #319864 is a reply to message #319682] Tue, 13 May 2008 04:52 Go to previous messageGo to next message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
Viewing redo logs / archived logs requires using Logminer features.
Visit
http://www.oracle.com/technology/oramag/oracle/05-jul/o45dba.html

As I have already suggested, you can also achieve this by
writting triggers, which will have performance impact.
I hope you have understood what I mean.

Regards,

MSMallya

Report message to a moderator

Re: User script [message #321820 is a reply to message #319318] Wed, 21 May 2008 07:07 Go to previous message
nivedita.sharma
Messages: 1
Registered: March 2008
Junior Member
Daxesh,
U can use logminer to read redo logs and how to use ,for that u have to go through the oracle documentation.
Even i can provide steps here but what u'll do when u face problem next time.
keep this in mind that if u really wanna do database administration than u have to develop a habit of searching solutions on your own.

u can use following link:-
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/logminer.htm#24738

regards

Report message to a moderator

Previous Topic: REDO log status
Next Topic: Migration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 22:27:14 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.