Home » RDBMS Server » Backup & Recovery » recovery catalog creating error
recovery catalog creating error [message #576950] Mon, 11 February 2013 05:27 Go to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
hello experts,

i want to create recovery catalog, to do this.....


i have created a new databaase for catalog schema called RCAT and


C:\>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 11 16:24:13 2013

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

Enter user-name: sys@rcat as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace rcatts datafile 'c:\oradata\rcat\rcatts01.dbf' size 100m
autoextend on next 10m maxsize 500m;

Tablespace created.

SQL> create user rcat_user identified by rcat_user  quota unlimited on rcatts;

User created.

SQL> grant recovery_catalog_owner to rcat_user;

Grant succeeded.

SQL> select table_name,tablespace_name from all_tables where tablespace_name like 'NEW';

no rows selected

SQL>



and then

C:\>rman target=sys/rcat catalog=rcat_user/rcat_user@rcat

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Feb 11 16:33:06 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: RCAT (DBID=579270447)
connected to recovery catalog database

RMAN> create catalog;

error creating config_update
ORACLE error from recovery catalog database: ORA-01950: no privileges on tablespace 'USERS'

ORACLE error from recovery catalog database: ORA-00942: table or view does not exist

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

RMAN> drop catalog;

recovery catalog owner is RCAT_USER
enter DROP CATALOG command again to confirm catalog removal

RMAN> drop catalog;

recovery catalog dropped

RMAN> create catalog;

error creating config_update
ORACLE error from recovery catalog database: ORA-01950: no privileges on tablespace 'USERS'

ORACLE error from recovery catalog database: ORA-00942: table or view does not exist

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




then how to create catalog....

thanks...
Re: recovery catalog creating error [message #576951 is a reply to message #576950] Mon, 11 February 2013 05:32 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
If you do not want to create the catalog in your default tablespace, you must nominate the tablespace that you want to use.
Re: recovery catalog creating error [message #576955 is a reply to message #576951] Mon, 11 February 2013 06:05 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks for your kind response,

actually i have created the tablesapace rcatts to hold recovery catalog data only
and i have assigned it to catalog user.

thanks........
Re: recovery catalog creating error [message #576957 is a reply to message #576955] Mon, 11 February 2013 06:16 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
actually i have created the tablesapace rcatts to hold recovery catalog data only
and i have assigned it to catalog user.
This tablespace is neither the user's default tablespace, nor is it specified on your CREATE CATALOG command. You need to to dso one or the other.

(by the way, there is sdomething wrng with your keyboard: it inserts multiple "....." characters)
Re: recovery catalog creating error [message #576964 is a reply to message #576957] Mon, 11 February 2013 07:36 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks John for your response

Quote:

This tablespace is neither the user's default tablespace, nor is it specified on your CREATE CATALOG command. You need to to dso one or the other.


SQL> alter user rcat_user default tablespace rcatts quota unlimited on rcatts;

User altered.

SQL>  select default_tablespace from dba_users where username ='RCAT_USER';

DEFAULT_TABLESPACE
------------------------------
RCATTS

SQL>


query:-

1) how to specify default tablespace on CREATE CATALOG command

2) what is/are other things.



thanks.......
Re: recovery catalog creating error [message #576965 is a reply to message #576957] Mon, 11 February 2013 07:36 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks again

[Updated on: Mon, 11 February 2013 07:37]

Report message to a moderator

Re: recovery catalog creating error [message #576981 is a reply to message #576965] Mon, 11 February 2013 09:46 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
query:-


1) what is/are other things.



thanks.......

[Updated on: Mon, 11 February 2013 09:46]

Report message to a moderator

Re: recovery catalog creating error [message #576985 is a reply to message #576981] Mon, 11 February 2013 10:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

They are things that are not currently mentioned.

Regards
Michel
Re: recovery catalog creating error [message #577023 is a reply to message #576985] Tue, 12 February 2013 00:35 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks for your kind response,

will you please tell me what i am missing, it will be your great help to me?

thanks....

Re: recovery catalog creating error [message #577026 is a reply to message #577023] Tue, 12 February 2013 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
John Watson wrote on Mon, 11 February 2013 13:16

This tablespace is neither the user's default tablespace, nor is it specified on your CREATE CATALOG command. You need to to do one or the other.


So do one or the other, and post what you do and get.

Regards
Michel

Re: recovery catalog creating error [message #577104 is a reply to message #577026] Tue, 12 February 2013 07:13 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
hello sir,

recovery catalog is created.

code is here:


Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Neetesh>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 12 18:42:48 2013

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

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------
RCAT


SQL> create tablespace catalogts datafile 'C:\oradata\RCAT\rcat01.dbf' size 100m
 autoextend on;

Tablespace created.



SQL> create user rcatt identified by rcatt default tablespace catalogts quota un
limited on catalogts;

User created.

SQL> grant recovery_catalog_owner to rcatt;

Grant succeeded.

SQL> alter user rcatt account unlock;

User altered.

SQL> exit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\Users\Neetesh>rman target sys catalog rcatt/rcatt

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Feb 12 18:49:58 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

target database Password:
connected to target database: RCAT (DBID=579270447)
connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

RMAN> exit;


Recovery Manager complete.

C:\Users\Neetesh>rman target sys@myprodb catalog rcatt/rcatt

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Feb 12 18:51:10 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

target database Password:
connected to target database: MYPRODB (DBID=703298088)
connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN>


thanks........
Re: recovery catalog creating error [message #577107 is a reply to message #577104] Tue, 12 February 2013 07:18 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Sussed.
The alternative approach would have been to specify the tablespace when you created the catalogue:

create catalog tablespace catalogts;



Re: recovery catalog creating error [message #577115 is a reply to message #577104] Tue, 12 February 2013 08:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Enter user-name: sys as sysdba


No, not to create tablespace or user, use a DBA for this.

- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer)
- SYS/SYSDBA does not act like any other user
- When you use SYS/SYSDBA Oracle deactivates some code path and activates others
- Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user.

NEVER EVER use SYS/SYSDBA for anything that can be done by another user.
Use SYS/SYSDBA ONLY for something that can't be done by someone else.


Regards
Michel
Re: recovery catalog creating error [message #577121 is a reply to message #577115] Tue, 12 February 2013 09:31 Go to previous messageGo to next message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
thanks alot both of you ,

@Michel
thanks again for your valuable guidance

Quote:

No, not to create tablespace or user, use a DBA for this.


sorry i didn't get you

you mean (one of the below)

1) create a user with DBA role
or
2)use SYS user.

to create the recovery catalog

thanks.......

[Updated on: Tue, 12 February 2013 09:32]

Report message to a moderator

Re: recovery catalog creating error [message #577126 is a reply to message #577121] Tue, 12 February 2013 10:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SYS is NOT a DBA, so 1) is correct.

Regards
Michel
Re: recovery catalog creating error [message #577127 is a reply to message #577126] Tue, 12 February 2013 10:04 Go to previous message
neetesh87
Messages: 280
Registered: September 2011
Location: bhopal
Senior Member
ok .
thanks a lot sir

Previous Topic: how to take backup and recover of oracle database
Next Topic: Rman status report
Goto Forum:
  


Current Time: Thu Mar 28 10:41:46 CDT 2024