11.2.0.4rman duplicate 通过 backup or atcive database

最新推荐文章于 2021-01-06 08:43:01 发布
最新推荐文章于 2021-01-06 08:43:01 发布
阅读量1.4k 收藏
点赞数
分类专栏： RMAN
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/wuxbeyond/article/details/16923749
版权
本文详细介绍了如何使用RMAN（恢复管理器）通过backup和active数据库的方式设置Oracle数据库的standby实例。内容涵盖从源库备份、standby库的初始化配置、文件传输到standby库的启动和复制过程，以及如何解决可能出现的问题。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

源库 db_name=primary sid=primary
复制库standby db_name=standby  sid= standby

1:首先为standby库添加静态注册信息
vi $ORACLE_HOME/network/admin/listener.ora
SID_LIST_LISTENER =   --这是静态注册,这样rman客户端才能连接到nomount状态的实例
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = standby)
      (ORACLE_HOME = /u01/app/oracle/product/11g)
      (SID_NAME = standby)
    )
  )

LISTENER =         --这是动态注册监听信息 也是netca图形界面下创建出来的监听
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )


2：为standby库创建一个密码文件和adump和其他目录否则复制的时候会报错哦
[oracle@standby dbs]$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=redhat entries=10

[oracle@standby admin]$ mkdir -p $ORACLE_BASE/admin/primary/adump

[oracle@standby admin]$ mkdir -p $ORACLE_BASE/diag/rdbms/primary/primary

[oracle@standby admin]$ mkdir -p $ORACLE_BASE/fast_recovery_area/primary

3：为standby实例建立一个初始化参数文件用于standby实例启动到nomount
[oracle@standby dbs]$ echo DB_NAME='standby' > initstandby.ora

4： 备份primary库
backup database plus archivelog delete input format='/u01/app/oracle/backup/dd_%U';

5：将备份的文件拷贝到standby里
[oracle@standby backup]$ scp oracle@primary:/u01/app/oracle/backup/*  /u01/app/oracle
[oracle@standby backup]$ scp oracle@primary:/u01/app/oracle/fast_recovery_area/PRIMARY/backupset/2013_11_24/*  /u01/app/oracle

6：启动standby实例到 nomount状态
[oracle@standby dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Nov 24 11:30:13 2013
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/u01/app/oracle/product/11g/dbs/initstandby.ora';
ORACLE instance started.
Total System Global Area  263090176 bytes
Fixed Size                  2252256 bytes
Variable Size             205521440 bytes
Database Buffers           50331648 bytes
Redo Buffers                4984832 bytes

7：rman客户端连接到standby(only auxiliary) 执行脚本
[oracle@primary primary]$ rman auxiliary sys/redhat@standby
run
{
  allocate auxiliary channel dup type disk;
  SET NEWNAME FOR DATABASE TO '/oradata/standby%U'; --db_name被修改为standby了
  SET NEWNAME FOR DATAFILE 1 TO '/u01/app/oracle/oradata/standby/system01.dbf';
  SET NEWNAME FOR DATAFILE 2 TO '/u01/app/oracle/oradata/standby/sysaux01.dbf';
  SET NEWNAME FOR DATAFILE 3 TO '/u01/app/oracle/oradata/standby/undotbs01.dbf';
  SET NEWNAME FOR DATAFILE 4 TO '/u01/app/oracle/oradata/standby/users01.dbf';
  SET NEWNAME FOR TEMPFILE 1 TO '/u01/app/oracle/oradata/standby/temp01.dbf';
  duplicate database to 'standby' spfile backup location '/u01/app/oracle/backup' nofilenamecheck  --因为只连了auxiliary所以要指定backup location
  logfile
   GROUP 1 ('/u01/app/oracle/oradata/standby/redo01.log') size 50m,
   GROUP 2 ('/u01/app/oracle/oradata/standby/redo02.log') size 50m,
   GROUP 3 ('/u01/app/oracle/oradata/standby/redo03.log') size 50m;
}

8：rman客户端连接到target auxiliary (from active database) 执行脚本
[oracle@primary primary]$ rman target sys/redhat@primary auxiliary sys/redhat@standby
run
{
  SET NEWNAME FOR DATABASE TO '/oradata/standby%U'; --db_name被修改为standby了
  SET NEWNAME FOR DATAFILE 1 TO '/u01/app/oracle/oradata/standby/system01.dbf';
  SET NEWNAME FOR DATAFILE 2 TO '/u01/app/oracle/oradata/standby/sysaux01.dbf';
  SET NEWNAME FOR DATAFILE 3 TO '/u01/app/oracle/oradata/standby/undotbs01.dbf';
  SET NEWNAME FOR DATAFILE 4 TO '/u01/app/oracle/oradata/standby/users01.dbf';
  SET NEWNAME FOR TEMPFILE 1 TO '/u01/app/oracle/oradata/standby/temp01.dbf';
  duplicate database to 'standby' from active database spfile nofilenamecheck  --因为直接从活动的数据库里复制需要加上 from active database

   --skip tablespace tablespace_name --可以跳过复制某个表空间
  logfile
   GROUP 1 ('/u01/app/oracle/oradata/standby/redo01.log') size 50m,
   GROUP 2 ('/u01/app/oracle/oradata/standby/redo02.log') size 50m,
   GROUP 3 ('/u01/app/oracle/oradata/standby/redo03.log') size 50m;
}

脚本执行完毕之后OK了。如果报错就根据错误具体解决！

最后查询2个库的dbid 是不一样的，和手动复制有点不一样。

SQL>  select dbid ,name from v$database;

      DBID NAME
---------- ---------
1669545047 PRIMARY

SQL> select dbid ,name from v$database;

      DBID NAME
---------- ---------
1644075315 STANDBY


所有的步骤官方网有帮助文档不明白的jump过去查   连接地址

这是 rman duplicate的日志 可以看具体在干什么东西。

RMAN> run
{
  allocate auxiliary channel dup type disk;
  SET NEWNAME FOR DATABASE TO '/oradata/standby%U'; 
  SET NEWNAME FOR DATAFILE 1 TO '/u01/app/oracle/oradata/standby/system01.dbf'; 
  SET NEWNAME FOR DATAFILE 2 TO '/u01/app/oracle/oradata/standby/sysaux01.dbf';
  SET NEWNAME FOR DATAFILE 3 TO '/u01/app/oracle/oradata/standby/undotbs01.dbf';
  SET NEWNAME FOR DATAFILE 4 TO '/u01/app/oracle/oradata/standby/users01.dbf'; 
  SET NEWNAME FOR TEMPFILE 1 TO '/u01/app/oracle/oradata/standby/temp01.dbf'; 
  duplicate database to 'standby' spfile backup location '/u01/app/oracle/backup' nofilenamecheck logfile GROUP 1 

('/u01/app/oracle/oradata/standby/redo01.log') size 50m,GROUP 2 ('/u01/app/oracle/oradata/standby/redo02.log') size 50m,GROUP 3 

('/u01/app/oracle/oradata/standby/redo03.log') size 50m;
} 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 

allocated channel: dup
channel dup: SID=5 device type=DISK

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 Duplicate Db at 24-NOV-13

contents of Memory Script:
{
   restore clone spfile to  '/u01/app/oracle/product/11g/dbs/spfilestandby.ora' from 
 '/u01/app/oracle/backup/o1_mf_ncsnf_TAG20131124T104823_992t8n7y_.bkp';
   sql clone "alter system set spfile= ''/u01/app/oracle/product/11g/dbs/spfilestandby.ora''";
}
executing Memory Script

Starting restore at 24-NOV-13

channel dup: restoring spfile from AUTOBACKUP /u01/app/oracle/backup/o1_mf_ncsnf_TAG20131124T104823_992t8n7y_.bkp
channel dup: SPFILE restore from AUTOBACKUP complete
Finished restore at 24-NOV-13

sql statement: alter system set spfile= ''/u01/app/oracle/product/11g/dbs/spfilestandby.ora''

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''STANDBY'' comment=
 ''duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''STANDBY'' comment= ''duplicate'' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    6263357440 bytes

Fixed Size                     2264856 bytes
Variable Size               3271557352 bytes
Database Buffers            2969567232 bytes
Redo Buffers                  19968000 bytes
allocated channel: dup
channel dup: SID=191 device type=DISK

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''PRIMARY'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name = 
 ''STANDBY'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile from  '/u01/app/oracle/backup/o1_mf_ncsnf_TAG20131124T104823_992t8n7y_.bkp';
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''PRIMARY'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''STANDBY'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area    6263357440 bytes

Fixed Size                     2264856 bytes
Variable Size               3271557352 bytes
Database Buffers            2969567232 bytes
Redo Buffers                  19968000 bytes
allocated channel: dup
channel dup: SID=191 device type=DISK

Starting restore at 24-NOV-13

channel dup: restoring control file
channel dup: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/primary/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/primary/control02.ctl
Finished restore at 24-NOV-13

database mounted

contents of Memory Script:
{
   set until scn  201900;
   set newname for datafile  1 to 
 "/u01/app/oracle/oradata/standby/system01.dbf";
   set newname for datafile  2 to 
 "/u01/app/oracle/oradata/standby/sysaux01.dbf";
   set newname for datafile  3 to 
 "/u01/app/oracle/oradata/standby/undotbs01.dbf";
   set newname for datafile  4 to 
 "/u01/app/oracle/oradata/standby/users01.dbf";
   restore
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 24-NOV-13

channel dup: starting datafile backup set restore
channel dup: specifying datafile(s) to restore from backup set
channel dup: restoring datafile 00001 to /u01/app/oracle/oradata/standby/system01.dbf
channel dup: restoring datafile 00002 to /u01/app/oracle/oradata/standby/sysaux01.dbf
channel dup: restoring datafile 00003 to /u01/app/oracle/oradata/standby/undotbs01.dbf
channel dup: restoring datafile 00004 to /u01/app/oracle/oradata/standby/users01.dbf
channel dup: reading from backup piece /u01/app/oracle/backup/o1_mf_nnndf_TAG20131124T104823_992t7vgp_.bkp
channel dup: piece handle=/u01/app/oracle/backup/o1_mf_nnndf_TAG20131124T104823_992t7vgp_.bkp tag=TAG20131124T104823
channel dup: restored backup piece 1
channel dup: restore complete, elapsed time: 00:00:07
Finished restore at 24-NOV-13

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

datafile 1 switched to datafile copy
input datafile copy RECID=5 STAMP=832331826 file name=/u01/app/oracle/oradata/standby/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=6 STAMP=832331826 file name=/u01/app/oracle/oradata/standby/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=832331826 file name=/u01/app/oracle/oradata/standby/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=832331826 file name=/u01/app/oracle/oradata/standby/users01.dbf

contents of Memory Script:
{
   set until scn  201900;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 24-NOV-13

starting media recovery

channel dup: starting archived log restore to default destination
channel dup: restoring archived log
archived log thread=1 sequence=20
channel dup: reading from backup piece /u01/app/oracle/backup/dd_04opomcl_1_1
channel dup: piece handle=/u01/app/oracle/backup/dd_04opomcl_1_1 tag=TAG20131124T104853
channel dup: restored backup piece 1
channel dup: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/fast_recovery_area/STANDBY/archivelog/2013_11_24/o1_mf_1_20_992vxlvs_.arc thread=1 sequence=20
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/STANDBY/archivelog/2013_11_24/o1_mf_1_20_992vxlvs_.arc RECID=1 STAMP=832331826
media recovery complete, elapsed time: 00:00:01
Finished recover at 24-NOV-13
Oracle instance started

Total System Global Area    6263357440 bytes

Fixed Size                     2264856 bytes
Variable Size               3271557352 bytes
Database Buffers            2969567232 bytes
Redo Buffers                  19968000 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''STANDBY'' comment=
 ''Reset to original value by RMAN'' scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''STANDBY'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    6263357440 bytes

Fixed Size                     2264856 bytes
Variable Size               3271557352 bytes
Database Buffers            2969567232 bytes
Redo Buffers                  19968000 bytes
allocated channel: dup
channel dup: SID=191 device type=DISK
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "STANDBY" RESETLOGS ARCHIVELOG 
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP   1 ( '/u01/app/oracle/oradata/standby/redo01.log' ) SIZE 50 M ,
  GROUP   2 ( '/u01/app/oracle/oradata/standby/redo02.log' ) SIZE 50 M ,
  GROUP   3 ( '/u01/app/oracle/oradata/standby/redo03.log' ) SIZE 50 M 
 DATAFILE
  '/u01/app/oracle/oradata/standby/system01.dbf'
 CHARACTER SET AL32UTF8


contents of Memory Script:
{
   set newname for tempfile  1 to 
 "/u01/app/oracle/oradata/standby/temp01.dbf";
   switch clone tempfile all;
   catalog clone datafilecopy  "/u01/app/oracle/oradata/standby/sysaux01.dbf", 
 "/u01/app/oracle/oradata/standby/undotbs01.dbf", 
 "/u01/app/oracle/oradata/standby/users01.dbf";
   switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/standby/temp01.dbf in control file

cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/standby/sysaux01.dbf RECID=1 STAMP=832331839
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/standby/undotbs01.dbf RECID=2 STAMP=832331839
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/standby/users01.dbf RECID=3 STAMP=832331839

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=832331839 file name=/u01/app/oracle/oradata/standby/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=832331839 file name=/u01/app/oracle/oradata/standby/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=832331839 file name=/u01/app/oracle/oradata/standby/users01.dbf

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 24-NOV-13
released channel: dup


下面是from active database 的日志

RMAN> run
{
  SET NEWNAME FOR DATABASE TO '/oradata/standby%U';
  SET NEWNAME FOR DATAFILE 1 TO '/u01/app/oracle/oradata/standby/system01.dbf';
  SET NEWNAME FOR DATAFILE 2 TO '/u01/app/oracle/oradata/standby/sysaux01.dbf';
  SET NEWNAME FOR DATAFILE 3 TO '/u01/app/oracle/oradata/standby/undotbs01.dbf';
  SET NEWNAME FOR DATAFILE 4 TO '/u01/app/oracle/oradata/standby/users01.dbf';
  SET NEWNAME FOR TEMPFILE 1 TO '/u01/app/oracle/oradata/standby/temp01.dbf';
  duplicate database to 'standby' FROM ACTIVE DATABASE spfile nofilenamecheck
  logfile
   GROUP 1 ('/u01/app/oracle/oradata/standby/redo01.log') size 50m,
   GROUP 2 ('/u01/app/oracle/oradata/standby/redo02.log') size 50m,
   GROUP 3 ('/u01/app/oracle/oradata/standby/redo03.log') size 50m;
}2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 

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 Duplicate Db at 24-NOV-13
using channel ORA_AUX_DISK_1

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '/u01/app/oracle/product/11g/dbs/spfileprimary.ora' auxiliary format 
 '/u01/app/oracle/product/11g/dbs/spfilestandby.ora'   ;
   sql clone "alter system set spfile= ''/u01/app/oracle/product/11g/dbs/spfilestandby.ora''";
}
executing Memory Script

Starting backup at 24-NOV-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
Finished backup at 24-NOV-13

sql statement: alter system set spfile= ''/u01/app/oracle/product/11g/dbs/spfilestandby.ora''

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''STANDBY'' comment=
 ''duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''STANDBY'' comment= ''duplicate'' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    6263357440 bytes

Fixed Size                     2264856 bytes
Variable Size               3271557352 bytes
Database Buffers            2969567232 bytes
Redo Buffers                  19968000 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''PRIMARY'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name = 
 ''STANDBY'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   backup as copy current controlfile auxiliary format  '/u01/app/oracle/oradata/primary/control01.ctl';
   restore clone controlfile to  '/u01/app/oracle/fast_recovery_area/primary/control02.ctl' from 
 '/u01/app/oracle/oradata/primary/control01.ctl';
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''PRIMARY'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''STANDBY'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area    6263357440 bytes

Fixed Size                     2264856 bytes
Variable Size               3271557352 bytes
Database Buffers            2969567232 bytes
Redo Buffers                  19968000 bytes

Starting backup at 24-NOV-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/product/11g/dbs/snapcf_primary.f tag=TAG20131124T133028 RECID=1 STAMP=832339829
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 24-NOV-13

Starting restore at 24-NOV-13
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=191 device type=DISK

channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 24-NOV-13

database mounted

contents of Memory Script:
{
   set newname for datafile  1 to 
 "/u01/app/oracle/oradata/standby/system01.dbf";
   set newname for datafile  2 to 
 "/u01/app/oracle/oradata/standby/sysaux01.dbf";
   set newname for datafile  3 to 
 "/u01/app/oracle/oradata/standby/undotbs01.dbf";
   set newname for datafile  4 to 
 "/u01/app/oracle/oradata/standby/users01.dbf";
   backup as copy reuse
   datafile  1 auxiliary format 
 "/u01/app/oracle/oradata/standby/system01.dbf"   datafile 
 2 auxiliary format 
 "/u01/app/oracle/oradata/standby/sysaux01.dbf"   datafile 
 3 auxiliary format 
 "/u01/app/oracle/oradata/standby/undotbs01.dbf"   datafile 
 4 auxiliary format 
 "/u01/app/oracle/oradata/standby/users01.dbf"   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 24-NOV-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/primary/system01.dbf
output file name=/u01/app/oracle/oradata/standby/system01.dbf tag=TAG20131124T133035
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/primary/sysaux01.dbf
output file name=/u01/app/oracle/oradata/standby/sysaux01.dbf tag=TAG20131124T133035
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/primary/undotbs01.dbf
output file name=/u01/app/oracle/oradata/standby/undotbs01.dbf tag=TAG20131124T133035
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/primary/users01.dbf
output file name=/u01/app/oracle/oradata/standby/users01.dbf tag=TAG20131124T133035
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 24-NOV-13

sql statement: alter system archive log current

contents of Memory Script:
{
   backup as copy reuse
   archivelog like  "/u01/app/oracle/fast_recovery_area/PRIMARY/archivelog/2013_11_24/o1_mf_1_21_9933rq3h_.arc" auxiliary format 
 "/u01/app/oracle/fast_recovery_area/STANDBY/archivelog/2013_11_24/o1_mf_1_21_%u_.arc"   ;
   catalog clone recovery area;
   switch clone datafile all;
}
executing Memory Script

Starting backup at 24-NOV-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=21 RECID=3 STAMP=832339863
output file name=/u01/app/oracle/fast_recovery_area/STANDBY/archivelog/2013_11_24/o1_mf_1_21_0aopovsn_.arc RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 24-NOV-13

searching for all files in the recovery area

List of Files Unknown to the Database
=====================================
File Name: /u01/app/oracle/fast_recovery_area/STANDBY/archivelog/2013_11_24/o1_mf_1_21_0aopovsn_.arc
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u01/app/oracle/fast_recovery_area/STANDBY/archivelog/2013_11_24/o1_mf_1_21_0aopovsn_.arc

datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=832339815 file name=/u01/app/oracle/oradata/standby/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=832339815 file name=/u01/app/oracle/oradata/standby/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=832339815 file name=/u01/app/oracle/oradata/standby/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=832339815 file name=/u01/app/oracle/oradata/standby/users01.dbf

contents of Memory Script:
{
   set until scn  207621;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 24-NOV-13
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 21 is already on disk as file /u01/app/oracle/fast_recovery_area/STANDBY/archivelog/2013_11_24/o1_mf_1_21_0aopovsn_.arc
archived log file name=/u01/app/oracle/fast_recovery_area/STANDBY/archivelog/2013_11_24/o1_mf_1_21_0aopovsn_.arc thread=1 sequence=21
media recovery complete, elapsed time: 00:00:00
Finished recover at 24-NOV-13
Oracle instance started

Total System Global Area    6263357440 bytes

Fixed Size                     2264856 bytes
Variable Size               3271557352 bytes
Database Buffers            2969567232 bytes
Redo Buffers                  19968000 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''STANDBY'' comment=
 ''Reset to original value by RMAN'' scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''STANDBY'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    6263357440 bytes

Fixed Size                     2264856 bytes
Variable Size               3271557352 bytes
Database Buffers            2969567232 bytes
Redo Buffers                  19968000 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "STANDBY" RESETLOGS ARCHIVELOG 
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP   1 ( '/u01/app/oracle/oradata/standby/redo01.log' ) SIZE 50 M ,
  GROUP   2 ( '/u01/app/oracle/oradata/standby/redo02.log' ) SIZE 50 M ,
  GROUP   3 ( '/u01/app/oracle/oradata/standby/redo03.log' ) SIZE 50 M 
 DATAFILE
  '/u01/app/oracle/oradata/standby/system01.dbf'
 CHARACTER SET AL32UTF8


contents of Memory Script:
{
   set newname for tempfile  1 to 
 "/u01/app/oracle/oradata/standby/temp01.dbf";
   switch clone tempfile all;
   catalog clone datafilecopy  "/u01/app/oracle/oradata/standby/sysaux01.dbf", 
 "/u01/app/oracle/oradata/standby/undotbs01.dbf", 
 "/u01/app/oracle/oradata/standby/users01.dbf";
   switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/standby/temp01.dbf in control file

cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/standby/sysaux01.dbf RECID=1 STAMP=832339827
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/standby/undotbs01.dbf RECID=2 STAMP=832339827
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/standby/users01.dbf RECID=3 STAMP=832339827

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=832339827 file name=/u01/app/oracle/oradata/standby/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=832339827 file name=/u01/app/oracle/oradata/standby/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=832339827 file name=/u01/app/oracle/oradata/standby/users01.dbf

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 24-NOV-13

 


duplicate database 复制数据库
lyfhehe的博客
03-26 1167
duplicate database 关于复制数据库的几点总结： 1、Starting with Oracle Database 12c, the version of the RMAN client, target database, and auxiliary database must be the same. 也就是说不能在不同的版本上使用复制数据库的方式 2、测试过程中，在...
使用duplicate搭建oracle 11.2.0.4.0数据库active dataguard (ADG)
weeknd的博客
05-14 1359
1：配置情况（主库需要建立实例，从库只需要安装软件） 主库 Centos6.7 Oracle 11.2.0.4.0 IP:192.168.1.155  sid:orcl   备库 Centos6.7 Oracle 11.2.0.4.0软件 IP：192.168.1.156   2：关闭防火墙(两边都需要操作)   lsnrctl iptables stop   chk
RMAN duplicate database到新主机
weixin_34364135的博客
09-22 182
万变不离其宗 duplicate database 也是一个备份与恢复的过程。网上有 RAMN用于迁移数据库也是这个道理。duplicate database有一个优点，它为duplicated database生成了新的DBID。 metalink`ID 388431`.`1`给出了duplicate database的大致步骤：  1. Backup of the primary ...
Oracle11gR2使用RMAN duplicate复制数据库——Backup-based database duplicate
weixin_33813128的博客
11-08 300
本实例测试ORACLE 11g使用rman复制数据库。11g的RMAN duplicate可以通过Active database duplicate和Backup-based duplicate两种方法实现。这里的测试使用的是Backup-based duplicate。 应用场景。基于Active database duplicate参考http:/...
Duplicate Database
Aamir 的专栏
06-29 1574
In the following example of active database duplication, a connection is established to three database instances, all through the use of net service names: RMAN> CONNECT TARGET SYS/sysdba@prod;
duplicate database
cst730827的博客
06-06 174
前些天被用户叫去给创建备用库，通过rman duplicate在相同主机上生成辅助数据库，整理了下步骤。target database directory hierarchy/u01/app/oracle/oradata/ORC...
Centos6.5 64+oracle11.2.0.4+rman 搭建物理DG
treacle田 --love work and life......
03-04 1272
1环境列表 名称 主机1 主机2 主机名 orcl orcldg ip 192.168.204.210 192.168.204.211 2分别配置主机环境 2.1配置主机名 临时生效 hostname  name 永久生效vi /etc/sysconfig/ne
Oracle 11g Data Guard 使用duplicate from active database 创建物理DG
kexianmiao的专栏
10-16 2213
直接把原数据库进行复制,11g的RMANduplicate 可以通过Active databaseduplicate和Backup-based duplicate两种方法实现,这里用Activedatabase duplicate这种方式来搭建DG,主库的停机时间很少,只需要重启一下,使参数生效。也可以用这种方法进行DB迁移。DG搭建好，然后把备库激活就可以了,这样整个迁移中宕机时间也比
ORACLE之搭建DG（RMAN Duplicate方式）
Csong的专栏
03-23 6904
1.准备工作         首先得准备两个能够PING通，并且装了Oracle软件且已经建库的Linux虚拟机。操作系统不限，至少有一个虚拟机已经建好库，最好两个都建好相同SID的库，这样少很多创建目录的麻烦，这里库的SID都是orcl，Linux严格区分大小写，所以SID的大小写得注意。         我这里有两个名为PD和ST的Linux虚拟机。         PD:192.168
Oracle 数据迁移
qq_41141058的博客
07-16 1203
一、数据迁移课程概述 Oracle 跨平台跨版本数据迁移 停机时间 100G 4小时，20TB 2小时 数据量 数据库版本11.2.0.1 11.2.0.4 操作系统平台 win->linux,aix->linux,hpxu->linux 字节序 大端还是小端 x86 合适的迁移技术 数据迁移技术: dataguard RMAN异机恢复 exp/imp、expdp/impdp...
通过Oracle的duplicate database to 【newsid】实现数据库克隆；
ciyuanzha1639的博客
05-24 180
环境：Oracle10.2 RAC 到10.2单机环境运行；[@more@]1.准备好相应的目录结构 $cd /home/oracle/admin$mkdir test$cd test$mkdir adump bdump cdu...
【11.2拾遗】rman复制数据库 Duplicating a Database
viviliving的专栏
04-16 727
本章描述如何使用DUPLICATE命令创建独立运行的数据库副本。 This chapter contains the following topics: Overview of RMAN Database Duplication Preparing to Duplicate a Database Placing the Source Database in the Pr...
RMAN duplicate database
Watson的专栏
01-08 3331
原理是： Use the RMAN DUPLICATE command to create a duplicate database using target database backups. 通过RMAN用目标数据库的备份来创建duplicate database   什么是duplicate database: A duplicate database is a copy of t
ORACLE_OCP之Duplicating a Database-复制数据库
XiaoHG_优快云的博客
01-06 416
ORACLE_OCP之Duplicating a Database-复制数据库 文章目标： 列出复制数据库的目的 选择一种复制数据库的技术 用RMAN复制数据库 使用RMAN备份来复制数据库 根据正在运行的实例复制数据库 一、复制数据库 使用复制数据库主要用来: 测试备份和恢复过程 通过创建导出并将对象导入生产数据库来进行恢复。 复制数据库的操作过程: 使用RMAN DUPLICATE命令 在相同或单独的主机上 具有相同的内容或子集 由辅助通道执行，用于基于备份的复制 二、选择数据
Oracle DUPLICATE复制数据库
一玩儿家的田地
01-16 1256
一、DUPLICATE复制数据库         1.使用duplicate命令可以在不影响目标数据库（Target/Primary Database）的情况下，依靠目标数         据库的备份集创建一个Duplicate数据库（数据库副本）。         在创建时既可以选择完整复制目标数据库，也可以仅包含目标数据库中的部分表空间，目标数据库         和Dupli
使用oracle duplicate技术复制需要恢复的表空间到测试环境(异机)（二）
cuijiaoru6165的博客
11-24 214
续《使用oracle duplicate技术复制需要恢复的表空间到测试环境(异机)（一）》[@more@]datafile 61 not processed because file is offlinedatafile 62 ...
基于RMAN的异机数据库克隆(rman duplicate)
乐沙弥的世界
07-31 9497
对于基于生产环境下的数据库的版本升级或者测试新的应用程序的性能及其影响，备份恢复等等，我们可以采取从生产环境以克隆的方式将其克隆到本地而不影响生产数据库的正常使用。实现这个功能我们可以借助rman duplicate方式以及其简单的方式来完成。duplicate方式不同于OS级别的备份，它会为辅助数据库(克隆出来的数据库)生成一个新的dbid，而能够同时将目标数据库(原数据库)与辅助数据库注册到同
RMAN高级应用之Duplicate复制数据库(5)补充
cqbh2011的博客
12-07 472
使用rman的duplicate命令复制数据库系列，本系列可以视为一步一步学RMAN的姊妹篇~~~~ RMAN高级应用之Duplicate复制数据库(1)概述RMAN高级应用之Duplicate复制数据库(2)辅助实例RMAN高...
rman 在11.2.0.3 和11.2.0.4之间操作
最新发布
05-25
在11.2.0.3和11.2.0.4之间进行操作时，需要注意以下几点： 1. 版本差异：11.2.0.3和11.2.0.4之间存在一些差异，包括一些新增的功能、修复的问题等。在进行操作时需要注意版本差异，避免因版本不兼容而导致的问题。 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值