愛數(shù)(Version: 6.0.17.0.1704)oracle rac下異機單節(jié)點恢復(fù)

1、恢復(fù)參數(shù)文件--任意可讀寫路徑/u01/oracle/recoverydata(數(shù)據(jù)庫需在nomount或mount狀態(tài))
2、修改參數(shù)文件---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、根據(jù)恢復(fù)的參數(shù)文件創(chuàng)建spfile啟動Oracle實例到STARTED
3.1、關(guān)閉數(shù)據(jù)庫
shutdown abort；
3.2、根據(jù)恢復(fù)的參數(shù)文件創(chuàng)建spfile文件
create spfile from pfile='/u01/oracle/recoverydata/pfile_dmsdb.ora';
3.3、開啟數(shù)據(jù)庫至nomount狀態(tài)
startup nomount；
3.3、查看數(shù)據(jù)庫狀態(tài) 狀態(tài)應(yīng)為STARTED
select status from v$instance；4、恢復(fù)日志文件，控制文件和數(shù)據(jù)文件并重定向--任意可讀寫路徑/u01/oracle/recoverydata
5、重命名在線日志文件@/home/oracle/test.sql
br/>4、恢復(fù)日志文件，控制文件和數(shù)據(jù)文件并重定向--任意可讀寫路徑/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.啟動數(shù)據(jù)庫
alter database open resetlogs；

select name from v$datafile查詢oracle數(shù)據(jù)文件位置
select member from v$logfile; 查看redo路徑

愛數(shù)操作：
#ps -ef | grep esf
#cd /etc/init.d
#./AnyBac status
#./AnyBac stop
#su - oracle