After copying the controlfile backupset it worked fine . thanks to all. On 9/12/07, Prasad <p4cldba@xxxxxxxxx> 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@xxxxxxxxxxxxx> wrote: > > > > Do a "show all;" from the RMAN> prompt and you'll see the standby > > controlfile location defined there. > > > > ----- Original Message ---- > > From: Prasad < p4cldba@xxxxxxxxx> > > To: oracle-l <oracle-l@xxxxxxxxxxxxx> > > 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@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 > > > > > > > > > > > > >