Create catalog process and troubleshooting for rman

Source: Internet
Author: User

Background description:
Create a catalog database in the rman environment.

Problem:
The following error message is displayed when you register a catalog database on the target machine:


RMAN> register database;

PL/SQL package RMAN. DBMS_RCVCAT version 10.02.00.00 in RCVCAT database is not current
PL/SQL package RMAN. DBMS_RCVMAN version 10.02.00.00 in RCVCAT database is not current
RMAN-00571: ========================================================== ==============================
RMAN-00569: ==================== error message stack follows ==========================
RMAN-00571: ========================================================== ==============================
RMAN-03002: failure of register command at 01/05/2013 15:50:52
RMAN-06004: Oracle error from recovery catalog database: ORA-06550 :? 1 ?, ? 2273? :
PLS-00302 :???? 'Getrangealbackup '??
ORA-06550 :? 1 ?, ? 2238? :
PL/SQL: Statement ignored
ORA-06550 :? 1 ?, ? 2453? :
PLS-00302 :???? 'Restorecmd _ t '??
ORA-06550 :? 1 ?, ? 2424? :
PL/SQL: Statement ignored

Problem Analysis:
At the beginning of the semester, I thought that I deleted the previous catalog library, which resulted in the absence of relevant information required for subsequent cancellation, resulting in an error.
So I sought help in this regard.
However, I was disappointed to search for baidu, and the search for corresponding keywords could not return the desired results. So I use google to search for the same keyword.
As a result, I found out what I wanted. It was not that I liked the foreign technology. The foreign technology was too advanced than ours.

It turned out to be simple. The key to the problem was not the following prompt, but the above prompt:
PL/SQL package RMAN. DBMS_RCVCAT version 10.02.00.00 in RCVCAT database is not current
PL/SQL package RMAN. DBMS_RCVMAN version 10.02.00.00 in RCVCAT database is not current
It turns out that an error was reported when the command was executed due to different package versions on both sides. The solution is simple. You only need to upgrade the catalog Library:
[Oracle @ vmlinux ~] $ Rman target/catalogrman/cat @ catalog

Recovery Manager: Release 10.2.0.4.0-Production on Sat Jan 5 15:59:47 2013

Copyright (c) 1982,200 7, Oracle. All rights reserved.

Connected to target database: ORA10G (DBID = 3976420220, not open)
Connected to recovery catalog database
PL/SQL package RMAN. DBMS_RCVCAT version 10.02.00.00 in RCVCAT database is not current
PL/SQL package RMAN. DBMS_RCVMAN version 10.02.00.00 in RCVCAT database is not current

RMAN> upgrade catalog;

Recovery catalog owner is RMAN
Enter upgrade catalog command again to confirm catalog upgrade


Make a confirm for the upgrade command system that is executed for the first time, and then run it again to make it valid (you can see the version changes in the upgrade information ):
RMAN> upgrade catalog;

Recovery catalog upgraded to version 10.02.00.04
DBMS_RCVMAN package upgraded to version 10.02.00.00
DBMS_RCVCAT package upgraded to version 10.02.00.00

 

Register catalog again. Successful:
RMAN> register database;

Database registered in recovery catalog
Starting full resync of recovery catalog
Full resync complete

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.