OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Recovery Catalog (Linux, ORACLE 11G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Recovery Catalog [message #537627]

Thu, 29 December 2011 22:10

zutty
Messages: 45
Registered: December 2011

Member

when i run SQL> grant recovery_catalog_owner to rman;
i got error like
"grant recovery_catalog_owner to rman
*
ERROR at line 1:
ORA-01919: role 'RECOVERY_CATALOG_OWNER' does not exist"

how to solve this?

Report message to a moderator

Re: Recovery Catalog [message #537628 is a reply to message #537627]

Thu, 29 December 2011 22:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

what can you learn from below?

19:50:03 SQL> show user
USER is "SYS"
20:15:05 SQL> grant RECOVERY_CATALOG_OWNER to dbadmin;

Grant succeeded.

20:15:26 SQL> connect user2/user2
Connected.
20:15:39 SQL> grant RECOVERY_CATALOG_OWNER to dbadmin;
grant RECOVERY_CATALOG_OWNER to dbadmin
*
ERROR at line 1:
ORA-01919: role 'RECOVERY_CATALOG_OWNER' does not exist


20:15:57 SQL>

Report message to a moderator

Re: Recovery Catalog [message #537629 is a reply to message #537628]

Thu, 29 December 2011 22:23

zutty
Messages: 45
Registered: December 2011

Member

SQL> show user
USER is "SYS"
SQL> grant RECOVERY_CATALOG_OWNER to rman;
grant RECOVERY_CATALOG_OWNER to rman
*
ERROR at line 1:
ORA-01919: role 'RECOVERY_CATALOG_OWNER' does not exist

Report message to a moderator

Re: Recovery Catalog [message #537630 is a reply to message #537629]

Thu, 29 December 2011 22:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> select count(*) from dba_roles where role = 'RECOVERY_CATALOG_OWNER';

  COUNT(*)
----------
	 1

Report message to a moderator

Re: Recovery Catalog [message #537631 is a reply to message #537630]

Thu, 29 December 2011 22:49

zutty
Messages: 45
Registered: December 2011

Member

SQL> select count(*) from dba_roles where role = 'RECOVERY_CATALOG_OWNER';
select count(*) from dba_roles where role = 'RECOVERY_CATALOG_OWNER'
*
ERROR at line 1:
ORA-00942: table or view does not exist

Report message to a moderator

Re: Recovery Catalog [message #537632 is a reply to message #537631]

Thu, 29 December 2011 22:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> connect user3/user3
Connected.
SQL> /
select count(*) from dba_roles where role = 'RECOVERY_CATALOG_OWNER'
                     *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> connect / as sysdba
Connected.
SQL> /

  COUNT(*)
----------
	 1

Report message to a moderator

Re: Recovery Catalog [message #537633 is a reply to message #537629]

Thu, 29 December 2011 22:54

himabija
Messages: 33
Registered: December 2011
Location: San Francisco

Member

Please check the output of below code as 'SYS' user

select * from dba_roles;

If you get output like below,

 ERROR at line 1:
 ORA-00942: table or view does not exist

then you might have created your database manually and forgot to run catalog.sql and catproc.sql . Try to run these sql this may solve your problem. If you are running these on production/test environment take necessary precaution before running these sqls.

Report message to a moderator

Re: Recovery Catalog [message #537634 is a reply to message #537632]

Thu, 29 December 2011 22:57

zutty
Messages: 45
Registered: December 2011

Member

again it shows the same error
ERROR at line 1:
ORA-00942: table or view does not exist

Report message to a moderator

Re: Recovery Catalog [message #537635 is a reply to message #537634]

Thu, 29 December 2011 23:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/m/536519/136107/#msg_536519

is this the same DB?

Report message to a moderator

Re: Recovery Catalog [message #537644 is a reply to message #537635]

Fri, 30 December 2011 00:25

zutty
Messages: 45
Registered: December 2011

Member

now its working......
now another problem

RMAN> register database;

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 12/29/2011 11:50:06
RMAN-06002: command not allowed when not connected to a recovery catalog

Report message to a moderator

Re: Recovery Catalog [message #537645 is a reply to message #537644]

Fri, 30 December 2011 00:30

himabija
Messages: 33
Registered: December 2011
Location: San Francisco

Member

How do you solve your problem?

For the error occuring now check the output log.

RMAN-06002: command not allowed when not connected to a recovery catalog

Ensure you are connected to recovery catalog

Report message to a moderator

Re: Recovery Catalog [message #537647 is a reply to message #537644]

Fri, 30 December 2011 00:35

zutty
Messages: 45
Registered: December 2011

Member

i cant register database in rman....
actually i want to take single backup (.bkf) of my database using rman.
i have done the following procedure
rman> connect target
connected to target database: AIS (DBID=433371981)
rman>backup database

i got a set of files.. with different extension
dbf.dbx etc

i need all in a single file

Report message to a moderator

Re: Recovery Catalog [message #537649 is a reply to message #537647]

Fri, 30 December 2011 00:44

zutty
Messages: 45
Registered: December 2011

Member

how to connect recovery catalog?

CONNECT CATALOG catowner@ais

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06445: cannot connect to recovery catalog after NOCATALOG has been used

Report message to a moderator

Re: Recovery Catalog [message #537650 is a reply to message #537647]

Fri, 30 December 2011 00:45

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can't use an Oracle tool from scratch.
Please read:
Database Backup and Recovery Basics
Database Backup and Recovery Reference
Database Backup and Recovery Advanced User's Guide

Regards
Michel

[Updated on: Fri, 30 December 2011 05:10]

Report message to a moderator

Previous Topic:	Recover drop table
Next Topic:	Perform incomplete user managed backup and recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 20:43:24 CST 2025