RE: Oracle9i RMAN Backup and Recovery
Thanks Jared! RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 8:13 PM To: Multiple recipients of list ORACLE-L Looks very enticing Robert, can't wait to see it. Jared Freeman, Robert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/10/2002 07:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle9i RMAN Backup and Recovery Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 9:28 AM To: Multiple recipients of list ORACLE-L We are in the midst of a big move to RMAN. We use EMC's EDM to do backups, and the SAs have been pushing us towards RMAN for a while now, cause the EDM interface intergrates w/ RMAN seamlessly. It really is a nice backup solution. (We started the process by upgrading all our EDM units to 5.0) Anyhow, we are setting up the RMAN catalog databases ringht on the EDM boxes. (The EDMs are Solaris boxes.) It's working well. We haven't yet fully rolled out, but all our testing has worked fine. We're about to start the production database migration next week. -Mark On Thu, 2002-10-10 at 06:23, Connor McDonald wrote: There is a Metalink note (73431.1) which talks about the rman version compatibility, but it also states: Ensure that the RMAN executable version matches the version of the target database that it is backing up which I presume to mean that you need to run rman from each target and push to the catalog storage management node(s). This is how I've always seen it done - but I've often wondered if one could get away driving eveything from the catalog node, pulling client databases over sqlnet - thus only having a single TSM client (and license) on the rman catalog node. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: I'm trying to use RMAN and TSM to backup multiple databases spread across various nodes with some nodes hosting more than one database. The RMAN catalog database will reside on a node different from any of the nodes hosting the other databases. I have long used ADSM without the RMAN clothing to backup the databases. I have convinced the SA's to move on to TSM, and now I need to add the RMAN adornments. I assume I need the SA's to install TDP for Oracle on all the nodes requiring RMAN backup. Do I also need to install it on the machine which will host the catalog database. That database will undergo cold backup using naked TSM. The same question applies to the tdpo.opt file. Do I need multiple TDPO_FS values and multiple tdpo.opt files to hold them. I am also assuming I will start RMAN from one of the databases requiring backup and connect also to the RMAN catalog. Is this typical. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ 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 -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
RE: Oracle9i RMAN Backup and Recovery
Congratulations, Robert!! Looking forward to receiving my copy... - Kirti -Original Message- Sent: Thursday, October 10, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 9:28 AM To: Multiple recipients of list ORACLE-L We are in the midst of a big move to RMAN. We use EMC's EDM to do backups, and the SAs have been pushing us towards RMAN for a while now, cause the EDM interface intergrates w/ RMAN seamlessly. It really is a nice backup solution. (We started the process by upgrading all our EDM units to 5.0) Anyhow, we are setting up the RMAN catalog databases ringht on the EDM boxes. (The EDMs are Solaris boxes.) It's working well. We haven't yet fully rolled out, but all our testing has worked fine. We're about to start the production database migration next week. -Mark On Thu, 2002-10-10 at 06:23, Connor McDonald wrote: There is a Metalink note (73431.1) which talks about the rman version compatibility, but it also states: Ensure that the RMAN executable version matches the version of the target database that it is backing up which I presume to mean that you need to run rman from each target and push to the catalog storage management node(s). This is how I've always seen it done - but I've often wondered if one could get away driving eveything from the catalog node, pulling client databases over sqlnet - thus only having a single TSM client (and license) on the rman catalog node. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: I'm trying to use RMAN and TSM to backup multiple databases spread across various nodes with some nodes hosting more than one database. The RMAN catalog database will reside on a node different from any of the nodes hosting the other databases. I have long used ADSM without the RMAN clothing to backup the databases. I have convinced the SA's to move on to TSM, and now I need to add the RMAN adornments. I assume I need the SA's to install TDP for Oracle on all the nodes requiring RMAN backup. Do I also need to install it on the machine which will host the catalog database. That database will undergo cold backup using naked TSM. The same question applies to the tdpo.opt file. Do I need multiple TDPO_FS values and multiple tdpo.opt files to hold them. I am also assuming I will start RMAN from one of the databases requiring backup and connect also to the RMAN catalog. Is this typical. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ 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 -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: Oracle9i RMAN Backup and Recovery
I hope it meets everyone's expectations. We worked like dogs to get this one done by OOW. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Congratulations, Robert!! Looking forward to receiving my copy... - Kirti -Original Message- Sent: Thursday, October 10, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 9:28 AM To: Multiple recipients of list ORACLE-L We are in the midst of a big move to RMAN. We use EMC's EDM to do backups, and the SAs have been pushing us towards RMAN for a while now, cause the EDM interface intergrates w/ RMAN seamlessly. It really is a nice backup solution. (We started the process by upgrading all our EDM units to 5.0) Anyhow, we are setting up the RMAN catalog databases ringht on the EDM boxes. (The EDMs are Solaris boxes.) It's working well. We haven't yet fully rolled out, but all our testing has worked fine. We're about to start the production database migration next week. -Mark On Thu, 2002-10-10 at 06:23, Connor McDonald wrote: There is a Metalink note (73431.1) which talks about the rman version compatibility, but it also states: Ensure that the RMAN executable version matches the version of the target database that it is backing up which I presume to mean that you need to run rman from each target and push to the catalog storage management node(s). This is how I've always seen it done - but I've often wondered if one could get away driving eveything from the catalog node, pulling client databases over sqlnet - thus only having a single TSM client (and license) on the rman catalog node. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: I'm trying to use RMAN and TSM to backup multiple databases spread across various nodes with some nodes hosting more than one database. The RMAN catalog database will reside on a node different from any of the nodes hosting the other databases. I have long used ADSM without the RMAN clothing to backup the databases. I have convinced the SA's to move on to TSM, and now I need to add the RMAN adornments. I assume I need the SA's to install TDP for Oracle on all the nodes requiring RMAN backup. Do I also need to install it on the machine which will host the catalog database. That database will undergo cold backup using naked TSM. The same question applies to the tdpo.opt file. Do I need multiple TDPO_FS values and multiple tdpo.opt files to hold them. I am also assuming I will start RMAN from one of the databases requiring backup and connect also to the RMAN catalog. Is this typical. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ 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 -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San
Re: Oracle9i RMAN Backup and Recovery
Looks very enticing Robert, can't wait to see it. Jared Freeman, Robert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/10/2002 07:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle9i RMAN Backup and Recovery Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 9:28 AM To: Multiple recipients of list ORACLE-L We are in the midst of a big move to RMAN. We use EMC's EDM to do backups, and the SAs have been pushing us towards RMAN for a while now, cause the EDM interface intergrates w/ RMAN seamlessly. It really is a nice backup solution. (We started the process by upgrading all our EDM units to 5.0) Anyhow, we are setting up the RMAN catalog databases ringht on the EDM boxes. (The EDMs are Solaris boxes.) It's working well. We haven't yet fully rolled out, but all our testing has worked fine. We're about to start the production database migration next week. -Mark On Thu, 2002-10-10 at 06:23, Connor McDonald wrote: There is a Metalink note (73431.1) which talks about the rman version compatibility, but it also states: Ensure that the RMAN executable version matches the version of the target database that it is backing up which I presume to mean that you need to run rman from each target and push to the catalog storage management node(s). This is how I've always seen it done - but I've often wondered if one could get away driving eveything from the catalog node, pulling client databases over sqlnet - thus only having a single TSM client (and license) on the rman catalog node. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: I'm trying to use RMAN and TSM to backup multiple databases spread across various nodes with some nodes hosting more than one database. The RMAN catalog database will reside on a node different from any of the nodes hosting the other databases. I have long used ADSM without the RMAN clothing to backup the databases. I have convinced the SA's to move on to TSM, and now I need to add the RMAN adornments. I assume I need the SA's to install TDP for Oracle on all the nodes requiring RMAN backup. Do I also need to install it on the machine which will host the catalog database. That database will undergo cold backup using naked TSM. The same question applies to the tdpo.opt file. Do I need multiple TDPO_FS values and multiple tdpo.opt files to hold them. I am also assuming I will start RMAN from one of the databases requiring backup and connect also to the RMAN catalog. Is this typical. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ 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 -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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