本实验是恢复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/p本文来源gaodai#ma#com搞@代~码^网+roduct/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
，
转载请注明原文链接：Oracle基础教程： 关于spfile 的恢复
