- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Can you help me,about oracle database
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2002 07:28 PM
тАО04-01-2002 07:28 PM
Can you help me,about oracle database
The database is Oracle 8.0.6 and in Hp-Ux11.0,
I want to know 'who and what time what he did',
Where can find the logfile and find about 'Update,Insert and Delete' information?
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2002 08:04 PM
тАО04-01-2002 08:04 PM
Re: Can you help me,about oracle database
If your database is open to the whole wide world, well, its going to be difficult.
If you have a rough idea of the time the data was changed, you can try to find out who was logged in at the time using 'last'.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2002 08:18 PM
тАО04-01-2002 08:18 PM
Re: Can you help me,about oracle database
Did you know where is the logfile?Oracle has no alertlog?
I can't believe it!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2002 08:27 PM
тАО04-01-2002 08:27 PM
Re: Can you help me,about oracle database
By the way, you may find more people wanting to respond if you did something about your points-allocation history:
---------------------------
gaolu - forum profile
basic information
country:
HONG_KONG
personal quote:
certification:
member since:
February 26, 2002
last contribution date:
April 02, 2002
This member has assigned points to 0 of 12 responses to his/her questions.
------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2002 08:35 PM
тАО04-01-2002 08:35 PM
Re: Can you help me,about oracle database
1. You'll find all the "logfiles" oracle has (if you follow the OFA structure) underneath /oracle1/app/oracle/admin/
To know which file is where, you'll have to take a look in the init.ora file for that SID. That file should be in /oracle1/app/oracle/admin/
2. Probably these files are useless. They will show major changes in the environment, but not inserts, deletes, updates or even table drops.
3. In order to find those things you'll need your archivelog files. To find the location of those, you'll have to look into the init.ora file again (search for "log_archive_dest"). However, there is one small problem. There is no default/free tool to interpret those archivelogs :-(. On top of that you'll still have NO track of table drops.
4. In your case I would try a recovery of a backup of the database (in another location) of a time you are sure the database was still ok. I would then start replaying the archivelogs. This would help you pinpoint the exact time the change occured. However, this is a very intensive job ... :-(. It would help if you know what the "change" was exactly.
Hope this helps,
Tom Geudens
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2002 12:02 AM
тАО04-02-2002 12:02 AM
Re: Can you help me,about oracle database
Oracle infact has a alertlog, but this functions only for the system, so it logs logswitches, stop and start and error messages.
Alertlog is found in $ORACLE_BASE/admin/
To get more info logged you'll have to turn on auditing, but this will inturn generate wast amounts of data.
So I would say that you have no way of checking who did what in your database.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2002 12:23 AM
тАО04-02-2002 12:23 AM
Re: Can you help me,about oracle database
thanks your help!
If I have some I don't know
please tell me !
thanks again
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2002 01:16 AM
тАО04-02-2002 01:16 AM
Re: Can you help me,about oracle database
Just one small point (as Deepak already mentioned). It would help if you assigned points to the answers (giving points according to how much a particular answer helped). You (and only you) can do this for this thread (you have to be logged in to do this). This has several positive effects :
- The people that answer get a "physical" reward for their effort.
- Other people know whether or not a question has been resolved (if you award 8 or more points to an answer, the thread gets a "rabbit" in front of it). This will also help when someone is searching a solution for a similar problem.
- You are more likely to get help if you assign points. I know it should not make a difference, but it does :-)
If you have questions on how this works, let me know !
Regards,
Tom Geudens
P.S. No points (N/A) for this answer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2002 12:53 PM
тАО04-02-2002 12:53 PM
Re: Can you help me,about oracle database
1. You can find out the session connection log to your database in $ORACLE_HOME/network/log/listener.log file. There is a timestamp, username, and host address (IP), etc.
2. You can also use logminer utility provided by Oracle to find out the DML statements againt your database objects.
Hope you can get a little help.