RMAN is unable to restore

From: Martin Doering <doeringm_at_gmx.de>
Date: Mon, 03 Dec 2001 14:01:46 GMT
Message-ID: <3c0b8200.28961314@news.mn.man.de>

We have the following setup:

HP Omniback II 3.5
Oracle 8.1.7.2 Enterprise edition
RMAN 8.1.7.2 Production

I can save our database and our archived logfiles with RMAN, but if I try a restore, I always get just errors. I tried all 3 possible mount states (nomount, mount, open), but all did fail.

Here is, how I did try (broken line by mail):

rman target sys/xxx_at_pk1 rcvcat rman/yyy_at_rm1 <<EOF run {
allocate channel 'dev_0' type 'sbt_tape' parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=pk1,OB2BARLIST=ORA_pk1_ONL)';
allocate channel 'dev_1' type 'sbt_tape' parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=pk1,OB2BARLIST=ORA_pk1_ONL)';
allocate channel 'dev_2' type 'sbt_tape' parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=pk1,OB2BARLIST=ORA_pk1_ONL)';
allocate channel 'dev_3' type 'sbt_tape' parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=pk1,OB2BARLIST=ORA_pk1_ONL)';
restore database;
sql "alter database mount";
recover database;
sql "alter database open resetlogs";
release channel dev1;
}

EOF I always get this message:

mmwr1050:/usr/ora_pk1/dba/rman > ./restore_pk1.sh

Recovery Manager: Release 8.1.7.2.0 - Production

RMAN-06005: connected to target database: PK1 (DBID=1202488877)
RMAN-06008: connected to recovery catalog database
RMAN-00571:
===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

RMAN-00571:

RMAN-00554: initialization of internal recovery manager package failed
RMAN-07001: could not open channel default
RMAN-10008: could not create channel context
RMAN-10024: error setting up for rpc polling
RMAN-10006: error running sql statement: select distinct my.sid,

sex.serial from v$mystat my, x$ksusex sex where sex.sid = my.sid
RMAN-10002: ORACLE error: ORA-01220: file based sort illegal before database is open

If I start the query by hand, I get nearly the same message. My database is for shure not open. I did bring it up just in the mount status, as is said in different tips and tricks. Possibly - if my database is really damaged some day - I can not bring it up. So, what do I do wrong?

Once I tried to bring up the database in an open status, but the I got error messages, that the *.dbf files would be in access. :-)

Here the query of RMAN by hand - don't know, whatfor it is good:

mmwr1050:/usr/ora_pk1/dba/rman > svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production JServer Release 8.1.7.2.0 - 64bit Production

SVRMGR> connect internal
Connected.
SVRMGR> select distinct my.sid, sex.serial from v$mystat my, x$ksusex sex where sex.sid = my.sid;
SID SERIAL
---------- ----------
ORA-01220: file based sort illegal before database is open

SVRMGR> startup mount
ORA-01081: cannot start already-running ORACLE - shut it down first

I can do a "select * from v$thread;" without errors. I am user sys.

Any ideas, what I do wrong?

Thanks in advance...

--
Martin Doering

Received on Mon Dec 03 2001 - 08:01:46 CST