Re: Help with an RMAN restore

On 9/28/07, Scott Stefick <sstefick_at_gmail.com> wrote:
>
> Ok, so I'm trying to restore a datafile from an rman backup. It's on
> oooooold crap! It's 8.1.7 on SunOS 5.7. Here is my syntax:
>
> run{
> allocate channel ch1 type "SBT_TAPE"
> parms 'ENV=(NSR_SERVER=satpcztape1.domain)';
> sql 'ALTER DATABASE DATAFILE 7 OFFLINE';
> restore datafile 7;
> recover datafile 7;
> sql 'ALTER DATABASE DATAFILE 7 ONLINE';
> release channel ch1;
> }
>
> Here is what I'm getting when I run it:
>
> RMAN-03022: compiling command: allocate
> ...
> RMAN-03013: command type: IRESTORE
> RMAN-06004: ORACLE error from recovery catalog database: ORA-01460:
> unimplemented or unreasonable conversion requested
>
> I don't get it. I've been looking up that last error in the stack and it
> keeps telling me that I have some kind of conversion (TO_CHAR, etc, etc...)
> and I don't!!
>
> Please tell me someone has seen this and knows how to fix it. I want to
> get this done and go to sleep!!
>

Hi Scott,

Did you resolve this?

If not:

Are you using a recovery catalog?

If so, did you try the recovery with 'nocatalog' as well?

What is your MML? If Veritas, my sympathies. Symantec keeps finding new and unusual ways to break the MML.

If it is Veritas, try using the 'SEND' command rather than using PARMS with ALLOCATE CHANNEL.
See above about broken MML.

Degging may help. There are a few methods that I know of to turn on debugging.

ALLOCATE CHANNEL ... debug 6 trace 6.
There are various levels of 1-6 (maybe higher) for each, but it is not well documented.

OH/bin/rman ... debug trace "quoted output file name"

And an interesting method courtesy of Tuomas Pystynen, though it won't work on 8.1.7

http://www.miracleltd.com/msdbf2007/tp.pdf

RMAN tracing

alter system set service_names = 'TEST, TEST_RMAN' scope=both;

exec dbms_monitor.serv_mod_act_trace_enable( service_name=>'TEST_RMAN',module_name=> 'backup full datafile',waits=>true);

exec
dbms_monitor.serv_mod_act_trace_enable(service_name=>'TEST_RMAN',module_name=> 'backup incr datafile',waits=>true);

$ rman target=sys/password_at_test_rman

backup device type 'sbt_tape' tablespace 'TEST';

These may help.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l