一、主库rac情况:
#public
10.10.6.53 rac1
10.10.6.54 rac2
#private
1.1.1.1 rac1-priv
1.1.1.2 rac2-priv
#virtual
10.10.6.71 rac1-vip
10.10.6.72 rac2-vip
#scan
10.10.6.73 rac-scan
备库:
10.10.6.51
二、数据库版本:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
三、监听
主:
10.10.6.54
rac=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.10.6.54 )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
)
)
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.10.6.51 )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
10.10.6.53:
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.10.6.51 )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
rac =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.10.6.53 )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
)
)
备:
[oracle@localhost admin]$ vi tnsnames.ora
rac=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.6.53)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.6.54)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
)
)
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.10.6.51 )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
设置静态监听
[oracle@localhost admin]$ vi listener.ora
# listener.ora Network Configuration File: /u01/app/product/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /u01/app/product)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app
四、添加主库的standby日志
SQL>alterdatabase add standby logfile thread 1
group 7('+data/rac/onlinelog/redo07') size 50M,
group 8('+data/rac/onlinelog/redo08') size 50M,
group 9('+data/rac/onlinelog/redo09') size 50M;
SQL>alterdatabase add standby logfile thread 2
group 10('+data/rac/onlinelog/redo010') size 50M,
group 11('+data/rac/onlinelog/redo011') size 50M,
group 12('+data/rac/onlinelog/redo012') size 50M;
SQL> select * From v$logfile;GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------------------------------------------ ---
1 ONLINE +DATA/rac/onlinelog/redo001.log NO
2 ONLINE +DATA/rac/onlinelog/redo002.log NO
3 ONLINE +DATA/rac/onlinelog/redo003.log NO
4 ONLINE +DATA/rac/onlinelog/redo004.log NO
5 ONLINE +DATA/rac/onlinelog/redo005.log NO
6 ONLINE +DATA/rac/onlinelog/redo006.log NO
7 STANDBY +DATA/rac/onlinelog/redo07.log NO
8 STANDBY +DATA/rac/onlinelog/redo08.log NO
9 STANDBY +DATA/rac/onlinelog/redo09.log NO
10 STANDBY +DATA/rac/onlinelog/redo10.log NO
11 STANDBY +DATA/rac/onlinelog/redo11.log NO
12 STANDBY +DATA/rac/onlinelog/redo12.log NO
五、参数文件配置
主:拷贝密码文件到备库
主:
scp orapwrac 10.10.6.51:/u01
备:vi initorcl.ora
*.audit_file_dest='/u01/app/admin/adump'
*.background_dump_dest='/u01/app/admin/bdump'
*.compatible='11.2.0.1.0'
*.control_files='/u01/app/oradata/control01.ctl','/u01/app/oradata/control02.ctl','/u01/app/oradata/control03.ctl'
*.core_dump_dest='/u01/app/diag/rdbms/orcl/orcl/trace'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='rac'
*.db_recovery_file_dest='/u01/app/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.global_names=FALSE
*.job_queue_processes=10
*.local_listener=''
*.log_archive_dest_1='location=/arc'
*.open_cursors=300
*.pga_aggregate_target=169869312
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=509607936
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/oracle/admin/udump'
*.DB_NAME=rac
*.DB_UNIQUE_NAME=orcl
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(rac,orcl)'
*.LOG_ARCHIVE_DEST_1='LOCATION=/arc VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'
*.LOG_ARCHIVE_DEST_2='SERVICE=rac ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=rac'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
*.LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.FAL_SERVER=orcl
*.fal_client=rac
*.DB_FILE_NAME_CONVERT=''+DATA/rac/datafile/',/u01/app/oradata/'
*.LOG_FILE_NAME_CONVERT='+data/rac/onlinelog','/u01/app/oradata/'
*.STANDBY_FILE_MANAGEMENT=AUTO
主:
alter system set db_unique_name=rac scope=spfile;
alter system set log_archive_config='dg_config=(rac,orcl)' scope=both;
alter system set log_archive_dest_1='LOCATION=+data/log valid_for=(all_logfiles,all_roles) db_unique_name=rac' scope=both;
alter system set log_archive_dest_2='service=orcl OPTIONAL LGWR aSYNC valid_for=(online_logfiles,primary_role) db_unique_name=orcl' scope=both sid='*';
alter system set log_archive_dest_state_1=enable scope=both;
alter system set log_archive_dest_state_2=enable scope=both;
alter system set remote_login_passwordfile=exclusive scope=spfile;
alter system set log_archive_format='%t_%s_%r.arc' scope=spfile;
alter system set log_archive_max_processes=4 scope=both;
alter system set compatible='11.2.0.1' scope=spfile;
alter system set fal_client='rac' scope=both;
alter system set fal_server='orcl' scope=both;
alter system set standby_file_management=auto scope=both;
alter system set db_file_name_convert='/u01/app/oradata/' ,'+data/rac/datafile/' scope=spfile;
alter system set log_file_name_convert='/u01/app/oradata/' ,'+data/rac/onlinelog' scope=spfile;
六、备份
主:主库和备库设置相同的目录 /u01/backup
RUN {
allocate channel c1 type disk;
allocate channel c2 type disk;
sql 'alter system archive log current';
backup current controlfile for standby format='/u01/backup/control_%U';
BACKUP FORMAT '/u01/backup/orcl_%U_%T' skip inaccessible filesperset 5 DATABASE ;
sql 'alter system archive log current';
BACKUP FORMAT '/u01/backup/arch_%U_%T' skip inaccessible filesperset 5 ARCHIVELOG ALL DELETE INPUT;
release channel c2;
release channel c1;
}
将主库的备份拷贝到备库,相同位置/u01/backup
七、恢复
主:
conn sys/oracle@orcl as sysdba
startup nomont;
[oracle@localhost backup]$ rman target sys/oracle@rac auxiliary /Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jul 25 18:17:40 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: RAC (DBID=2407816564)
connected to auxiliary database: RAC (not mounted)
RMAN> duplicate target database for standby nofilenamecheck dorecover;
Starting Duplicate Db at 25-JUL-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=20 device type=DISK
contents of Memory Script:
{
set until scn 10067706;
restore clone standby controlfile;
}
executing Memory Script
executing command: SET until clause
Starting restore at 25-JUL-13
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/orcl_05ofgitr_1_1_20130724
channel ORA_AUX_DISK_1: piece handle=/u01/backup/orcl_05ofgitr_1_1_20130724 tag=TAG20130724T000853
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/u01/app/oradata/control01.ctl
output file name=/u01/app/oradata/control02.ctl
output file name=/u01/app/oradata/control03.ctl
Finished restore at 25-JUL-13
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
Using previous duplicated file /u01/app/oradata/system.256.819834275 for datafile 1 with checkpoint SCN of 9554869
Using previous duplicated file /u01/app/oradata/sysaux.257.819834277 for datafile 2 with checkpoint SCN of 9553560
Using previous duplicated file /u01/app/oradata/undotbs1.258.819834277 for datafile 3 with checkpoint SCN of 9554869
Using previous duplicated file /u01/app/oradata/users.259.819834277 for datafile 4 with checkpoint SCN of 9553560
Using previous duplicated file /u01/app/oradata/undotbs2.267.819834689 for datafile 5 with checkpoint SCN of 9554869
contents of Memory Script:
{
set until scn 10067706;
set newname for tempfile 1 to
"/u01/app/oradata/temp.266.819834569";
switch clone tempfile all;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oradata/temp.266.819834569 in control file
contents of Memory Script:
{
catalog clone datafilecopy "/u01/app/oradata/system.256.819834275",
"/u01/app/oradata/sysaux.257.819834277",
"/u01/app/oradata/undotbs1.258.819834277",
"/u01/app/oradata/users.259.819834277",
"/u01/app/oradata/undotbs2.267.819834689";
switch clone datafile 1 to datafilecopy
"/u01/app/oradata/system.256.819834275";
switch clone datafile 2 to datafilecopy
"/u01/app/oradata/sysaux.257.819834277";
switch clone datafile 3 to datafilecopy
"/u01/app/oradata/undotbs1.258.819834277";
switch clone datafile 4 to datafilecopy
"/u01/app/oradata/users.259.819834277";
switch clone datafile 5 to datafilecopy
"/u01/app/oradata/undotbs2.267.819834689";
}
executing Memory Script
cataloged datafile copy
datafile copy file name=/u01/app/oradata/system.256.819834275 RECID=1 STAMP=821729901
cataloged datafile copy
datafile copy file name=/u01/app/oradata/sysaux.257.819834277 RECID=2 STAMP=821729901
cataloged datafile copy
datafile copy file name=/u01/app/oradata/undotbs1.258.819834277 RECID=3 STAMP=821729901
cataloged datafile copy
datafile copy file name=/u01/app/oradata/users.259.819834277 RECID=4 STAMP=821729901
cataloged datafile copy
datafile copy file name=/u01/app/oradata/undotbs2.267.819834689 RECID=5 STAMP=821729901
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=821729901 file name=/u01/app/oradata/system.256.819834275
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=821729901 file name=/u01/app/oradata/sysaux.257.819834277
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=821729901 file name=/u01/app/oradata/undotbs1.258.819834277
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=821729901 file name=/u01/app/oradata/users.259.819834277
datafile 5 switched to datafile copy
input datafile copy RECID=5 STAMP=821729901 file name=/u01/app/oradata/undotbs2.267.819834689
contents of Memory Script:
{
set until scn 10067706;
recover
standby
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 25-JUL-13
using channel ORA_AUX_DISK_1
starting media recovery
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=128
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=95
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=129
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=96
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_1qofl65i_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_1qofl65i_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/arc/2_128_819834549.arc thread=2 sequence=128
archived log file name=/arc/1_95_819834549.arc thread=1 sequence=95
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_128_819834549.arc RECID=2 STAMP=821729904
archived log file name=/arc/2_129_819834549.arc thread=2 sequence=129
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_95_819834549.arc RECID=1 STAMP=821729903
archived log file name=/arc/1_96_819834549.arc thread=1 sequence=96
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_129_819834549.arc RECID=3 STAMP=821729904
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=130
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=97
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=131
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_1rofl65j_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_1rofl65j_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08
archived log file name=/arc/2_130_819834549.arc thread=2 sequence=130
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_96_819834549.arc RECID=4 STAMP=821729904
archived log file name=/arc/1_97_819834549.arc thread=1 sequence=97
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_130_819834549.arc RECID=7 STAMP=821729917
archived log file name=/arc/2_131_819834549.arc thread=2 sequence=131
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_131_819834549.arc RECID=6 STAMP=821729917
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=132
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=98
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=133
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_1sofl664_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_1sofl664_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
archived log file name=/arc/2_132_819834549.arc thread=2 sequence=132
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_97_819834549.arc RECID=5 STAMP=821729916
archived log file name=/arc/1_98_819834549.arc thread=1 sequence=98
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_132_819834549.arc RECID=10 STAMP=821730019
archived log file name=/arc/2_133_819834549.arc thread=2 sequence=133
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_98_819834549.arc RECID=9 STAMP=821730019
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=99
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=134
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=135
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=100
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=101
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_1tofl66k_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_1tofl66k_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
archived log file name=/arc/1_99_819834549.arc thread=1 sequence=99
archived log file name=/arc/2_134_819834549.arc thread=2 sequence=134
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_99_819834549.arc RECID=15 STAMP=821730081
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_133_819834549.arc RECID=8 STAMP=821730018
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_134_819834549.arc RECID=11 STAMP=821730079
archived log file name=/arc/2_135_819834549.arc thread=2 sequence=135
archived log file name=/arc/1_100_819834549.arc thread=1 sequence=100
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_100_819834549.arc RECID=12 STAMP=821730080
archived log file name=/arc/1_101_819834549.arc thread=1 sequence=101
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_135_819834549.arc RECID=14 STAMP=821730080
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=136
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=102
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=103
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=137
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=138
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_1uofl66n_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_1uofl66n_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
archived log file name=/arc/2_136_819834549.arc thread=2 sequence=136
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_101_819834549.arc RECID=13 STAMP=821730080
archived log file name=/arc/1_102_819834549.arc thread=1 sequence=102
archived log file name=/arc/1_103_819834549.arc thread=1 sequence=103
archived log file name=/arc/2_137_819834549.arc thread=2 sequence=137
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_102_819834549.arc RECID=16 STAMP=821730115
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_136_819834549.arc RECID=17 STAMP=821730115
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_137_819834549.arc RECID=18 STAMP=821730116
archived log file name=/arc/2_138_819834549.arc thread=2 sequence=138
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_138_819834549.arc RECID=19 STAMP=821730116
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=139
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=104
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=105
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=140
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=141
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_1vofl66o_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_1vofl66o_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:04
archived log file name=/arc/2_139_819834549.arc thread=2 sequence=139
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_103_819834549.arc RECID=20 STAMP=821730116
archived log file name=/arc/1_104_819834549.arc thread=1 sequence=104
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_104_819834549.arc RECID=23 STAMP=821730125
archived log file name=/arc/1_105_819834549.arc thread=1 sequence=105
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_139_819834549.arc RECID=24 STAMP=821730125
archived log file name=/arc/2_140_819834549.arc thread=2 sequence=140
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_140_819834549.arc RECID=21 STAMP=821730123
archived log file name=/arc/2_141_819834549.arc thread=2 sequence=141
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_105_819834549.arc RECID=22 STAMP=821730124
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=106
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=107
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=142
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_20ofl670_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_20ofl670_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
archived log file name=/arc/1_106_819834549.arc thread=1 sequence=106
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_106_819834549.arc RECID=28 STAMP=821730152
archived log file name=/arc/1_107_819834549.arc thread=1 sequence=107
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_141_819834549.arc RECID=25 STAMP=821730126
archived log file name=/arc/2_142_819834549.arc thread=2 sequence=142
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_142_819834549.arc RECID=27 STAMP=821730152
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=143
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=108
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/arch1_21ofl67h_1_1_20130725
channel ORA_AUX_DISK_1: piece handle=/u01/backup/arch1_21ofl67h_1_1_20130725 tag=TAG20130725T180801
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/arc/2_143_819834549.arc thread=2 sequence=143
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_107_819834549.arc RECID=26 STAMP=821730151
archived log file name=/arc/1_108_819834549.arc thread=1 sequence=108
channel clone_default: deleting archived log(s)
archived log file name=/arc/1_108_819834549.arc RECID=29 STAMP=821730210
channel clone_default: deleting archived log(s)
archived log file name=/arc/2_143_819834549.arc RECID=30 STAMP=821730211
media recovery complete, elapsed time: 00:00:02
Finished recover at 25-JUL-13
Finished Duplicate Db at 25-JUL-13
SQL> conn /as sysdba
Connected.
备库应用日志:
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
查看日志的应用:
SQL> select sequence#,first_time,next_time from v$archived_log order by 1;
SEQUENCE# FIRST_TIM NEXT_TIME
---------- --------- ---------
95 24-JUL-13 24-JUL-13
96 24-JUL-13 24-JUL-13
97 24-JUL-13 24-JUL-13
98 24-JUL-13 24-JUL-13
99 24-JUL-13 24-JUL-13
100 24-JUL-13 24-JUL-13
101 24-JUL-13 24-JUL-13
102 24-JUL-13 24-JUL-13
103 24-JUL-13 24-JUL-13
104 24-JUL-13 25-JUL-13
105 25-JUL-13 25-JUL-13
106 25-JUL-13 25-JUL-13
107 25-JUL-13 25-JUL-13
108 25-JUL-13 25-JUL-13
108 25-JUL-13 25-JUL-13
109 25-JUL-13 25-JUL-13
128 24-JUL-13 24-JUL-13
129 24-JUL-13 24-JUL-13
130 24-JUL-13 24-JUL-13
131 24-JUL-13 24-JUL-13
132 24-JUL-13 24-JUL-13
133 24-JUL-13 24-JUL-13
134 24-JUL-13 24-JUL-13
135 24-JUL-13 24-JUL-13
136 24-JUL-13 24-JUL-13
137 24-JUL-13 24-JUL-13
138 24-JUL-13 24-JUL-13
139 24-JUL-13 25-JUL-13
140 25-JUL-13 25-JUL-13
141 25-JUL-13 25-JUL-13
142 25-JUL-13 25-JUL-13
143 25-JUL-13 25-JUL-13
144 25-JUL-13 25-JUL-13
145 25-JUL-13 25-JUL-13
34 rows selected.
或者通过
/u01/app/diag/rdbms/orcl/orcl/trace/*.log 来查看日志的应用
停止应用日志:
SQL> alter database recover managed standby database cancel;
SQL> alter database open;
出现的错误:
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/25/2013 01:15:02
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-03114: not connected to ORACLE
解决方法:
修改参数
*.LOG_FILE_NAME_CONVERT='+data/rac/onlinelog/','/u01/app/oradata/',
为
*.LOG_FILE_NAME_CONVERT='+data/rac/onlinelog/','/u01/app/oradata/','+data/asm/onlinelog/','/u01/app/oradata/'
还有,忘记转换了tempfile 文件的路径
*.DB_FILE_NAME_CONVERT='+data/rac/datafile/','/u01/app/oradata/','+data/rac/tempfile','/u01/app/oradata'
DUPLICATE TARGET DATABASE TO "clone" NOFILENAMECHECK;
selectdatabase_role,db_unique_name,open_mode,protection_mode,protection_level,switchover_status from v$database;