【RMAN】使用duplicate本地复制数据库

最新推荐文章于 2024-07-18 16:32:46 发布
最新推荐文章于 2024-07-18 16:32:46 发布
阅读量129 收藏
点赞数
文章标签： 数据库 网络 操作系统

任务：同一台主机使用RMAN的duplicate复制数据库，linux操作系统中有一套正在运行的数据库enmoedu  复制后的数据库aux

 

实验步骤：

1.       主库RMAN备份

[oracle@test ~]$ export ORACLE_SID=enmoedu

[oracle@test ~]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jun 6 00:43:13 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ENMOEDU (DBID=108163061)

 

RMAN> backup database plus archivelog;

 

Starting backup at 06-JUN-14

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=61 device type=DISK

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/11g/app/oracle/oradata/enmoedu/system01.dbf

input datafile file number=00002 name=/11g/app/oracle/oradata/enmoedu/sysaux01.dbf

input datafile file number=00005 name=/11g/app/oracle/oradata/enmoedu/example01.dbf

input datafile file number=00003 name=/11g/app/oracle/oradata/enmoedu/undotbs01.dbf

input datafile file number=00006 name=/11g/app/oracle/oradata/enmoedu/pitr.dbf

input datafile file number=00007 name=/11g/app/oracle/oradata/enmoedu/pitr_ind.dbf

input datafile file number=00008 name=/11g/app/oracle/oradata/enmoedu/index01.dbf

input datafile file number=00010 name=/11g/app/oracle/oradata/enmoedu/ts_users_1.dbf

input datafile file number=00004 name=/11g/app/oracle/oradata/enmoedu/users01.dbf

input datafile file number=00009 name=/11g/app/oracle/oradata/enmoedu/ts_users.dbf

input datafile file number=00011 name=/11g/app/oracle/oradata/enmoedu/ts_users1.dbf

channel ORA_DISK_1: starting piece 1 at 06-JUN-14

channel ORA_DISK_1: finished piece 1 at 06-JUN-14

piece handle=/11g/app/backup/db_53pa49ha_1_1.bak tag=TAG20140606T004322 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

including current SPFILE in backup set

channel ORA_DISK_1: starting piece 1 at 06-JUN-14

channel ORA_DISK_1: finished piece 1 at 06-JUN-14

piece handle=/11g/app/backup/db_54pa49i3_1_1.bak tag=TAG20140606T004322 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 06-JUN-14

 

RMAN>quit

 

2.       配置监听文件及tnsnames.ora

--监听改静态 listener.ora 因为复制的aux库是nomount状态，pmon是mount的时候去动态注册，所以需要加静态注册。

Listener.ora文件修改后：

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = enmoedu)

      (ORACLE_HOME = /11g/app/oracle/product/11.2.0/dbhome)

      (SID_NAME = enmoedu)

    )

 

    (SID_DESC =

      (GLOBAL_DBNAME = aux)

      (ORACLE_HOME = /11g/app/oracle/product/11.2.0/dbhome)

      (SID_NAME = aux)

    )

  )

 

Tnsnames.ora文件中添加：

aux =

(DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.8)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = aux)

    )

)

 

3.       通过enmoedu库的SPFILE生成PFILE，复制PFILE文件，将SID名字更改为aux，并且将文件中参数进行修改。

[oracle@test ~]$ sqlplus  / as sysdba

SQLPlus Release 11.2.0.3.0 Production on Thu Jun 5 235614 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 

Connected to

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL select instance_name,status from v$instance;

 

INSTANCE_NAME    STATUS

---------------- ------------

enmoedu          OPEN

 

SQL create pfile from spfile;

 

File created.

 

SQLexit

 

[oracle@test ~]$ cd $ORACLE_HOMEdbs

 

[oracle@test dbs]$ cp initenmoedu.ora initaux.ora

 

修改前initaux.ora

enmoedu.__db_cache_size=201326592

enmoedu.__java_pool_size=4194304

enmoedu.__large_pool_size=4194304

enmoedu.__oracle_base='/11g/app/oracle'#ORACLE_BASE set from environment

enmoedu.__pga_aggregate_target=293601280

enmoedu.__sga_target=545259520

enmoedu.__shared_io_pool_size=0

enmoedu.__shared_pool_size=318767104

enmoedu.__streams_pool_size=8388608

*._shared_io_pool_size=0

*.audit_file_dest='/11g/app/oracle/admin/enmoedu/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/11g/app/oracle/oradata/enmoedu/control01.ctl','/11g/app/oracle/oradata/enmoedu/control02.ctl'

*.db_block_size=8192

*.db_cache_size=201326592

*.db_create_file_dest=''

*.db_domain=''

*.db_flashback_retention_target=2880

*.db_name='enmoedu'

*.db_recovery_file_dest_size=2147483648

*.db_recovery_file_dest='/11g/app/backup'

*.db_writer_processes=2

*.diagnostic_dest='/11g/app/oracle'

*.java_pool_size=4194304

*.large_pool_size=4194304

*.log_archive_format='%t_%s_%r.arc'

*.memory_target=0

*.open_cursors=300

*.pga_aggregate_target=293601280

*.processes=300

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=0

*.shared_pool_size=318767104

*.streams_pool_size=8388608

*.undo_tablespace='UNDOTBS1'

 

 

修改后initaux.ora(具体参数可根据自己环境进行调整）标黄色部分为更改项，要建立更改后的路径目录

aux.__db_cache_size=201326592

aux.__java_pool_size=4194304

aux.__large_pool_size=4194304

aux.__oracle_base='/11g/app/oracle'#ORACLE_BASE set from environment

aux.__pga_aggregate_target=293601280

aux.__sga_target=545259520

aux.__shared_io_pool_size=0

aux.__shared_pool_size=318767104

aux.__streams_pool_size=8388608

*._shared_io_pool_size=0

*.audit_file_dest='/11g/app/oracle/admin/aux/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/11g/app/oracle/oradata/aux/control01.ctl','/11g/app/oracle/oradata/aux/control02.ctl'

*.db_block_size=8192

*.db_cache_size=201326592

*.db_create_file_dest=''

*.db_domain=''

*.db_flashback_retention_target=2880

*.db_name='aux'

*.db_recovery_file_dest_size=2147483648

*.db_recovery_file_dest='/11g/app/flashback_aux'

*.db_writer_processes=2

*.diagnostic_dest='/11g/app/oracle'

*.java_pool_size=4194304

*.large_pool_size=4194304

*.log_archive_format='%t_%s_%r.arc'

*.memory_target=0

*.open_cursors=300

*.pga_aggregate_target=293601280

*.processes=300

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=0

*.shared_pool_size=318767104

*.streams_pool_size=8388608

*.undo_tablespace='UNDOTBS1'

*.db_file_name_convert='/11g/app/oracle/oradata/enmoedu/','/11g/app/oracle/oradata/aux/'

*.log_file_name_convert='/11g/app/oracle/oradata/enmoedu/','/11g/app/oracle/oradata/aux/'

 

 

4.       通过修改后的initaux.ora文件建立spfileaux.ora，并且将数据库实例启动到nomount状态。

[oracle@test dbs]$ export ORACLE_SID=aux

[oracle@test dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 6 00:22:42 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 

Connected to an idle instance.

 

SQL> create spfile from pfile;

 

File created.

 

SQL> startup nomount;

ORACLE instance started.

 

Total System Global Area  542851072 bytes

Fixed Size                  2230072 bytes

Variable Size             335546568 bytes

Database Buffers          201326592 bytes

Redo Buffers                3747840 bytes

SQL>

 

5.       将主库备份的文件复制到aux建立的db_recovery_file_dest目录下

[oracle@test backup]$ pwd

/11g/app/backup

[oracle@test backup]$ cp db*.bak  /11g/app/flashback_aux

 

6.       RMAN连接主库enmoedu并且使用auxiliary参数连接备库aux

[oracle@test flashback_aux]$ rman target / auxiliary sys/oracle@aux

 

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jun 6 06:58:28 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ENMOEDU (DBID=108163061)

connected to auxiliary database: AUX (not mounted)

 

7.       执行duplicate进行备份

 

RMAN> duplicate database enmoedu to aux nofilenamecheck;

 

Starting Duplicate Db at 06-JUN-14

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=21 device type=DISK

 

contents of Memory Script:

{

   sql clone "alter system set  db_name =

 ''ENMOEDU'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   sql clone "alter system set  db_unique_name =

 ''AUX'' comment=

 ''Modified by RMAN duplicate'' scope=spfile";

   shutdown clone immediate;

   startup clone force nomount

   restore clone primary controlfile;

   alter clone database mount;

}

executing Memory Script

 

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

 

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

 

Oracle instance shut down

 

Oracle instance started

 

Total System Global Area     542851072 bytes

 

Fixed Size                     2230072 bytes

Variable Size                335546568 bytes

Database Buffers             201326592 bytes

Redo Buffers                   3747840 bytes

 

Starting restore at 06-JUN-14

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=19 device type=DISK

 

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 /11g/app/backup/db_5hpa4vc5_1_1.bak

channel ORA_AUX_DISK_1: piece handle=/11g/app/backup/db_5hpa4vc5_1_1.bak tag=TAG20140606T065539

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/11g/app/oracle/oradata/aux/control01.ctl

output file name=/11g/app/oracle/oradata/aux/control02.ctl

Finished restore at 06-JUN-14

 

database mounted

 

contents of Memory Script:

{

   set until scn  3533705;

   set newname for datafile  1 to

 "/11g/app/oracle/oradata/aux/system01.dbf";

   set newname for datafile  2 to

 "/11g/app/oracle/oradata/aux/sysaux01.dbf";

   set newname for datafile  3 to

 "/11g/app/oracle/oradata/aux/undotbs01.dbf";

   set newname for datafile  4 to

 "/11g/app/oracle/oradata/aux/users01.dbf";

   set newname for datafile  5 to

 "/11g/app/oracle/oradata/aux/example01.dbf";

   set newname for datafile  6 to

 "/11g/app/oracle/oradata/aux/pitr.dbf";

   set newname for datafile  7 to

 "/11g/app/oracle/oradata/aux/pitr_ind.dbf";

   set newname for datafile  8 to

 "/11g/app/oracle/oradata/aux/index01.dbf";

   set newname for datafile  9 to

 "/11g/app/oracle/oradata/aux/ts_users.dbf";

   set newname for datafile  10 to

 "/11g/app/oracle/oradata/aux/ts_users_1.dbf";

   set newname for datafile  11 to

 "/11g/app/oracle/oradata/aux/ts_users1.dbf";

   set newname for datafile  12 to

 "/11g/app/oracle/oradata/aux/sqlldr01.dbf";

   set newname for datafile  13 to

 "/11g/app/oracle/oradata/aux/sqlldr02.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

 

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 restore at 06-JUN-14

using channel ORA_AUX_DISK_1

 

channel ORA_AUX_DISK_1: starting datafile backup set restore

channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_AUX_DISK_1: restoring datafile 00001 to /11g/app/oracle/oradata/aux/system01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00002 to /11g/app/oracle/oradata/aux/sysaux01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00003 to /11g/app/oracle/oradata/aux/undotbs01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00004 to /11g/app/oracle/oradata/aux/users01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00005 to /11g/app/oracle/oradata/aux/example01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00006 to /11g/app/oracle/oradata/aux/pitr.dbf

channel ORA_AUX_DISK_1: restoring datafile 00007 to /11g/app/oracle/oradata/aux/pitr_ind.dbf

channel ORA_AUX_DISK_1: restoring datafile 00008 to /11g/app/oracle/oradata/aux/index01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00009 to /11g/app/oracle/oradata/aux/ts_users.dbf

channel ORA_AUX_DISK_1: restoring datafile 00010 to /11g/app/oracle/oradata/aux/ts_users_1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00011 to /11g/app/oracle/oradata/aux/ts_users1.dbf

channel ORA_AUX_DISK_1: restoring datafile 00012 to /11g/app/oracle/oradata/aux/sqlldr01.dbf

channel ORA_AUX_DISK_1: restoring datafile 00013 to /11g/app/oracle/oradata/aux/sqlldr02.dbf

channel ORA_AUX_DISK_1: reading from backup piece /11g/app/backup/db_5gpa4vbb_1_1.bak

channel ORA_AUX_DISK_1: piece handle=/11g/app/backup/db_5gpa4vbb_1_1.bak tag=TAG20140606T065539

channel ORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25

Finished restore at 06-JUN-14

 

contents of Memory Script:

{

   switch clone datafile all;

}

executing Memory Script

 

datafile 1 switched to datafile copy

input datafile copy RECID=26 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/system01.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=27 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=28 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=29 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/users01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=30 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/example01.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=31 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/pitr.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=32 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/pitr_ind.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=33 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/index01.dbf

datafile 9 switched to datafile copy

input datafile copy RECID=34 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/ts_users.dbf

datafile 10 switched to datafile copy

input datafile copy RECID=35 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/ts_users_1.dbf

datafile 11 switched to datafile copy

input datafile copy RECID=36 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/ts_users1.dbf

datafile 12 switched to datafile copy

input datafile copy RECID=37 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/sqlldr01.dbf

datafile 13 switched to datafile copy

input datafile copy RECID=38 STAMP=849509960 file name=/11g/app/oracle/oradata/aux/sqlldr02.dbf

 

contents of Memory Script:

{

   set until scn  3533705;

   recover

   clone database

    delete archivelog

   ;

}

executing Memory Script

 

executing command: SET until clause

 

Starting recover at 06-JUN-14

using channel ORA_AUX_DISK_1

 

starting media recovery

 

archived log for thread 1 with sequence 50 is already on disk as file /11g/app/backup/ENMOEDU/archivelog/2014_06_06/o1_mf_1_50_9s1xd7lq_.arc

archived log file name=/11g/app/backup/ENMOEDU/archivelog/2014_06_06/o1_mf_1_50_9s1xd7lq_.arc thread=1 sequence=50

media recovery complete, elapsed time: 00:00:00

Finished recover at 06-JUN-14

Oracle instance started

 

Total System Global Area     542851072 bytes

 

Fixed Size                     2230072 bytes

Variable Size                335546568 bytes

Database Buffers             201326592 bytes

Redo Buffers                   3747840 bytes

 

contents of Memory Script:

{

   sql clone "alter system set  db_name =

 ''AUX'' 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 =  ''AUX'' 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     542851072 bytes

 

Fixed Size                     2230072 bytes

Variable Size                335546568 bytes

Database Buffers             201326592 bytes

Redo Buffers                   3747840 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE "AUX" RESETLOGS ARCHIVELOG

  MAXLOGFILES     16

  MAXLOGMEMBERS      3

  MAXDATAFILES      100

  MAXINSTANCES     8

  MAXLOGHISTORY      292

 LOGFILE

  GROUP   1 ( '/11g/app/oracle/oradata/aux/redo01.log' ) SIZE 50 M  REUSE,

  GROUP   2 ( '/11g/app/oracle/oradata/aux/redo2.log' ) SIZE 50 M  REUSE,

  GROUP   3 ( '/11g/app/oracle/oradata/aux/redo03.log' ) SIZE 50 M  REUSE,

  GROUP   4 ( '/11g/app/oracle/oradata/aux/redo04.log' ) SIZE 50 M  REUSE

 DATAFILE

  '/11g/app/oracle/oradata/aux/system01.dbf'

 CHARACTER SET ZHS16GBK

 

 

contents of Memory Script:

{

   set newname for tempfile  1 to

 "/11g/app/oracle/oradata/aux/temp01.dbf";

   switch clone tempfile all;

   catalog clone datafilecopy  "/11g/app/oracle/oradata/aux/sysaux01.dbf",

 "/11g/app/oracle/oradata/aux/undotbs01.dbf",

 "/11g/app/oracle/oradata/aux/users01.dbf",

 "/11g/app/oracle/oradata/aux/example01.dbf",

 "/11g/app/oracle/oradata/aux/pitr.dbf",

 "/11g/app/oracle/oradata/aux/pitr_ind.dbf",

 "/11g/app/oracle/oradata/aux/index01.dbf",

 "/11g/app/oracle/oradata/aux/ts_users.dbf",

 "/11g/app/oracle/oradata/aux/ts_users_1.dbf",

 "/11g/app/oracle/oradata/aux/ts_users1.dbf",

 "/11g/app/oracle/oradata/aux/sqlldr01.dbf",

 "/11g/app/oracle/oradata/aux/sqlldr02.dbf";

   switch clone datafile all;

}

executing Memory Script

 

executing command: SET NEWNAME

 

renamed tempfile 1 to /11g/app/oracle/oradata/aux/temp01.dbf in control file

 

cataloged datafile copy

datafile copy file name=/11g/app/oracle/oradata/aux/sysaux01.dbf RECID=1 STAMP=849509970

cataloged datafile copy

datafile copy file name=/11g/app/oracle/oradata/aux/undotbs01.dbf RECID=2 STAMP=849509970

cataloged datafile copy

datafile copy file name=/11g/app/oracle/oradata/aux/users01.dbf RECID=3 STAMP=849509970

cataloged datafile copy

datafile copy file name=/11g/app/oracle/oradata/aux/example01.dbf RECID=4 STAMP=849509970

cataloged datafile copy

datafile copy file name=/11g/app/oracle/oradata/aux/pitr.dbf RECID=5 STAMP=849509970

cataloged datafile copy

datafile copy file name=/11g/app/oracle/oradata/aux/pitr_ind.dbf RECID=6 STAMP=849509970

cataloged datafile copy

datafile copy file name=/11g/app/oracle/oradata/aux/index01.dbf RECID=7 STAMP=849509970

cataloged datafile copy

datafile copy file name=/11g/app/oracle/oradata/aux/ts_users.dbf RECID=8 STAMP=849509970

cataloged datafile copy

datafile copy file name=/11g/app/oracle/oradata/aux/ts_users_1.dbf RECID=9 STAMP=849509970

cataloged datafile copy

datafile copy file name=/11g/app/oracle/oradata/aux/ts_users1.dbf RECID=10 STAMP=849509970

cataloged datafile copy

datafile copy file name=/11g/app/oracle/oradata/aux/sqlldr01.dbf RECID=11 STAMP=849509970

cataloged datafile copy

datafile copy file name=/11g/app/oracle/oradata/aux/sqlldr02.dbf RECID=12 STAMP=849509970

 

datafile 2 switched to datafile copy

input datafile copy RECID=1 STAMP=849509970 file name=/11g/app/oracle/oradata/aux/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=2 STAMP=849509970 file name=/11g/app/oracle/oradata/aux/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=3 STAMP=849509970 file name=/11g/app/oracle/oradata/aux/users01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=4 STAMP=849509970 file name=/11g/app/oracle/oradata/aux/example01.dbf

datafile 6 switched to datafile copy

input datafile copy RECID=5 STAMP=849509970 file name=/11g/app/oracle/oradata/aux/pitr.dbf

datafile 7 switched to datafile copy

input datafile copy RECID=6 STAMP=849509970 file name=/11g/app/oracle/oradata/aux/pitr_ind.dbf

datafile 8 switched to datafile copy

input datafile copy RECID=7 STAMP=849509970 file name=/11g/app/oracle/oradata/aux/index01.dbf

datafile 9 switched to datafile copy

input datafile copy RECID=8 STAMP=849509970 file name=/11g/app/oracle/oradata/aux/ts_users.dbf

datafile 10 switched to datafile copy

input datafile copy RECID=9 STAMP=849509970 file name=/11g/app/oracle/oradata/aux/ts_users_1.dbf

datafile 11 switched to datafile copy

input datafile copy RECID=10 STAMP=849509970 file name=/11g/app/oracle/oradata/aux/ts_users1.dbf

datafile 12 switched to datafile copy

input datafile copy RECID=11 STAMP=849509970 file name=/11g/app/oracle/oradata/aux/sqlldr01.dbf

datafile 13 switched to datafile copy

input datafile copy RECID=12 STAMP=849509970 file name=/11g/app/oracle/oradata/aux/sqlldr02.dbf

 

contents of Memory Script:

{

   Alter clone database open resetlogs;

}

executing Memory Script

 

database opened

Finished Duplicate Db at 06-JUN-14

 

RMAN>

 

8.       检查aux数据状态

[oracle@test ~]$ export ORACLE_SID=aux

[oracle@test ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 6 10:11:41 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

 

Connected to:

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

SQL> select instance_name,status from v$instance;

 

INSTANCE_NAME    STATUS

----------------      ------------

aux              OPEN

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26148431/viewspace-1225284/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26148431/viewspace-1225284/

civbl2961
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
使用RMAN创建复制数据库
12-14
我的实验环境： 　- 源数据库A机： 　RHEL6.4 + Oracle 11.2.0.4 　IP地址：192.168.99.159 　db_name=oradb 数据库已正常运行 ...运行RMAN DUPLICATE命令 　5.打开辅助实例 　1.为复制数据库
RMAN duplicate 方式 做个备库
海鲨MYSQL精英架构师
04-28 6319
采用RMAN duplicate 方式做备库 可以说是ORACLE 公司对 以前做DATA GUARD 方式的 用户友好性的提升.这样我们不用去 备份数据文件,然后网络传送, 再还原恢复操作了.这里就一个简单的命令搞定一切那就是 duplicate target database for standby from active database nofilenamecheck;0 前提是你已经搞定
duplicate 数据库 from backupset [oracle 11.2.0.3 + asm] => [oracle 11.2.0.3 + fs ]
weixin_30740295的博客
05-11 97
参考 rhel64_11gr2_asm.txt 安装好另一台机器的rhel6.4，gi software，rdbms software。 vi /etc/hosts 10.1.1.35 asmnode 10.1.1.36 asmnodedup 在asmnode 节点 查看initdbasm.ora 文件，确保target database 处于归档模式，否则d...
11g新特性之active databaes duplicate
Linucle的专栏
05-26 1221
一，环境信息 主库：rhel6.2 oracle 11.2.0.4 duplicate库：orace linux 6.6 oracle 11.2.0.3 注意：数据库软件版本一定要相同，最起码compatible参数要一致 二，在duplicate端创建参数文件和密码文件 1.确认主库数据文件和日志文件的路径 SQL> select name from v$datafile
使用rman中的duplicate复制数据库
03-19 236
目标库和复制库环境: OS: Linux Red Hat AS 4 DB Version: 10.2.0.1 1.目标库和复制库信息 Rman 中的目标库(t...
【DataGuard安装】Oracle单实例到RAC用duplicate active database做DataGuard之一
DATA
11-20 2273
说明 1.源端：（11g单实例） IP:                      192.168.114.176 Hostname:    vmzj db_unique_name:         vmzj   2.目标端：（11gRAC） IP:                      192.168.20.241,  192.168,20.242 VIP:
RMAN高级应用之Duplicate复制数据库.docx
10-25
RMAN高级应用之Duplicate复制数据库
Oracle 11gR2 使用 RMAN duplicate from active database 复制数据库
02-28
Oracle 11gR2 使用 RMAN duplicate from active database 复制数据库 Oracle 11gR2 中使用 RMAN duplicate from active database 复制数据库是一种高效的数据库复制方法。这种方法可以直接从活动数据库复制，省去...
ORACLE Duplicate复制数据库
12-20
duplicate绝对干货。利用duplicate复制数据库，文档中包换每一步的试验步骤，详细说明了每一步的作用及用途，和注意事项，一步一步至试验成功，绝对一次成功。
Oracle RMAN 异机 复制数据库
04-22
以下是如何使用RMAN进行异机复制数据库的详细步骤： 1. **构建辅助数据库目录结构**： 在辅助服务器上，你需要创建与目标数据库相同的目录结构，包括Oracle数据目录、参数文件、口令文件以及日志文件等。例如，在`...
数据库升级二 11.2.0.3升级到11.2.0.4完整步骤
乡下人
07-30 2410
转自:http://blog.itpub.net/20674423/viewspace-1352257/ 探索Oracle之数据库升级二 11.2.0.3升级到11.2.0.4完整步骤 说明： 这篇文章主要是记录下单实例环境下Oracle 11.2.0.1升级到11.2.0.3的过程，当然RAC的升级是会有所不同。但是他们每个版本之间升级步骤都是差不多的，先升...
Oracle 11.2.0.1升级到11.2.0.3
coco3600的博客
09-28 169
Oracle 11.2.0.1升级到11.2.0.3 最近听了李光老师的关于oracle的升级公开课，深有感悟，之前一直想自己测试的，没有下定决心，这几天自己在虚拟机上测试了一...
Oracle 11g Data Guard 使用duplicate from active database 创建物理DG
kexianmiao的专栏
10-16 2139
直接把原数据库进行复制,11g的RMANduplicate 可以通过Active databaseduplicate和Backup-based duplicate两种方法实现,这里用Activedatabase duplicate这种方式来搭建DG,主库的停机时间很少,只需要重启一下,使参数生效。也可以用这种方法进行DB迁移。DG搭建好，然后把备库激活就可以了,这样整个迁移中宕机时间也比
用duplicate创建物理DG
Dillon Oracle博客
08-31 1086
实验环境： OEL 5.8 +oracle 11.2.0.3 主机： source.up.com     192.168.1.161     target.up.com      192.168.1.162   实验目的： 将source机器上的source数据库duplicate到 target主机上，命名为standby     db_name: source db_
使用RMAN的duplicate命令创建Physical Standby Database
cuiju3758的博客
06-19 137
1. 确保P运行在Archivelog 模式下 2. 设置P端的初始化参数DB_NAME= shacol11 DB_UNIQUE_NAME= shacol11 db_recovery_file_dest_size=200gdb_...
RMAN 兼容性矩阵及版本比较
cuanxiu7017的博客
08-11 95
今天客户配置RMAN 备份发现错误。 报RMAN-6186 错误，发现是RMAN 版本之间的错误。解决后顺便将RMAN 多版本的兼容性列表发出来，希望大家有所帮助。 Target/Auxi...
RMAN--用rman的duplicate来复制数据库
cuifan5176的博客
05-25 244
在日常的工作中我们有很多种方法来clone一个数据库，今天早上起来花了二十分钟测试了一下，记下测试用到的脚本。所有的这些脚本都在目标库上运行--先做一次包括archivelog的全备份run {allocate channel ...
【星海随笔】vCenter Server 和主机管理。
weixin_41997073的博客
07-16 194
1.方法：删除页面信息，然后断连这个受管主机，断开受管主机的连接不会将其从 vCenter Server 中移除，而只是临时挂起 vCenter Server 执行的所有监控活动。2.方法：在分布式存储中找到该虚拟设备的存储盘，文件里找到相关的vmdk磁盘文件，点击注册虚拟机。当资料不匹配时候，可以删除展示页面，孤立的设备的 匹配位置的信息。断开后，然后重新连接，既可以重新识别受监管的主机。数据库在Vserver中展示的是一个数据库的资料，应该是client的资料。1.确定为资料不匹配导致的展示问题。
PostgreSQL的逻辑架构
最新发布
weixin_41992498的博客
07-18 96
一、PostgreSql的逻辑架构：所有者：
RMAN高级应用：Duplicate复制数据库详解
"RMAN高级应用之Duplicate复制数据库" Oracle数据库的Recovery Manager (RMAN) 是一个强大的工具，用于数据库备份、恢复和维护。在RMAN中，`DUPLICATE`命令是一个非常实用的功能，它允许用户在保留原始数据库的同时...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值