RE: RMAN compatibility issues
You can upgrade the 816 catalog to be 817 compliant with the command RMAN upgrade catalog You need to be connected to an 8.1.7 target first to do this. It effectively recreates two packages DBMS_RCVMAN and DBMS_RCVCAT John -Original Message- Sent: 20 November 2002 16:39 To: Multiple recipients of list ORACLE-L Rachna - Yes, RMAN is VERY picky about Oracle versions. What I understand is that you are trying to use an 816 catalog to back up an 817 database. I think that you usually must keep your catalog at the level of the target database or higher. In other words, you could use an 817 catalog db to back up an 816 target, but not the other way around. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 20, 2002 9:21 AM To: Multiple recipients of list ORACLE-L DBAs, I experienced following while trying to test interoperatibility between 816 and 817. Any comments, experiences? Target - 817 Catalog - 816 rman rcvcat rman/rman@rcatqual connect target register database; . RMAN-06429: RCVCAT database is not compatible with this version of RMAN . Target - 816 Catalog - 817 rman rcvcat rman/rman@rcattest connect target register database; . RMAN-08006: database registered in recovery catalog . -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RMAN compatibility issues
DBAs, I experienced following while trying to test interoperatibility between 816 and 817. Any comments, experiences? Target - 817 Catalog - 816 rman rcvcat rman/rman@rcatqual connect target register database; . RMAN-06429: RCVCAT database is not compatible with this version of RMAN . Target - 816 Catalog - 817 rman rcvcat rman/rman@rcattest connect target register database; . RMAN-08006: database registered in recovery catalog . -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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).
RE: RMAN compatibility issues
Rachna, you forgot one more test: 816 version of Rman against an 817 target database using an 816 version of catalog - should work ok. other than that, your test results are as expected. you can use a lower version of rman against a higher version of the catalog, but the opposite is not true. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, November 20, 2002 10:21 AM To: Multiple recipients of list ORACLE-L DBAs, I experienced following while trying to test interoperatibility between 816 and 817. Any comments, experiences? Target - 817 Catalog - 816 rman rcvcat rman/rman@rcatqual connect target register database; . RMAN-06429: RCVCAT database is not compatible with this version of RMAN . Target - 816 Catalog - 817 rman rcvcat rman/rman@rcattest connect target register database; . RMAN-08006: database registered in recovery catalog . -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F 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).
RE: RMAN compatibility issues
Rachna - Yes, RMAN is VERY picky about Oracle versions. What I understand is that you are trying to use an 816 catalog to back up an 817 database. I think that you usually must keep your catalog at the level of the target database or higher. In other words, you could use an 817 catalog db to back up an 816 target, but not the other way around. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 20, 2002 9:21 AM To: Multiple recipients of list ORACLE-L DBAs, I experienced following while trying to test interoperatibility between 816 and 817. Any comments, experiences? Target - 817 Catalog - 816 rman rcvcat rman/rman@rcatqual connect target register database; . RMAN-06429: RCVCAT database is not compatible with this version of RMAN . Target - 816 Catalog - 817 rman rcvcat rman/rman@rcattest connect target register database; . RMAN-08006: database registered in recovery catalog . -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
RE: RMAN compatibility issues
On page 204 of Oracle9i RMAN Backup and Recovery (available on Amazon!) the answer is written thusly: When using database version 8.1.7 When using RMAN version 8.1.x Catalog Schema requirement: Oracle 8.1.x (or later) catalog database, with a catalog schema created by an RMAN version that is equivalent to or greater than the RMAN version being used to back up the database. In other words, if you are using 8.1.7 RMAN, then you need to use a recovery catalog schema created by and RMAN executable that is also 8.1.7 or later. 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: Wednesday, November 20, 2002 10:21 AM To: Multiple recipients of list ORACLE-L DBAs, I experienced following while trying to test interoperatibility between 816 and 817. Any comments, experiences? Target - 817 Catalog - 816 rman rcvcat rman/rman@rcatqual connect target register database; . RMAN-06429: RCVCAT database is not compatible with this version of RMAN . Target - 816 Catalog - 817 rman rcvcat rman/rman@rcattest connect target register database; . RMAN-08006: database registered in recovery catalog . -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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).