Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN-00554: initialization of internal recovery manager package failed
After copying the controlfile backupset it worked fine . thanks to all.
On 9/12/07, Prasad <p4cldba_at_gmail.com> wrote:
>
> Hi Dan,
>
> I am now struck while doing the restore of spfile
>
> Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 12 14:12:04
> 2007
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> connected to target database (not started)
>
> RMAN> set DBID 3782488593
>
> executing command: SET DBID
>
> RMAN> STARTUP NOMOUNT
>
> startup failed: ORA-01078: failure in processing system parameters
> LRM-00109: could not open parameter file
> '/devel/app/oracle/product/10.2/dbs/initdev10g.ora'
>
> starting Oracle instance without parameter file for retrival of spfile
> Oracle instance started
>
> Total System Global Area 159383552 bytes
>
> Fixed Size 1218244 bytes
> Variable Size 58722620 bytes
> Database Buffers 92274688 bytes
> Redo Buffers 7168000 bytes
>
> RMAN> show all;
>
> RMAN configuration parameters are:
> CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
> CONFIGURE BACKUP OPTIMIZATION OFF; # default
> CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
> CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; #
> default
> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; #
> default
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> CONFIGURE MAXSETSIZE TO UNLIMITED; # default
> CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
> CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
> RMAN> run{
> 2> allocate channel c1 device type disk format '/obackup/oracle/rman/%U';
> 3> restore spfile to pfile '?/dbs/initdev10g.ora' from autobackup;
> 4> }
>
> released channel: ORA_DISK_1
> allocated channel: c1
> channel c1: sid=36 devtype=DISK
>
> Starting restore at 12-SEP-07
>
> channel c1: looking for autobackup on day: 20070912
> channel c1: looking for autobackup on day: 20070911
> channel c1: looking for autobackup on day: 20070910
> channel c1: looking for autobackup on day: 20070909
> channel c1: looking for autobackup on day: 20070908
> channel c1: looking for autobackup on day: 20070907
> channel c1: looking for autobackup on day: 20070906
> channel c1: no autobackup in 7 days found
> released channel: c1
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of restore command at 09/12/2007 14:16:03
> RMAN-06172: no autobackup found or specified handle is not a valid copy or
> piece
>
>
>
> On 9/12/07, Dan Norris <dannorris_at_dannorris.com> wrote:
> >
> > Do a "show all;" from the RMAN> prompt and you'll see the standby
> > controlfile location defined there.
> >
> > ----- Original Message ----
> > From: Prasad < p4cldba_at_gmail.com>
> > To: oracle-l <oracle-l_at_freelists.org>
> > Sent: Wednesday, September 12, 2007 2:19:34 PM
> > Subject: RMAN-00554: initialization of internal recovery manager package
> > failed
> >
> > Hi All,
> >
> > I am trying to simulate this .
> > Restore and Recovery of the Database on a New Host
> > however after I did this
> > set DBID 3782488593
> >
> > on db1 on hostb
> >
> > when I try to do this
> >
> > rman target / nocatalog
> >
> > Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 12 14:02:06
> > 2007
> >
> > Copyright (c) 1982, 2005, Oracle. All rights reserved.
> >
> > RMAN-00571: ===========================================================
> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> > RMAN-00571: ===========================================================
> > RMAN-00554: initialization of internal recovery manager package failed
> > RMAN-06003: ORACLE error from target database:
> > ORA-00210: cannot open the specified control file
> > ORA-00202: control file: '/devel/dev02/dev10g/standbyctl.ctl'
> > ORA-27041: unable to open file
> > Linux Error: 2: No such file or directory
> > Additional information: 3
> >
> > oracle_at_asb-dev-dgs-002:dev10g:/devel/app/oracle/product/10.2/dbs>
> > ls -ltr /devel/dev02/dev10g/standbyctl.ctl
> > ls: /devel/dev02/dev10g/standbyctl.ctl: No such file or directory
> >
> > I am getting the above error . i am not able to determine where does the
> > rman pick up the '/devel/dev02/dev10g/standbyctl.ctl'
> >
> > apprciate any suggestions.
> >
> > TIA
> > -Prasad
> >
> >
> >
> >
> >
> >
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 12 2007 - 16:15:30 CDT