【dataguard】使用deplicate创建异机的dataguard

最新推荐文章于 2024-09-09 22:34:29 发布
最新推荐文章于 2024-09-09 22:34:29 发布
阅读量158 收藏
点赞数
文章标签： 数据库 网络 操作系统
原文链接：https://yq.aliyun.com/articles/28419
版权

版本：11gr2  环境：linux

实施dg的方法有很多种，这里介绍使用oracle提供的deplicate复制功能建立异机的dg的方法。对于备库安装和主库一样路径的软件和数据存放结构。配置参数文件，监听文件，启动到nomount状态后，就可以在主库上使用rman进行建立dg！

一前期准备工作
---对于主库：
1 开启归档功能
shutdown normal
shutdown immediate
startup mount
alter database archivelog;
alter database open;
--设置归档路径
alter system set log_archive_format = "archive_%t_%s_%r.log" scope=spfile;
alter system set log_archive_dest_1='LOCATION=/home/opt/oracle/archive_log';
alter database force logging;
2 拷贝源库的密码文件到备库主机和主机的一样的路径。
3 修改spfile参数文件。
db_name=yangql
alter system set db_unique_name=yangql scope=spfile;
alter system set log_archive_config='dg_config=(yangql,yangqldg)' scope=both;
alter system set log_archive_dest_1='LOCATION=/home/opt/oracle/archive_log' scope=both;
alter system set log_archive_dest_2='SERVICE=yangqldg LGWR ASYN VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLES) DB_UNIQUE_NAME=yangqldg' scope=both;
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=30 scope=spfile;
alter system set FAL_SERVER=yangqldg scope=both;
alter system set FAL_CLIENT=yangql scope=both;
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT =AUTO SCOPE=both;
4 修改listener.ora  tnames.ora文件
---listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = pre_publish)(PORT = 1521))
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = yangql)
      (ORACLE_HOME = /home/opt/oracle/products/11.2.0)
      (SID_NAME = yangql)
    )
  )

----tnsnames.ora-----
yangql =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.112.230)(PORT = 1521))
    )
    (CONNECT_DATA =
      (server = dedicated)
      (service_name = yangql)
    )
  )


yangqldg =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.87.199)(PORT = 1521))
    )
    (CONNECT_DATA =
      (server = dedicated)
      (service_name = yangql)
    )
  )
----备库操作

---备库的参数文件yangqldg.ora中关于dg的部分内容----
db_name=yangql
db_unique_name=yangqldg
log_archive_config='db_config=(yangqldg,yangql)'
log_archive_dest_1='LOCATION=/home/opt/oracle/archive_log'
log_archive_dest_2='SERVICE=yangql LGWR ASYN VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLES) DB_UNIQUE_NAME=yangql'
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable/defer
remote_login_passwordfile=exclusive
log_archive_format=%t_%s_%r.arc
log_archive_max_processes=30
FAL_SERVER=yangqldg
FAL_CLIENT=yangql


-----listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = alibank_pre_publish)(PORT = 1521))
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = yangql)
      (ORACLE_HOME = /home/opt/oracle/products/11.2.0)
      (SID_NAME = yangql)
    )
  )

----tnsnames.ora-----
yangql =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.112.230)(PORT = 1521))
    )
    (CONNECT_DATA =
      (server = dedicated)
      (service_name = yangql)
    )
  )
 
yangqldg =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.87.199)(PORT = 1521))
    )
    (CONNECT_DATA =
      (server = dedicated)
      (service_name = yangql)
    )
  )
--rman 复制
--启动备库到nomount状态
sqlplus "/as sysdba"
startup nomount pfile='/yangqldg.ora'

--执行duplicate standby 库
主库登陆rman，并auxiliary连接备库
oracle>rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Apr 26 14:42:24 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: yangql (DBID=3584031961)
RMAN> connect auxiliary sys/yangql@yangqldg
connected to auxiliary database: yangql (not mounted)
RMAN> run {
2>  allocate channel c1 type disk;
3>   allocate auxiliary channel s1 type disk;
4>    allocate auxiliary channel s2 type disk;
5>    sql channel c1 "alter system archive log current";
6>    duplicate target database for standby 
7>         from active database
8>         spfile
9>         set db_name='yangql'
10>         set db_unique_name='yangqldg'
11>         set instance_name='yangql'
12>         set audit_file_dest='/home/opt/oracle/admin/yangql/adump'
13>         set log_archive_dest_1='LOCATION=/home/opt/oracle/archive_log'
14>         set control_files='/home/opt/oracle/oradata/yangql/control01.ctl','/home/opt/oracle/oradata/yangql/control02.ctl'
15>         set standby_file_management='AUTO'
16>         set log_archive_config='dg_config=(yangqldg,yangql)'
17>         set log_archive_dest_2='service=yangql LGWR ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=yangql'
18>         set log_archive_dest_state_1='enable'
19>         set log_archive_dest_state_2='enable'
20>         set log_archive_format='%t_%s_%r.dbf'
21>         set undo_tablespace='UNDOTBS1'
22>         set LOG_FILE_NAME_CONVERT='/home/opt/oracle/oradata/yangql','/home/opt/oracle/oradata/yangql'
23>         set fal_client='yangqldg'
24>         set fal_server='yangql'
25>         NOFILENAMECHECK; 
26>    sql channel c1 "alter system archive log current";
27> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=838 device type=DISK

allocated channel: s1
channel s1: SID=91 device type=DISK

allocated channel: s2
channel s2: SID=113 device type=DISK

sql statement: alter system archive log current

Starting Duplicate Db at 26-APR-11

contents of Memory Script.:
{
   backup as copy reuse
   targetfile  '/home/opt/oracle/products/11.2.0/dbs/orapwyangql' auxiliary format
 '/home/opt/oracle/products/11.2.0/dbs/orapwyangql'   targetfile
 '/home/opt/oracle/products/11.2.0/dbs/spfileyangql.ora' auxiliary format
 '/home/opt/oracle/products/11.2.0/dbs/spfileyangql.ora'   ;
   sql clone "alter system set spfile= ''/home/opt/oracle/products/11.2.0/dbs/spfileyangql.ora''";
}
executing Memory Script
Starting backup at 26-APR-11
Finished backup at 26-APR-11
sql statement: alter system set spfile= ''/home/opt/oracle/products/11.2.0/dbs/spfileyangql.ora''
contents of Memory Script.:
{
   sql clone "alter system set  db_name =  ''yangql'' comment= '''' scope=spfile";
   sql clone "alter system set  db_unique_name =  ''yangqldg'' comment= '''' scope=spfile";
   sql clone "alter system set  instance_name =  ''yangql'' comment= '''' scope=spfile";
   sql clone "alter system set  audit_file_dest =  ''/home/opt/oracle/admin/yangql/adump'' comment= '''' scope=spfile";
   sql clone "alter system set  log_archive_dest_1 =  ''LOCATION=/home/opt/oracle/archive_log'' comment= '''' scope=spfile";
   sql clone "alter system set  control_files =  ''/home/opt/oracle/oradata/yangql/control01.ctl'', ''/home/opt/oracle/oradata/yangql/control02.ctl'' comment= '''' scope=spfile";
   sql clone "alter system set  standby_file_management =  ''AUTO'' comment= '''' scope=spfile";
   sql clone "alter system set  log_archive_config =  ''dg_config=(yangqldg,yangql)'' comment= '''' scope=spfile";
   sql clone "alter system set  log_archive_dest_2 =  ''service=yangql LGWR ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=yangql'' comment= '''' scope=spfile";
   sql clone "alter system set  log_archive_dest_state_1 =  ''enable'' comment= '''' scope=spfile";
   sql clone "alter system set  log_archive_dest_state_2 =  ''enable'' comment= '''' scope=spfile";
   sql clone "alter system set  log_archive_format =  ''%t_%s_%r.dbf'' comment= '''' scope=spfile";
   sql clone "alter system set  undo_tablespace =  ''UNDOTBS1'' comment= '''' scope=spfile";
   sql clone "alter system set  LOG_FILE_NAME_CONVERT =  ''/home/opt/oracle/oradata/yangql'', ''/home/opt/oracle/oradata/yangql'' comment= '''' scope=spfile";
   sql clone "alter system set  fal_client =  ''yangqldg'' comment= '''' scope=spfile";
   sql clone "alter system set  fal_server =  ''yangql'' comment= '''' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script
sql statement: alter system set  db_name =  ''yangql'' comment= '''' scope=spfile
sql statement: alter system set  db_unique_name =  ''yangqldg'' comment= '''' scope=spfile
sql statement: alter system set  instance_name =  ''yangql'' comment= '''' scope=spfile
sql statement: alter system set  audit_file_dest =  ''/home/opt/oracle/admin/yangql/adump'' comment= '''' scope=spfile
sql statement: alter system set  log_archive_dest_1 =  ''LOCATION=/home/opt/oracle/archive_log'' comment= '''' scope=spfile
sql statement: alter system set  control_files =  ''/home/opt/oracle/oradata/yangql/control01.ctl'', ''/home/opt/oracle/oradata/yangql/control02.ctl'' comment= '''' scope=spfile
sql statement: alter system set  standby_file_management =  ''AUTO'' comment= '''' scope=spfile
sql statement: alter system set  log_archive_config =  ''dg_config=(yangqldg,yangql)'' comment= '''' scope=spfile
sql statement: alter system set  log_archive_dest_2 =  ''service=yangql LGWR ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=yangql'' comment= '''' scope=spfile
sql statement: alter system set  log_archive_dest_state_1 =  ''enable'' comment= '''' scope=spfile
sql statement: alter system set  log_archive_dest_state_2 =  ''enable'' comment= '''' scope=spfile
sql statement: alter system set  log_archive_format =  ''%t_%s_%r.dbf'' comment= '''' scope=spfile
sql statement: alter system set  undo_tablespace =  ''UNDOTBS1'' comment= '''' scope=spfile
sql statement: alter system set  LOG_FILE_NAME_CONVERT =  ''/home/opt/oracle/oradata/yangql'', ''/home/opt/oracle/oradata/yangql'' comment= '''' scope=spfile
sql statement: alter system set  fal_client =  ''yangqldg'' comment= '''' scope=spfile
sql statement: alter system set  fal_server =  ''yangql'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area    1653518336 bytes
Fixed Size                     2213896 bytes
Variable Size                939526136 bytes
Database Buffers             704643072 bytes
Redo Buffers                   7135232 bytes
allocated channel: s1
channel s1: SID=958 device type=DISK
allocated channel: s2
channel s2: SID=1149 device type=DISK
contents of Memory Script.:
{
   backup as copy current controlfile for standby auxiliary format  '/home/opt/oracle/oradata/yangql/control01.ctl';
   restore clone controlfile to  '/home/opt/oracle/oradata/yangql/control02.ctl' from
 '/home/opt/oracle/oradata/yangql/control01.ctl';
}
executing Memory Script

Starting backup at 26-APR-11
channel c1: starting datafile copy
copying standby control file
output file name=/home/opt/oracle/products/11.2.0/dbs/snapcf_yangql.f tag=TAG20110426T144453 RECID=3 STAMP=749486694
channel c1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 26-APR-11
Starting restore at 26-APR-11
channel s2: skipped, AUTOBACKUP already found
channel s1: copied control file copy
Finished restore at 26-APR-11
contents of Memory Script.:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
RMAN-05538: WARNING: implicitly using DB_FILE_NAME_CONVERT

contents of Memory Script.:
{
   set newname for tempfile  1 to  "/home/opt/oracle/oradata/yangql/temp01.dbf";
   switch clone tempfile all;
   set newname for datafile  1 to  "/home/opt/oracle/oradata/yangql/system01.dbf";
   set newname for datafile  2 to  "/home/opt/oracle/oradata/yangql/sysaux01.dbf";
   set newname for datafile  3 to  "/home/opt/oracle/oradata/yangql/undotbs01.dbf";
   set newname for datafile  4 to  "/home/opt/oracle/oradata/yangql/users01.dbf";
   set newname for datafile  5 to  "/home/opt/oracle/oradata/yangql/alijr01.dbf";
   set newname for datafile  6 to  "/home/opt/oracle/oradata/yangql/alijr02.dbf";
   set newname for datafile  7 to  "/home/opt/oracle/oradata/yangql/alijr03.dbf";
   set newname for datafile  8 to  "/home/opt/oracle/oradata/yangql/alijr04.dbf";
   set newname for datafile  9 to  "/home/opt/oracle/oradata/yangql/alijr05.dbf";
   set newname for datafile  10 to  "/home/opt/oracle/oradata/yangql/alijr06.dbf";
   set newname for datafile  11 to  "/home/opt/oracle/oradata/yangql/alijr07.dbf";
   set newname for datafile  12 to  "/home/opt/oracle/oradata/yangql/alijr08.dbf";
   set newname for datafile  13 to  "/home/opt/oracle/oradata/yangql/alijr09.dbf";
   set newname for datafile  14 to  "/home/opt/oracle/oradata/yangql/alijr10.dbf";
   set newname for datafile  15 to  "/home/opt/oracle/oradata/yangql/alijr11.dbf";
   set newname for datafile  16 to  "/home/opt/oracle/oradata/yangql/alijr12.dbf";
   set newname for datafile  17 to  "/home/opt/oracle/oradata/yangql/alijr13.dbf";
   set newname for datafile  18 to  "/home/opt/oracle/oradata/yangql/alijr14.dbf";
   set newname for datafile  19 to  "/home/opt/oracle/oradata/yangql/alijr15.dbf";
   set newname for datafile  20 to  "/home/opt/oracle/oradata/yangql/alijr16.dbf";
   set newname for datafile  21 to  "/home/opt/oracle/oradata/yangql/alijr17.dbf";
   set newname for datafile  22 to  "/home/opt/oracle/oradata/yangql/alijr18.dbf";
   set newname for datafile  23 to  "/home/opt/oracle/oradata/yangql/alijr19.dbf";
   backup as copy reuse
   datafile
    1 auxiliary format  "/home/opt/oracle/oradata/yangql/system01.dbf"   datafile
 2 auxiliary format  "/home/opt/oracle/oradata/yangql/sysaux01.dbf"   datafile
 3 auxiliary format  "/home/opt/oracle/oradata/yangql/undotbs01.dbf"   datafile
 4 auxiliary format  "/home/opt/oracle/oradata/yangql/users01.dbf"   datafile
 5 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr01.dbf"   datafile
 6 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr02.dbf"   datafile
 7 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr03.dbf"   datafile
 8 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr04.dbf"   datafile
 9 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr05.dbf"   datafile
 10 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr06.dbf"   datafile
 11 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr07.dbf"   datafile
 12 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr08.dbf"   datafile
 13 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr09.dbf"   datafile
 14 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr10.dbf"   datafile
 15 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr11.dbf"   datafile
 16 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr12.dbf"   datafile
 17 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr13.dbf"   datafile
 18 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr14.dbf"   datafile
 19 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr15.dbf"   datafile
 20 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr16.dbf"   datafile
 21 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr17.dbf"   datafile
 22 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr18.dbf"   datafile
 23 auxiliary format  "/home/opt/oracle/oradata/yangql/alijr19.dbf"   ;
   sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /home/opt/oracle/oradata/yangql/temp01.dbf 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
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
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
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 26-APR-11
channel c1: starting datafile copy
input datafile file number=00005 name=/home/opt/oracle/oradata/yangql/alijr01.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr01.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:55
channel c1: starting datafile copy
input datafile file number=00006 name=/home/opt/oracle/oradata/yangql/alijr02.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr02.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:02:05
channel c1: starting datafile copy
input datafile file number=00007 name=/home/opt/oracle/oradata/yangql/alijr03.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr03.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:45
channel c1: starting datafile copy
input datafile file number=00008 name=/home/opt/oracle/oradata/yangql/alijr04.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr04.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:35
channel c1: starting datafile copy
input datafile file number=00009 name=/home/opt/oracle/oradata/yangql/alijr05.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr05.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:35
channel c1: starting datafile copy
input datafile file number=00010 name=/home/opt/oracle/oradata/yangql/alijr06.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr06.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:35
channel c1: starting datafile copy
input datafile file number=00011 name=/home/opt/oracle/oradata/yangql/alijr07.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr07.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:35
channel c1: starting datafile copy
input datafile file number=00012 name=/home/opt/oracle/oradata/yangql/alijr08.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr08.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:35
channel c1: starting datafile copy
input datafile file number=00013 name=/home/opt/oracle/oradata/yangql/alijr09.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr09.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:55
channel c1: starting datafile copy
input datafile file number=00014 name=/home/opt/oracle/oradata/yangql/alijr10.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr10.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:35
channel c1: starting datafile copy
input datafile file number=00015 name=/home/opt/oracle/oradata/yangql/alijr11.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr11.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:35
channel c1: starting datafile copy
input datafile file number=00016 name=/home/opt/oracle/oradata/yangql/alijr12.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr12.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:45
channel c1: starting datafile copy
input datafile file number=00017 name=/home/opt/oracle/oradata/yangql/alijr13.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr13.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:35
channel c1: starting datafile copy
input datafile file number=00018 name=/home/opt/oracle/oradata/yangql/alijr14.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr14.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:41
channel c1: starting datafile copy
input datafile file number=00019 name=/home/opt/oracle/oradata/yangql/alijr15.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr15.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:02:35
channel c1: starting datafile copy
input datafile file number=00020 name=/home/opt/oracle/oradata/yangql/alijr16.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr16.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:55
channel c1: starting datafile copy
input datafile file number=00021 name=/home/opt/oracle/oradata/yangql/alijr17.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr17.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:02:00
channel c1: starting datafile copy
input datafile file number=00022 name=/home/opt/oracle/oradata/yangql/alijr18.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr18.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:44
channel c1: starting datafile copy
input datafile file number=00023 name=/home/opt/oracle/oradata/yangql/alijr19.dbf
output file name=/home/opt/oracle/oradata/yangql/alijr19.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:45
channel c1: starting datafile copy
input datafile file number=00003 name=/home/opt/oracle/oradata/yangql/undotbs01.dbf
output file name=/home/opt/oracle/oradata/yangql/undotbs01.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:01:36
channel c1: starting datafile copy
input datafile file number=00001 name=/home/opt/oracle/oradata/yangql/system01.dbf
output file name=/home/opt/oracle/oradata/yangql/system01.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:00:35
channel c1: starting datafile copy
input datafile file number=00002 name=/home/opt/oracle/oradata/yangql/sysaux01.dbf
output file name=/home/opt/oracle/oradata/yangql/sysaux01.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:00:15
channel c1: starting datafile copy
input datafile file number=00004 name=/home/opt/oracle/oradata/yangql/users01.dbf
output file name=/home/opt/oracle/oradata/yangql/users01.dbf tag=TAG20110426T144511
channel c1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 26-APR-11
sql statement: alter system archive log current
contents of Memory Script.:
{
   switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=3 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=4 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=5 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=6 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=7 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=8 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr02.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=9 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr03.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=10 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr04.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=11 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr05.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=12 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr06.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=13 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr07.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=14 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr08.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=15 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr09.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=16 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr10.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=17 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr11.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=18 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr12.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=19 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr13.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=20 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr14.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=21 STAMP=749488890 file name=/home/opt/oracle/oradata/yangql/alijr15.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=22 STAMP=749488891 file name=/home/opt/oracle/oradata/yangql/alijr16.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=23 STAMP=749488891 file name=/home/opt/oracle/oradata/yangql/alijr17.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=24 STAMP=749488891 file name=/home/opt/oracle/oradata/yangql/alijr18.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=25 STAMP=749488891 file name=/home/opt/oracle/oradata/yangql/alijr19.dbf
Finished Duplicate Db at 26-APR-11
sql statement: alter system archive log current
released channel: c1
released channel: s1
released channel: s2
RMAN> exit
Recovery Manager complete.
======================备库的操作================

检查备库上的数据文件。
oracle>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 26 13:07:48 2011
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to an idle instance.
@>startup nomount pfile='/home/opt/oracle/products/11.2.0/dbs/yangql.ora'
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size                  2213896 bytes
Variable Size            1006635000 bytes
Database Buffers          637534208 bytes
Redo Buffers                7135232 bytes
@>exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning option
oracle>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 26 14:04:43 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning option

@>select * from v$logfile;
GROUP# STATUS  TYPE   MEMBER   IS_
------ ------- ----------------------------------------------------------------------
 3     ONLINE      /home/opt/oracle/oradata/yangql/redo03.log NO
2      ONLINE      /home/opt/oracle/oradata/yangql/redo02.log NO
1      ONLINE      /home/opt/oracle/oradata/yangql/redo01.log NO

@>col member for a45
@>select * from v$logfile;
    GROUP# STATUS  TYPE    MEMBER                                        IS_
---------- ------- ------- --------------------------------------------- ---
         3         ONLINE  /home/opt/oracle/oradata/yangql/redo03.log   NO
         2         ONLINE  /home/opt/oracle/oradata/yangql/redo02.log   NO
         1         ONLINE  /home/opt/oracle/oradata/yangql/redo01.log   NO
@>col ts#        format 9999
@>col tablespace format a20
@>col file       format a52
@>select t.ts#, t.name "tablespace", d.file#, d.name "file", d.status, d.enabled
  2  from v$tablespace t, v$datafile d
  3  where t.ts#=d.ts#
  4  union all
  5  select t.ts#, t.name "tablespace", d.file#, d.name "file", d.status, d.enabled
  6  from v$tablespace t, v$tempfile d
  7  where t.ts#=d.ts#  order by 1, 4;
  TS# tablespace                FILE# file                                                 STATUS  ENABLED
----- -------------------- ---------- ---------------------------------------------------- ------- ----------
    0 SYSTEM                        1 /home/opt/oracle/oradata/yangql/system01.dbf        SYSTEM  READ WRITE
    1 SYSAUX                        2 /home/opt/oracle/oradata/yangql/sysaux01.dbf        ONLINE  READ WRITE
    2 UNDOTBS1                      3 /home/opt/oracle/oradata/yangql/undotbs01.dbf       ONLINE  READ WRITE
    3 TEMP                          1 /home/opt/oracle/oradata/yangql/temp01.dbf          ONLINE  READ WRITE
    4 USERS                         4 /home/opt/oracle/oradata/yangql/users01.dbf         ONLINE  READ WRITE
    6 AJR                         5 /home/opt/oracle/oradata/yangql/alijr01.dbf         ONLINE  READ WRITE
    6 AJR                         6 /home/opt/oracle/oradata/yangql/alijr02.dbf         ONLINE  READ WRITE
    6 AJR                         7 /home/opt/oracle/oradata/yangql/alijr03.dbf         ONLINE  READ WRITE
    6 AJR                         8 /home/opt/oracle/oradata/yangql/alijr04.dbf         ONLINE  READ WRITE
    6 AJR                         9 /home/opt/oracle/oradata/yangql/alijr05.dbf         ONLINE  READ WRITE
    6 AJR                        10 /home/opt/oracle/oradata/yangql/alijr06.dbf         ONLINE  READ WRITE
    6 AJR                        11 /home/opt/oracle/oradata/yangql/alijr07.dbf         ONLINE  READ WRITE
    6 AJR                        12 /home/opt/oracle/oradata/yangql/alijr08.dbf         ONLINE  READ WRITE
    6 AJR                        13 /home/opt/oracle/oradata/yangql/alijr09.dbf         ONLINE  READ WRITE
    6 AJR                        14 /home/opt/oracle/oradata/yangql/alijr10.dbf         ONLINE  READ WRITE
    6 AJR                        15 /home/opt/oracle/oradata/yangql/alijr11.dbf         ONLINE  READ WRITE
    6 AJR                        16 /home/opt/oracle/oradata/yangql/alijr12.dbf         ONLINE  READ WRITE
    6 AJR                        17 /home/opt/oracle/oradata/yangql/alijr13.dbf         ONLINE  READ WRITE
    6 AJR                        18 /home/opt/oracle/oradata/yangql/alijr14.dbf         ONLINE  READ WRITE
    6 AJR                        19 /home/opt/oracle/oradata/yangql/alijr15.dbf         ONLINE  READ WRITE
    6 AJR                        20 /home/opt/oracle/oradata/yangql/alijr16.dbf         ONLINE  READ WRITE
    6 AJR                        21 /home/opt/oracle/oradata/yangql/alijr17.dbf         ONLINE  READ WRITE
    6 AJR                        22 /home/opt/oracle/oradata/yangql/alijr18.dbf         ONLINE  READ WRITE
    6 AJR                        23 /home/opt/oracle/oradata/yangql/alijr19.dbf         ONLINE  READ WRITE

24 rows selected.

@>exit             
剩下的就是进行切换日志检查dg的功能了~！

weixin_34315189
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
速成大神小技巧——Mysql批量|DUPLICATE高级用法
魏小言的博客
05-26 5182
文章目录数据入库单条入库批量入库数据冲突入库冲突Replace & Deplicate异同Q&A附录 此系列为速成大神系列，掌握这些小技巧，让你在人群中脱颖而出！ 数据入库 单条入库 一般初级或简单场景，单条数据入库，SQL如下： insert into user_info （user_id,user_name,status,years）values (123,'你好’,1,15） 或者 insert into user_info set user_id=123,user_name=“你
Oracle_DataGuard 11g RAC+单机
12-28
本篇详细介绍了如何在一个Oracle 11g RAC环境下配置DataGuard，并使用单机作为备库的具体步骤。通过上述配置，可以有效地实现数据库的高可用性和灾难恢复能力。值得注意的是，在实际部署过程中，还需要根据具体情况...
MySQL的Replace into 与Insert into on duplicate key update真正的不同之处
xlxxcc的专栏
09-05 2万+
相同点：（1）没有key的时候，replace与insert .. on deplicate udpate相同。 （2）有key的时候，都保留主键值，并且auto_increment自动+1。不同点　有key的时候，replace是delete老记录，而录入新的记录，所以原有的所有记录会被清除，这个时候，如果replace语句的字段不全的话，有些原有的比如例子中c字段的值会被自动填充为默认值。
ON DUPLICATE KEY UPDATE 用法与说明
zyb2017的博客
11-05 7万+
ON DUPLICATE KEY UPDATE作用先声明一点，ON DUPLICATE KEY UPDATE为Mysql特有语法，这是个坑 语句的作用，当insert已经存在的记录时，执行Update用法什么意思？举个例子： user_admin_t表中有一条数据如下表中的主键为id，现要插入一条数据，id为‘1’，password为‘第一次插入的密码’，正常写法为：INSERT INTO
MySQL_插入更新 ON DUPLICATE KEY UPDATE
热门推荐
迎难而上
01-12 8万+
平时我们在设计数据库表的时候总会设计 unique  或者 给表加上 primary key 的限制条件. 此时 插入数据的时候 ，经常会有这样的情况： 我们想向数据库插入一条记录：   若数据表中存在以相同主键的记录，我们就更新该条记录。   否则就插入一条新的记录。 逻辑上我们需要怎么写： $result = mysql_query('select * from x
mysql可以使用dataguard,DataGuard相关参数
weixin_42169245的博客
03-23 176
定义数据库唯一名称，因为DB_NAME参数对于物理数据库是必须相同，对于逻辑数据库必须不同，所以在Oracle 10g中引入DB_UNIQUE_NAMDB_UNIQUE_NAME定义数据库唯一名称，因为DB_NAME参数对于物理数据库是必须相同，对于逻辑数据库必须不同，所以在Oracle 10g中引入DB_UNIQUE_NAME参数来确定DataGuard配置中的每个数据库，如果未定义该参数，默认...
mysql可以使用dataguard_应用dataguard 好处
weixin_30561959的博客
01-27 206
应用dataguard 好处[@more@]Data Guard 和 RACData Guard 和真正应用集群是互补的，应一起使用以实现最高可用性结构真正应用集群提供了高可用性能够快速和自动地从节点故障或一个实例崩溃中恢复过来提供了增强的可伸缩性Data Guard 提供了灾难保护并防止数据丢失维护主数据库的几个事务一致的副本防止灾难、数据损坏和用户错误无需昂贵且复杂的 HW/SW 镜像Stre...
mysql可以使用dataguard_DataGuard与异构平台
weixin_32637935的博客
01-27 109
Prior to Data Guard 11g, the Data Guard Broker did not support different word-size in the same Data Guard configuration, thus requiring management from the SQL*Plus command line for mixed word-size Da...
grid单实例创建dataguard
Du.的博客
04-12 998
PR操作 1、srvctl删除已有的数据库资源 查看db_unique_name sql>show parameter name sql>create pfile='/oracle/pfilecc.ora' from spfile; 如果db_unique_name 与需要修改的dbname不相同，需要修改 oracle：srvctl config database -d cc 记录下当前cc的-spfile，-pwfile，-diskgroup #主备机都需要删除 or
oracle 高可用 dataguard 单机到RAC复制与几乎无停顿全数据迁移
12-25
- 使用备份文件恢复并创建新的RAC数据库。 **2. DataGuard配置** - **配置物理备库**：在备库上启用归档模式，并创建物理备库。 - **同步物理备库**：使用`switchover`或`failover`命令同步物理备库，确保其与...
ORACLE dataguard创建步骤
07-07
### ORACLE DataGuard 创建步骤详解 #### 一、前期准备工作 在进行Oracle DataGuard物理Standby数据库的创建之前，确保所有必要的准备工作都已经完成，并且配置正确。这些准备工作分为软件部分和硬件部分。 #####...
oracle 11g RAC<-->单机 高可用dataguard 主备正确切换步骤
12-07
本文将详细介绍Oracle 11g RAC高可用Dataguard 主备正确切换步骤，涵盖RAC切单机、单机切换回RAC、切换失败强制升级备机到主用、不同步、重新同步等步骤。 一、RAC切单机 在进行高可用Dataguard 主备切换前，需要...
Oracle_dataguard的3种创建方法
07-08
"Oracle Dataguard 的 3 种创建方法" Oracle Dataguard 是 Oracle 数据库中的一种灾难恢复解决方案，它可以将主数据库的数据实时同步到备用数据库中，确保数据的安全和高可用性。本文将详细介绍 Oracle Dataguard ...
spring事务详细讲解-深入浅出
小电玩
09-08 483
Spring 事务是本身就是对数据库的事务的支持，没有数据库的事务 Spring 是本身无法实现事务的。Spring只提供了统一事务管理接口，具体的实现还是由各数据库自己实现。在使用 Spring 事务时，可以通过注解或编程方式将需要进行事务管理的方法和代码块标记为事务性操作，当这些操作被执行时，Spring 会负责开启时根据当前环境中设置的隔离级别，调整数据库隔离级别。
【提效工具】AI工作流的1-10个实际落地场景
万物皆有灵
09-09 1029
在这个快速发展的数字时代，人工智能（AI）正在以惊人的速度改变我们的工作方式。无论你是开发者、教育工作者还是内容创作者，AI工作流提示词助手都能为你提供无与伦比的支持。今天，我们将深入探讨，20个实际落地场景，帮助你更好地理解如何利用这些工具提升工作效率和创造力。💡。
PLSQL-将一份excel数据导入到一张物理表(Oracle)
最新发布
qq_38294275的博客
09-09 496
在Oracle中，FOR UPDATE子句用于SELECT语句中，以便在检索数据的同时锁定这些数据，防止其他会话在此期间修改它们。这个子句通常用于需要确保数据一致性的情况，特别是在多用户环境中，当多个会话可能同时尝试修改相同的数据时。研究了半天，看网上说的可以用：Tools → ODBC Importer ，然后再选择csv啥的即可，一打开我的PLSQL，啊，空白的啊，啥都没有…最后的最后，记得插入的数据/excel文件，要在第一列新增一列，空白也行/ID也行，总之要再插入一列，这样数据就不会错位。
jmeter之setUP、tearDown线程组
回家吃月饼的学习交流地
09-07 552
jmeter之setUP、tearDown线程组的使用
问题： java.sql.SQLException：The server time zone value ‘�й���׼ʱ��‘
m0_74293254的博客
09-08 327
译文: Mybatis Plus服务器时区值“h”无法识别或表示多个时区。如果希望利用时区支持，必须配置服务器或JDBC驱动程序(通过serverTimezone配置属性)以使用更具体的时区值。出现上述问题后，一般为数据库连接的url地址配置中，没有配置时区serverTimezone=UTC或配置错误，修改下即可。
Oracle DataGuard 11g单机主备配置详解与测试
Oracle DataGuard 11g 主备系统在单机模式下是一种高可用性和灾备解决方案，适用于企业级数据库环境。它主要涉及以下几个关键步骤和配置： 1. **主库准备工作**： - 检查数据库版本是否支持DataGuard，确保是企业...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值