11g RMAN新特性 active database duplication 複製資料庫
第二.利用active database duplication 複製一個資料庫
前面1到5步 和建立standby 資料庫一樣
其中第5步設定dataguard相關初始化引數可以去掉
6.登入主庫 開始複製
C:\Documents and Settings\Administrator>set oracle_sid=primary
C:\Documents and Settings\Administrator>rman target / auxiliary
Recovery Manager: Release 11.1.0.6.0 - Production on Thu Jul 31 14:10:57 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: PRIMARY (DBID=1498839992)
connected to auxiliary database: PRIMARY (not mounted)
RMAN> RMAN> duplicate target database to 'standby'
2> from active database
3> spfile set DB_UNIQUE_NAME 'standby'
4> set log_archive_dest_1
5> 'LOCATION=d:\standby\archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
6> '
7> set CONTROL_FILES 'd:\app\administrator\oradata\standby\control01.ctl',
8> 'd:\app\administrator\oradata\standby\control02.ctl',
9> 'd:\app\administrator\oradata\standby\control03.ctl'
10> ;
Starting Duplicate Db at 31-JUL-08
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=98 device type=DISK
contents of Memory Script.:
{
backup as copy reuse
file 'D:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEPRIMARY.ORA' auxiliary format
'D:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILESTANDBY.ORA' ;
sql clone "alter system set spfile= ''D:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILESTANDBY.ORA''";
}
executing Memory Script
Starting backup at 31-JUL-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=138 device type=DISK
Finished backup at 31-JUL-08
sql statement: alter system set spfile= ''D:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILESTANDBY.ORA''
contents of Memory Script.:
{
sql clone "alter system set db_name =
''STANDBY'' comment=
''duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''standby'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_1 =
''LOCATION=d:\standby\archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES)'' comment=
'''' scope=spfile";
sql clone "alter system set CONTROL_FILES =
''d:\app\administrator\oradata\standby\control01.ctl'', ''d:\app\administrator\oradata\standby\control02.ctl'', ''d:\app\administrator\oradata\standby\control03.ctl'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount ;
}
executing Memory Script
sql statement: alter system set db_name = ''STANDBY'' comment= ''duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''standby'' comment= '''' scope=spfile
sql statement: alter system set log_archive_dest_1 = ''LOCATION=d:\standby\archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES)'' comment= '''' scope=spfile
sql statement: alter system set CONTROL_FILES = ''d:\app\administrator\oradata\standby\control01.ctl'', ''d:\app\administrator\oradata\standby\control02.ctl'', ''d:\app\administrator\oradata\standby\control03.ctl'' comment= '''' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 431038464 bytes
Fixed Size 1333676 bytes
Variable Size 255854164 bytes
Database Buffers 167772160 bytes
Redo Buffers 6078464 bytes
contents of Memory Script.:
{
set newname for datafile 1 to
"D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSTEM01.DBF";
set newname for datafile 2 to
"D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBF";
set newname for datafile 3 to
"D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF";
set newname for datafile 4 to
"D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF";
set newname for datafile 5 to
"D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF";
backup as copy reuse
datafile 1 auxiliary format
"D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSTEM01.DBF" datafile
2 auxiliary format
"D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBF" datafile
3 auxiliary format
"D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF" datafile
4 auxiliary format
"D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF" datafile
5 auxiliary format
"D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.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
executing command: SET NEWNAME
Starting backup at 31-JUL-08
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=D:\APP\ADMINISTRATOR\ORADATA\PRIMARY\SYSTEM01.DBF
output file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSTEM01.DBF tag=TAG20080731T141157 RECID=0 STAMP=0
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=D:\APP\ADMINISTRATOR\ORADATA\PRIMARY\UNDOTBS01.DBF
output file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF tag=TAG20080731T141157 RECID=0 STAMP=0
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=D:\APP\ADMINISTRATOR\ORADATA\PRIMARY\SYSAUX01.DBF
output file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBF tag=TAG20080731T141157 RECID=0 STAMP=0
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=D:\APP\ADMINISTRATOR\ORADATA\PRIMARY\TEST01_NEW.DBF
output file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF tag=TAG20080731T141157 RECID=0 STAMP=0
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=D:\APP\ADMINISTRATOR\ORADATA\PRIMARY\USERS01.DBF
output file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF tag=TAG20080731T141157 RECID=0 STAMP=0
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 31-JUL-08
sql statement: alter system archive log current
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "STANDBY" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( 'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\REDO01.LOG' ) SIZE 50 M REUSE,
GROUP 2 ( 'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\REDO02.LOG' ) SIZE 50 M REUSE,
GROUP 3 ( 'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\REDO03.LOG' ) SIZE 50 M REUSE
DATAFILE
'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSTEM01.DBF'
CHARACTER SET WE8MSWIN1252
contents of Memory Script.:
{
backup as copy reuse
archivelog like "D:\PRIMARY\ARCHIVELOG\ARC00047_0661357304.001" auxiliary format
"D:\STANDBY\ARCHIVELOG\ARC00047_0661357304.001" ;
catalog clone archivelog "D:\STANDBY\ARCHIVELOG\ARC00047_0661357304.001";
switch clone datafile all;
}
executing Memory Script
Starting backup at 31-JUL-08
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=47 RECID=65 STAMP=661529574
output file name=D:\STANDBY\ARCHIVELOG\ARC00047_0661357304.001 RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 31-JUL-08
cataloged archived log
archived log file name=D:\STANDBY\ARCHIVELOG\ARC00047_0661357304.001 RECID=1 STAMP=661529578
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=661529578 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=661529579 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=661529579 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=661529579 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF
contents of Memory Script.:
{
set until scn 286773;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 31-JUL-08
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=153 device type=DISK
starting media recovery
archived log for thread 1 with sequence 47 is already on disk as file D:\STANDBY\ARCHIVELOG\ARC00047_0661357304.001
archived log file name=D:\STANDBY\ARCHIVELOG\ARC00047_0661357304.001 thread=1 sequence=47
media recovery complete, elapsed time: 00:00:00
Finished recover at 31-JUL-08
contents of Memory Script.:
{
shutdown clone immediate;
startup clone nomount ;
}
executing Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 431038464 bytes
Fixed Size 1333676 bytes
Variable Size 255854164 bytes
Database Buffers 167772160 bytes
Redo Buffers 6078464 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "STANDBY" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( 'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\REDO01.LOG' ) SIZE 50 M REUSE,
GROUP 2 ( 'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\REDO02.LOG' ) SIZE 50 M REUSE,
GROUP 3 ( 'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\REDO03.LOG' ) SIZE 50 M REUSE
DATAFILE
'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSTEM01.DBF'
CHARACTER SET WE8MSWIN1252
contents of Memory Script.:
{
set newname for tempfile 1 to
"D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEMP01.DBF";
switch clone tempfile all;
catalog clone datafilecopy "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBF";
catalog clone datafilecopy "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF";
catalog clone datafilecopy "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF";
catalog clone datafilecopy "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEMP01.DBF in control file
cataloged datafile copy
datafile copy file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBF RECID=1 STAMP=661529588
cataloged datafile copy
datafile copy file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF RECID=2 STAMP=661529588
cataloged datafile copy
datafile copy file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF RECID=3 STAMP=661529588
cataloged datafile copy
datafile copy file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF RECID=4 STAMP=661529588
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=661529588 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=661529588 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=661529588 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=661529588 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF
contents of Memory Script.:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 31-JUL-08
7.登入複製的資料庫
C:\Documents and Settings\Administrator>set oracle_sid=standby
C:\Documents and Settings\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 31 14:05:15 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select status,instance_name from v$instance;
STATUS INSTANCE_NAME
------------ ----------------
OPEN standby
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination d:\standby\archivelog
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7199859/viewspace-416194/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 11g RMAN新特性 active database duplication createing standbyDatabase
- 11g 新特性—— Active Database DuplicationDatabase
- 11g 新特性—— Active Database Duplication for A standby databaseDatabase
- 使用RMAN複製資料庫 active database資料庫Database
- 11g RMAN新特性active database duplicate 資料庫異構Database資料庫
- RMAN duplicate from active database 複製資料庫Database資料庫
- oracle 11gr2 活動資料庫複製(active database duplication)Oracle資料庫Database
- 11g rman新特性 duplicate target database for standby from active databaseDatabase
- oracle 11g duplicate from active database 複製資料庫(四)OracleDatabase資料庫
- oracle 11g duplicate from active database 複製資料庫(三)OracleDatabase資料庫
- oracle 11g duplicate from active database 複製資料庫(二)OracleDatabase資料庫
- oracle 11g duplicate from active database 複製資料庫(一)OracleDatabase資料庫
- Oracle Active database duplicationOracleDatabase
- Oracle 11gR2 使用 RMAN duplicate from active database 複製資料庫OracleDatabase資料庫
- 實戰10g新特性之rman duplicate複製資料庫資料庫
- Oracle 11g Rman Active database duplicateOracleDatabase
- 使用oracle 11g rman新特性 duplicate target database for standby from active database 建立物理dataguard並開啟RealOracleDatabase
- RMAN複製資料庫（十)資料庫
- RMAN複製資料庫（九）資料庫
- RMAN複製資料庫（八）資料庫
- RMAN複製資料庫（七)資料庫
- RMAN複製資料庫（六）資料庫
- RMAN複製資料庫（五）資料庫
- RMAN複製資料庫（四）資料庫
- RMAN複製資料庫（三）資料庫
- RMAN複製資料庫（二）資料庫
- RMAN複製資料庫（一）資料庫
- 使用RMAN複製資料庫資料庫
- oracle rman複製資料庫Oracle資料庫
- RMAN 同機複製資料庫資料庫
- RMAN的活動資料庫複製資料庫
- RMAN 異機複製資料庫資料庫
- rman管理的複製資料庫資料庫
- 11g新特性--active dataguard
- 【RMAN】使用RMAN duplicate複製同機資料庫資料庫
- 【RMAN】使用duplicate本地複製資料庫資料庫
- duplicate rman複製資料庫技術資料庫
- 克隆資料庫之RMAN複製（二）資料庫