修改日期 | 修改人 | 备注 |
2023-01-06 18:14:20[当前版本] | 张奎呈 | 修改标题 |
2023-01-06 18:12:39 | 张奎呈 | CREAT |
步骤一:迁移原数据库相关文件:
1、将数据库实例库文件放置到新服务器的对应位置上:
scp -r data/ root@172.0.128.72:/
2、将该实例的spfile文件放置到新服务器的对应位置上:
scp /opt/oracle/product/19c/dbhome_1/dbs/spfileorcl1.ora root@172.0.127.72:/opt/oracle/product/19c/dbhome_1/dbs/
3、将该实例的adump文件放置到新服务器的对应位置上:
步骤二:在新服务器对相关文件赋权限
chown -R oracle /data chown -R oracle /opt/oracle/product/19c/dbhome_1/dbs/spfileorcl1.ora chown -R oracle /opt/oracle/admin/orcl1 |
步骤三:启动数据库
[root@s72 2022-12-21 11:46:59 ~]# su - oracle Last login: Wed Dec 21 10:17:37 CST 2022 on pts/0 [oracle@s72 ~]$ export ORACLE_SID=orcl1 [oracle@s72 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 21 11:47:15 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ; ORACLE instance started. Total System Global Area 2.0133E+10 bytes Fixed Size 19769056 bytes Variable Size 2885681152 bytes Database Buffers 1.7180E+10 bytes Redo Buffers 47337472 bytes Database mounted. Database opened. |