oracle数据重定向,Oracle数据库之爱数(Version: 6.0.17.0.1704)oracle rac下异机单节点恢复...

本文主要向大家介绍了Oracle数据库之爱数(Version: 6.0.17.0.1704)oracle rac下异机单节点恢复，通过具体的内容向大家展现，希望对大家学习Oracle数据库有所帮助。

1、恢复参数文件--任意可读写路径/u01/oracle/recoverydata2、修改参数文件---pfile_dmsdb.ora#plusdb.db_cache_size=11408506880#plusdb.java_pool_size=939524096#plusdb.large_pool_size=805306368plusdb.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=6174015488plusdb.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=1655plusdb.thread=1plusdb.undo_tablespace='UNDOTBS1'#.user_dump_dest='/u01/oracle/diag/rdbms/plusdb'*.diagnostic_dest='/u01/oracle'3、根据恢复的参数文件创建spfile启动Oracle实例到STARTED3.1、关闭数据库shutdown abort；3.2、根据恢复的参数文件创建spfile文件create spfile from pfile='/u01/oracle/recoverydata/pfile_dmsdb.ora';3.3、开启数据库至nomount状态 startup nomount；3.3、查看数据库状态   状态应为STARTEDselect status from v$instance；br/>4、恢复日志文件，控制文件和数据文件并重定向--任意可读写路径/u01/oracle/recoverydata

5、重命名在线日志文件@/home/oracle/test.sql

<="" a="">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

本文由职坐标整理并发布，希望对同学们学习Oracle有所帮助，更多内容请关注职坐标数据库Oracle数据库频道！