18C搭建OGG迁移19C.txt - 墨天轮文档

18C搭建OGG迁移19C.txt

默人

2311

9页

18次

2021-06-15

5墨值下载

在原有的 18C 上部署 OGG 程序，以及做数据库备份

查看语言字符集

select userenv('language') from dual;

USERENV('LANGUAGE')

----------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

select parameter, value from nls_database_parameters where parameter like

'%CHARACTERSET%';

PARAMETER VALUE

------------------------------ ------------------------------

NLS_NCHAR_CHARACTERSET AL16UTF16

NLS_CHARACTERSET AL32UTF8

select * from v$nls_parameters;

PARAMETER VALUE CON_ID

------------------------------ ------------------------------ ----------

NLS_LANGUAGE AMERICAN 0

NLS_TERRITORY AMERICA 0

NLS_CURRENCY $ 0

NLS_ISO_CURRENCY AMERICA 0

NLS_NUMERIC_CHARACTERS ., 0

NLS_CALENDAR GREGORIAN 0

NLS_DATE_FORMAT YYYY-MM-DD hh24:mi:ss 0

NLS_DATE_LANGUAGE AMERICAN 0

NLS_CHARACTERSET AL32UTF8 0

NLS_SORT BINARY 0

NLS_TIME_FORMAT HH.MI.SSXFF AM 0

NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM 0

NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR 0

NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR 0

NLS_DUAL_CURRENCY $ 0

NLS_NCHAR_CHARACTERSET AL16UTF16 0

NLS_COMP BINARY 0

NLS_LENGTH_SEMANTICS BYTE 0

NLS_NCHAR_CONV_EXCP FALSE 0

1、打开最小附加日志

alter database add supplemental log data;

2、打开归档

STARTUP MOUNT

ALTER DATABASE ARCHIVELOG;

ALTER DATABASE OPEN;

archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination +DATADG

Oldest online log sequence 41

Next log sequence to archive 43

Current log sequence 43

3、打开强制归档

alter database force logging;

select force_logging, supplemental_log_data_min from v$database;

FORCE_LOGGING SUPPLEME

--------------------------------------- --------

YES YES

4、设置归档路径

ASM

alter system set log_archive_dest_1= 'location=+datadg' scope=both sid='*';

文件系统

alter system set log_archive_dest_1='location=/arch' scope=both sid='*

show parameter log_archive_dest_1

NAME TYPE VALUE

------------------------------------ -----------

------------------------------

log_archive_dest_1 string location=+datadg

log_archive_dest_10 string

log_archive_dest_11 string

log_archive_dest_12 string

log_archive_dest_13 string

log_archive_dest_14 string

log_archive_dest_15 string

log_archive_dest_16 string

log_archive_dest_17 string

log_archive_dest_18 string

log_archive_dest_19 string

5、rman 备份

run{

allocate channel c1 device type disk;

allocate channel c2 device type disk;

allocate channel c3 device type disk;

backup as backupset filesperset 2 database format '/orabak/rman/database_%T_%s_

%d_%p'

skip inaccessible;

sql 'alter system archive log current';

backup archivelog all format '/orabak/rman/arch_%d_%T_%s_%p' delete all input;

backup spfile format '/orabak/rman/spfile_%d_%T_%s_%p';

backup current controlfile format '/orabak/rman/contl_%d_%T_%s_%p';

}

6、scp 传输给 19C 服务器

scp 18Cbak.tar.gz oracle@192.168.100.98:/orabak/rman