oracle rac改成单机,oracle 12C RAC 迁移到单机

本帖最后由 lihfe 于 2020-5-9 19:06 编辑

环境说明：

RAC、单机：

操作系统：Redhat Linux6.5

数据库：Oracle 12.1.0.2

操作步骤：

1、对RAC环境进行备份(每周日0级备份，周一到周六累计增量备份)，1级备份脚本：

0级备份脚本：

#!/bin/bash

# incremental level 0 backup script

source /home/oracle/.bash_profile

current_day=`date +%Y%m%d`

mkdir /nfsbackup/oracle12c/arch/$current_day

rman target / <

run

{

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/nfsbackup/oracle12c/arch/$current_day/PID-%F';

allocate channel c1 type disk;

allocate channel c2 type disk;

backup incremental level 0 tag='db0'

format '/nfsbackup/oracle12c/arch/$current_day/%n_%T_%U' database;

sql 'alter system archive log current';

backup archivelog all format '/nfsbackup/oracle12c/arch/$current_day/arc_%n_%T_%U' delete all input;

release channel c1;

release channel c2;

}

EOF

1级备份脚本：

#!/bin/bash

# incremental level 1 backup script

source /home/oracle/.bash_profile

current_day=`date +%Y%m%d`

incr_day=incr$current_day

mkdir /nfsbackup/oracle12c/arch/$incr_day

rman target / <

run

{

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE