使用RMAN异机建立Dataguard

最新推荐文章于 2022-12-20 12:37:29 发布

原创最新推荐文章于 2022-12-20 12:37:29 发布 · 700 阅读

0 ·

CC 4.0 BY-SA版权

DataGuard 专栏收录该内容

13 篇文章

订阅专栏

本文详细介绍了数据库在高可用性环境下的配置步骤，包括建立目录、创建密码文件、PFILE设置、监听器配置、RMAN备份过程，以及主备库之间的同步操作。通过实施这些步骤，可以确保数据库在故障情况下能够快速切换到备用节点，实现业务连续性和数据保护。

1.建立相应目录(备库)

mkdir -p /u01/app/oracle/admin/rac1/adump

mkdir -p /u01/app/oracle/admin/rac1/bdump

mkdir -p /u01/app/oracle/admin/rac1/cdump

mkdir -p /u01/app/oracle/admin/rac1/udump

mkdir -p /u01/app/oracle/oradata/rac1/

mkdir -p /u01/app/oracle/oradata/archivelog/

2.创建密码文件(备库)

orapwd file=$ORACLE_HOME/dbs/orapwrac1 password=sysdba entries=10

3.创建pfile(备库)

拷贝pfile到备库的相应目录下，并修正

增加

*.fal_client='standby'
*.fal_server='primary'

*.standby_archive_dest='/oradata/rac1/archivelog'
*.standby_management='AUTO'

*.service_names=rac1
*.local_listener='(ADDRESS_LIST=(Address=(Protocol=TCP)(Host=192.168.1.98)(Port=1521)) (Adress=(Protocol=IPC)(K
ey=rac1)))'

总的如下:

rac1.__db_cache_size=180355072
rac1.__java_pool_size=4194304
rac1.__large_pool_size=4194304
rac1.__shared_pool_size=92274688
rac1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/rac1/adump'
*.background_dump_dest='/u01/app/oracle/admin/rac1/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/rac1/control01.ctl','/u01/app/oracle/oradata/rac1/control02.ctl','/u01/app/oracle/oradata/rac1/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/rac1/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='rac1'
*.fal_client='standby'
*.fal_server='primary'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/oradata/rac1/archive/'
*.log_archive_format='%t_%s_%r.dbf'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=285212672
*.standby_archive_dest='/u01/app/oracle/oradata/rac1/archive'
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/rac1/udump'
*.service_names=rac1
*.local_listener='(ADDRESS_LIST=(Address=(Protocol=TCP)(HOST=192.168.1.89)(Port=1521)) (Address=(Portocol=IPC)(Key=rac1)))'

主库pfile

rac1.__db_cache_size=180355072
rac1.__java_pool_size=4194304
rac1.__large_pool_size=4194304
rac1.__shared_pool_size=92274688
rac1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/rac1/adump'
*.background_dump_dest='/u01/app/oracle/admin/rac1/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/rac1/control01.ctl','/u01/app/oracle/oradata/rac1/control02.ctl','/u01/app/oracle/oradata/rac1/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/rac1/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='rac1'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/u01/app/oracle/oradata/rac1/archive'
*.log_archive_dest_2='service=standby'
*.log_archive_format='%t_%s_%r.arc'
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=285212672
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/rac1/udump'

4.修改监听

主库 listener.ora

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
   (SID_DESC =
      (GLOBAL_DBNAME = rac1)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME = rac1)
    )
   )

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.88)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
)

主库tnsnames.ora

PRIMARY =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.88)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac1)
    )
)

STANDBY =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.89)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac1)
    )
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
)

备库

listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
   (PROGRAM = extproc)
)
(SID_DESC =
    (GLOBAL_DBNAME =rac1)
    (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
    (SID_NAME = rac1)
)
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.89)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
)

tnsnames.ora

standby =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.89)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac1)
    )
)

primary =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.88)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac1)
    )
)

5.利用RMAN备份主库数据库

RMAN> run {
2> allocate channel d1 device type disk;
3> backup as compressed backupset
4> incremental level=0
5> format='/u01/rmanbak/inc0_%d_%U'
6> tag='inc0'
7> channel=d1
8> database;
9> sql "alter system switch logfile";
10> backup as compressed backupset
11> format='/u01/rmanbak/arch_%d_%U'
12> tag='arch'
13> channel=d1
14> archivelog all delete input;
15> backup as compressed backupset
16> format='/u01/rmanbak/standby.ctl'
17> tag='standby'
18> channel=d1
19> current controlfile for standby reuse;
20> }