Oracle基础教程：关于spfile的恢复

本实验是恢复spfile: SQLgt; shutdown immediate;Database closed.Database dismounted.Oracle instance shut down.SQLgt; sta

本实验是恢复spfile:

SQL> shutdown immediate;
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 335544320 bytes
Fixed Size 1219280 bytes
Variable Size 79693104 bytes
Database Buffers 251658240 bytes
Redo Buffers 2973696 bytes
SQL> !
[oracle@aoracle ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Dec 8 16:43:31 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ezhou (not mounted)

RMAN> restore spfile;

Starting restore at 08-DEC-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/08/2011 16:43:41
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP

看一下spfile 文件：
已经被移走：
[oracle@aoracle dbs]$ ls -l spfile*
-rw-r----- 1 oracle oinstall 2560 Oct 10 15:20 spfileezhoudg.ora
-rw-r----- 1 oracle oinstall 2560 Dec 8 15:16 spfileezhou.ora_b

[oracle@aoracle dbs]$ tnsping prd

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 08-DEC-2011 17:17:27

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.190.140)(PORT = 1521))) (CONNECT_DATA = (SID = EZHOU)))
OK (10 msec)
[oracle@aoracle dbs]$ tnsping prdd

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 08-DEC-2011 17:17:34

Copyright (c) 1997, 2005, Oracle. All rights reserved.

[oracle@aoracle dbs]$ rman target rman_user/rman_user

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Dec 8 17:19:02 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: EZHOU (DBID=4046377924, not open)

RMAN> restore spfile;

Starting restore at 08-DEC-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: restoring SPFILE
output filename=/u01/pp/oracle/product/10.2/db_1/dbs/spfileezhou.ora
channel ORA_DISK_1: reading from backup piece /u02/rman/ctl_c-4046377924-20111208-00
channel ORA_DISK_1: restored backup piece 1
piece handle=/u02/rman/ctl_c-4046377924-20111208-00 tag=TAG20111208T134435
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 08-DEC-11

RMAN>

检查 spfile 已经恢复。

[oracle@aoracle dbs]$ ls -l spfile*
-rw-r----- 1 oracle oinstall 2560 Oct 10 15:20 spfileezhoudg.ora
-rw-r----- 1 oracle oinstall 2560 Dec 8 17:19 spfileezhou.ora
-rw-r----- 1 oracle oinstall 2560 Dec 8 15:16 spfileezhou.ora_b
[oracle@aoracle dbs]$ date
Thu Dec 8 17:29:22 CST 2011