- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Best practices with Oracle and root access
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
тАО02-10-2006 03:55 AM
тАО02-10-2006 03:55 AM
Re: Best practices with Oracle and root access
That is not the subject of this thread but, the SCN recovery would have only give me 100 minutes of data more (a few material transactions and a dozen of documents) since the corruption happened at 10H40 AM. But I'm considering the SCN (archivelog mode) recovery for other reasons...
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2006 05:21 AM
тАО02-10-2006 05:21 AM
Re: Best practices with Oracle and root access
We would fail SOX if the ORACLE DBA had Root privileges. OR if the Superuser had DBA privileges.
Rory
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2006 05:24 AM
тАО02-10-2006 05:24 AM
Re: Best practices with Oracle and root access
It's a good thing that you spelled out that you weren't interested in opinions!!
;^)
Pete
(N/A, please)
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2006 09:08 PM
тАО02-10-2006 09:08 PM
Re: Best practices with Oracle and root access
with Oracle 10g and ASM/OMF, you don't need any special privileges for the DBA.
DBAs no longer need to manage files and drives individually. Instead, disk groups can be created consisting of disks and their assigned files.
Essentialy, the combination of OMF and ASM eliminates the need for a DBA to specify the file name and location for the physical database files when creating a new database, as well as in other database operations - you simply identify the destination disk group, and oracle takes care of the rest. ASM can also be extended to support other administrative procedurees, including backup/recovery and disk management.
I find the diskgroup concept very interesting such that diskgroup is like a logical volume, like a filesystem but only for database files.
It is said that "ASM is for DBA's for managing database data what Filesystems are for SA's for managing disk"
hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2006 09:11 PM
тАО02-10-2006 09:11 PM
Re: Best practices with Oracle and root access
see also metalink Note:265633.1
Subject: ASM Technical Best Practices
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-13-2006 02:56 AM
тАО02-13-2006 02:56 AM
Re: Best practices with Oracle and root access
http://h21007.www2.hp.com/dspp/files/unprotected/database/HP3KOracle.ppt
Also, thanks for all the answers so far.
Rgds...Geoff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-13-2006 04:25 AM
тАО02-13-2006 04:25 AM
Re: Best practices with Oracle and root access
Why is ASM important? ASM not only empowers the DBA to lower the cost of storage management, but also provides high performance capabilities and utilization.
ASM is a management tool specifically built to simplify the job of the DBA. It provides a simple storage management interface across all server and storage platforms. ASM provides the DBA flexibility to manage a dynamic database environment with increased efficiency. This feature is a key aspect of Grid Computing.
Thanks just the same - as I talked to one of our other DBA's - and they will be going down the ASM road in the near future...
Rgds...Geoff
- « Previous
- Next »