rac+dg+rman

最新推荐文章于 2024-03-15 20:17:56 发布
最新推荐文章于 2024-03-15 20:17:56 发布
阅读量1.2k 收藏
点赞数
分类专栏： dataguard
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wll_1017/article/details/9445181
版权

一、主库rac情况：

 #public
10.10.6.53 rac1
10.10.6.54 rac2
#private
1.1.1.1 rac1-priv
1.1.1.2 rac2-priv
#virtual
10.10.6.71 rac1-vip
10.10.6.72 rac2-vip
#scan
10.10.6.73 rac-scan

备库：

10.10.6.51

二、数据库版本：

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

三、监听

主：

10.10.6.54

rac=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =10.10.6.54 )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = rac)
    )
  )

orcl =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =10.10.6.51 )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

10.10.6.53：

orcl =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =10.10.6.51 )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
rac =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =10.10.6.53 )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = rac)
    )
  )


备：

[oracle@localhost admin]$ vi   tnsnames.ora 

rac=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.6.53)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.6.54)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = rac)
    )
  )


orcl =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =10.10.6.51 )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

设置静态监听

[oracle@localhost admin]$ vi  listener.ora 
# listener.ora Network Configuration File: /u01/app/product/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
 (SID_LIST =
 (SID_DESC =
      (SID_NAME = orcl)
     (ORACLE_HOME = /u01/app/product)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app

四、添加主库的standby日志

SQL>alterdatabase add standby logfile thread 1

group 7('+data/rac/onlinelog/redo07') size 50M,

group 8('+data/rac/onlinelog/redo08') size 50M,

group 9('+data/rac/onlinelog/redo09') size 50M;

SQL>alterdatabase add standby logfile thread 2

group 10('+data/rac/onlinelog/redo010') size 50M,

group 11('+data/rac/onlinelog/redo011') size 50M,

group 12('+data/rac/onlinelog/redo012') size 50M;

SQL> select * From v$logfile;
    GROUP# STATUS  TYPE    MEMBER IS_
---------- ------- ------- ------------------------------------------------------------ ---
1   ONLINE  +DATA/rac/onlinelog/redo001.log NO
2   ONLINE  +DATA/rac/onlinelog/redo002.log NO
3   ONLINE  +DATA/rac/onlinelog/redo003.log NO
4   ONLINE  +DATA/rac/onlinelog/redo004.log NO
5   ONLINE  +DATA/rac/onlinelog/redo005.log NO
6   ONLINE  +DATA/rac/onlinelog/redo006.log NO
7   STANDBY +DATA/rac/onlinelog/redo07.log NO
8   STANDBY +DATA/rac/onlinelog/redo08.log NO
9   STANDBY +DATA/rac/onlinelog/redo09.log NO
10   STANDBY +DATA/rac/onlinelog/redo10.log NO
11   STANDBY +DATA/rac/onlinelog/redo11.log NO
12   STANDBY +DATA/rac/onlinelog/redo12.log NO

五、参数文件配置

主：拷贝密码文件到备库

主：

scp orapwrac 10.10.6.51:/u01

备库：mv orapwrac  $ORACLE_HOME/dbs/orapworcl


备：vi initorcl.ora

*.audit_file_dest='/u01/app/admin/adump'
*.background_dump_dest='/u01/app/admin/bdump'
*.compatible='11.2.0.1.0'
*.control_files='/u01/app/oradata/control01.ctl','/u01/app/oradata/control02.ctl','/u01/app/oradata/control03.ctl'
*.core_dump_dest='/u01/app/diag/rdbms/orcl/orcl/trace'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='rac'
*.db_recovery_file_dest='/u01/app/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.global_names=FALSE
*.job_queue_processes=10
*.local_listener=''
*.log_archive_dest_1='location=/arc'
*.open_cursors=300
*.pga_aggregate_target=169869312
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=509607936
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/oracle/admin/udump'
*.DB_NAME=rac
*.DB_UNIQUE_NAME=orcl
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(rac,orcl)'
*.LOG_ARCHIVE_DEST_1='LOCATION=/arc VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'
*.LOG_ARCHIVE_DEST_2='SERVICE=rac ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=rac'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
*.LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.FAL_SERVER=orcl
*.fal_client=rac
*.DB_FILE_NAME_CONVERT=''+DATA/rac/datafile/',/u01/app/oradata/'
*.LOG_FILE_NAME_CONVERT='+data/rac/onlinelog','/u01/app/oradata/'
*.STANDBY_FILE_MANAGEMENT=AUTO



主：

alter system set db_unique_name=rac scope=spfile;
alter system set log_archive_config='dg_config=(rac,orcl)' scope=both;
alter system set log_archive_dest_1='LOCATION=+data/log valid_for=(all_logfiles,all_roles) db_unique_name=rac' scope=both;
alter system set log_archive_dest_2='service=orcl OPTIONAL LGWR aSYNC  valid_for=(online_logfiles,primary_role) db_unique_name=orcl' scope=both sid='*';
alter system set log_archive_dest_state_1=enable scope=both;
alter system set log_archive_dest_state_2=enable scope=both;
alter system set remote_login_passwordfile=exclusive scope=spfile;
alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;
alter system set log_archive_max_processes=4 scope=both;
alter system set compatible='11.2.0.1' scope=spfile;
alter system set fal_client='rac' scope=both;
alter system set fal_server='orcl' scope=both;
alter system set standby_file_management=auto scope=both;
alter system set db_file_name_convert='/u01/app/oradata/' ,'+data/rac/datafile/' scope=spfile;
alter system set log_file_name_convert='/u01/app/oradata/' ,'+data/rac/onlinelog' scope=spfile;


六、备份

主：主库和备库设置相同的目录 /u01/backup

RUN { 
allocate channel c1 type disk;
allocate channel c2 type disk;
sql 'alter system archive log current';
backup current controlfile for standby format='/u01/backup/control_%U';
BACKUP FORMAT '/u01/backup/orcl_%U_%T' skip inaccessible filesperset 5 DATABASE ; 
sql 'alter system archive log current';
BACKUP FORMAT '/u01/backup/arch_%U_%T' skip inaccessible filesperset 5 ARCHIVELOG ALL DELETE INPUT; 
release channel c2;
release channel c1;
}


将主库的备份拷贝到备库，相同位置/u01/backup



七、恢复

主：

conn sys/oracle@orcl  as sysdba

startup nomont;

[oracle@localhost backup]$ rman target  sys/oracle@rac auxiliary /
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jul 25 18:17:40 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: RAC (DBID=2407816564)
connected to auxiliary database: RAC (not mounted)
RMAN>  duplicate target database for standby nofilenamecheck dorecover;
Starting Duplicate Db at 25-JUL-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=20 device type=DISK
contents of Memory Script:
{
   set until scn  10067706;
   restore clone standby controlfile;
}
executing Memory Script
executing command: SET until clause
Starting restore at 25-JUL-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/backup/orcl_05ofgitr_1_1_20130724
channel ORA_AUX_DISK_1: piece handle=/u01/backup/orcl_05ofgitr_1_1_20130724 tag=TAG20130724T000853
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/oradata/control01.ctl
output file name=/u01/app/oradata/control02.ctl
output file name=/u01/app/oradata/control03.ctl
Finished restore at 25-JUL-13
contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
Using previous duplicated file /u01/app/oradata/system.256.819834275 for datafile 1 with checkpoint SCN of 9554869
Using previous duplicated file /u01/app/oradata/sysaux.257.819834277 for datafile 2 with checkpoint SCN of 9553560
Using previous duplicated file /u01/app/oradata/undotbs1.258.819834277 for datafile 3 with checkpoint SCN of 9554869
Using previous duplicated file /u01/app/oradata/users.259.819834277 for datafile 4 with checkpoint SCN of 9553560
Using previous duplicated file /u01/app/oradata/undotbs2.267.819834689 for datafile 5 with checkpoint SCN of 9554869

contents of Memory Script:
{
   set until scn  10067706;
   set newname for tempfile  1 to 
 "/u01/app/oradata/temp.266.819834569";
   switch clone tempfile all;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oradata/temp.266.819834569 in control file
contents of Memory Script:
{
   catalog clone datafilecopy  "/u01/app/oradata/system.256.819834275", 
 "/u01/app/oradata/sysaux.257.819834277", 
 "/u01/app/oradata/undotbs1.258.819834277", 
 "/u01/app/oradata/users.259.819834277", 
 "/u01/app/oradata/undotbs2.267.819834689";
   switch clone datafile  1 to datafilecopy 
 "/u01/app/oradata/system.256.819834275";
   switch clone datafile  2 to datafilecopy 
 "/u01/app/oradata/sysaux.257.819834277";
   switch clone datafile  3 to datafilecopy 
 "/u01/app/oradata/undotbs1.258.819834277";
   switch clone datafile  4 to datafilecopy 
 "/u01/app/oradata/users.259.819834277";
   switch clone datafile  5 to datafilecopy 
 "/u01/app/oradata/undotbs2.267.819834689";
}
executing Memory Script
cataloged datafile copy
datafile copy file name=/u01/app/oradata/system.256.819834275 RECID=1 STAMP=821729901
cataloged datafile copy
datafile copy file name=/u01/app/oradata/sysaux.257.819834277 RECID=2 STAMP=821729901
cataloged datafile copy
datafile copy file name=/u01/app/oradata/undotbs1.258.819834277 RECID=3 STAMP=821729901
cataloged datafile copy
datafile copy file name=/u01/app/oradata/users.259.819834277 RECID=4 STAMP=821729901
cataloged datafile copy
datafile copy file name=/u01/app/oradata/undotbs2.267.819834689 RECID=5 STAMP=821729901
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=821729901 file name=/u01/app/oradata/system.256.819834275
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=821729901 file name=/u01/app/oradata/sysaux.257.819834277
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=821729901 file name=/u01/app/oradata/undotbs1.258.819834277
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=821729901 file name=/u01/app/oradata/users.259.819834277
datafile 5 switched to datafile copy
input datafile copy RECID=5 STAMP=821729901 file name=/u01/app/oradata/undotbs2.267.819834689
contents of Memory Script:
{
   set until scn  10067706;
   recover
   standby
   clone database
    delete archivelog
   ;
}
executing Memory Script
executing command: SET until clause
Starting recover at 25-JUL-13
using channel ORA_AUX_DISK_1
starting media recovery
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=128
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=95
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=129
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=96
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_1qofl65i_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_1qofl65i_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/arc/2_128_819834549.arc thread=2 sequence=128
archived log file name=/arc/1_95_819834549.arc thread=1 sequence=95
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_128_819834549.arc RECID=2 STAMP=821729904
archived log file name=/arc/2_129_819834549.arc thread=2 sequence=129
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_95_819834549.arc RECID=1 STAMP=821729903
archived log file name=/arc/1_96_819834549.arc thread=1 sequence=96
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_129_819834549.arc RECID=3 STAMP=821729904
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=130
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=97
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=131
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_1rofl65j_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_1rofl65j_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08
archived log file name=/arc/2_130_819834549.arc thread=2 sequence=130
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_96_819834549.arc RECID=4 STAMP=821729904
archived log file name=/arc/1_97_819834549.arc thread=1 sequence=97
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_130_819834549.arc RECID=7 STAMP=821729917
archived log file name=/arc/2_131_819834549.arc thread=2 sequence=131
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_131_819834549.arc RECID=6 STAMP=821729917
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=132
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=98
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=133
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_1sofl664_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_1sofl664_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
archived log file name=/arc/2_132_819834549.arc thread=2 sequence=132
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_97_819834549.arc RECID=5 STAMP=821729916
archived log file name=/arc/1_98_819834549.arc thread=1 sequence=98
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_132_819834549.arc RECID=10 STAMP=821730019
archived log file name=/arc/2_133_819834549.arc thread=2 sequence=133
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_98_819834549.arc RECID=9 STAMP=821730019
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=99
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=134
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=135
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=100
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=101
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_1tofl66k_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_1tofl66k_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
archived log file name=/arc/1_99_819834549.arc thread=1 sequence=99
archived log file name=/arc/2_134_819834549.arc thread=2 sequence=134
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_99_819834549.arc RECID=15 STAMP=821730081
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_133_819834549.arc RECID=8 STAMP=821730018
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_134_819834549.arc RECID=11 STAMP=821730079
archived log file name=/arc/2_135_819834549.arc thread=2 sequence=135
archived log file name=/arc/1_100_819834549.arc thread=1 sequence=100
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_100_819834549.arc RECID=12 STAMP=821730080
archived log file name=/arc/1_101_819834549.arc thread=1 sequence=101
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_135_819834549.arc RECID=14 STAMP=821730080
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=136
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=102
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=103
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=137
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=138
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_1uofl66n_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_1uofl66n_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
archived log file name=/arc/2_136_819834549.arc thread=2 sequence=136
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_101_819834549.arc RECID=13 STAMP=821730080
archived log file name=/arc/1_102_819834549.arc thread=1 sequence=102
archived log file name=/arc/1_103_819834549.arc thread=1 sequence=103
archived log file name=/arc/2_137_819834549.arc thread=2 sequence=137
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_102_819834549.arc RECID=16 STAMP=821730115
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_136_819834549.arc RECID=17 STAMP=821730115
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_137_819834549.arc RECID=18 STAMP=821730116
archived log file name=/arc/2_138_819834549.arc thread=2 sequence=138
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_138_819834549.arc RECID=19 STAMP=821730116
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=139
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=104
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=105
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=140
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=141
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_1vofl66o_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_1vofl66o_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:04
archived log file name=/arc/2_139_819834549.arc thread=2 sequence=139
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_103_819834549.arc RECID=20 STAMP=821730116
archived log file name=/arc/1_104_819834549.arc thread=1 sequence=104
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_104_819834549.arc RECID=23 STAMP=821730125
archived log file name=/arc/1_105_819834549.arc thread=1 sequence=105
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_139_819834549.arc RECID=24 STAMP=821730125
archived log file name=/arc/2_140_819834549.arc thread=2 sequence=140
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_140_819834549.arc RECID=21 STAMP=821730123
archived log file name=/arc/2_141_819834549.arc thread=2 sequence=141
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_105_819834549.arc RECID=22 STAMP=821730124
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=106
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=107
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=142
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_20ofl670_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_20ofl670_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
archived log file name=/arc/1_106_819834549.arc thread=1 sequence=106
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_106_819834549.arc RECID=28 STAMP=821730152
archived log file name=/arc/1_107_819834549.arc thread=1 sequence=107
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_141_819834549.arc RECID=25 STAMP=821730126
archived log file name=/arc/2_142_819834549.arc thread=2 sequence=142
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_142_819834549.arc RECID=27 STAMP=821730152
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=143
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=108
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_21ofl67h_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_21ofl67h_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/arc/2_143_819834549.arc thread=2 sequence=143
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_107_819834549.arc RECID=26 STAMP=821730151
archived log file name=/arc/1_108_819834549.arc thread=1 sequence=108
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_108_819834549.arc RECID=29 STAMP=821730210
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_143_819834549.arc RECID=30 STAMP=821730211
media recovery complete, elapsed time: 00:00:02
Finished recover at 25-JUL-13

Finished Duplicate Db at 25-JUL-13


SQL> conn /as sysdba
Connected.

备库应用日志：
SQL> alter database  recover managed standby database using current logfile disconnect from session;
Database altered.

查看日志的应用：
SQL> select sequence#,first_time,next_time from v$archived_log order by 1;
 SEQUENCE# FIRST_TIM NEXT_TIME
---------- --------- ---------
95 24-JUL-13 24-JUL-13
96 24-JUL-13 24-JUL-13
97 24-JUL-13 24-JUL-13
98 24-JUL-13 24-JUL-13
99 24-JUL-13 24-JUL-13
       100 24-JUL-13 24-JUL-13
       101 24-JUL-13 24-JUL-13
       102 24-JUL-13 24-JUL-13
       103 24-JUL-13 24-JUL-13
       104 24-JUL-13 25-JUL-13
       105 25-JUL-13 25-JUL-13
       106 25-JUL-13 25-JUL-13
       107 25-JUL-13 25-JUL-13
       108 25-JUL-13 25-JUL-13
       108 25-JUL-13 25-JUL-13
       109 25-JUL-13 25-JUL-13
       128 24-JUL-13 24-JUL-13
       129 24-JUL-13 24-JUL-13
       130 24-JUL-13 24-JUL-13
       131 24-JUL-13 24-JUL-13
       132 24-JUL-13 24-JUL-13
       133 24-JUL-13 24-JUL-13
       134 24-JUL-13 24-JUL-13
       135 24-JUL-13 24-JUL-13
       136 24-JUL-13 24-JUL-13
       137 24-JUL-13 24-JUL-13
       138 24-JUL-13 24-JUL-13
       139 24-JUL-13 25-JUL-13
       140 25-JUL-13 25-JUL-13
       141 25-JUL-13 25-JUL-13
       142 25-JUL-13 25-JUL-13
       143 25-JUL-13 25-JUL-13
       144 25-JUL-13 25-JUL-13
       145 25-JUL-13 25-JUL-13
34 rows selected.

或者通过

/u01/app/diag/rdbms/orcl/orcl/trace/*.log 来查看日志的应用

停止应用日志：

SQL> alter database recover managed standby database cancel;

SQL> alter database open;



出现的错误：

contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/25/2013 01:15:02
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-03114: not connected to ORACLE

解决方法：

修改参数

*.LOG_FILE_NAME_CONVERT='+data/rac/onlinelog/','/u01/app/oradata/',

为

*.LOG_FILE_NAME_CONVERT='+data/rac/onlinelog/','/u01/app/oradata/','+data/asm/onlinelog/','/u01/app/oradata/'


还有，忘记转换了tempfile 文件的路径

*.DB_FILE_NAME_CONVERT='+data/rac/datafile/','/u01/app/oradata/','+data/rac/tempfile','/u01/app/oradata'


 DUPLICATE TARGET DATABASE TO "clone" NOFILENAMECHECK;  

selectdatabase_role,db_unique_name,open_mode,protection_mode,protection_level,switchover_status from v$database；

wluckdog
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle19c RAC+ RACDG配置详细部署文档
07-13
1，Oracle19c RAC+ RACDG配置详细部署文档 2，Oracle19c RAC+ RACDG+racdg2配置详细部署文档 涉及主库备库参数配置、spfile、crs资源配置更新及实施过程中故障排除等； 来自于现实上亿级生产系统的实操记录。
RAC11.2.0.4+单节点物理standby dataguard-rman恢复方式
offbeatmine的专栏
01-18 1392
1.1、dg名词和概念 （1）、primary数据库（主数据库） primary数据库既可以是单实例数据库，也可以是rac结构。 日志传输服务log transport service：包括LGWR/ARCH进程， （2）、standby数据库（从数据库） standby数据库可以视作primary数据库在某个时间点的备份（事务上一致）。standby数据库既可以是单实例数据库，也可以是rac结构。 日志应用服务log apply service：包括RFS（redo transport service，把
第18 章、RMAN 与DG 、RAC
cuiping5771的博客
02-27 128
第18章、RMAN与DG 1. 创建备用控制文件： u SQL方式： SQL中：alter database create standby controlfile as ‘x...
oracle RAC + DG高可用部署
最新发布
qq_61748012的博客
03-15 867
(ADDRESS = (PROTOCOL = TCP)(HOST = 备库主机名)(PORT = 1521)主库参数（重启生效）(itpuxdb主库 itpuxdg备库)数据库架构:Oracle 19c RAC+dataguard。源数据库:Oracle19c RAC(itpuxdb)目标库IP:192.168.1.70 (备库)oracle19c RAC DG 创建过程。oracle19c RAC DG创建过程。oracle19c DB环境准备过程。启动dataguard数据同步。
RAC+DG架构部署（使用备份集）
Baldwin的博客
04-07 1991
本文章为网络资源学习，自己做笔记使用，如有侵权请联系删除！ 概述 RAC全称是Real Application Clusters，中文译为“实时应用集群”，是ORACLE甲骨文公司提供的在低成本服务器上构建高可用性数据库系统的解决方案，部署自由，无需购买额外部件，就可以实现多节点的负载均衡和故障转移功能，满足7*24业务不间断的需求，而且，结合“Oracle数据卫士”（OracleData Gua...
oracle+rac+dg+搭建,Oracle RAC+DG环境搭建（CentOS 7+Oracle 12C）( 十） 部署 DataGuard
weixin_40008566的博客
04-03 1110
一、配置主机1. 设置主机名hostnamectlset-hostnameDG2. 配置网络vim/etc/sysconfig/network-scripts/ifcfg-enp0s3重启网卡systemctlrestartnetwork测试：nslookup重启生效3. 主机环境(1)执行env.sh. 配置环境，脚本如下：(2)执行rpm.sh . 安装依赖包，脚本如下：二、配置共...
Oracle RAC+DG安装流程
minmax329的博客
02-14 353
从Oracle 11g R2开始，Oracle RAC网络对IP地址有特殊要求，新增了加监听IP地址（SCAN IP），所以从Oracle 11g R2开始Oracle RAC网络至少需要4种IP地址（前面介绍三种IP地址）。该特性的好处在于，在数据库与客户端之间，添加了一层虚拟的服务层，就是所谓的SCAN IP以及SCAN IP Listener，在客户端仅需要配置SCAN IP的tns信息，通过SCAN IP Listener，连接后台集群数据库。
Oracle 11g RAC+DG安装配置
08-09
基于Vmware 15 + CentOS 7.6 + Oracle 11g RAC+DG安装配置
Oracle 12c RAC+DG安装配置
08-09
基于Vmware 15 + CentOS 7.6 + Oracle 12c RAC+DG 的安装配置
Oracle 11g RAC+DG 非常牛逼的部署手册
09-19
Oracle 11g RAC+DG 非常牛逼的部署手册
RAC+DG的环境搭建部署
杨建荣的学习笔记
02-23 683
1.1 BLOG文档结构图前言部分1.1.1 导读和注意事项各位技术爱好者，看完本文后，你可以掌握如下的技能，也可以学到一些其它你所不知道的知识，~O(∩_∩)O~：...
部署企业级RAC+DG架构
demonson的专栏
02-23 4913
概述       RAC全称是Real Application Clusters，中文译为“实时应用集群”，是ORACLE甲骨文公司提供的在低成本服务器上构建高可用性数据库系统的解决方案，部署自由，无需购买额外部件，就可以实现多节点的负载均衡和故障转移功能，满足7*24业务不间断的需求，而且，结合“Oracle数据卫士”（OracleData Guard），Oracle RAC所受到的保护就能抵御...
RAC上的DG搭建
zclinux的博客
07-29 3301
准备工作 修改rman_backup这个文件的所有者和所属组，修改为oracle用户的oinstall组的文件 #chown –Roracle:oinstall /rman_backup/ 主库和备库都要执行 RAC主库准备工作： 1.RAC主库必须为归档模式： 查看是否为归档模式，强制日志是否开启 集群当前状态： 将集群数据库停止，为了开启归档，在其
通过 RMAN备份恢复搭建Oracle DG
Hehuyi_In的博客
09-04 3847
平时都是通过RMAN DUPLICATE来搭建dg，今天遇到了问题，只能改换方法。 一、 奇怪的问题 执行RMAN DUPLICATE时发现数据文件传输十分之慢，在约250M/s的磁盘上传输速度居然只有10M/s左右。检查存储、网络、服务器均无异常。查看源库有remote DB file write等待，搜索发现MOS有相关文档RMAN Hangs When Creating Standby DB As Duplicate From Active Primary (文档 ID 2512075.1) 。.
双RAC主备切换流程
xielong8866的博客
10-09 1396
双RAC 主备切换测试
rman duplicate target database RMAN-03002 RMAN-03015 RMAN-06136
03-24 731
通过RMAN的duplicate命令将目标数据库在另一主机上复制一个副本数据库时报以下错误信息： RMAN-00571: ===============================================...
RAC+DG搭建过程
lijingkuan的博客
08-25 5616
环境描述   节点1 节点2 Public IP 192.168.77.185 192.168.77.186 Private IP 192.168.56.101 192.168.56.102 VIP 192.168.77.187 192.168.77.188 scan IP 192.168.77.189    
oracle 12c rac+dg
07-28
抱歉，我无法回答关于Oracle 12c RAC+DG的问题。 #### 引用[.reference_title] - *1* [ORACLE RAC+DG(单实例)](https://blog.csdn.net/weixin_42239187/article/details/94438300)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^koosearch_v1,239^v3^insert_chatgpt"}} ] [.reference_item] - *2* *3* [Oracle 19c rac+adg](https://blog.csdn.net/kiral07/article/details/96855937)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^koosearch_v1,239^v3^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值