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_archive_format='%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 alter database rename file '+DATA/mhdb/onlinelog/group_1.256.982084575' to '/oradata/oracle/oradata/mhdb/redo01_1.log'; 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
