| recovery catalog creating error [message #576950] |
Mon, 11 February 2013 05:27  |
 |
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 #576957 is a reply to message #576955] |
Mon, 11 February 2013 06:16  |
John Watson
Messages: 8964
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 #577104 is a reply to message #577026] |
Tue, 12 February 2013 07:13 |
|
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 #577121 is a reply to message #577115] |
Tue, 12 February 2013 09:31 |
|
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
