三、主库配置
1. 设置数据库归档
查看数据库是否运行在归档模式： SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled #未开启归档 Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 117 Current log sequence 119 SQL> 备注：如果数据库已经开启归档，下面的操纵可以忽略。 如上所示未开启归档，可按下面方法开启数据库归档 SQL> shutdownimmediate #关闭数据库 Database closed. Database dismounted. ORACLE instance shut down. SQL> startupmount; #启动到mount状态 ORACLE instance started. Total System Global Area 688959488 bytes Fixed Size 2256432 bytes Variable Size 566231504 bytes Database Buffers 117440512 bytes Redo Buffers 3031040 bytes Database mounted. SQL> alterdatabase archivelog; #开启归档 Database altered. SQL> alterdatabase open; #open数据库 Database altered. SQL> altersystem set log_archive_dest_1='location=/data/CEBPM/archivelog'; #设置归档路径 System altered. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /data/CEBPM/archivelog Oldest online log sequence 119 Next log sequence to archive 121 Current log sequence 121
2. 设置数据库闪回
验证是否开启闪回 SQL> select flashback_on fromv$database; FLASHBACK_ON ------------------ NO 备注：如果数据库已经开启flashback，那么下面步骤可忽略。 如上显示，该数据库未开启flashback，可按下面方法开启。 SQL> altersystem set db_recovery_file_dest='/data/CEBPM'; #设置闪回去路径 System altered. SQL> altersystem set db_recovery_file_dest_size='5G'; #设置闪回区大小 System altered. SQL> shutdownimmediate; #关闭数据库 Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 688959488 bytes Fixed Size 2256432 bytes Variable Size 566231504 bytes Database Buffers 117440512 bytes Redo Buffers 3031040 bytes Database mounted. SQL> alterdatabase flashback on; #开启闪回 Database altered. SQL> alterdatabase open; #open数据库 Database altered. SQL> selectflashback_on from v$database; #验证是否开启 FLASHBACK_ON ------------------ YES
3. 设置数据库强制归档
验证是否开启focelogging SQL>select force_logging from v$database; FOR --- NO 如果数据库已经开启force logging，那么下面步骤可忽略。 如上可以看出数据库未开启，则按下面步骤执行： SQL>alter database force logging; #开启force logging Databasealtered. SQL>select force_logging fromv$database; #验证 FOR --- YES
4. 添加数据库 standby 日志
通过下面语句可以查询主库在线日志的大小和组数： SQL> select group#,bytes/1024/1024 from v$log; 通过下面的语句可以查询备库 Standby 日志的大小和组数： SQL> select group#,bytes/1024/1024 from v$standby_log; 创建 standby logfile SQL> alter database add standby logfile group 11 '/u01/app/oracle/oradata/orcl/redo11_stb01.log' size 50M; SQL> alter database add standby logfile group 12 '/u01/app/oracle/oradata/orcl/redo12_stb01.log'size 50M; SQL> alter database add standby logfile group 13 '/u01/app/oracle/oradata/orcl/redo13_stb01.log'size 50M; SQL> alter database add standby logfile group 14 '/u01/app/oracle/oradata/orcl/redo14_stb01.log'size 50M;
5. 修改参数文件
SQL> create pfile='/home/oracle/initorcl.ora' from spfile; File created. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup pfile='/home/oracle/initorcl.ora' ORACLE instance started. Total System Global Area 308981760 bytes Fixed Size 2252784 bytes Variable Size 167772176 bytes Database Buffers 134217728 bytes Redo Buffers 4739072 bytes Database mounted. Database opened. SQL> create spfile from pfile; [root@localhost dbs]# cp /home/oracle/initorcl.ora initorcl.ora [root@localhost ~]# vim /home/oracle/initorcl.ora orcl.__sga_target=310378496 orcl.__shared_io_pool_size=0 orcl.__shared_pool_size=130023424 orcl.__streams_pool_size=4194304 *.audit_file_dest='/u01/app/oracle/admin/orcl/adump' *.audit_trail='db' *.compatible='11.2.0.4.0' *.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/fast_recovery_area/orcl/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='orcl' *.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area' *.db_recovery_file_dest_size=1073741824 *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)' *.log_archive_format='%t_%s_%r.dbf' *.open_cursors=300 *.pga_aggregate_target=102760448 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=308281344 *.undo_tablespace='UNDOTBS1' DB_UNIQUE_NAME=orcl LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,orcl)' DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/orcl/','/u01/app/oracle/oradata/orcl/' LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/orcl/','/u01/app/oracle/oradata/orcl/' LOG_ARCHIVE_DEST_2= 'SERVICE=orcl LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl' LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE STANDBY_FILE_MANAGEMENT=AUTO FAL_SERVER=orcl FAL_CLIENT=orcl
