RAC+ASM在单机上恢复的过程

核心提示： 10 写恢复脚本来恢复库，其中重新指定恢复时，RAC+ASM在单机上恢复的过程(5)，数据文件的存放路径，由ASM到文件系统，绝大部分操作都在此窗口完成，--辅助窗口--由于之前曾成功恢复了数据库，run{allocate channel d1 type disk;set newname

10 写恢复脚本来恢复库，其中重新指定恢复时，数据文件的存放路径，由ASM到文件系统。

run
{allocate channel d1 type disk;
set newname for datafile 1 to '/oradata/ccdb/system.dbf';
set newname for datafile 2 to '/oradata/ccdb/undotbs1.dbf';
set newname for datafile 3 to '/oradata/ccdb/sysaux.dbf';
set newname for datafile 4 to '/oradata/ccdb/users.dbf';
set newname for datafile 5 to '/oradata/ccdb/undotbs2.dbf';
set newname for datafile 6 to '/oradata/ccdb/unicall2x.dbf';
set newname for datafile 7 to '/oradata/ccdb/unicall2x_idx.dbf';
restore database;
switch datafile all;
release channel d1;
}

13 recover database，注意恢复完成后，系统提示需要的日志文件及SCN好。

recover database;

14 罗列出归档日志的备份集，和上面的RECOVER DATABASE 信息作比较，以确定是否已经用完备份集里的归档日志。

list backup of archivelog all;

15 alter database open resetlogs;

四 下面是恢复操作过程，其中，"辅助窗口" 执行恢复过程中起辅助作用的操作, "RMAN窗口" 执行正式操作，绝大部分操作都在此窗口完成。

--辅助窗口

--由于之前曾成功恢复了数据库，现需要删除之。

ibm1 ->sqlplus
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Jun 26 14:49:39 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> show parameter instance;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 1
instance_groups string
instance_name string ccdb1
instance_number integer 0
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 1
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount restrict;
ORACLE instance started.
Total System Global Area 3221225472 bytes
Fixed Size 2076312 bytes
Variable Size 1996489064 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14700544 bytes
Database mounted.
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> exit