OFF-LINE

一、最大性能转换至最大可用 确认主库模式： SYS@enmo2 hey~2->select protection_mode,protection_level from v$database; PROTECTION_MODE PROTECTION_LEVEL -------------------- -------------------- MAXIMUM PERFORMANC

切换前enmo1为主库，enmo2为备库 [oracle@enmo1 admin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat May 6 10:14:57 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. C

SQL> select database_role,open_mode from v$database; DATABASE_ROLE OPEN_MODE ---------------- -------------------- PHYSICAL STANDBY MOUNTED 取消应用日志 SQL> alter database recover managed standb

SQL> select database_role,open_mode from v$database; DATABASE_ROLE OPEN_MODE ---------------- -------------------- PHYSICAL STANDBY READ ONLY WITH APPLY SQL> alter database recover managed sta

因为搭建DG时备库中的db_name为SBCD,实际应该是主库db_name的PROD1 所以在【主库】执行如下rman操作命令时会报错控制文件记录的数据库名与实际拷贝的数据库名不相同 RMAN> duplicate target database for standby from active database; Starting Duplicate Db at 01-MAY-

准备工作： 1、开启归档 SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch Oldest online log seque