-
RMAN Recovery Catalog
Hi there,
I am trying to create a recovery catalog on a 9i database on a Linux box.
When I invoke the rman command from the prompt it just freezes and nothing happens (like the application is running in the background)
If I try the command rman catalog rman_user/rman@portals I get the error
portals@cream:~$ rman catalog rman_user/rman@portals
rman: can't open catalog
Similarly
portals@cream:~$ rman nocatalog
rman: can't open nocatalog
However
portals@cream:~$ sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Dec 11 14:04:01 2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect rman_user/rman@portals
Connected.
SQL>
Works, so the connectivity and the user is correct
I can't work out why I can't get the executable to run.
I have followed the procedure many times before on my NT machine with no problems.
Any help would be greatly appreciated.
Allie
What's the sound of one hand clapping - "CL"
-
I'm having the same problem. Oracle9i on Fedora Core 4. If I find a solution, I will let you know!
-
dude, that post was over 3 and half years ago! i bet they still aint checking this forum for an answer
-
I have problem with Oracle 10g r1 database in DR site. That is Oracle 10g database and running in "mount" mode. I have setup rman job to apply archive logs and recover the database.
We have added data file to the production system and when particular archive apply to the DR site database, there wasn't enough space to create the datafile.
Now we have increase the space and there are enough space to create the particular fle.
How do we continue the recovery?
Starting recover at 17-JUL-06
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=161 devtype=DISK
starting media recovery
archive log filename=/archive1/isw1/1_10896_571279999.arc thread=1 sequence=1089
6
creating datafile fno=30 name=/oradata/isw/isw_cust_data25_raw_2000m
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/17/2006 12:31:00
ORA-19502: write error on file "/oradata/isw/isw_cust_data25_raw_2000m", blockno
64768 (blocksize=8192)
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 1048576
ORA-19502: write error on file "/oradata/isw/isw_cust_data25_raw_2000m", blockno
64896 (blocksize=8192)
ORA-27063: number of bytes read/written is incorrect
Additional information: 311296
Additional information: 1048576
RMAN>
Recovery Manager complete.
Recovery Manager: Release 10.1.0.3.0 - 64bit Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
RMAN>
connected to target database: ISW (DBID=1237080350)
RMAN>
Starting recover at 17-JUL-06
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/17/2006 13:01:05
RMAN-06094: datafile 30 must be restored
Thank you
Colin
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
|