Today's Birthday
Quote of the Day
This Day in History

Wednesday, June 13, 2007

Output log of restore_spfile.ksh

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