oracle12c到19c adg搭建（六）切换后12c备库服务器安装19c软件在19c主库升
一、安装19c软件参考文章oracle12c到19c adg搭建（三）oracle19c数据库软件安装
二、原主库尝试通过19c软件启动数据库
2.1复制12c的相干参数文件和密码文件到19c目录
注意:密码文件需要从已切换主库19c传过来
$ cd /u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/
$ ls
hc_orcl.dat init.ora initorcl.ora lkORCL orapworcl snapcf_orcl.f spfileorcl.ora
$ cp * /u01/app/oracle/product/19.3.0.0/dbhome_1/dbs/
$ cd /u01/app/oracle/product/19.3.0.0/dbhome_1/dbs/
$ ls
hc_orcl.dat init.ora initorcl.ora lkORCL orapworcl snapcf_orcl.f spfileorcl.ora
$
2.2主库天生控制文件
SQL> ALTER DATABASE CREATE standby controlfile AS '/backup/orcl.ctl';
Database altered.
$ scp orcl.ctl oracle@o12u19p:/backuphttps://i-blog.csdnimg.cn/blog_migrate/2b8d73f00e913f61a09e8b831dee5e38.png
2.3规复控制文件
$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jun 19 10:02:39 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 6174013840 bytes
Fixed Size 9148816 bytes
Variable Size 1056964608 bytes
Database Buffers 5100273664 bytes
Redo Buffers 7626752 bytes
SQL>
RMAN> restore controlfile from'/backup/orcl.ctl';
Starting restore at 19-JUN-24
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=21 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=/u01/app/oracle/oradata/orcl/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/orcl/control02.ctl
Finished restore at 19-JUN-24
RMAN>
2.4复制12c监听文件到19c目录下并启动监听文件
$ cd /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/
$ scp * /u01/app/oracle/product/19.3.0.0/dbhome_1/network/admin/
cp: omitting directory ‘samples’
$ ls
listener.ora samples shrept.lst sqlnet.ora tnsnames.ora
$ lsnrclt start
bash: lsnrclt: command not found...
$ lsnrctl start
https://i-blog.csdnimg.cn/blog_migrate/ac2dbedf62f8d37caf301fc372226872.png
2.5备库开库
$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jun 19 10:29:44 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> alter database open
2 ;
报错:
https://i-blog.csdnimg.cn/blog_migrate/742ca16abcd19b464a08bc38e5afb049.png
https://i-blog.csdnimg.cn/blog_migrate/79cd4b3564cb217739d40fd7561c373b.png
由于控制文件的scn和数据文件的scn差别过大导致
2.6尝试从主库拷贝一些日志到备库 备库尝试日志应用
$ cd /u01/app/oracle/oradata/
$ ls
orcl orcldg
$ cd orcldg/
$ ls
arch pdb1 pdbseed sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf
$ cd arch/
$ ls
https://i-blog.csdnimg.cn/blog_migrate/bef2b371e0f1bfbe10904becf045acc1.png
备库日志到1-27
https://i-blog.csdnimg.cn/blog_migrate/4669c1053bce38cef680c08573b1a1bb.png
主库从1-28开始拷贝
$ scp 1_28_1171969607.dbf 1_28_1171991791.dbf 1_29_1171991791.dbf 1_30_1171991791.dbf 1_31_1171991791.dbf oracle@o12u19p:/u01/app/oracle/oradata/orcl/arch
https://i-blog.csdnimg.cn/blog_migrate/b2b7adb1081325d0c76feb48287cf14d.png
2.7开启日志应用
alter database recover managed standby database using current logfile disconnect from session;
https://i-blog.csdnimg.cn/blog_migrate/6a8b39ad6b5fd1ec2fbef62646cd93d2.png
2.8主备库打开pdb
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
SQL> alter pluggable database pdb1 open;
Pluggable database altered.
三、主备库同步检查
主库查看seq
SQL> select sequence#,applied from v$archived_log order by sequence# asc;
https://i-blog.csdnimg.cn/blog_migrate/66e27f228937664d9f1f8400d2c3f600.png
备库查看seq
https://i-blog.csdnimg.cn/blog_migrate/11db299a734646d0bbeb95d7c6dd307b.png
可以看到备库已经开始同步主库的日志从283开始。
至此我们完成了12c到19cadg的搭建及12c滚动升级到19c的过程
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
页:
[1]