oracle 误删spfile,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

，

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网