当前位置：首页 > news >正文

Oracle database 12cRAC异地恢复至单机

news 2025/7/6 4:00:03

环境

rac 环境 byoradbrac Oracle12.1.0.2

系统版本：Red Hat Enterprise Linux Server release 6.5
软件版本：Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
byoradb1：172.17.38.44
byoradb2：172.17.38.45

单机环境 byoradb Oracle12.1.0.2

系统版本：CentOS Linux release 7.9.2009
软件版本：Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
byoradb：172.17.38.55

rac环境挂载共享盘

可参考Linux 挂载 linux/Windows 共享目录

在服务器端（172.17.38.55）安装 NFS

sudo yum install nfs-utils

创建要共享的目录

创建一个名为 /shared 的目录：

sudo mkdir /shared

修改 NFS 配置文件

编辑 /etc/exports 文件，添加你想要共享的目录和允许访问的客户端 IP 地址。例如：

sudo vi /etc/exports

在文件中添加以下行（替换为你的客户端 IP 地址）：

/shared 172.17.38.44(rw,sync,anonuid=502,anongid=501)

anonuid 为 172.17.38.44 上oracle用户id
anongid 为 172.17.38.44 上 oinstall 组id

 exportfs -r

配置即时生效
启动 NFS 服务

sudo systemctl start nfs-server
sudo systemctl enable nfs-server

在客户端（172.17.38.44）挂载共享目录

创建一个挂载点/nob：

sudo mkdir /nob

可以使用以下命令将服务器的共享目录挂载到这个挂载点：

sudo mount -t nfs 172.17.38.55:/shared /nob

rac备份

备份脚本

rman target /
run {allocate channel ch1 device type disk format '/nob/backup/datafile_backup_%U';backup database include current controlfile spfile;release channel ch1;allocate channel ch2 device type disk format '/nob/backup/controlfile_backup_%U';backup current controlfile;release channel ch2;allocate channel ch3 device type disk format '/nob/backup/spfile_backup_%U';backup spfile;release channel ch3;
}

创建参数文件(基于单机或rac创建都可以)

SQL> create pfile='/shared/backup/initbyoradb.ora' from spfile;

修改参数文件

此处使用单机pfile修改需先在单机安装数据库
也可使用rac环境pfile修改需注意各个文件路径

vi /shared/backup/initbyoradb.orabyoradb.__data_transfer_cache_size=0
byoradb.__db_cache_size=1761607680
byoradb.__java_pool_size=16777216
byoradb.__large_pool_size=150994944
byoradb.__oracle_base='/oracledata/app/oracle'#ORACLE_BASE set from environment
byoradb.__pga_aggregate_target=822083584
byoradb.__sga_target=2432696320
byoradb.__shared_io_pool_size=0
byoradb.__shared_pool_size=486539264
byoradb.__streams_pool_size=0
enable_pluggable_database=true
*.audit_file_dest='/oracledata/app/oracle/admin/byoradb/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='/oracledata/app/oracle/oradata/byoradb/control01.ctl','/oracledata/app/oracle/flash_recovery_area/byoradb/control02.ctl'#Restore Controlfile
*.db_block_size=8192
*.db_domain=''
*.db_name='byoradb'
*.db_recovery_file_dest='/oracledata/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4560m
*.diagnostic_dest='/oracledata/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=byoradbXDB)'
*.open_cursors=300
*.pga_aggregate_target=770m
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=2310m
*.undo_tablespace='UNDOTBS1'

需注意是否使用pdb，如果使用pdb，此参数应为true

 enable_pluggable_database=true

单机恢复（172.17.38.55）

需预先安装好数据库软件
可参考
Oracle database 静默安装 oracle12c 一键安装 12.1.0.2

复制备份文件并修改权限

mkdir /backup
cd /shared/backup
cp * /backup
chown oracle:oinstall -R /backup

恢复控制文件

rman target /#开启数据库至nomount状态 注意参数文件位置与权限
startup nomount pfile 'backup/initbyoradb.ora';
#恢复控制文件
restore controlfile from '/backup/controlfile_backup_k12fejsm_1_1';
#开启数据库至mount
alter database mount;
#注册备份文件
catalog start with '/backup/'

修改redo路径

RMAN> select * from v$logfile;alter database rename file '+DATA/byoradb/redo01.log' to  '/oracledata/app/oracle/oradata/onlinelog/redo01.log';
alter database rename file '+DATA/byoradb/redo02.log' to  '/oracledata/app/oracle/oradata/onlinelog/redo02.log';
alter database rename file '+DATA/byoradb/redo03.log' to  '/oracledata/app/oracle/oradata/onlinelog/redo03.log';
alter database rename file '+DATA/byoradb/redo04.log' to  '/oracledata/app/oracle/oradata/onlinelog/redo04.log';

修改数据文件路径（rac上查询）

select  file# ,name  from v$datafile;

在这里插入图片描述

#根据实际情况修改sql
select 'SET NEWNAME FOR DATAFILE '|| file# ||' to ' ||'''/oracledata/app/oracle/oradata/DATAFILE'|| substr(name,INSTR(name, '/',-1))  ||''''|| ';' from v$datafile;

在这里插入图片描述
修改成单机数据文件期望存放位置
注意目录需提前创建好、

执行恢复脚本

run{
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
SET NEWNAME FOR DATAFILE 1 to '/oracledata/app/oracle/oradata/DATAFILE/system01.dbf';
SET NEWNAME FOR DATAFILE 3 to '/oracledata/app/oracle/oradata/DATAFILE/sysaux01.dbf';
SET NEWNAME FOR DATAFILE 4 to '/oracledata/app/oracle/oradata/DATAFILE/undotbs01.dbf';
SET NEWNAME FOR DATAFILE 5 to '/oracledata/app/oracle/oradata/DATAFILE/system.267.946651233';
SET NEWNAME FOR DATAFILE 6 to '/oracledata/app/oracle/oradata/DATAFILE/users01.dbf';
SET NEWNAME FOR DATAFILE 7 to '/oracledata/app/oracle/oradata/DATAFILE/sysaux.266.946651233';
SET NEWNAME FOR DATAFILE 8 to '/oracledata/app/oracle/oradata/DATAFILE/undotbs02.dbf';
SET NEWNAME FOR DATAFILE 9 to '/oracledata/app/oracle/oradata/DATAFILE/portaltest_system.dbf';
SET NEWNAME FOR DATAFILE 10 to '/oracledata/app/oracle/oradata/DATAFILE/portaltest_sysaux.dbf';
SET NEWNAME FOR DATAFILE 11 to '/oracledata/app/oracle/oradata/DATAFILE/portaltest_users01.dbf';
SET NEWNAME FOR DATAFILE 13 to '/oracledata/app/oracle/oradata/DATAFILE/soaprd_ias_ums.264.960632073';
SET NEWNAME FOR DATAFILE 14 to '/oracledata/app/oracle/oradata/DATAFILE/soaprd_iau.266.960632075';
SET NEWNAME FOR DATAFILE 15 to '/oracledata/app/oracle/oradata/DATAFILE/soaprd_ias_opss.267.960632077';
SET NEWNAME FOR DATAFILE 16 to '/oracledata/app/oracle/oradata/DATAFILE/soaprd_wls.260.960632077';
SET NEWNAME FOR DATAFILE 17 to '/oracledata/app/oracle/oradata/DATAFILE/soaprd_mds.262.960632079';
SET NEWNAME FOR DATAFILE 18 to '/oracledata/app/oracle/oradata/DATAFILE/soaprd_ess.259.960632081';
SET NEWNAME FOR DATAFILE 19 to '/oracledata/app/oracle/oradata/DATAFILE/soaprd_soainfra.261.960632081';
SET NEWNAME FOR DATAFILE 20 to '/oracledata/app/oracle/oradata/DATAFILE/qas_iau.280.947953527';
SET NEWNAME FOR DATAFILE 21 to '/oracledata/app/oracle/oradata/DATAFILE/qas_mds.285.947953529';
SET NEWNAME FOR DATAFILE 22 to '/oracledata/app/oracle/oradata/DATAFILE/qas_wls.278.947953529';
SET NEWNAME FOR DATAFILE 23 to '/oracledata/app/oracle/oradata/DATAFILE/qas_stb.279.947953529';
SET NEWNAME FOR DATAFILE 24 to '/oracledata/app/oracle/oradata/DATAFILE/qas_ess.284.947953529';
SET NEWNAME FOR DATAFILE 25 to '/oracledata/app/oracle/oradata/DATAFILE/qas_ias_opss.283.947953531';
SET NEWNAME FOR DATAFILE 26 to '/oracledata/app/oracle/oradata/DATAFILE/qas_ias_ums.281.947953531';
SET NEWNAME FOR DATAFILE 27 to '/oracledata/app/oracle/oradata/DATAFILE/qas_soainfra.282.947953531';
SET NEWNAME FOR DATAFILE 28 to '/oracledata/app/oracle/oradata/DATAFILE/soaprd_stb.263.960632083';
SET NEWNAME FOR DATAFILE 29 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_users_data.dbf';
SET NEWNAME FOR DATAFILE 32 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_portalprod_system.dbf';
SET NEWNAME FOR DATAFILE 33 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_portalprod_sysaux.dbf';
SET NEWNAME FOR DATAFILE 36 to '/oracledata/app/oracle/oradata/DATAFILE/catdb_system.dbf';
SET NEWNAME FOR DATAFILE 37 to '/oracledata/app/oracle/oradata/DATAFILE/catdb_sysaux.dbf';
SET NEWNAME FOR DATAFILE 38 to '/oracledata/app/oracle/oradata/DATAFILE/tbs_catalog.dbf';
SET NEWNAME FOR DATAFILE 39 to '/oracledata/app/oracle/oradata/DATAFILE/dcloud2.dbf';
SET NEWNAME FOR DATAFILE 44 to '/oracledata/app/oracle/oradata/DATAFILE/hcmodi_wls.346.970670425';
SET NEWNAME FOR DATAFILE 45 to '/oracledata/app/oracle/oradata/DATAFILE/hcmodi_iau.326.970670429';
SET NEWNAME FOR DATAFILE 46 to '/oracledata/app/oracle/oradata/DATAFILE/hcmodi_odi_user.323.970670431';
SET NEWNAME FOR DATAFILE 47 to '/oracledata/app/oracle/oradata/DATAFILE/hcmodi_ias_opss.324.970670433';
SET NEWNAME FOR DATAFILE 48 to '/oracledata/app/oracle/oradata/DATAFILE/hcmodi_stb.350.970670435';
SET NEWNAME FOR DATAFILE 49 to '/oracledata/app/oracle/oradata/DATAFILE/bahealhcm_data.dbf';
SET NEWNAME FOR DATAFILE 50 to '/oracledata/app/oracle/oradata/DATAFILE/bahealbpm_data.dbf';
SET NEWNAME FOR DATAFILE 51 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_bahealhcm_data.dbf';
SET NEWNAME FOR DATAFILE 52 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_bahealbpm_data.dbf';
SET NEWNAME FOR DATAFILE 53 to '/oracledata/app/oracle/oradata/DATAFILE/bahealout_data.dbf';
SET NEWNAME FOR DATAFILE 54 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_bahealout_data.dbf';
SET NEWNAME FOR DATAFILE 55 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_02.dbf';
SET NEWNAME FOR DATAFILE 56 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_03.dbf';
SET NEWNAME FOR DATAFILE 57 to '/oracledata/app/oracle/oradata/DATAFILE/system.360.996936127';
SET NEWNAME FOR DATAFILE 58 to '/oracledata/app/oracle/oradata/DATAFILE/sysaux.356.996936127';
SET NEWNAME FOR DATAFILE 59 to '/oracledata/app/oracle/oradata/DATAFILE/users.357.996936127';
SET NEWNAME FOR DATAFILE 60 to '/oracledata/app/oracle/oradata/DATAFILE/dis_data.361.996936127';
SET NEWNAME FOR DATAFILE 61 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_biplatform.292.957175159';
SET NEWNAME FOR DATAFILE 63 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_ias_portlet.288.957175163';
SET NEWNAME FOR DATAFILE 64 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_ias_iau.318.957175165';
SET NEWNAME FOR DATAFILE 65 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_ias_webcenter.317.957175167';
SET NEWNAME FOR DATAFILE 66 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_ocssearch.289.957175167';
SET NEWNAME FOR DATAFILE 67 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_urmserver.313.957175169';
SET NEWNAME FOR DATAFILE 68 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_ipm.291.957175171';
SET NEWNAME FOR DATAFILE 69 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_orairm.299.957175173';
SET NEWNAME FOR DATAFILE 70 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_ocs.307.957175173';
SET NEWNAME FOR DATAFILE 71 to '/oracledata/app/oracle/oradata/DATAFILE/bahealmon.dbf';
SET NEWNAME FOR DATAFILE 72 to '/oracledata/app/oracle/oradata/DATAFILE/soaprd_system.dbf';
SET NEWNAME FOR DATAFILE 73 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_ias_opss.311.957175179';
SET NEWNAME FOR DATAFILE 74 to '/oracledata/app/oracle/oradata/DATAFILE/soaprd_sysaux.dbf';
SET NEWNAME FOR DATAFILE 75 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_capture.304.957175183';
SET NEWNAME FOR DATAFILE 76 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_ias_discuss.287.957175185';
SET NEWNAME FOR DATAFILE 77 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_ias_activity.310.957175185';
SET NEWNAME FOR DATAFILE 78 to '/oracledata/app/oracle/oradata/DATAFILE/portaluat_mds.290.957175187';
SET NEWNAME FOR DATAFILE 79 to '/oracledata/app/oracle/oradata/DATAFILE/bahealidm_data.dbf';
SET NEWNAME FOR DATAFILE 80 to '/oracledata/app/oracle/oradata/DATAFILE/bahealucm_data.dbf';
SET NEWNAME FOR DATAFILE 81 to '/oracledata/app/oracle/oradata/DATAFILE/dcloud.dbf';
SET NEWNAME FOR DATAFILE 82 to '/oracledata/app/oracle/oradata/DATAFILE/portal_data.dbf';
SET NEWNAME FOR DATAFILE 83 to '/oracledata/app/oracle/oradata/DATAFILE/soaprd_users01.dbf';
SET NEWNAME FOR DATAFILE 84 to '/oracledata/app/oracle/oradata/DATAFILE/bahealoa.dbf';
SET NEWNAME FOR DATAFILE 85 to '/oracledata/app/oracle/oradata/DATAFILE/df_stage_space.dbf';
SET NEWNAME FOR DATAFILE 86 to '/oracledata/app/oracle/oradata/DATAFILE/osb01.dbf';
SET NEWNAME FOR DATAFILE 87 to '/oracledata/app/oracle/oradata/DATAFILE/dsgc_cfg_ts_01.dbf';
SET NEWNAME FOR DATAFILE 88 to '/oracledata/app/oracle/oradata/DATAFILE/dsgc_log_pl_pinited_01.dbf';
SET NEWNAME FOR DATAFILE 89 to '/oracledata/app/oracle/oradata/DATAFILE/dsgc_log_rec_pinited_01.dbf';
SET NEWNAME FOR DATAFILE 90 to '/oracledata/app/oracle/oradata/DATAFILE/dsgc_log_common_01.dbf';
SET NEWNAME FOR DATAFILE 91 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_04.dbf';
SET NEWNAME FOR DATAFILE 92 to '/oracledata/app/oracle/oradata/DATAFILE/soauat_mds02.dbf';
SET NEWNAME FOR DATAFILE 93 to '/oracledata/app/oracle/oradata/DATAFILE/soauat_soainfra02.dbf';
SET NEWNAME FOR DATAFILE 94 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_05.dbf';
SET NEWNAME FOR DATAFILE 95 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_06.dbf';
SET NEWNAME FOR DATAFILE 96 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_07.dbf';
SET NEWNAME FOR DATAFILE 97 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_08.dbf';
SET NEWNAME FOR DATAFILE 98 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_09.dbf';
SET NEWNAME FOR DATAFILE 99 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_10.dbf';
SET NEWNAME FOR DATAFILE 100 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_11.dbf';
SET NEWNAME FOR DATAFILE 101 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_12.dbf';
SET NEWNAME FOR DATAFILE 102 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_13.dbf';
SET NEWNAME FOR DATAFILE 103 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_14.dbf';
SET NEWNAME FOR DATAFILE 104 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_15.dbf';
SET NEWNAME FOR DATAFILE 105 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soaprd_soainfra_16.dbf';
SET NEWNAME FOR DATAFILE 107 to '/oracledata/app/oracle/oradata/DATAFILE/olts_default.340.957371529';
SET NEWNAME FOR DATAFILE 108 to '/oracledata/app/oracle/oradata/DATAFILE/bahealoamuat_ias_opss.343.957371533';
SET NEWNAME FOR DATAFILE 109 to '/oracledata/app/oracle/oradata/DATAFILE/olts_battrstore.342.957371533';
SET NEWNAME FOR DATAFILE 110 to '/oracledata/app/oracle/oradata/DATAFILE/bahealoamuat_mds.347.957371535';
SET NEWNAME FOR DATAFILE 111 to '/oracledata/app/oracle/oradata/DATAFILE/olts_attrstore.344.957371537';
SET NEWNAME FOR DATAFILE 112 to '/oracledata/app/oracle/oradata/DATAFILE/bahealoamuat_apm.345.957371539';
SET NEWNAME FOR DATAFILE 113 to '/oracledata/app/oracle/oradata/DATAFILE/bahealoamuat_ias_iau.335.957371541';
SET NEWNAME FOR DATAFILE 114 to '/oracledata/app/oracle/oradata/DATAFILE/olts_svrmgstore.330.957371543';
SET NEWNAME FOR DATAFILE 115 to '/oracledata/app/oracle/oradata/DATAFILE/olts_ct_store.331.957371545';
SET NEWNAME FOR DATAFILE 116 to '/oracledata/app/oracle/oradata/DATAFILE/bahealoamuat_oam.329.957371547';
SET NEWNAME FOR DATAFILE 117 to '/oracledata/app/oracle/oradata/DATAFILE/bahealoamuat_omsm_ts.333.957371547';
SET NEWNAME FOR DATAFILE 118 to '/oracledata/app/oracle/oradata/DATAFILE/soauat_iau.328.957527675';
SET NEWNAME FOR DATAFILE 119 to '/oracledata/app/oracle/oradata/DATAFILE/soauat_ias_opss.301.957527679';
SET NEWNAME FOR DATAFILE 120 to '/oracledata/app/oracle/oradata/DATAFILE/soauat_ess.337.957527679';
SET NEWNAME FOR DATAFILE 121 to '/oracledata/app/oracle/oradata/DATAFILE/soauat_stb.334.957527681';
SET NEWNAME FOR DATAFILE 122 to '/oracledata/app/oracle/oradata/DATAFILE/soauat_ias_ums.306.957527683';
SET NEWNAME FOR DATAFILE 123 to '/oracledata/app/oracle/oradata/DATAFILE/soauat_soainfra.293.957527685';
SET NEWNAME FOR DATAFILE 124 to '/oracledata/app/oracle/oradata/DATAFILE/soauat_wls.308.957527685';
SET NEWNAME FOR DATAFILE 125 to '/oracledata/app/oracle/oradata/DATAFILE/soauat_mds.300.957527687';
SET NEWNAME FOR DATAFILE 126 to '/oracledata/app/oracle/oradata/DATAFILE/system.371.1107951849';
SET NEWNAME FOR DATAFILE 127 to '/oracledata/app/oracle/oradata/DATAFILE/sysaux.372.1107951849';
SET NEWNAME FOR DATAFILE 128 to '/oracledata/app/oracle/oradata/DATAFILE/system.374.1107951937';
SET NEWNAME FOR DATAFILE 129 to '/oracledata/app/oracle/oradata/DATAFILE/sysaux.375.1107951937';
SET NEWNAME FOR DATAFILE 130 to '/oracledata/app/oracle/oradata/DATAFILE/temp_romens2fi_dev.dbf';
SET NEWNAME FOR DATAFILE 131 to '/oracledata/app/oracle/oradata/DATAFILE/temp_romens2fi_prod.dbf';
SET NEWNAME FOR DATAFILE 134 to '/oracledata/app/oracle/oradata/DATAFILE/odiprd_odi_user.268.958224981';
SET NEWNAME FOR DATAFILE 137 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_ias_orasdpm.273.958234613';
SET NEWNAME FOR DATAFILE 138 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_capture.274.958234615';
SET NEWNAME FOR DATAFILE 139 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_soainfra.277.958234619';
SET NEWNAME FOR DATAFILE 140 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_ipm.278.958234619';
SET NEWNAME FOR DATAFILE 141 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_ias_activity.279.958234621';
SET NEWNAME FOR DATAFILE 142 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_ias_discuss.282.958234625';
SET NEWNAME FOR DATAFILE 143 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_ias_portlet.283.958234625';
SET NEWNAME FOR DATAFILE 144 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_ocssearch.284.958234627';
SET NEWNAME FOR DATAFILE 145 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_biplatform.285.958234627';
SET NEWNAME FOR DATAFILE 146 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_orairm.286.958234629';
SET NEWNAME FOR DATAFILE 147 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_mds.288.958234631';
SET NEWNAME FOR DATAFILE 148 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_ias_webcenter.289.958234631';
SET NEWNAME FOR DATAFILE 149 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_ocs.292.958234635';
SET NEWNAME FOR DATAFILE 150 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_ias_opss.293.958234637';
SET NEWNAME FOR DATAFILE 151 to '/oracledata/app/oracle/oradata/DATAFILE/portalprd_urmserver.294.958234639';
SET NEWNAME FOR DATAFILE 152 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_bahealoa_data.dbf';
SET NEWNAME FOR DATAFILE 153 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_bahealidm_data.dbf';
SET NEWNAME FOR DATAFILE 154 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_dcloud.dbf';
SET NEWNAME FOR DATAFILE 155 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_portal_data.dbf';
SET NEWNAME FOR DATAFILE 156 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_dportal_data.dbf';
SET NEWNAME FOR DATAFILE 176 to '/oracledata/app/oracle/oradata/DATAFILE/soa_stb.301.959687985';
SET NEWNAME FOR DATAFILE 177 to '/oracledata/app/oracle/oradata/DATAFILE/PORTALPROD_soa_servgov.dbf';
SET NEWNAME FOR DATAFILE 178 to '/oracledata/app/oracle/oradata/DATAFILE/olts_default.269.960215845';
SET NEWNAME FOR DATAFILE 179 to '/oracledata/app/oracle/oradata/DATAFILE/olts_battrstore.272.960215845';
SET NEWNAME FOR DATAFILE 181 to '/oracledata/app/oracle/oradata/DATAFILE/olts_attrstore.303.960215849';
SET NEWNAME FOR DATAFILE 187 to '/oracledata/app/oracle/oradata/DATAFILE/olts_svrmgstore.313.960215861';
SET NEWNAME FOR DATAFILE 188 to '/oracledata/app/oracle/oradata/DATAFILE/olts_ct_store.315.960215863';
SET NEWNAME FOR DATAFILE 189 to '/oracledata/app/oracle/oradata/DATAFILE/idmprd_mds.314.960560321';
SET NEWNAME FOR DATAFILE 190 to '/oracledata/app/oracle/oradata/DATAFILE/idmprd_omsm_ts.309.960560323';
SET NEWNAME FOR DATAFILE 191 to '/oracledata/app/oracle/oradata/DATAFILE/idmprd_ias_opss.311.960560325';
SET NEWNAME FOR DATAFILE 192 to '/oracledata/app/oracle/oradata/DATAFILE/idmprd_ias_iau.312.960560327';
SET NEWNAME FOR DATAFILE 193 to '/oracledata/app/oracle/oradata/DATAFILE/idmprd_apm.305.960560329';
SET NEWNAME FOR DATAFILE 194 to '/oracledata/app/oracle/oradata/DATAFILE/idmprd_oam.308.960560331';
restore database root ;
restore database "PDB$SEED" ;
restore pluggable database PORTALTEST;
restore pluggable database PORTALPROD;
restore pluggable database CATDB;
restore pluggable database BIEEDB;
restore pluggable database SOAPRD;
restore pluggable database TEMP_ROMENS2FI_DEV;
restore pluggable database TEMP_ROMENS2FI_PROD;
switch datafile all;
release channel d4;
release channel d3;
release channel d2;
release channel d1;
}

打开数据库

>RMAN alter database open resetlogs；

顺利的话直接打开、不顺利的话根据报错排查trc

#xxxx 为报错的进程id
find / -name  *xxxx*.trc

如果极端情况问题无法解决
可参考此文章中的重建控制文件方式、
Oracle Database 11g RAC 迁移至单机

可能遇到的问题

如果 trc文件中提示asm background 之类的信息
是12.1的bug、需要打补丁解决

如果提示 ACDRROWTSINTCOL#
可能是由于备份文件与数据库版本不一致的原因导致

Oracle database 12cRAC异地恢复至单机

环境 rac 环境 byoradbrac Oracle12.1.0.2 系统版本：Red Hat Enterprise Linux Server release 6.5 软件版本：Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit byoradb1：172.17.38.44 byoradb2：172.17.38.4…...

编程日记 2024/1/7 20:14:45

【docker】linux部署docker

简介首先我需要声明的是，我的系统是centos7，下载工具使用的是yum；在linux上部署docker，之前一直看的是这篇文章Linux之Docker部署，基本上功能方面也都可以使用，部署起来也是比较的简单。首先我先讲述这篇…...

编程日记 2024/1/7 20:10:42

【K8S 云原生】Pod资源限制、Pod容器健康检查（探针）

目录一、docker的重启方式和K8S重启方式 1、Pod的重启方式： 2、docker的重启策略： 二、yaml文件快速生成： 三、pod的状态： 四、Pod的资源限制 1、限制的方式和种类 2、CPU的限制的格式： 五、K8S拉取镜像的策…...

编程日记 2024/1/7 20:09:41

Python从入门到网络爬虫（模块详解）

模块我们知道，函数和类都是可以重复调用的代码块。在程序中使用位于不同文件的代码块的方法是：导入 (import) 该对象所在的模块 (mudule)。当程序变得越来越大时，将程序的不同部分根据不同分类方法保存在不同文件中通常会更加方便。导入模…...

编程日记 2024/1/7 19:57:32

[大厂实践] 无停机迁移大规模关键流量(下)

在系统升级、迁移的过程中，如何验证系统逻辑、性能正确无误，是一个很大的挑战。这一系列介绍了Netflix通过重放流量测试解决这一挑战的实践。原文: Migrating Critical Traffic At Scale with No Downtime — Part 2 想象一下，你被心爱的Netf…...

编程日记 2024/1/7 19:56:31

VMware Workstation虚拟机CentOS 7.9 配置固定ip的步骤

VMware Workstation虚拟机CentOS7.9配置固定ip的步骤编辑虚拟机打开VMware Workstation。选择要配置的虚拟机，但不要启动它。点击“编辑虚拟机设置”（Edit virtual machine settings）。选择“网络适配器”（Network Adapter&…...

编程日记 2024/1/7 19:55:30

构建自己的私人GPT

创作不易，请大家多鼓励支持。在现实生活中，很多人的资料是不愿意公布在互联网上的，但是我们又要使用人工智能的能力帮我们处理文件、做决策、执行命令那怎么办呢？于是我们构建自己或公司的私人GPT变得非常重要。一、本地部署…...

编程日记 2024/1/7 19:53:28

EtherCAT主站SOEM -- 14 --Qt-Soem通过界面采集从站IO进行显示

EtherCAT主站SOEM -- 14 --Qt-Soem通过界面采集从站IO进行显示一 mainwindow.c 文件函数：1.1 自定义PDO配置1.2 主站初始化二 motrorcontrol.c 文件三 allvalue.h 文件该文档修改记录：总结一 mainwindow.c 文件函数： 1.1 自定义PDO配置 int IO_setup(uint16 slave) {int...

编程日记 2024/1/7 19:52:27

线程安全、共享变量的可见性

Java中的线程安全问题谈到线程安全问题，我们先说说什么是共享资源。所谓共享资源，就是说该资源被多个线程所持有或者说多个线程都可以去访问该资源。线程安全问题是指当多个线程同时读写一个共享资源并且没有任何同步措施时，导致出现脏数…...

编程日记 2024/1/7 19:51:26

电动汽车BMS PCB制板的技术分析与可制造性设计

随着电动汽车行业的迅猛发展，各大厂商纷纷投入巨资进行技术研发和创新。电动汽车的核心之一在于其电池管理系统（Battery Management System, BMS），而BMS的心脏则是其印刷电路板（PCB）。通过这篇文章探讨电动…...

编程日记 2024/1/7 19:50:25

Android 车联网——多屏多用户（十五）

前面几篇文章介绍了多用户和多屏相关的 Manager 和 Service。上一篇文章最后虽然车内乘员都根据配置有自己的对应屏幕，但默认情况下，所有车内乘员依然使用的是当前主用户（司机用户），这一篇我们继续放下看一下用户的创建与分配。一、用户创建分配 1、创建用户对于创建用…...

编程日记 2024/1/7 19:49:24

uwsgitop 使用

背景：Django项目 uwsgi，uwsgi.ini 在工程下。使用： 下载安装uwsgitop [roothost ~]# tar -zxvf uwsgitop-0.11.tar.gz [rootuwsgitop-0.11 ~]# cd uwsgitop-0.11/ [rootuwsgitop-0.11 ~]# python setup.py install [rootuwsgitop-0.11 …...

编程日记 2024/1/7 19:45:20

深信服技术认证“SCSA-S”划重点：文件包含漏洞

为帮助大家更加系统化地学习网络安全知识，以及更高效地通过深信服安全服务认证工程师考核，深信服特别推出“SCSA-S认证备考秘笈”共十期内容，“考试重点”内容框架，帮助大家快速get重点知识~ 划重点来啦 *点击图片放大展示深信服…...

编程日记 2024/1/7 19:43:18

Color Control

设计一个优秀的用户界面是一项艰巨的任务。特别是如果你想改变UI的颜色，调整所有元素可能需要花费大量时间。Color Control可以帮助你！在检查器中以可视化的方式将你的项目颜色定义为资源。Color Control为你提供了组件，当你编辑它们时，它们会自动更新你的UI元素。颜色控制…...

编程日记 2024/1/7 19:42:17

端口开放问题

端口开放问题所遇问题在宿主主机上可以ping通虚拟机ip192.168.27.129，但无法在宿主主机上访问http://192.168.27.129:8080navavcat 16连接mysql时，2002 - Can’t connect to server on ‘192.168.27.129’(100601） 原因以上两个问题&a…...

编程日记 2024/1/7 19:40:16

KNN 回归

K 近邻回归（K-Nearest Neighbors Regression）是一种基于实例的回归算法，用于预测连续数值型的输出变量。它的基本思想是通过找到与给定测试样本最近的 K 个训练样本，并使用它们的输出值来预测测试样本的输出。它与 K 最近邻分类类…...

编程日记 2024/1/7 19:38:14

Kali Linux——获取root权限

目录一、设置root密码【操作命令】【操作实例】二、临时获取root权限【操作命令】【操作实例】三、提升用户到root 1、获取root权限 2、进入/etc/passwd 3、查看root账号ID 4、找到需要修改的用户 5、输入i，进入编辑模式 6、把用户的ID改成跟r…...

编程日记 2024/1/7 19:37:13

听GPT 讲Rust源代码--compiler(28)

File: rust/compiler/rustc_codegen_llvm/src/llvm/mod.rs 文件rust/compiler/rustc_codegen_llvm/src/llvm/mod.rs是Rust编译器的LLVM代码生成模块的一个文件。该文件定义了一些用于与LLVM交互的结构体、枚举和常量。此文件的主要作用是： 定义编译器和LLVM之间的接…...

编程日记 2024/1/7 19:36:12

Debezium日常分享系列之：Debezium2.5版本之connector for JDBC

Debezium日常分享系列之：Debezium2.5版本之connector for JDBC 一、概述二、JDBC 连接器的工作原理三、使用复杂的 Debezium 变更事件四、至少一次交付五、多项任务六、数据和列类型映射七、主键处理八、删除模式九、幂等写入十、Schema evolution十一、引用和区分大…...

编程日记 2024/1/7 19:35:11

爬虫网易易盾滑块案例：某乎

声明： 该文章为学习使用，严禁用于商业用途和非法用途，违者后果自负，由此产生的一切后果均与作者无关一、滑块初步分析 js运行 atob(‘aHR0cHM6Ly93d3cuemhpaHUuY29tL3NpZ25pbg’) 拿到网址，浏览器打开网站&#xff0…...

编程日记 2024/1/7 19:34:10

Java 加密常用的各种算法及其选择

在数字化时代，数据安全至关重要，Java 作为广泛应用的编程语言，提供了丰富的加密算法来保障数据的保密性、完整性和真实性。了解这些常用加密算法及其适用场景，有助于开发者在不同的业务需求中做出正确的选择。一、对称加密算法…...

编程新知 2025/7/5 15:23:53

Ascend NPU上适配Step-Audio模型

1 概述 1.1 简述 Step-Audio 是业界首个集语音理解与生成控制一体化的产品级开源实时语音对话系统，支持多语言对话（如中文，英文，日语），语音情感（如开心，悲伤）&#x…...

编程新知 2025/7/4 15:22:36

【C++从零实现Json-Rpc框架】第六弹 —— 服务端模块划分

一、项目背景回顾前五弹完成了Json-Rpc协议解析、请求处理、客户端调用等基础模块搭建。本弹重点聚焦于服务端的模块划分与架构设计，提升代码结构的可维护性与扩展性。二、服务端模块设计目标高内聚低耦合：各模块职责清晰，便于独立开发…...

编程新知 2025/7/4 17:35:30

3-11单元格区域边界定位(End属性)学习笔记

返回一个Range 对象，只读。该对象代表包含源区域的区域上端下端左端右端的最后一个单元格。等同于按键 End 向上键(End(xlUp))、End向下键(End(xlDown))、End向左键(End(xlToLeft)End向右键(End(xlToRight)) 注意：它移动的位置必须是相连的有内容的单元格…...

编程新知 2025/7/3 17:19:47