After copying the controlfile backupset it worked fine . thanks to all.
On 9/12/07, Prasad 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 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
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: ===========================================================
