- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: oracle 9i
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
тАО08-06-2003 07:09 AM
тАО08-06-2003 07:09 AM
oracle 9i
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 07:19 AM
тАО08-06-2003 07:19 AM
Re: oracle 9i
We keep three on different physical disks.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 07:28 AM
тАО08-06-2003 07:28 AM
Re: oracle 9i
Rgds,
JL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 07:31 AM
тАО08-06-2003 07:31 AM
Re: oracle 9i
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 07:40 AM
тАО08-06-2003 07:40 AM
Re: oracle 9i
you can find the information in the init
JL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 07:45 AM
тАО08-06-2003 07:45 AM
Re: oracle 9i
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:496646066771
Rgds,
JL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 07:59 AM
тАО08-06-2003 07:59 AM
Re: oracle 9i
these files are very important.
You must have at least one per database.
You should have them mirrored as already suggested to three diffrent physical disks.
You should save a backup copy beside your backup. Watch it! If the database is up and running, you cannot backup the actual file. You need to execute
"ALTER DATABASE BACKUP CONTROLFILE TO '/somewhere_safe/backup_controlfile';"
and save this file along with your backup. Might be worth to save the usertrace-destination after a
"ALTER DATABASE BACKUP CONTROLFILE TO TRACE;"
as well.
The binary version of this file is the only way to sync the datafiles to their creation SCN. This is important in case you loose a datafile before it has been backed up for the first time.
Take good care of them !
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 09:00 AM
тАО08-06-2003 09:00 AM
Re: oracle 9i
The control file is a critical resource and Oracle requires that you have at least 2. It reads only the primary and writes to all copies to keep them in snyc. Should Oracle become unable to write to the multiplexed copy Oracle has to hang to keep the files in sync. The purpose of multiplexing the control file is not to provide alternate access in the event of a failure but to prevent loss of the control file information, which is critical to recovery operations.
For Oracle to be able to mark a control file as inaccessible and to continue you would have to have at least 3 of them so that a hot backup was always available.
Oracle recommends putting the second copy of the control file with the second copy of the online redo logs works under the theory that one disk is used and this provides a complete backup set for media recovery if the primary set is lost due to media failure. The control file is not updated that frequenty except for checkpoint information since you would not expect that many datafile extentions or additions to take place on an ongoing basis so IO wise having the files together makes sense. It also prevented Oracle OFA from having to specify an additional disk just to hold the second control file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 09:37 AM
тАО08-06-2003 09:37 AM
Re: oracle 9i
No control file is on the same drive as another control file.
Even with mirroring and BCVs we like to keep them in sync. {if you have problems with a recovery match all three control files from a previous backup and roll your archive logs forward. (We keep 100 GB) two days worth of archive logs.
Tim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2003 09:58 AM
тАО08-06-2003 09:58 AM
Re: oracle 9i
to add to above replies:
By storing multiple control files for a single database on different disks, you can safeguard against a single point of failure with respect to control files. If a single disk that contained a control file crashes, then the current instance fails when Oracle attempts to access the damaged control file. However, when other copies of the current control file are available on different disks, an instance can be restarted easily without the need for database recovery.
read: http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96524/c04space.htm
Hope this helps too!
regards
Yogeeraj