Hi
I've configured RCAT database including the previously installed production database. I cant create catalog and tried some other commands that dose not functioning well. The following steps has been done so far:
1. created rcat database
2. created rcvcat tablespace
3. create user rman user
4. grant the permissions to rman user
5. connecting rman for
creating rman catalog results in the following:
RMAN> create catalog tablespace rcvcat
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "rcvcat": expecting one of: "double-quoted-string, identifier, single-quoted-string"
RMAN-01007: at line 1 column 27 file: standard input
RMAN-03022: compiling command: host
RMAN-06428: recovery catalog is not installed
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: host
RMAN-06429: RCVCAT database is not compatible with this version of RMAN
-------------------------------
7. Testing another commands like:
RMAN> run { sql "select * from v$datafile"; }
RMAN-03022: compiling command: sql
RMAN-06428: recovery catalog is not installed
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: sql
RMAN-06429: RCVCAT database is not compatible with this version of RMAN
Originally posted by hamhey
$ rman target / catalog rman/rman@rcat
Recovery Manager: Release 8.1.5.0.0 - Production
RMAN-06005: connected to target database: RCAT (DBID=268301244)
RMAN-06008: connected to recovery catalog database
It is clear that you are connecting to the Catalog database as your target database. I think i told you to keep the target and the catalog database seperate.
Use $ rman target sys/password@target catalog rman/rman@rcat
after connection do
RMAN> register database;
Clearly mention the target username/password and the connect_string.
Amar "There is a difference between knowing the path and walking the path."
RMAN-03022: compiling command: register
RMAN-03023: executing command: register
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03006: non-retryable error occurred during execution of command: register
RMAN-07004: unhandled exception during command execution on channel default
RMAN-10015: error compiling PL/SQL program
RMAN-10033: error during compilation of job step 1: ORA-01041: internal error. hostdef extension doesn't exist
Any idea what is wrong again.
//Hamhey
And morever since you are connected to Catalog database which is your target database also and it is not open, its only mounted (see above) how will you register. Keep them seperate.
Amar "There is a difference between knowing the path and walking the path."
If you are using / (without connect string) make sure that your oracle_sid is set to target db. It is set to catalog db so your target and catalog db is same. And when catalog database is not opened you can't create catalog.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Reply With Quote
Bookmarks