oracle11g dataguard物理备库搭建（关闭主库cp数据文件到备库）-白红宇的个人博客

oracle11g dataguard物理备库搭建（关闭主库cp数据文件到备库）

发布日期：2025-04-29 23:43:46 浏览次数：15 分类：精选文章

本文共 3681 字，大约阅读时间需要 12 分钟。

Data Guard????

1. Primary?????

????Primary????Data Guard???

1.1??Data Guard?

SQL> $ sqlplus '/as sysdba'

SQL> select * from v$option where parameter = 'Managed Standby';

2.2??archive???

SQL> archive log list

SQL> startup mount
SQL> alter database archivelog;

2.3??force logging?

SQL> alter database force logging;

2.4??Redo????

SQL> alter database add standby logfile group 4 ('/u01/app/oracle/oradata/ora11g/stdby_redo04.log') size 50m;

SQL> alter database add standby logfile group 5 ('/u01/app/oracle/oradata/ora11g/stdby_redo05.log') size 50m;
SQL> alter database add standby logfile group 6 ('/u01/app/oracle/oradata/ora11g/stdby_redo06.log') size 50m;
SQL> alter database add standby logfile group 7 ('/u01/app/oracle/oradata/ora11g/stdby_redo07.log') size 50m;

2.5??Redo????

standby redolog (online redolog + 1) * (1) RAC 2

2. Standby?????

2.1??Standby?????

SQL> alter database create standby controlfile as '/u01/standby_ctl01.ctl';

2.2??listener.ora?

Listener.ora?????

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ora11g)(SID_NAME = ora11g)(ORACLE_HOME = /home/db/oracle/product/11.2.0/dbhome_1)))

LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DG-Primary)(PORT = 1521))))

ADR_BASE_LISTENER = /u01/app/oracle

tnsnames.ora???

ORA11G_PRIMARY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.122)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ora11g)))

ORA11G_STANDBY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.123)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = ora11g)))

3. ???????

3.1???????

mkdir -p $ORACLE_BASE/oradata/ora11g

mkdir -p $ORACLE_BASE/admin/ora11g
mkdir -p $ORACLE_BASE/admin/ora11g/adump
mkdir -p $ORACLE_BASE/admin/ora11g/bdump
mkdir -p $ORACLE_BASE/admin/ora11g/cdump
mkdir -p $ORACLE_BASE/admin/ora11g/dpdump
mkdir -p $ORACLE_BASE/admin/ora11g/pfile
mkdir -p $ORACLE_BASE/admin/ora11g/udump
mkdir -p $ORACLE_BASE/diag/rdbms
mkdir -p $ORACLE_BASE/diag/tnslsnr
mkdir -p $ORACLE_BASE/flash_recovery_area/ora11g
mkdir -p $ORACLE_BASE/flash_recovery_area/ORA11g
mkdir -p $ORACLE_BASE/archive

3.2??????Standby????

$ scp $ORACLE_BASE/oradata/.dbf 192.168.1.123:$ORACLE_BASE/oradata/ora11g

$ scp $ORACLE_BASE/oradata/.log 192.168.1.123:$ORACLE_BASE/oradata/ora11g
$ scp /u01/standby_ctl01.ctl 192.168.1.123:$ORACLE_BASE/oradata/ora11g
$ scp $ORACLE_HOME/dbs/initora11g.ora 192.168.1.123:$ORACLE_HOME/dbs/

4. Data Guard??

4.1??Data Guard?

SQL> shutdown immediate

SQL> startup
SQL> alter database create standby controlfile as '/u01/standby_ctl01.ctl';

4.2??Data Guard???

SQL> select open_mode, database_role from v$database;

OPEN_MODE DATABASE_ROLE

5. Switchover?Failover

5.1 Switchover???

5.1.1?Primary???????

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE; -- ??SWITCHOVER_STATUS

5.1.2?????

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;

5.1.3??????

SQL> shutdown immediate

SQL> startup nomount
SQL> alter database mount standby database;

5.1.4?Standby???????

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

5.2 Failover???

SQL> alter database recover managed standby database finish;

SQL> alter database commit to switchover to primary;

5.3?????

SQL> alter database recover managed standby database using current logfile disconnect from session;

6. ???????

6.1??archive_dest???

SQL> select dest_name, status, error from v$archive_dest;

6.2??Redo???

alter database add/drop logfile

alter database add/drop standby logfile member
alter database create datafile as;

6.3Switchover???

SQL> alter database commit to switchover to physical standby with session shutdown;

6.4??Dataguard???

SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;

上一篇：Oracle11G基本操作

下一篇：Oracle10g安装了11g的ODAC后，PL/SQL连接提示TNS：无法解析指定的连接标识符

发表评论

关于作者

喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！

-- 愿君每日到此一游！