?
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38709: Recovery Area is not enabled.
?
SQL> show parameter db_recover
?NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest? ? ? ? ? ? ? ? string
db_recovery_file_dest_size? ? ? ? ? big integer 0
SQL> alter system set db_recovery_file_dest_size=5G;
?System altered.
?
SQL> alter system set db_recovery_file_dest='/u01/app/oracle/product/11.2.0/db_1/dbs/arch';
?System altered.
?
SQL> select status from v$instance;
?STATUS
------------
MOUNTED
?SQL> alter database flashback on;
?Database altered.
按之前的规划设置数据库的参数
主要是db_unique_name, log_archive_config, log_archive_dest_1,? log_archive_dest_2, log_archive_format, fal_server, fal_client, standby_file_management的设置，standby logfile的添加，密码文件的创建。
alter system set db_unique_name='jyzhao' scope=spfile;?
alter system set log_archive_config='DG_CONFIG=(jyzhao,jyzhao_s)'? scope=spfile;
?
alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/product/11.2.0/db_1/dbs/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=jyzhao' scope=spfile;?
alter system set log_archive_dest_2='SERVICE=jyzhao_s ASYNC LGWR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=jyzhao_s' scope=spfile;
alter system set log_archive_format='arch_%r_%t_%s.arc' scope=spfile;
alter system set fal_server=jyzhao_s scope=spfile;
alter system set fal_client=jyzhao scope=spfile;
alter system set standby_file_management=AUTO;
alter database add standby logfile group 4 size 50M;
alter database add standby logfile group 5 size 50M;
alter database add standby logfile group 6 size 50M;
alter database add standby logfile group 7 size 50M;
?
rm /u01/app/oracle/product/11.2.0/db_1/dbs/orapwjyzhao
orapwd file=$ORACLE_HOME/dbs/orapwjyzhao password=oracle entries=10 ignorecase=Y?
grid用户配置监听
--listener.ora
DGL =
? (DESCRIPTION =
? ? ? ? (ADDRESS = (PROTOCOL = TCP)(HOST = JY-DB)(PORT = 1521))
? )
?
SID_LIST_DGL =
? (SID_LIST =
? ? ? ? (SID_DESC =
? ? ? ? ? (GLOBAL_DBNAME = jyzhao)
? ? ? ? ? (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
? ? ? ? ? (SID_NAME = jyzhao)? ?
? ? ? ? )? ?
? ? ? ? (SID_DESC =? ? ?
? ? ? ? ? (GLOBAL_DBNAME = jyzhao_dgmgrl)? ? ?
? ? ? ? ? (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)? ? ?
? ? ? ? ? (SID_NAME = jyzhao)
? ? ? ? )?
? ? )? ? ?
? ? ? ? ? ? ? ? ? ? ?
ADR_BASE_DGL = /u01/app/grid
oracle用户配置tnsnames.ora
--tnsnames.ora
LINUXIDC =
? (DESCRIPTION =
? ? (ADDRESS = (PROTOCOL = TCP)(HOST = JY-DB)(PORT = 1521))
? ? (CONNECT_DATA =
? ? ? (SERVER = DEDICATED)
? ? ? (SERVICE_NAME = jyzhao )
? ? )
? )?
LINUXIDC_S =
? (DESCRIPTION =? ?
? ? (ADDRESS = (PROTOCOL = TCP)(HOST = JY-DBS)(PORT = 1521))? ?
? ? (CONNECT_DATA =? ? ?
? ? ? (SERVER = DEDICATED)? ? ?
? ? ? (SERVICE_NAME = jyzhao_s)
? ? )
? )?
grid用户重启监听：
lsnrctl stop dgl
lsnrctl start dgl
oracle用户测试连接：
sqlplus sys/oracle@jyzhao as sysdba
sqlplus sys/oracle@JY-DB/jyzhao_dgmgrl as sysdba
sqlplus sys/oracle@JY-DB/jyzhao as sysdba
?SQL> show parameter audi
?NAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE? ? ? ? VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest? ? ? ? ? ? ? ? ? ? ? string? ? ? /u01/app/oracle/admin/jyzhao/a
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? dump
重启primary
shutdown immediate
startup
2.机器B：standby数据库配置：
grid用户配置监听
--li