Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Help with an RMAN restore

Re: Help with an RMAN restore

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Fri, 28 Sep 2007 23:33:25 +0800
Message-Id: <200709281533.l8SFXNxP008414@smtp14.singnet.com.sg>

8.1.7 is not "ooooooooold crap" It is still quite respectable.

The ORA-1460 error is coming from your Recovery Catalog. If you are using a Recovery Catalog, RMAN queries and updates the Catalog in the same manner as any normal SQL queries and updates to an Application Schema.
The RMAN catalog is nothing but a schema inside a database instead of structures inside a controlfile.

Find out why the Catalog returns ORA-1460. Did you convert from 32bit to 64bit ? (is the RMAN client one side and the Catalog running a different size) ? See Bug#5945072 for clues.

OR are you using differing NLS character sets ?

Trace your RMAN session in the Catalog database. Lookup MetaLink for ORA-1460 errors.

HEmant

At 03:45 PM Friday, you 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-03023: executing command: allocate
>RMAN-08030: allocated channel: ch1
>RMAN-08500: channel ch1: sid=16 devtype=SBT_TAPE
>RMAN-08526: channel ch1: BMO v3.0
>RMAN-03022: compiling command: sql
>RMAN-06162: sql statement: ALTER DATABASE DATAFILE 7 OFFLINE
>RMAN-03023: executing command: sql
>RMAN-03022: compiling command: restore
>RMAN-03022: compiling command: IRESTORE
>RMAN-03026: error recovery releasing channel resources
>RMAN-08031: released channel: ch1
>RMAN-00571: ===========================================================
>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>RMAN-00571: ===========================================================
>RMAN-03002: failure during compilation of command
>RMAN-03013: command type: restore
>RMAN-03002: failure during compilation of command
>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!!
>
>Thanks,
>
>Scott

Hemant K Chitale
http://hemantoracledba.blogspot.com

"There is more to life than increasing its speed." Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 28 2007 - 10:33:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US