-
RMAN catalog failure
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> create catalog tablespace rcvcat
--------------------------------------
6.Testing another commands like:
RMAN> run {host "ls -l";}
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
Do you have any idea what is wrong.
//Hamhey
-
Create a tablespace and make it default tablesapce for rman user.
Login as rman and simply type
Register your target database and you are ready to go.
HTH
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Oh just noticed that you are missing quotes. Try this.
Code:
CREATE CATALOG TABLESPACE 'RCVCAT';
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Hi,
Thanks alot, it worked.
But registet the database failed:
I used the following:
$ 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
RMAN> shutdown immediate;
RMAN-06405: database closed
RMAN-06404: database dismounted
RMAN-06402: Oracle instance shut down
RMAN> startup mount;
RMAN-06193: connected to target database (not started)
RMAN-06196: Oracle instance started
RMAN-06199: database mounted
Total System Global Area 34897296 bytes
Fixed Size 64912 bytes
Variable Size 17883136 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
RMAN> register database;
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
-
Any trace file generated ? Any further info in alert.log ??
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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."
-
Originally posted by hamhey
RMAN> startup mount;
RMAN-06193: connected to target database (not started)
RMAN-06196: Oracle instance started
RMAN-06199: database mounted
Total System Global Area 34897296 bytes
Fixed Size 64912 bytes
Variable Size 17883136 bytes
Database Buffers 16777216 bytes
Redo Buffers 172032 bytes
RMAN> register database;
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"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|