RAC+ASM在单机上恢复的过程
2008-12-18 13:07:14 来源:WEB开发网--RMAN窗口
--强行启动数据库,使用指定的备份集,恢复参数文件,并创建参数文件的pfile。
ibm1 ->rman target /
Recovery Manager: Release 10.2.0.3.0 - Production on Thu Jun 26 15:04:52 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/product/10.2/dbs/initccdb1.ora'
starting Oracle instance without parameter file for retrival of spfile
Oracle instance started
Total System Global Area 159383552 bytes
Fixed Size 2071296 bytes
Variable Size 67110144 bytes
Database Buffers 83886080 bytes
Redo Buffers 6316032 bytes
RMAN> restore spfile from '/oradata/orabak/rmanspctlback/c-3276392049-20080620-01';
Starting restore at 2008-06-26 15:05:05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=36 devtype=DISK
channel ORA_DISK_1: autobackup found: /oradata/orabak/rmanspctlback/c-3276392049-20080620-01
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 2008-06-26 15:05:07
RMAN> host;
ibm1 ->sqlplus
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Jun 26 15:05:17 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> create pfile from spfile;
File created.
SQL> shutdown abort;
ORACLE instance shut down.
SQL>
更多精彩
赞助商链接