registering database fails in rman

All posts relating to Oracle database administration.

Moderator: Tim...

registering database fails in rman

Postby sridhartempalle » Fri Jul 26, 2013 8:59 pm

Hello Tim,

I've been trying to issue 'register database' command but it throws the following error:

[oracle@localhost ~]$ rman | tee /u01/bkup/rman/script_logs/rman.log

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jul 26 13:53:10 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN> connect target /

connected to target database: ORCL (DBID=1342690537)

RMAN> connect catalog rman/rman@orcl

connected to recovery catalog database

RMAN> register database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 07/27/2013 01:27:36
RMAN-06428: recovery catalog is not installed

RMAN> create catalog;

ORACLE error from recovery catalog database: ORA-00955: name is already used by an existing object

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog

RMAN> create catalog tablespace cat_ts;

ORACLE error from recovery catalog database: ORA-00959: tablespace 'CAT_TS' does not exist

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog

RMAN>

Why did the registration fail and what should I do now?
sridhartempalle
Member
 
Posts: 41
Joined: Mon May 06, 2013 7:13 pm

Re: registering database fails in rman

Postby Tim... » Sat Jul 27, 2013 7:44 am

Hi.

Questions:

1) Was this an existing catalog as far as you are concerned?
2) Was the catalog from the same version as the database you are trying to register?
3) Has a database with the same name or DBID ever been registered with this catalog before?

The second error is obvious. You are trying to create a catalog that already exists, which kinda answers question 1.

The third error is also obvious, since you have referenced a tablespace that does not already exist.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: registering database fails in rman

Postby newbie_nz » Wed Jul 31, 2013 5:44 am

Hi,

Are you sure the tablespace in question exist?
newbie_nz
Senior Member
 
Posts: 53
Joined: Tue Dec 16, 2008 5:54 am

Re: registering database fails in rman

Postby Tim... » Wed Jul 31, 2013 1:31 pm

Hi.

The error message would suggest not. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: registering database fails in rman

Postby sridhartempalle » Thu Aug 01, 2013 12:11 pm

Hello Tim,

1) This is the first time that i've logged into the RMAN and have not created any catalog prior to this.
2) As found from the online search for this error, many suggest it's only the connection that has been formed and the catalog db has actually not been installed.
3) No database has ever been registered with the same name with this catalog.

Tim... wrote:Hi.

Questions:

1) Was this an existing catalog as far as you are concerned?
2) Was the catalog from the same version as the database you are trying to register?
3) Has a database with the same name or DBID ever been registered with this catalog before?

The second error is obvious. You are trying to create a catalog that already exists, which kinda answers question 1.

The third error is also obvious, since you have referenced a tablespace that does not already exist.

Cheers

Tim...
sridhartempalle
Member
 
Posts: 41
Joined: Mon May 06, 2013 7:13 pm

Re: registering database fails in rman

Postby Tim... » Thu Aug 01, 2013 9:05 pm

Hi.

I would suggest you drop the user you were attempting to use as the catalog and start from scratch. You can see how to do the setup here:

http://www.oracle-base.com/articles/9i/ ... ger-9i.php

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 2 guests

cron