Do you use RMAN?
Hi, I'm in the process of upgrading my database to 9i and I was trying to decide whether I wanted to change my backup strategy to use RMAN. Do most of you use it? If you use it, what is your opinion of it? If you don't use it, why did you decide not to? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF 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 use RMAN?
Bill ; I am just in the process of implementing RMAN at our shop. We decided to go with RMAN for the following reasons : * Reason1 RMAN manages what backups are required to perform the restore and where the backup are located (will get the files off tape). * Reason 2 The ability to perform HOT backups without the "ALTER TABLESPACE ..BEGIN/END" commands. This will reduce the amount of REDO that is generated during the backup. IE: You get HOT backups with out the adverse impact of the volume of redo. Since a datafile does not have to be placed in backup mode - there is no risk of the database going down during a hot backup and asking for media recovery. * Reason 3 The ability to only backup "used" Oracle blocks. This greatly reduces the amount of data that needs to be backed up. BACKUP SETS - Will only copy database blocks containing data. This saves on IO by not copying empty blocks. * Reason 4 The ability to detect database block corruption. Because RMAN uses Server Processes to perform its backup reads - it will raise the same error a SQL statement will raise upon detection of something amiss inside a database block. * Reason 5 The ability to perform incremental backups and restores. This greatly reduces the amount of data that needs to be backed up (block level backups). LEVEL 0 - Will copy all database blocks containing data (FULL). This saves on IO by not copying empty blocks. LEVEL 1 - Will copy database blocks that have changed since the most recent level0 bkup. This further reduces IO. LEVEL 2 - Will copy database blocks that have changed since the most recent level1 bkup. This further reduces IO. * Reason 6 A Enterprise Centralized Backup and Recovery solution. _ Patrick J. Howe Oracle DBA Illuminet Inc. (Carrier Division of Verisign) 4501 Intelco Loop SE Olympia, WA 98507 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Howe 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 use Rman
If your company is using Rman right now, please send me a private email and let me know. I'd like to know your company name and number of databases that you backup with Rman. I would be most thankful as I will be using this information to demonstrate the viability of an Rman book to Oracle Press. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Do you use RMAN?
Do you have tape software such as Legato or NetBackup? I have used it very successfully with both - makes backup and recovery a breeze. -Joe --- "Carle, William T (Bill), ALINF" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm in the process of upgrading my database to 9i and I was > trying to decide whether I wanted to change my backup strategy to > use RMAN. Do most of you use it? If you use it, what is your > opinion of it? If you don't use it, why did you decide not to? > > > Bill Carle > AT&T > Database Administrator > 816-995-3922 > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Carle, William T (Bill), ALINF > 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!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Do you use RMAN?
hmmm, the question of the day, a good one! I don't use it now but plan on using it. The question is when :) >>> [EMAIL PROTECTED] 03/06/02 10:48AM >>> Hi, I'm in the process of upgrading my database to 9i and I was trying to decide whether I wanted to change my backup strategy to use RMAN. Do most of you use it? If you use it, what is your opinion of it? If you don't use it, why did you decide not to? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF 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: Gene Sais 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: Do you use RMAN?
I use it, I think it's great. Runs faster (if you multi-thread it), doesn't put the tablespaces in hotbackup mode (doesn't freeze file header blocks), and checks for corruption. Tim Gorman has a good paper on his website (http://www.evdbt.com/) : http://www.evdbt.com/TD_Rman.pdf - Jerry -Original Message- Sent: Wednesday, March 06, 2002 10:48 AM To: Multiple recipients of list ORACLE-L Hi, I'm in the process of upgrading my database to 9i and I was trying to decide whether I wanted to change my backup strategy to use RMAN. Do most of you use it? If you use it, what is your opinion of it? If you don't use it, why did you decide not to? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF 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: Cunningham, Gerald 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: Do you use RMAN?
I use RMAN with veritas Netbackup and it is sweet. Recovery is ridiculously easy: Even recovering to an alternative host (not as fast as cloning) is a doddle and u can apply redo logs to the recovery to bring it up to current time: All in all well worth the learning curve to set up - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 06, 2002 9:03 PM hmmm, the question of the day, a good one! I don't use it now but plan on using it. The question is when :) >>> [EMAIL PROTECTED] 03/06/02 10:48AM >>> Hi, I'm in the process of upgrading my database to 9i and I was trying to decide whether I wanted to change my backup strategy to use RMAN. Do most of you use it? If you use it, what is your opinion of it? If you don't use it, why did you decide not to? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF 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: Gene Sais 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: Sam Roberts 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: Do you use RMAN?
I use it with 8i. We backup to disk. What I like: - Backups are faster. - Backup files are smaller. - "Duplicating" a test database from production is a breeze. What I don't like: - I find the report and list commands cumbersome. There have been numerous times that I needed to go into the repository and use SQL statements to find the information that I needed. - It is easy to corrupt your catalog when duplicating a database (try resyncing the duplicated database with your production catalog instead of registering). Make sure you have separate catalogs for production and test databases. It has been argued on this list that you should have a catalog for each database. - Can't duplicate a database using a specific cold backup without specifying "SET UNTIL...". This causes RMAN to look for the next redo log after the specified time or scn. Which means that after your cold backup, you need to do a log switch, then backup that redo log. RMAN isn't smart enough to know that it doesn't really need this post-cold-backup redo log. If somebody has a better way of doing this, I'd like to hear it. - I don't completely trust tools that "think" for me. DBAs who grow up on RMAN will have no idea what to do with database files that have been backed up the old fashioned way (alter tablespace x begin backup, cp file01.dbf file01_backup.dbf, alter tablespace x end backup). Understanding what RMAN is doing in the background is helpful. Overall, I give it an 8 out of 10. Jay >>> [EMAIL PROTECTED] 03/06/02 10:48AM >>> Hi, I'm in the process of upgrading my database to 9i and I was trying to decide whether I wanted to change my backup strategy to use RMAN. Do most of you use it? If you use it, what is your opinion of it? If you don't use it, why did you decide not to? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF 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: Jay Hostetter 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: Do you use RMAN?
Bill - I'll take the contrarian stand, just so you see the "cons" as well as the "pros". I notice you say "my database" as in singular. If you truly are responsible for a single database, I would argue that RMAN may be more than you want to bite off. Most of us DBAs are paid as professional skeptics, so I'll ask you "what is wrong with your current backup methods?". I have worked with RMAN a little, and keep getting drawn away to production support, but I find it is difficult to work learn and hard to get up and going. On the other hand, everyone says that recovery is really nifty, assuming you have all the files RMAN needs. On the other hand, if you are planning to take the OCP exam for backup and recovery, then you should definitely start using RMAN, because I hear it is most of the exam. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 06, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Hi, I'm in the process of upgrading my database to 9i and I was trying to decide whether I wanted to change my backup strategy to use RMAN. Do most of you use it? If you use it, what is your opinion of it? If you don't use it, why did you decide not to? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF 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: Do you use RMAN?
Pat & others, For your information something that I hope is helpful. To add a point we discovered the hard way - RMAN doesn't so much backup blocks containing data but rather it backs up blocks that have ever contained data. To quote from Metalink note 105208.1: "RMAN will not back up NEVER USED blocks, but will back up blocks that were used once, even if they are not in use now." This can be a problem if you're not using uniform extent sizes and you temporarily get (say) large indexes. In our case we worked around this at the time by rebuilding indexes to a new tablespace, resizing the original tablespace to a smaller value and then moving them back. Our longer term "fix" has been to move to LMTs with uniform extent sizes. Regards, Bruce Reardon -Original Message- Sent: Friday, 8 March 2002 9:32 Bill ; I am just in the process of implementing RMAN at our shop. We decided to go with RMAN for the following reasons : * Reason1 RMAN manages what backups are required to perform the restore and where the backup are located (will get the files off tape). * Reason 2 The ability to perform HOT backups without the "ALTER TABLESPACE ..BEGIN/END" commands. This will reduce the amount of REDO that is generated during the backup. IE: You get HOT backups with out the adverse impact of the volume of redo. Since a datafile does not have to be placed in backup mode - there is no risk of the database going down during a hot backup and asking for media recovery. * Reason 3 The ability to only backup "used" Oracle blocks. This greatly reduces the amount of data that needs to be backed up. BACKUP SETS - Will only copy database blocks containing data. This saves on IO by not copying empty blocks. * Reason 4 The ability to detect database block corruption. Because RMAN uses Server Processes to perform its backup reads - it will raise the same error a SQL statement will raise upon detection of something amiss inside a database block. * Reason 5 The ability to perform incremental backups and restores. This greatly reduces the amount of data that needs to be backed up (block level backups). LEVEL 0 - Will copy all database blocks containing data (FULL). This saves on IO by not copying empty blocks. LEVEL 1 - Will copy database blocks that have changed since the most recent level0 bkup. This further reduces IO. LEVEL 2 - Will copy database blocks that have changed since the most recent level1 bkup. This further reduces IO. * Reason 6 A Enterprise Centralized Backup and Recovery solution. _ Patrick J. Howe Oracle DBA Illuminet Inc. (Carrier Division of Verisign) 4501 Intelco Loop SE Olympia, WA 98507 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Do you use RMAN?
New Rman features in 9i make it even nicer... Recover specific blocks, while the database and the datafile is still available. Automatic channel allocation. retention policies. restartable backups and restores. backing up database and archivelog files in one operation run command isn't needed in most places anymore... Also Rman is FREE, unlike some of the other backup/recovery tools out there... :-) I do know that one major software supplier of backup and recovery tools is reworking their product so that it's just a front end to Rman RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 11:28 PM To: Multiple recipients of list ORACLE-L Pat & others, For your information something that I hope is helpful. To add a point we discovered the hard way - RMAN doesn't so much backup blocks containing data but rather it backs up blocks that have ever contained data. To quote from Metalink note 105208.1: "RMAN will not back up NEVER USED blocks, but will back up blocks that were used once, even if they are not in use now." This can be a problem if you're not using uniform extent sizes and you temporarily get (say) large indexes. In our case we worked around this at the time by rebuilding indexes to a new tablespace, resizing the original tablespace to a smaller value and then moving them back. Our longer term "fix" has been to move to LMTs with uniform extent sizes. Regards, Bruce Reardon -Original Message- Sent: Friday, 8 March 2002 9:32 Bill ; I am just in the process of implementing RMAN at our shop. We decided to go with RMAN for the following reasons : * Reason1 RMAN manages what backups are required to perform the restore and where the backup are located (will get the files off tape). * Reason 2 The ability to perform HOT backups without the "ALTER TABLESPACE ..BEGIN/END" commands. This will reduce the amount of REDO that is generated during the backup. IE: You get HOT backups with out the adverse impact of the volume of redo. Since a datafile does not have to be placed in backup mode - there is no risk of the database going down during a hot backup and asking for media recovery. * Reason 3 The ability to only backup "used" Oracle blocks. This greatly reduces the amount of data that needs to be backed up. BACKUP SETS - Will only copy database blocks containing data. This saves on IO by not copying empty blocks. * Reason 4 The ability to detect database block corruption. Because RMAN uses Server Processes to perform its backup reads - it will raise the same error a SQL statement will raise upon detection of something amiss inside a database block. * Reason 5 The ability to perform incremental backups and restores. This greatly reduces the amount of data that needs to be backed up (block level backups). LEVEL 0 - Will copy all database blocks containing data (FULL). This saves on IO by not copying empty blocks. LEVEL 1 - Will copy database blocks that have changed since the most recent level0 bkup. This further reduces IO. LEVEL 2 - Will copy database blocks that have changed since the most recent level1 bkup. This further reduces IO. * Reason 6 A Enterprise Centralized Backup and Recovery solution. _ Patrick J. Howe Oracle DBA Illuminet Inc. (Carrier Division of Verisign) 4501 Intelco Loop SE Olympia, WA 98507 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Freeman, Robert 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: Do you use RMAN?
Rob, Can one use 9i RMAN to backup lower version databases (8.0.x, 8.1.x)? What new functionality will be supported in doing so? We do not use RMAN at the moment, but we may consider it in the near future. Thanks. - Kirti -Original Message- Sent: Tuesday, March 12, 2002 3:28 PM To: Multiple recipients of list ORACLE-L New Rman features in 9i make it even nicer... Recover specific blocks, while the database and the datafile is still available. Automatic channel allocation. retention policies. restartable backups and restores. backing up database and archivelog files in one operation run command isn't needed in most places anymore... Also Rman is FREE, unlike some of the other backup/recovery tools out there... :-) I do know that one major software supplier of backup and recovery tools is reworking their product so that it's just a front end to Rman RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Do you use RMAN?
Rman is backwards compatible, but to be honest I have not tried the new features on 8i databases, so I can't tell you for sure that they work in that way. My guess is that they probably do, but don't hold me to that. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Wednesday, March 13, 2002 10:08 AM To: Multiple recipients of list ORACLE-L Rob, Can one use 9i RMAN to backup lower version databases (8.0.x, 8.1.x)? What new functionality will be supported in doing so? We do not use RMAN at the moment, but we may consider it in the near future. Thanks. - Kirti -Original Message- Sent: Tuesday, March 12, 2002 3:28 PM To: Multiple recipients of list ORACLE-L New Rman features in 9i make it even nicer... Recover specific blocks, while the database and the datafile is still available. Automatic channel allocation. retention policies. restartable backups and restores. backing up database and archivelog files in one operation run command isn't needed in most places anymore... Also Rman is FREE, unlike some of the other backup/recovery tools out there... :-) I do know that one major software supplier of backup and recovery tools is reworking their product so that it's just a front end to Rman RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Freeman, Robert 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: RE: Do you use RMAN?
But if using a backup catalog, doesn't the catalog have to be the same exact version of the database being backed up? That is, RMAN 9i may be used to do the backups as long as it writes to an appropriately versioned catalog. Is my thinking correct? Jim "Freeman, Robert " <[EMAIL PROTECTED]> wrote: >Rman is backwards compatible, but to be honest I have not tried the new >features on 8i databases, so I can't tell you for sure that they work >in that way. My guess is that they probably do, but don't hold me to that. > >RF > >Robert G. Freeman - Oracle8i OCP >Oracle DBA Technical Lead >CSX Midtier Database Administration > >The Cigarette Smoking Man: Anyone who can appease a man's conscience can >take his freedom away from him. > > > >-Original Message- >Sent: Wednesday, March 13, 2002 10:08 AM >To: Multiple recipients of list ORACLE-L > > >Rob, > Can one use 9i RMAN to backup lower version databases (8.0.x, 8.1.x)? > What new functionality will be supported in doing so? > > We do not use RMAN at the moment, but we may consider it in the near >future. > > Thanks. > >- Kirti > >-Original Message- >Sent: Tuesday, March 12, 2002 3:28 PM >To: Multiple recipients of list ORACLE-L > > >New Rman features in 9i make it even nicer... > >Recover specific blocks, while the database and the datafile is still >available. >Automatic channel allocation. >retention policies. >restartable backups and restores. >backing up database and archivelog files in one operation >run command isn't needed in most places anymore... > >Also Rman is FREE, unlike some of the other backup/recovery tools out >there... :-) >I do know that one major software supplier of backup and recovery tools is >reworking >their product so that it's just a front end to Rman > >RF > >Robert G. Freeman - Oracle8i OCP >Oracle DBA Technical Lead >CSX Midtier Database Administration > >The Cigarette Smoking Man: Anyone who can appease a man's conscience can >take his freedom away from him. > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Deshpande, Kirti > 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: Freeman, Robert > 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). > -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Do you use RMAN? DB clone problem
Does anyone have any suggestions on DB cloning with RMAN.Netbackup, I keep getting a file not found error: RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file, handle="EML_L0-EML- 455497207-2852-1", parms="" I'm missing something somewhere??? Origin DB "EML" on dolphin... Duplicate DB "EMLC" on cobra... rman RMAN> connect target sys/@eml RMAN> connect rcvcat rman/@ds8i RMAN> connect auxiliary / RMAN> "the usual file re-definition & redo log file descriptions" RMAN> run { RMAN> allocate auxiliary channel t type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=dolphin.xx.xxx.xxx)' trace=1; 5> duplicate target database to EMLC RMAN> } RTFM no help Oracle TAR no help Sun ticket - completely useless (we get our Veritas support from Sun [ big mistake]) TIA ...JIM... >>> [EMAIL PROTECTED] 3/6/02 11:53:34 AM >>> I use RMAN with veritas Netbackup and it is sweet. Recovery is ridiculously easy: Even recovering to an alternative host (not as fast as cloning) is a doddle and u can apply redo logs to the recovery to bring it up to current time: All in all well worth the learning curve to set up - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 06, 2002 9:03 PM hmmm, the question of the day, a good one! I don't use it now but plan on using it. The question is when :) >>> [EMAIL PROTECTED] 03/06/02 10:48AM >>> Hi, I'm in the process of upgrading my database to 9i and I was trying to decide whether I wanted to change my backup strategy to use RMAN. Do most of you use it? If you use it, what is your opinion of it? If you don't use it, why did you decide not to? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF 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: Gene Sais 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: Sam Roberts 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: James Howerton 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: Do you use RMAN? DB clone problem
I use this technique only as a failover routine, if the production machine were to crash: Cloning I would use standards methods as it is much faster: But once u restored the database you can rename it. But the steps that I take are 1.Install executables on other machine as same owner and group id as original database(this is very important)(RESTORE using Netbackup rather than re-install) 2.Update bp.conf in oracle home and /usr/openv/netbackup/ 3. set nb_ora_client=Original client 4.startup taget database nomount 5.connect rman catalog 6.Run scripts Sam p.s. scripts I use are run { allocate channel ch1 type 'sbt_tape'; restore controlfile; alter database mount; } --select min(scn) from (select max(next_change#)scn from v$archived_log group by thread#); -- get the last scn in svrmgrl run { set until scn=100075926; allocate channel ch1 type 'sbt_tape';restore database;recover database; } --back in svrmgrl alter database open resetlogs -- 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: Do you use RMAN? DB clone problem
Hi Lists I have encountered error(ORA-00600: internal error code, arguments arguments: [qersoAggDist.0], [3], [], [], [], [], [], [] ORA-06512:) while running package called 'JC_PR_SPLIT_PROCESS' Error message is listed below . I am using SQL Navigotor to process this package. Any idea or clue for this error. Please give me a soultion for this. * SCRIPT START : Session:prodho8i.world-MECJCPDAT:1 9-Mar-02 11:13:49 am SCRIPT File: UnNamed1 Starting from line number : 1 Processing ... BEGIN * ORA-00600: internal error code, arguments: [qersoAggDist.0], [3], [], [], [], [], [], [] ORA-06512: at "MECJCPDAT.JC_PR_SPLIT_PROCESS", line 688 ORA-06512: at "MECJCPDAT.JC_PR_SPLIT_PROCESS", line 306 ORA-06512: at "MECJCPDAT.JC_PR_SPLIT_PROCESS", line 913 ORA-06512: at line 2 * SCRIPT END : 9-Mar-02 11:16:40 am How do I solve this error Any help is really appreciated. Nitheesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pullikol Kumar 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: Do you use RMAN? DB clone problem
Hi Lists I have encountered error(ORA-00600: internal error code, arguments arguments: [qersoAggDist.0], [3], [], [], [], [], [], [] ORA-06512:) while running package called 'JC_PR_SPLIT_PROCESS' Error message is listed below . I am using SQL Navigotor to process this package. Any idea or clue for this error. Please give me a soultion for this. * SCRIPT START : Session:prodho8i.world-MECJCPDAT:1 9-Mar-02 11:13:49 am SCRIPT File: UnNamed1 Starting from line number : 1 Processing ... BEGIN * ORA-00600: internal error code, arguments: [qersoAggDist.0], [3], [], [], [], [], [], [] ORA-06512: at "MECJCPDAT.JC_PR_SPLIT_PROCESS", line 688 ORA-06512: at "MECJCPDAT.JC_PR_SPLIT_PROCESS", line 306 ORA-06512: at "MECJCPDAT.JC_PR_SPLIT_PROCESS", line 913 ORA-06512: at line 2 * SCRIPT END : 9-Mar-02 11:16:40 am How do I solve this error Any help is really appreciated. Nitheesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pullikol Kumar 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: Do you use RMAN? DB clone problem
I use this technique only as a failover routine, if the production machine were to crash: Cloning I would use standards methods as it is much faster: But once u restored the database you can rename it. But the steps that I take are 1.Install executables on other machine as same owner and group id as original database(this is very important)(RESTORE using Netbackup rather than re-install) 2.Update bp.conf in oracle home and /usr/openv/netbackup/ 3. set nb_ora_client=Original client 4.startup taget database nomount 5.connect rman catalog 6.Run scripts Sam p.s. scripts I use are run { allocate channel ch1 type 'sbt_tape'; restore controlfile; alter database mount; } --select min(scn) from (select max(next_change#)scn from v$archived_log group by thread#); -- get the last scn in svrmgrl run { set until scn=100075926; allocate channel ch1 type 'sbt_tape';restore database;recover database; } --back in svrmgrl alter database open resetlogs -- 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: Do you use RMAN? DB clone problem
Does anyone have any suggestions on DB cloning with RMAN.Netbackup, I keep getting a file not found error: RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file, handle="EML_L0-EML- 455497207-2852-1", parms="" I'm missing something somewhere??? Origin DB "EML" on dolphin... Duplicate DB "EMLC" on cobra... rman RMAN> connect target sys/@eml RMAN> connect rcvcat rman/@ds8i RMAN> connect auxiliary / RMAN> "the usual file re-definition & redo log file descriptions" RMAN> run { RMAN> allocate auxiliary channel t type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=dolphin.xx.xxx.xxx)' trace=1; 5> duplicate target database to EMLC RMAN> } RTFM no help Oracle TAR no help Sun ticket - completely useless (we get our Veritas support from Sun [ big mistake]) TIA ..JIM... >>> [EMAIL PROTECTED] 3/6/02 11:53:34 AM >>> I use RMAN with veritas Netbackup and it is sweet. Recovery is ridiculously easy: Even recovering to an alternative host (not as fast as cloning) is a doddle and u can apply redo logs to the recovery to bring it up to current time: All in all well worth the learning curve to set up - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 06, 2002 9:03 PM hmmm, the question of the day, a good one! I don't use it now but plan on using it. The question is when :) >>> [EMAIL PROTECTED] 03/06/02 10:48AM >>> Hi, I'm in the process of upgrading my database to 9i and I was trying to decide whether I wanted to change my backup strategy to use RMAN. Do most of you use it? If you use it, what is your opinion of it? If you don't use it, why did you decide not to? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALINF 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: Gene Sais 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: Sam Roberts 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: James Howerton 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). <>