Re: Oracle Parallel Server
You will need to put tablespace in backup mode and use "dd" to copy the appropriate raw device. Note that you can't write a dynamic hotbackup script for raw disk - your script will need to be modified whenever you added a datafile. HTH Regards, -Jalil [EMAIL PROTECTED] wrote: What is the best way to implement a HOT BACKUP on an Oracle Parallel Server which is using RAW disks.Please describe the process if possible.I know it has to be RMAN and some MML--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author:INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience
Re: Oracle Parallel Server
OK you can do DD ,but , can you use compression along with DD.What if you have allocated 40-50GB to the database,but in actual only 20GB is used.RMAN can do that.i am not too sure would DD be able to do it. Manpreet You will need to put tablespace in backup mode and use dd to copy the appropriate raw device. Note that you can't write a dynamic hotbackup script for raw disk - your script will need to be modified whenever you added a datafile. HTH Regards, -Jalil [EMAIL PROTECTED] wrote: What is the best way to implement a HOT BACKUP on an Oracle Parallel Server which is using RAW disks.Please describe the process if possible.I know it has to be RMAN and some MML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). - Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Parallel Server
Thisanswer (i.e. "can't write a dynamic hotbackup script for raw disk") is untrue. You would just use the same techniques (i.e. query the data dictionary to generate a shell script) as you would with any other type of datafile... Also, you do not need to "put tablespaces into backup mode and use 'dd'" if you are using RMAN, OPS or not.RMAN wasthe right idea to start with -- directing toward user-managed backups is a *big* step backward. The MML (media-manager layer)choices varywith the platform. Each platform (i.e. HPUX, AIX, Solaris, Tru64, NT/2000, etc) presents different choices for MML (i.e. Omniback, ADSM, Veritas, Legato, etc). There are several good bulletins on MetaLink (search keywords like "RMAN MML", for example) as well as excellent documentation in the standard docset (search http://docs.oracle.com). Also, the Oracle Press book "Oracle Backup Recovery 101" is excellent and the O'Reilly book "RMAN Pocket Reference" will be useful during implementation... - Original Message - From: Jalil Zabourdine To: Multiple recipients of list ORACLE-L Sent: Friday, May 24, 2002 5:23 AM Subject: Re: Oracle Parallel Server You will need to put tablespace in backup mode and use "dd" to copy the appropriate raw device. Note that you can't write a dynamic hotbackup script for raw disk - your script will need to be modified whenever you added a datafile. HTH Regards, -Jalil [EMAIL PROTECTED] wrote: What is the best way to implement a HOT BACKUP on an Oracle Parallel Server which is using RAW disks.Please describe the process if possible.I know it has to be RMAN and some MML--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author:INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do You Yahoo!?LAUNCH - Your Yahoo! Music Experience
Re: Oracle Parallel Server
Manpreet, raw disk is sliced as physical disk so that you can not compress. Do not get confused between DD and RMAN because DD is an OS utility andRMAN is an oracle utility they are totally different. Regards, Jalil [EMAIL PROTECTED] wrote: OK you can do DD ,but , can you use compression along with DD.What if you have allocated 40-50GB to the database,but in actual only 20GB is used.RMAN can do that.i am not too sure would DD be able to do it.Manpreet You will need to put tablespace in backup mode and use "dd" to copy the appropriate raw device. Note that you can't write a dynamic hotbackup script for raw disk - your script will need to be modified whenever you added a datafile. HTH Regards, -Jalil [EMAIL PROTECTED] wrote: What is the best way to implement a HOT BACKUP on an Oracle Parallel Server which is using RAW disks.Please describe the process if possible.I know it has to be RMAN and some MML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City ! ! Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). - Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author:INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists! ! To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience
Re: Oracle Parallel Server
The nature of symbolic links in UNIX is that they are aliases for files. That's all. Why should it make a difference? Before you respond again, please try it out first... - Original Message - From: Jalil Zabourdine To: Multiple recipients of list ORACLE-L Sent: Friday, May 24, 2002 8:48 AM Subject: Re: Oracle Parallel Server ## (i.e. "can't write a dynamic hotbackup script for raw disk") is untrue. Ok but in the case when datafile uses symbolic link point to raw device then how this could work? -Jalil Tim Gorman [EMAIL PROTECTED] wrote: Thisanswer (i.e. "can't write a dynamic hotbackup script for raw disk") is untrue. You would just use the same techniques (i.e. query the data dictionary to generate a shell script) as you would with any other type of datafile... Also, you do not need to "put tablespaces into backup mode and use 'dd'" if you are using RMAN, OPS or not.RMAN wasthe right idea to start with -- directing toward user-managed backups is a *big* step backward. The MML (media-manager layer)choices varywith the platform. Each platform (i.e. HPUX, AIX, Solaris, Tru64, NT/2000, etc) presents different choices for MML (i.e. Omniback, ADSM, Veritas, Legato, etc). There are several good bulletins on MetaLink (search keywords like "RMAN MML", for example) as well as excellent documentation in the standard docset (search http://docs.oracle.com). Also, the Oracle Press book "Oracle Backup Recovery 101" is excellent and the O'Reilly book "RMAN Pocket Reference" will be useful during implementation... - Original Message - From: Jalil Zabourdine To: Multiple recipients of list ORACLE-L Sent: Friday, May 24, 2002 5:23 AM Subject: Re: Oracle Parallel Server You will need to put tablespace in backup mode and use "dd" to copy the appropriate raw device. Note that you can't write a dynamic hotbackup script for raw disk - your script will need to be modified whenever you added a datafile. HTH Regards, -Jalil [EMAIL PROTECTED] wrote: What is the best way to implement a HOT BACKUP on an Oracle Parallel Server which is using RAW disks.Please describe the process if possible.I know it has to be RMAN and some MML--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author:INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do You Yahoo!?LAUNCH - Your Yahoo! Music Experience Do You Yahoo!?LAUNCH - Your Yahoo! Music Experience
Re: Oracle Parallel Server
## (i.e. "can't write a dynamic hotbackup script for raw disk") is untrue. Ok but in the case when datafile uses symbolic link point to raw device then how this could work? -Jalil Tim Gorman [EMAIL PROTECTED] wrote: Thisanswer (i.e. "can't write a dynamic hotbackup script for raw disk") is untrue. You would just use the same techniques (i.e. query the data dictionary to generate a shell script) as you would with any other type of datafile... Also, you do not need to "put tablespaces into backup mode and use 'dd'" if you are using RMAN, OPS or not.RMAN wasthe right idea to start with -- directing toward user-managed backups is a *big* step backward. The MML (media-manager layer)choices varywith the platform. Each platform (i.e. HPUX, AIX, Solaris, Tru64, NT/2000, etc) presents different choices for MML (i.e. Omniback, ADSM, Veritas, Legato, etc). There are several good bulletins on MetaLink (search keywords like "RMAN MML", for example) as well as excellent documentation in the standard docset (search http://docs.oracle.com). Also, the Oracle Press book "Oracle Backup Recovery 101" is excellent and the O'Reilly book "RMAN Pocket Reference" will be useful during implementation... - Original Message - From: Jalil Zabourdine To: Multiple recipients of list ORACLE-L Sent: Friday, May 24, 2002 5:23 AM Subject: Re: Oracle Parallel Server You will need to put tablespace in backup mode and use "dd" to copy the appropriate raw device. Note that you can't write a dynamic hotbackup script for raw disk - your script will need to be modified whenever you added a datafile. HTH Regards, -Jalil [EMAIL PROTECTED] wrote: What is the best way to implement a HOT BACKUP on an Oracle Parallel Server which is using RAW disks.Please describe the process if possible.I know it has to be RMAN and some MML--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author:INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do You Yahoo!?LAUNCH - Your Yahoo! Music ExperienceDo You Yahoo!? LAUNCH - Your Yahoo! Music Experience
Re: Oracle Parallel Server
Try "dd if=/dev/rdsk/x | compress -c /dev/rmt/0" or something like that if you want to compress your backups of "raw" devices using the standard UNIX "dd" utility. However, Oracle Support has always been leery about the use of "compress" for backups, with regards to possible corruption of the contents. Scan MetaLink for discussions on this... Most tape subsystems support hardware-based compression, so the issue of whether compression is possible using "raw" or "cooked" devices as input is quite irrelevant, for most configurations. The topic of this email thread seems to have veered into confusion over the difference between "compression" and "block-level incremental backups", so I'll just bail out now... - Original Message - From: Jalil Zabourdine To: Multiple recipients of list ORACLE-L Sent: Friday, May 24, 2002 8:18 AM Subject: Re: Oracle Parallel Server Manpreet, raw disk is sliced as physical disk so that you can not compress. Do not get confused between DD and RMAN because DD is an OS utility andRMAN is an oracle utility they are totally different. Regards, Jalil [EMAIL PROTECTED] wrote: OK you can do DD ,but , can you use compression along with DD.What if you have allocated 40-50GB to the database,but in actual only 20GB is used.RMAN can do that.i am not too sure would DD be able to do it.Manpreet You will need to put tablespace in backup mode and use "dd" to copy the appropriate raw device. Note that you can't write a dynamic hotbackup script for raw disk - your script will need to be modified whenever you added a datafile. HTH Regards, -Jalil [EMAIL PROTECTED] wrote: What is the best way to implement a HOT BACKUP on an Oracle Parallel Server which is using RAW disks.Please describe the process if possible.I know it has to be RMAN and some MML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City ! ! Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). - Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author:INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists! ! To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do You Yahoo!?LAUNCH - Your Yahoo! Music Experience
RE: Oracle Parallel Server
I agree with Tim. Start by learning RMAN. If you use RMAN, then the issues of OPS and raw disks go away. RMAN uses its own backup methods. You can learn RMAN by backing up to disk, then research whether you need an MML. RMAN is so superior for this type of backup that you should not consider creating your own backup using dd or whatever. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, May 24, 2002 5:24 AM To: Multiple recipients of list ORACLE-L What is the best way to implement a HOT BACKUP on an Oracle Parallel Server which is using RAW disks.Please describe the process if possible.I know it has to be RMAN and some MML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle parallel server
The Oracle parallel server (or RAC in 9i) manuals a good source of info. hth connor --- Sathish Tatikonda [EMAIL PROTECTED] wrote: Hi all, Have you implemented or worked with oracle parallel server. If yes could you please point or me some resources about application planning and partitioning. thanks in advance, Sathish. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sathish Tatikonda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle parallel server
hi all, we are using oracle 8i as our database server. So we have to user OPS and not RAC version which comes with 9i. So in light of the above could you please give me any pointers for application planning and data partitioning. I have some documents on OPS which says this is the most important aspect of implementation. thanks in advance, Sathish. -Original Message- Sent: Thursday, February 14, 2002 6:48 PM To: Multiple recipients of list ORACLE-L Sathish, Under Oracle's RAC in 9i you don't need to do any of this. Dick Goulet Reply Separator Author: Sathish Tatikonda [EMAIL PROTECTED] Date: 2/14/2002 12:33 AM Hi all, Have you implemented or worked with oracle parallel server. If yes could you please point or me some resources about application planning and partitioning. thanks in advance, Sathish. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sathish Tatikonda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sathish Tatikonda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).