个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2023-06-18 12:47:52
-
1. win上的主库先停1次，做冷备
-
rman target /
-
backup database format 'd:\bak\full_%u';
-
backup current controlfile format 'd:\bak\control_%u';
-
-
传输pfile和备份集到linux
-
-
2. 在linux上启动并恢复
-
startup nomount pfile=i.ora
-
rman target /
-
restore standby controlfile from '/bak/ccontrol_aabb';
-
sql 'alter database mount';
-
crosscheck backup;
-
delete expired backup;
-
catalog backuppiece '/bak/';
-
run {
-
set newname for database to '/oradata/orcl/datafile_%u';
-
restore database;
-
}
-
switch database to copy;
-
alter database recover managed standby database disconnect from session;
-
-
3. 参考doc id 1984091.1配置主备库
-
-
-
4. 确定linux上的数据同步后
-
alter database activate standby database;
-
关闭win上的库
-
-
5. 升级linux上的版本（这边是19c）
-
shutdown immediate
-
startup upgrade
-
@?/rdbms/admin/utlu112i.sql有待完善 -
@?/rdbms/admin/catupgrd.sql
-
startup
-
@?/rdbms/admin/utlu112s.sql
-
@?/rdbms/admin/catuppst.sql
-
execute dbms_stats.gather_fixed_objects_stats;
-
@?/rdbms/admin/utlrp.sql
-
select distinct object_name from dba_invalid_objects;
-
-
6. 添加服务重启检查
-
srvctl add database -d <db_unique_name> -o <oracle_home> -n <db_name> -p <spfile> -s <start_options> -t <stop_options>
-
-r primary -y automatic -a <disk_group_list>
-
shutdown immediate
-
startup
-
-
-
how to migrate 11g database running on windows to linux and upgrade to 19c using data guard with minimum downtime (doc id 2950115.1)
- migrating database to another host with higher oracle home version using data guard (doc id 2508481.1)
给主人留下些什么吧！~~