In order to isolate the problem I would run one command at a time at rman
prompt.I suspect that allocate channel command is not initializing use
allocate disk and see if it succeeds.
Once you identify offending stmt you can run complete script.
Anwer
"Martin Doering" <doeringm_at_gmx.de> wrote in message
news:3c0b8200.28961314_at_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
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> 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 Tue Dec 04 2001 - 11:13:41 CST
