SQL*Plus: Release 11.2.0.3.0 Production on Thu Sep 12 09:45:30 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 105
Next log sequence to archive 106
Current log sequence 106
SQL> alter database force logging;
Database altered.
SQL> show parameter db_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string dominic
SQL> show parameter db_unique_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string dominic
SQL> show parameter instance_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string dominic1
SQL> show parameter service_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string dominic
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DATAFILE/dominic/datafile/system.256.825091903
+DATAFILE/dominic/datafile/sysaux.257.825091907
+DATAFILE/dominic/datafile/undotbs1.258.825091909
+DATAFILE/dominic/datafile/users.259.825091909
+DATAFILE/dominic/datafile/example.264.825093429
+DATAFILE/dominic/datafile/undotbs2.265.825093865
+DATAFILE/dominic/datafile/gta_dcsys_data.269.825163105
7 rows selected.
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
+DATAFILE/dominic/onlinelog/group_2.262.825093365
+ARCHIVELOG/dominic/onlinelog/group_2.258.825093381
+DATAFILE/dominic/onlinelog/group_1.261.825093347
+ARCHIVELOG/dominic/onlinelog/group_1.257.825093349
+DATAFILE/dominic/onlinelog/group_3.266.825094085
+ARCHIVELOG/dominic/onlinelog/group_3.259.825094119
+DATAFILE/dominic/onlinelog/group_4.267.825094123
+ARCHIVELOG/dominic/onlinelog/group_4.260.825094125
8 rows selected.
SQL> select * from v$logfile; --(2+1)*2=6组,standby
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
2 ONLINE +DATAFILE/dominic/onlinelog/group_2.262.825093365 NO
2 ONLINE +ARCHIVELOG/dominic/onlinelog/group_2.258.82509338 YES
1
1 ONLINE +DATAFILE/dominic/onlinelog/group_1.261.825093347 NO
1 ONLINE +ARCHIVELOG/dominic/onlinelog/group_1.257.82509334 YES
9
3 ONLINE +DATAFILE/dominic/onlinelog/group_3.266.825094085 NO
3 ONLINE +ARCHIVELOG/dominic/onlinelog/group_3.259.82509411 YES
9
4 ONLINE +DATAFILE/dominic/onlinelog/group_4.267.825094123 NO
4 ONLINE +ARCHIVELOG/dominic/onlinelog/group_4.260.82509412 YES
SQL> alter system set log_archive_config='DG_CONFIG=(dominic,dominic_s)' scope=both sid='*';
System altered.
SQL> alter system set log_archive_dest_1='location=+ARCHIVELOG/archive_log VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dominic' scope=both sid='*';
System altered.
SQL> alter system set log_archive_dest_2='service=dominic_s sync affirm lgwr VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dominic_s' scope=both sid='*';
System altered.
SQL> alter system set log_archive_format='%t_%s_%r.arc' scope=spfile sid='*';
System altered.
SQL> alter system set log_archive_max_processes=4 scope=both sid='*';
System altered.
SQL> alter system set fal_server=dominic scope=both sid='*';
System altered.
SQL> alter system set fal_client=dominic_s scope=both sid='*';
System altered.
SQL> alter system set DB_FILE_NAME_CONVERT='/u01/app/oracle/datafile/','+DATAFILE/dominic/datafile/','/u01/app/oracle/tempfile/','+DATAFILE/dominic/tempfile/' scope=spfile sid='*';
SQL> alter system set LOG_FILE_NAME_CONVERT='/u01/app/oracle/logfile/','+DATAFILE/dominic/onlinelog/','/u01/app/oracle/oradata/','+ARCHIVELOG/dominic/onlinelog/' scope=spfile sid='*';
System altered.
SQL> alter system set standby_file_management=AUTO scope=both sid='*';
System altered.
创建备份文件pfile 文件。
SQL> create pfile='/u01/app/oracle/db_back/p_pfile' from spfile;
File created.
完之后,source RAC 参数文件为:
主的pfile 文件:
[oracle@lmocm189 db_back]$ cat p_pfile
dominic1.__db_cache_size=285212672
dominic2.__db_cache_size=285212672
dominic1.__java_pool_size=16777216
dominic2.__java_pool_size=16777216
dominic1.__large_pool_size=16777216
dominic2.__large_pool_size=16777216
dominic1.__pga_aggregate_target=402653184
dominic2.__pga_aggregate_target=402653184
dominic1.__sga_target=754974720
dominic2.__sga_target=754974720
dominic1.__shared_io_pool_size=0
dominic2.__shared_io_pool_size=0
dominic1.__shared_pool_size=402653184
dominic2.__shared_pool_size=419430400
dominic2.__streams_pool_size=0
dominic1.__streams_pool_size=16777216
*.audit_file_dest='/u01/app/oracle/admin/dominic/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATAFILE/dominic/controlfile/current.260.825093345','+ARCHIVELOG/dominic/controlfile/current.256.825093345'
*.db_block_size=8192
*.db_create_file_dest='+DATAFILE'
*.db_domain=''
*.db_file_name_convert='/u01/app/oracle/datafile/','+DATAFILE/dominic/datafile/'
*.db_name='dominic'
*.db_recovery_file_dest='+ARCHIVELOG'
*.db_recovery_file_dest_size=4558159872
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dominicXDB)'
*.fal_client='DOMINIC_S'
*.fal_server='DOMINIC'
dominic2.instance_number=2
dominic1.instance_number=1
*.log_archive_config='DG_CONFIG=(dominic,dominic_s)'
*.log_archive_dest_1='location=+ARCHIVELOG/archive_log VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dominic'
*.log_archive_dest_2='service=dominic_s sync affirm lgwr VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dominic_s'
*.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=4
*.log_file_name_convert='/u01/app/oracle/logfile/','+DATAFILE/dominic/onlinelog/','/u01/app/oracle/oradata/','+ARCHIVELOG/dominic/onlinelog/'
*.memory_target=1153433600
*.open_cursors=300
*.processes=150
*.remote_listener='scan.com:1521'
*.remote_login_passwordfile='exclusive'
*.sessions=170
*.standby_file_management='AUTO'
dominic2.thread=2
dominic1.thread=1
dominic2.undo_tablespace='UNDOTBS2'
dominic1.undo_tablespace='UNDOTBS1'
4, 根据source 备份pfile 设置target node单实例参数文件:
[oracle@lmocm191 db_back]$ cat s_pfile
*.audit_file_dest='/u01/app/oracle/admin/dominic_s/adump'
*.audit_trail='db'
*.cluster_database=false
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/dominic_s/controlfile/current.260.825093345','/u01/app/oracle/datafile/controlfile/current.256.825093345'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle'
*.db_domain=''
*.db_file_name_convert='+DATAFILE/dominic/datafile/','/u01/app/oracle/datafile/','+DATAFILE/dominic/tempfile/','/u01/app/oracle/tempfile/'
*.db_name='dominic'
*.db_unique_name='dominic_s'
*.db_recovery_file_dest='/u01/app/oracle/oradata/flashback_log'
*.db_recovery_file_dest_size=4558159872
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dominicXDB)'
*.fal_client='DOMINIC_S'
*.fal_server='DOMINIC'
*.log_archive_config='DG_CONFIG=(dominic,dominic_s)'
*.log_archive_dest_1='location=/u01/app/oracle/archive_log VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dominic_s'
*.log_archive_dest_2='service=dominic sync affirm lgwr VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dominic'
*.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=4
*.log_file_name_convert='+DATAFILE/dominic/onlinelog/','/u01/app/oracle/logfile/','+ARCHIVELOG/dominic/onlinelog/','/u01/app/oracle/oradata/'
*.memory_target=1153433600
*.open_cursors=300
*.processes=150
*.remote_listener='scan.com:1521'
*.remote_login_passwordfile='exclusive'
*.sessions=170
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
----其实NODE+NODE 单实例DG 和 RAC+node ,RAC+RAC 参数文件差不多,只是路劲,service,unique_name 有些区别。
5, 如果在之前,SOURCE RAC 不是在归档模式,那么需要在mount下,开启归档。
重启源库,设置为归档模式。
srvctl stop database –d oem –o immediate; srvctl start database
srvctl start database –d oem
注:
重启 11grac2 报错:
srvctl stop database –d oem –o immediate;
srvctl start database –d oem
+ASM2
ORA-00600: internal error code, arguments: [spstp: ORACLE_HOME uid does not match
euid], [504], [500], [], [], [], [], [], [], [], [], []
查看是 grid 用户下的的$oracle_home 目录的权限改变了,全都变成了 oracle:oinstall,
修改成 grid:oinstall 后,ASM 启动正常。
启动实例 2 时候报错:
NOTE: Deferred communication with ASM instance
ERROR: kfnUseConn - failure to make a connection
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
ORA-15055: unable to connect to ASM instance
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
ERROR: kfnUseConn - failure to make a connection
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
ORA-15055: unable to connect to ASM instance
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
ERROR: kfnUseConn - failure to make a connection
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
ORA-15055: unable to connect to ASM instance
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 13: Permission denied
ERROR: kfnUseConn - failure to make a connection
每个节点上$ORACLE_HOME/bin/oracle,$GRID_HOME/bin/oracle 权限应该一样,是
6751:
-rwsr-s—x
检查 11grac2 的这两个文件,发现 GRID_HOME/bin/oracled 的权限为:
-rwxrwxrwx 1 grid oinstall 203973009 Jul 30 21:43 oracle
修改:
chmod 6751 oracle
为:
-rwsr-s--x 1 grid oinstall 203973009 Jul 30 21:43 oracle
数据库重启完毕,检查修改的参数是否正确:
set linesize 500 pages 0
col value for a90
col name for a50
select name, value
from v$parameter
where name in ('db_name','db_unique_name','log_archive_config',
'log_archive_dest_1','log_archive_dest_2',
'log_archive_dest_state_1','log_archive_dest_state_2',
'remote_login_passwordfile',
'log_archive_format','log_archive_max_processes','fal_s
erver','db_file_name_convert',
'log_file_name_convert', 'standby_file_management');
6,SOURCE 端$ORACLE_HOME/dbs 下,拷贝密码文件 到备份目录下:
源库节点一:
orapwd file=/u01/app/oracle/11.2/dbhome_1/dbs/orapwoem1 password=Oracle11 force=y
传递到节点二:
scp /u01/app/oracle/11.2/dbhome_1/dbs/orapwoem1 11grac2:/u01/app/oracle/11.2/dbhome_1/dbs/
mv /u01/app/oracle/11.2.0/db_1/dbs/orapwdominic1 /u01/app/oracle/11.2.0/db_1/dbs/orapwdominic2
传递到目标库:
scp /u01/app/oracle/11.2.0/db_1/dbs/orapwoem1 DGTEST: /app/oracle/11.2.0/db_1/dbs/
mv /app/oracle/11.2.0/db_1/dbs/ orapwoem1 /app/oracle/11.2.0/db_1/dbs/ orapwoem
7,修改源端RAC,目标端node 的监听文件:target: netca, netmgr 都可!
TNSNAME.ORA 文件: target端,source端 都要修改。
[oracle@lmocm191 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
DOMINIC_S =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lmocm191)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dominic)
)
)
DOMINIC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dominic)
)
) --RAC 全局监听
DOMINIC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST=lmocm189)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dominic)
(SID=dominic1)
)
) --RAC 实例1
DOMINIC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST=lmocm190)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dominic)
(SID=dominic2)
)
) --RAC 实例2
[oracle@lmocm191 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = dominic)
(ORACLE_HOME = /u01/app/oracle/product/11.2/dbhome_1)
(SID_NAME = dominic)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lmocm191)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
SOURCE RAC 源端 主备份:
RMAN> run {
2> sql " alter system switch logfile ";
3> sql " alter system switch logfile ";
4> sql " alter system switch logfile ";
5> allocate channel c1 type disk format '/u01/app/oracle/db_back/Primary_for_DG_%U';
6> backup database ;
7> backup current controlfile for standby ;
8> sql " alter system switch logfile ";
9> } --归档可以通过主传送过来,不怕!
sql statement: alter system switch logfile
sql statement: alter system switch logfile
sql statement: alter system switch logfile
allocated channel: c1
channel c1: SID=35 instance=dominic2 device type=DISK
Starting backup at 12-SEP-13
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00007 name=+DATAFILE/dominic/datafile/gta_dcsys_data.269.825163105
input datafile file number=00002 name=+DATAFILE/dominic/datafile/sysaux.257.825091907
input datafile file number=00001 name=+DATAFILE/dominic/datafile/system.256.825091903
input datafile file number=00005 name=+DATAFILE/dominic/datafile/example.264.825093429
input datafile file number=00003 name=+DATAFILE/dominic/datafile/undotbs1.258.825091909
input datafile file number=00006 name=+DATAFILE/dominic/datafile/undotbs2.265.825093865
input datafile file number=00004 name=+DATAFILE/dominic/datafile/users.259.825091909
channel c1: starting piece 1 at 12-SEP-13
channel c1: finished piece 1 at 12-SEP-13
piece handle=/u01/app/oracle/db_back/Primary_for_DG_2pojljpk_1_1 tag=TAG20130912T110835 comment=NONE
channel c1: backup set complete, elapsed time: 00:22:32
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel c1: starting piece 1 at 12-SEP-13
channel c1: finished piece 1 at 12-SEP-13
piece handle=/u01/app/oracle/db_back/Primary_for_DG_2qojll3u_1_1 tag=TAG20130912T110835 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 12-SEP-13
Starting backup at 12-SEP-13
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including standby control file in backup set
channel c1: starting piece 1 at 12-SEP-13
channel c1: finished piece 1 at 12-SEP-13
piece handle=/u01/app/oracle/db_back/Primary_for_DG_2rojll44_1_1 tag=TAG20130912T113116 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:03
Finished backup at 12-SEP-13
sql statement: alter system switch logfile
released channel: c1
[oracle@lmocm191 ~]$ rman target sys/oracle@DOMINIC auxiliary sys/oracle@DOMINIC_S
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Sep 12 15:37:27 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: DOMINIC (DBID=1954767264)
connected to auxiliary database: DOMINIC (not mounted)
RMAN> duplicate target database for standby;
Starting Duplicate Db at 12-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
contents of Memory Script:
{
restore clone standby controlfile;
}
executing Memory Script
Starting restore at 12-SEP-13
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/db_back/Primary_for_DG_2rojll44_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/db_back/Primary_for_DG_2rojll44_1_1 tag=TAG20130912T113116
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/u01/app/oracle/oradata/dominic_s/controlfile/current.260.825093345
output file name=/u01/app/oracle/datafile/controlfile/current.256.825093345
Finished restore at 12-SEP-13
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/app/oracle/tempfile/temp.263.825093419";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/app/oracle/datafile/system.256.825091903";
set newname for datafile 2 to
"/u01/app/oracle/datafile/sysaux.257.825091907";
set newname for datafile 3 to
"/u01/app/oracle/datafile/undotbs1.258.825091909";
set newname for datafile 4 to
"/u01/app/oracle/datafile/users.259.825091909";
set newname for datafile 5 to
"/u01/app/oracle/datafile/example.264.825093429";
set newname for datafile 6 to
"/u01/app/oracle/datafile/undotbs2.265.825093865";
set newname for datafile 7 to
"/u01/app/oracle/datafile/gta_dcsys_data.269.825163105";
restore
clone database
;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/tempfile/temp.263.825093419 in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 12-SEP-13
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/datafile/system.256.825091903
channel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/app/oracle/datafile/sysaux.257.825091907
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/datafile/undotbs1.258.825091909
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/datafile/users.259.825091909
channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/app/oracle/datafile/example.264.825093429
channel ORA_AUX_DISK_1: restoring datafile 00006 to /u01/app/oracle/datafile/undotbs2.265.825093865
channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/app/oracle/datafile/gta_dcsys_data.269.825163105
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/db_back/Primary_for_DG_2pojljpk_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/db_back/Primary_for_DG_2pojljpk_1_1 tag=TAG20130912T110835
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:22:51
Finished restore at 12-SEP-13
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=10 STAMP=825955264 file name=/u01/app/oracle/datafile/system.256.825091903
datafile 2 switched to datafile copy
input datafile copy RECID=11 STAMP=825955264 file name=/u01/app/oracle/datafile/sysaux.257.825091907
datafile 3 switched to datafile copy
input datafile copy RECID=12 STAMP=825955265 file name=/u01/app/oracle/datafile/undotbs1.258.825091909
datafile 4 switched to datafile copy
input datafile copy RECID=13 STAMP=825955265 file name=/u01/app/oracle/datafile/users.259.825091909
datafile 5 switched to datafile copy
input datafile copy RECID=14 STAMP=825955265 file name=/u01/app/oracle/datafile/example.264.825093429
datafile 6 switched to datafile copy
input datafile copy RECID=15 STAMP=825955265 file name=/u01/app/oracle/datafile/undotbs2.265.825093865
datafile 7 switched to datafile copy
input datafile copy RECID=16 STAMP=825955265 file name=/u01/app/oracle/datafile/gta_dcsys_data.269.825163105
Finished Duplicate Db at 12-SEP-13
RMAN> exit
同时 alter database recover managed standby database disconnect from session 打开,接受日志应用。--异步的使用日志
--使用 ALTER DATABASE 语句来允许实时应用特性,如下:
对于物理备数据库,执行 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE 语句。
对于逻辑备数据库,执行ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE 语句。
9.5: 检测
检查主库备库归档目标状态:
select dest_id,status,destination,error from v$archive_dest where dest_id<=5;
--根据error信息查找,密码主备不同的话,会报错。
查看备用数据库的日志应用情况:
select sequence#,first_time,next_time,applied from v$archived_log order by sequence#;