- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: oracle 10g installation on raw file system and...
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-09-2006 10:36 AM
тАО04-09-2006 10:36 AM
Do we need to install control, data and redo logs of Oracle 10g on raw file system ?
How do we take backup of oracle using backup software like Dataprotector because oracle data resides on raw file system ?
I mean how come backup Software like Dataprotector work with raw file system for data or files ?
Thanks,
Shiv
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2006 11:12 AM
тАО04-09-2006 11:12 AM
SolutionFirst question: No. They can be on cooked filesystems.
Second Question: rman and or third party tools like Veritas Netbackup and Data Protector that use rman. Cold OS backups are out of the question on raw.
Third question: Answered by second answer. The third party utils use rman. They can use rman on raw or cooked filesystems.
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
тАО04-09-2006 12:59 PM
тАО04-09-2006 12:59 PM
Re: oracle 10g installation on raw file system and backup
One can backup oracle database (control files, data files redologs) all being on cooked file system or raw devices. It is not necessary that they should be defined on raw devices.
You can use Data protector to perform cold (off-line) hot (on-line) backups for the database on file-systems.
Dataprotector facilitates the configuration and integration of databases like (DB2, Informix, Lotus, MSSQL, MSVSSW, Mailbox, Oracle, SAP, SAPDB, Sybase).
You can use RMAN. Refer to metalink Note:77552.1 to see Configuring Dataprotector with RMAN.
You could also use Dataprotector alone using omnib (man omnib for details) without integration with RMAN, and backup the database (HOT or COLD). You will need to define the backup specification for the database, select the device and media pool and then schedule the backups through a script via cron.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2006 02:26 PM
тАО04-10-2006 02:26 PM
Re: oracle 10g installation on raw file system and backup
I was told by some DBAs that control files, data files, and redologs should be installed on raw file systems for better performance and excellent i/o.
Now i am confused which is best option.
Regards,
Shiv
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2006 02:35 PM
тАО04-10-2006 02:35 PM
Re: oracle 10g installation on raw file system and backup
2) Backups are very important. With raw i/o you really have two options 1) dd 2) rman.
3) Performance isn't necessarily worse with cooked files. It's certainly acceptable.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2006 03:49 PM
тАО04-10-2006 03:49 PM
Re: oracle 10g installation on raw file system and backup
The earlier question was about Oracle database backup "datafiles on raw devices" when using Dataprotector.
It was suggested that one can backup oracle database (control files, data files redologs) all being on cooked file system or raw devices. It is not necessary that they should be defined on raw devices.
Now we are talking about performance.......
Well as A. Clay mentioned, performance is good at the same time reliability is an necessary element. No matter how fast the database executes queries, if one cannot have a good backup and restore tool and procedures, then we end up in problems.
You can use raw devices but the backup option will be limited, Unless it is required (eg:- Parallel Processing) you can have the datafiles, redologs, control files on a cooked file system.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2006 03:56 PM
тАО04-10-2006 03:56 PM
Re: oracle 10g installation on raw file system and backup
Refer to Note:148462.1 in metalink "CHECKLIST-What else can influence the Performance of the Database" for details of what Other Factors Can Influence Database performance. This document lists several situations outside the database not commonly took in consideration when a database performance problem surfaces.
Also refer to the Note 37914.1 in metalink "Raw Devices and Oracle - 20 Common Questions and Answers" and Note 23037.1 "Using Unix Raw Partitions as Oracle Data File"
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2006 06:36 PM
тАО04-10-2006 06:36 PM
Re: oracle 10g installation on raw file system and backup
In the event you are using the online jfs then by setting mincache=direct you could bypass the system buffers and here too you gain performance on cooked file systems.
rgds
Faizer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2006 06:38 PM
тАО04-10-2006 06:38 PM
Re: oracle 10g installation on raw file system and backup
We are using veritas netbackup to backup oracle 9i RAC raw volumes.In raw volume backups,you have to backup entire volume regardless of data size.
If you use oracle RMAN,the size of backup will be related to data size regardless of size of raw volumes/
-sysadm-
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2006 06:40 PM
тАО04-10-2006 06:40 PM
Re: oracle 10g installation on raw file system and backup
In the event you are using the online jfs then by setting mincache=direct you could bypass the system buffers and here too you gain performance on cooked file systems.
Cold backups could not be done on raw file systems.
Dataprotector/Veritas could be used for backups of Oracle systems online [ on raw or cooked file systems] as rman is the undeline[primary] utilty that is being used for the backup purposes.
rgds
Faizer