爱数(Version: 6.0.17.0.1704)oracle rac下异机单节点恢复

1、恢复参数文件--任意可读写路径/u01/oracle/recoverydata(数据库需在nomount或mount状态)
2、修改参数文件---pfile_dmsdb.ora
#plusdb.db_cache_size=11408506880
#plusdb.java_pool_size=939524096
#plusdb.large_pool_size=805306368
plusdb.oracle_base='/u01/orabase'#ORACLE_BASE set from environment
#plusdb.pga_aggregate_target=34225520640
#plusdb.sga_target=19864223744
#plusdb.__shared_io_pool_size=268435456
#plusdb.shared_pool_size=6174015488
plusdb.streams_pool_size=0
.audit_file_dest='/u01/oracle/admin/plusdb/adump'
#.background_dump_dest='/u01/oracle/diag/rdbms/plusdb'
.compatible='11.2.0.4.0'
.control_files='/u01/oracle/oradata/plusdb/controlfile/current.256.952221069'
.core_dump_dest='/u01/oracle/diag/rdbms/plusdb'
.db_block_size=8192
.db_create_file_dest=''
.db_domain=''
.db_name='plusdb'
.db_recovery_file_dest='/u01/oracle/fast_recovery_area'
.db_recovery_file_dest_size=4282368
.diagnostic_dest='/u01/oracle'
.dispatchers='(PROTOCOL=TCP) (SERVICE=plusdbXDB)'
.log_archiveformat='%t%s_%r.dbf'
.memory_target=12884901888
.open_cursors=300
.processes=1500
.remote_login_passwordfile='exclusive'
.sessions=1655
plusdb.thread=1
plusdb.undo_tablespace='UNDOTBS1'
#.user_dump_dest='/u01/oracle/diag/rdbms/plusdb'
*.diagnostic_dest='/u01/oracle'
3、根据恢复的参数文件创建spfile启动Oracle实例到STARTED
3.1、关闭数据库
shutdown abort；
3.2、根据恢复的参数文件创建spfile文件
create spfile from pfile='/u01/oracle/recoverydata/pfile_dmsdb.ora';
3.3、开启数据库至nomount状态
startup nomount；
3.3、查看数据库状态 状态应为STARTED
select status from v$instance；4、恢复日志文件，控制文件和数据文件并重定向--任意可读写路径/u01/oracle/recoverydata
5、重命名在线日志文件@/home/oracle/test.sql
br/>4、恢复日志文件，控制文件和数据文件并重定向--任意可读写路径/u01/oracle/recoverydata
5、重命名在线日志文件@/home/oracle/test.sql
alter database rename file '+FRA/mhdb/onlinelog/group_1.438.982084575' to '/oradata/oracle/oradata/mhdb/redo01_2.log';
alter database rename file '+DATA/mhdb/onlinelog/group_2.262.982084577' to '/oradata/oracle/oradata/mhdb/redo02_1.log';
alter database rename file '+FRA/mhdb/onlinelog/group_2.260.982084577' to '/oradata/oracle/oradata/mhdb/redo02_2.log';
alter database rename file '+DATA/mhdb/onlinelog/group_3.266.982084577' to '/oradata/oracle/oradata/mhdb/redo03_1.log';
alter database rename file '+FRA/mhdb/onlinelog/group_3.259.982084579' to '/oradata/oracle/oradata/mhdb/redo03_2.log';
alter database rename file '+DATA/mhdb/onlinelog/group_4.261.982086153' to '/oradata/oracle/oradata/mhdb/redo04_1.log';
alter database rename file '+FRA/mhdb/onlinelog/group_4.258.982086153' to '/oradata/oracle/oradata/mhdb/redo04_2.log';
alter database rename file '+DATA/mhdb/onlinelog/group_5.260.982086155' to '/oradata/oracle/oradata/mhdb/redo05_1.log';
alter database rename file '+FRA/mhdb/onlinelog/group_5.257.982086155' to '/oradata/oracle/oradata/mhdb/redo05_2.log';
alter database rename file '+DATA/mhdb/onlinelog/group_6.259.982086155' to '/oradata/oracle/oradata/mhdb/redo06_1.log';
alter database rename file '+FRA/mhdb/onlinelog/group_6.408.982086157' to '/oradata/oracle/oradata/mhdb/redo06_2.log';
6.启动数据库
alter database open resetlogs；

select name from v$datafile查询oracle数据文件位置
select member from v$logfile; 查看redo路径

爱数操作：
#ps -ef | grep esf
#cd /etc/init.d
#./AnyBac status
#./AnyBac stop
#su - oracle