Output log of restore_spfile.ksh, see restore_spfile.ksh to make sense of this log
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 12 14:57:21 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>
RMAN>
connected to target database (not started)
RMAN>
RMAN>
startup failed: ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '/u01/oracle/product/10.2.0/dbs/spfilestgd.
ora'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
starting Oracle instance without parameter file for retrival of spfile
Oracle instance started
Total System Global Area 159383552 bytes
Fixed Size 2019328 bytes
Variable Size 67108864 bytes
Database Buffers 83886080 bytes
Redo Buffers 6369280 bytes
RMAN>
RMAN> 2> 3> 4>
executing command: SET DBID
RMAN>
RMAN> 2> 3> 4>
executing command: SET CONTROLFILE AUTOBACKUP FORMAT
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7>
allocated channel: disk_1
channel disk_1: sid=37 devtype=DISK
Starting restore at 12-JUL-07
channel disk_1: looking for autobackup on day: 20070712
channel disk_1: autobackup found: controlfile_c-3183102432-20070712-00
channel disk_1: SPFILE restore from autobackup complete
Finished restore at 12-JUL-07
released channel: disk_1
RMAN> 2> 3> 4>
Oracle instance shut down
RMAN>
connected to target database (not started)
Oracle instance started
database mounted
database opened
Total System Global Area 402653184 bytes
Fixed Size 2021192 bytes
Variable Size 125831352 bytes
Database Buffers 268435456 bytes
Redo Buffers 6365184 bytes
RMAN>
RMAN>
Recovery Manager complete.




No comments:
Post a Comment