Home » RDBMS Server » Backup & Recovery » Recovery Catalog (Linux, ORACLE 11G)
Recovery Catalog [message #537627] Thu, 29 December 2011 22:10 Go to next message
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?
Re: Recovery Catalog [message #537628 is a reply to message #537627] Thu, 29 December 2011 22:16 Go to previous messageGo to next message
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> 
Re: Recovery Catalog [message #537629 is a reply to message #537628] Thu, 29 December 2011 22:23 Go to previous messageGo to next message
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
Re: Recovery Catalog [message #537630 is a reply to message #537629] Thu, 29 December 2011 22:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> select count(*) from dba_roles where role = 'RECOVERY_CATALOG_OWNER';

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

Re: Recovery Catalog [message #537631 is a reply to message #537630] Thu, 29 December 2011 22:49 Go to previous messageGo to next message
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
Re: Recovery Catalog [message #537632 is a reply to message #537631] Thu, 29 December 2011 22:52 Go to previous messageGo to next message
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

Re: Recovery Catalog [message #537633 is a reply to message #537629] Thu, 29 December 2011 22:54 Go to previous messageGo to next message
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.

Re: Recovery Catalog [message #537634 is a reply to message #537632] Thu, 29 December 2011 22:57 Go to previous messageGo to next message
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
Re: Recovery Catalog [message #537635 is a reply to message #537634] Thu, 29 December 2011 23:03 Go to previous messageGo to next message
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?
Re: Recovery Catalog [message #537644 is a reply to message #537635] Fri, 30 December 2011 00:25 Go to previous messageGo to next message
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
Re: Recovery Catalog [message #537645 is a reply to message #537644] Fri, 30 December 2011 00:30 Go to previous messageGo to next message
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


Re: Recovery Catalog [message #537647 is a reply to message #537644] Fri, 30 December 2011 00:35 Go to previous messageGo to next message
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


Re: Recovery Catalog [message #537649 is a reply to message #537647] Fri, 30 December 2011 00:44 Go to previous messageGo to next message
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
Re: Recovery Catalog [message #537650 is a reply to message #537647] Fri, 30 December 2011 00:45 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Thu Mar 28 06:49:14 CDT 2024