TB级别库迁移操作
来源：互联网 发布：linux创建用户和组步骤 编辑：程序博客网 时间：2024/05/16 17:07
一、场景
因一套RAC库的机器需要更换机房，必须在原先机房保留一套与之一样的数据库，以便应用不断的情形做机器的搬迁:
1)、应用暂停为零最好，这种情形用goldengate做，可以做到零停机，成本太高；
2)、利用rman+dg来做，应用暂停时间大约在切应用和apply最后一批日志，因为是TB级库，如果顺利，控制在30分钟-50分钟左右；否则启用第二套方案，这里不作说明。
二、原理
采用10g RMAN duplicate方式将primary最近的备份集clone成auxiliary机器配的"standby"库，在clone完成到应用切这段时间做apply归档日志应用
注意事项：
a、standby库是理论上的备库，不是真正dg的备库；
b、primary库不自动同步日志，需要定期手工apply日志到备库上；
c、做完备库之后，应用一条最近的归档日志，open read only数据；
d、没有将停完应用的最后一批日志apply到standby库里，一定不能切换role，否则一定会丢数据；
e、停应用之后primary库的oracle网络及实例都掐断，防止有人连接；
f、切完standby为primary后，修改参数文件，去了相关参数，正常关闭启动数据，验证库有没有问题
三、primary及standby配置
1)、primary机器配置
a、双节点10.2.0.5.0版本的RAC
b、存储文件系统:ASM，47块盘做磁盘阵列
c、存储大小：大约8TB
d、数据量：3.2TB
e、最近一次备份集大小：350GB
f、无效对象：无
g、无效索引：3条，历史表，与实际生产数据没有关系
h、每周归档大约为1TB以上：归档采用压缩方式
i、redhat 5.5 x86_64
j、内存32GB,8cpu
2)、standby机器配置：
a、单实例10.2.0.5.0数据
b、存储文件系统:本地存储，30多块盘做磁盘阵列
c、存储大小：大约8.5TB
d、最近一次备份集大小：350GB
e、redhat 5.8 x86_64
f、内存194GB,8cpu
四、standby端配置
注：主库无需变动，因为不是真正上的dg，只要求做个physical standby库，手工同步日志
1)、配置密码及参数文件
create pfile='/tmp/initgpsdb.ora' from spfile;
orapwd file=orapwgpsdb password=zm_321Tl;
将产生的文件放置
/u01/app/oracle/product/10.2.0/db_1/dbs下
[oracle@gpsdb dbs]$ ll
-rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora
-rw-r--r-- 1 oracle oinstall 1179 Jun 4 10:03 initgpsdb.ora
-rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora
-rw-r----- 1 oracle oinstall 1536 May 26 15:32 orapwgpsdb
参数文件配置
[oracle@gpsdb dbs]$ more initgpsdb.ora
gpsdb.__db_cache_size=13824425984
gpsdb.__java_pool_size=33554432
gpsdb.__large_pool_size=16777216
gpsdb.__shared_pool_size=7516192768
gpsdb.__streams_pool_size=33554432
gpsdb._kghdsidx_count=3
*.audit_file_dest='/u01/app/oracle/admin/gpsdb/adump'
*.background_dump_dest='/u01/app/oracle/admin/gpsdb/bdump'
*.compatible='10.2.0.5.0'
*.control_files='/oradata/gpsdb/control1.ctl','/oradata/gpsdb/control2.ctl'
*.core_dump_dest='/u01/app/oracle/admin/gpsdb/cdump'
*.db_block_size=8192
*.db_cache_size=12884901888
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='gpsdb'
*.db_recovery_file_dest='/oradata/archivelog_dest'
*.db_recovery_file_dest_size=1152642973696
*.dispatchers='(PROTOCOL=TCP) (SERVICE=gpsdbXDB)'
*.java_pool_size=25165824
*.job_queue_processes=10
*.large_pool_size=10485760
*.log_archive_format='%t_%s_%r.arc'
*.open_cursors=300
*.pga_aggregate_target=8589934592
*.processes=500
*.remote_login_passwordfile='exclusive'
*.sessions=555
*.sga_max_size=22296920064
*.sga_target=22296920064
*.shared_pool_size=7516192768
*.streams_pool_size=33554432
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/gpsdb/udump'
*.LOG_ARCHIVE_DEST_1= 'LOCATION=/oradata/archivelog_dest VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB
_UNIQUE_NAME=gpsdb'
*.LOG_ARCHIVE_DEST_2= 'SERVICE=gpsdb_net LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_
UNIQUE_NAME=gpsdb'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.db_file_name_convert='+DATADG/gpsdb','/oradata/gpsdb','+FLASHAREA_DG/gpsdb','/oradata/gpsdb_fl
asharea_dg'
*.log_file_name_convert='+DATADG/gpsdb','/oradata/gpsdb'
*.FAL_SERVER=gpsdb_net
*.FAL_CLIENT=gpsdb
*.STANDBY_FILE_MANAGEMENT=AUTO
2)、目录
[oracle@gpsdb gpsdb]$ pwd
/u01/app/oracle/admin/gpsdb
[oracle@gpsdb gpsdb]$ ll
total 24
drwxr-x--- 2 oracle oinstall 4096 May 20 12:36 adump
drwxr-x--- 2 oracle oinstall 4096 May 20 12:41 bdump
drwxr-x--- 2 oracle oinstall 4096 May 13 12:26 cdump
drwxr-x--- 2 oracle oinstall 4096 May 13 12:27 dpdump
drwxr-x--- 2 oracle oinstall 4096 May 20 13:43 pfile
drwxr-x--- 2 oracle oinstall 4096 May 20 12:36 udump
3)、网络配置：
tnsnames.ora
##连接primary库
gpsdb_p =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.118.51)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.118.52)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gpsdb.trsen.zhang.com)
)
)
##连接stanby库
gpsdb_s =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.19.88)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gpsdb)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
listener.ora
##配置静态监听和动态监听
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME=gpsdb)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = gpsdb)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gpsdb)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
/etc/hosts配置
[oracle@gpsdb admin]$ more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
10.1.19.88 gpsdb
查看监听配置是否成功
[oracle@gpsdb admin]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 04-JUN-2014 14:57:53
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gpsdb)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 26-MAY-2014 15:09:25
Uptime 8 days 23 hr. 48 min. 27 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gpsdb)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "gpsdb" has 2 instance(s).
Instance "gpsdb", status UNKNOWN, has 1 handler(s) for this service...
Instance "gpsdb", status READY, has 1 handler(s) for this service...
Service "gpsdbXDB" has 1 instance(s).
Instance "gpsdb", status READY, has 1 handler(s) for this service...
Service "gpsdb_XPT" has 1 instance(s).
Instance "gpsdb", status READY, has 1 handler(s) for this service...
The command completed successfully
测试rman duplicate连接
[oracle@gpsdb admin]$rman target sys/zm_321Tl@gpsdb_p AUXILIARY sys/zm_321Tl@gpsdb_s
Recovery Manager: Release 10.2.0.5.0 - Production on Fri May 30 22:29:33 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: GPSDB (DBID=201808262)
connected to auxiliary database: GPSDB (not mounted)
RMAN>
五、做standby数据库
1)、脚本
[oracle@gpsdb ~]$ more duplicate.sh
#!/bin/bash
. /etc/profile
. ~/.bash_profile
date
rman target sys/zm_321Tl@gpsdb_p AUXILIARY sys/zm_321Tl@gpsdb_s <<EOF
run
{
allocate auxiliary channel aux1 device type disk;
allocate auxiliary channel aux2 device type disk;
allocate auxiliary channel aux3 device type disk;
DUPLICATE TARGET DATABASE FOR STANDBY;
}
EOF
date
2)、duplicate日志,整个过程花费将近7小时
[oracle@gpsdb ~]$ more duplicate.log
Fri May 30 22:29:33 CST 2014
Recovery Manager: Release 10.2.0.5.0 - Production on Fri May 30 22:29:33 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: GPSDB (DBID=201808262)
connected to auxiliary database: GPSDB (not mounted)
RMAN> 2> 3> 4> 5> 6> 7>
using target database control file instead of recovery catalog
allocated channel: aux1
channel aux1: sid=536 devtype=DISK
allocated channel: aux2
channel aux2: sid=535 devtype=DISK
allocated channel: aux3
channel aux3: sid=534 devtype=DISK
Starting Duplicate Db at 30-MAY-14
contents of Memory Script:
{
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script
Starting restore at 30-MAY-14
channel aux1: restoring control file
channel aux1: copied control file copy
input filename=/tmp/ctl
output filename=/oradata/gpsdb/control1.ctl
output filename=/oradata/gpsdb/control2.ctl
Finished restore at 30-MAY-14
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"/oradata/gpsdb/temp01.dbf";
set newname for tempfile 2 to
"/oradata/gpsdb/gps_temp_01.dbf";
set newname for tempfile 3 to
"/oradata/gpsdb/gps_temp_02.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/oradata/gpsdb/system01.dbf";
set newname for datafile 2 to
"/oradata/gpsdb/undotbs01.dbf";
set newname for datafile 3 to
"/oradata/gpsdb/sysaux01.dbf";
set newname for datafile 4 to
"/oradata/gpsdb/users01.dbf";
set newname for datafile 5 to
"/oradata/gpsdb/undotbs02.dbf";
set newname for datafile 6 to
"/oradata/gpsdb/wzt_tbs_01.dbf";
set newname for datafile 7 to
"/oradata/gpsdb/wzt_tbs_02.dbf";
set newname for datafile 8 to
"/oradata/gpsdb/wzt_tbs_03.dbf";
set newname for datafile 9 to
"/oradata/gpsdb/wzt_tbs_04.dbf";
set newname for datafile 10 to
"/oradata/gpsdb/wzt_tbs_05.dbf";
set newname for datafile 11 to
"/oradata/gpsdb/splex_tbs_01.dbf";
set newname for datafile 12 to
"/oradata/gpsdb/wzt_tbs_06.dbf";
set newname for datafile 13 to
"/oradata/gpsdb/wzt_tbs_07.dbf";
set newname for datafile 14 to
"/oradata/gpsdb/wzt_tbs_08.dbf";
set newname for datafile 15 to
"/oradata/gpsdb/wzt_tbs_09.dbf";
set newname for datafile 16 to
"/oradata/gpsdb/wzt_tbs_10.dbf";
set newname for datafile 17 to
"/oradata/gpsdb/dbf_130501.dbf";
set newname for datafile 18 to
"/oradata/gpsdb/dbf_130502.dbf";
set newname for datafile 19 to
"/oradata/gpsdb/dbf_130503.dbf";
set newname for datafile 20 to
"/oradata/gpsdb/wzt_tbs_11.dbf";
set newname for datafile 21 to
"/oradata/gpsdb/wzt_tbs_12.dbf";
set newname for datafile 22 to
"/oradata/gpsdb/wzt_tbs_13.dbf";
set newname for datafile 23 to
"/oradata/gpsdb/wzt_tbs_14.dbf";
set newname for datafile 24 to
"/oradata/gpsdb/wzt_tbs_15.dbf";
set newname for datafile 25 to
"/oradata/gpsdb/wzt_tbs_16.dbf";
set newname for datafile 26 to
"/oradata/gpsdb/wzt_tbs_17.dbf";
set newname for datafile 27 to
"/oradata/gpsdb/wzt_tbs_18.dbf";
set newname for datafile 28 to
"/oradata/gpsdb/wzt_tbs_19.dbf";
set newname for datafile 29 to
"/oradata/gpsdb/wzt_tbs_20.dbf";
set newname for datafile 30 to
"/oradata/gpsdb/idx_trenzhangmot_01.dbf";
set newname for datafile 31 to
"/oradata/gpsdb/idx_trenzhangmot_02.dbf";
set newname for datafile 32 to
"/oradata/gpsdb/idx_trenzhangmot_03.dbf";
set newname for datafile 33 to
"/oradata/gpsdb/idx_trenzhangmot_04.dbf";
set newname for datafile 34 to
"/oradata/gpsdb/idx_trenzhangmot_05.dbf";
set newname for datafile 35 to
"/oradata/gpsdb/idx_trenzhangmot_06.dbf";
set newname for datafile 36 to
"/oradata/gpsdb/idx_trenzhangmot_07.dbf";
set newname for datafile 37 to
"/oradata/gpsdb/idx_trenzhangmot_08.dbf";
set newname for datafile 38 to
"/oradata/gpsdb/idx_trenzhangmot_09.dbf";
set newname for datafile 39 to
"/oradata/gpsdb/idx_trenzhangmot_10.dbf";
set newname for datafile 40 to
"/oradata/gpsdb/dbf_06_1.dbf";
set newname for datafile 41 to
"/oradata/gpsdb/dbf_06_2.dbf";
set newname for datafile 42 to
"/oradata/gpsdb/dbf_06_3.dbf";
set newname for datafile 43 to
"/oradata/gpsdb/dbf_07_1.dbf";
set newname for datafile 44 to
"/oradata/gpsdb/dbf_07_2.dbf";
set newname for datafile 45 to
"/oradata/gpsdb/dbf_07_3.dbf";
set newname for datafile 46 to
"/oradata/gpsdb/wzt_tbs_21.dbf";
set newname for datafile 47 to
"/oradata/gpsdb/wzt_tbs_22.dbf";
set newname for datafile 48 to
"/oradata/gpsdb/wzt_tbs_23.dbf";
set newname for datafile 49 to
"/oradata/gpsdb/wzt_tbs_24.dbf";
set newname for datafile 50 to
"/oradata/gpsdb/wzt_tbs_25.dbf";
set newname for datafile 51 to
"/oradata/gpsdb/dbf_08_1.dbf";
set newname for datafile 52 to
"/oradata/gpsdb/dbf_08_2.dbf";
set newname for datafile 53 to
"/oradata/gpsdb/dbf_08_3.dbf";
set newname for datafile 54 to
"/oradata/gpsdb_flasharea_dg/dbf_08_2.dbf";
set newname for datafile 55 to
"/oradata/gpsdb_flasharea_dg/wzt_tbs_26.dbf";
set newname for datafile 56 to
"/oradata/gpsdb/dbf_06_1b.dbf";
set newname for datafile 57 to
"/oradata/gpsdb/dbf_06_2b.dbf";
set newname for datafile 58 to
"/oradata/gpsdb/dbf_06_3b.dbf";
set newname for datafile 59 to
"/oradata/gpsdb/dbf_07_1b.dbf";
set newname for datafile 60 to
"/oradata/gpsdb/dbf_07_2b.dbf";
set newname for datafile 61 to
"/oradata/gpsdb/dbf_07_3b.dbf";
set newname for datafile 62 to
"/oradata/gpsdb/dbf_08_1b.dbf";
set newname for datafile 63 to
"/oradata/gpsdb/dbf_08_2b.dbf";
set newname for datafile 64 to
"/oradata/gpsdb/dbf_08_3b.dbf";
set newname for datafile 65 to
"/oradata/gpsdb/wzt_tbs_26.dbf";
set newname for datafile 66 to
"/oradata/gpsdb/undotbs03.dbf";
set newname for datafile 67 to
"/oradata/gpsdb/undotbs04.dbf";
set newname for datafile 68 to
"/oradata/gpsdb/undotbs05.dbf";
set newname for datafile 69 to
"/oradata/gpsdb/undotbs06.dbf";
set newname for datafile 70 to
"/oradata/gpsdb/undotbs07.dbf";
set newname for datafile 71 to
"/oradata/gpsdb/undotbs08.dbf";
set newname for datafile 72 to
"/oradata/gpsdb/dbf_09_1.dbf";
set newname for datafile 73 to
"/oradata/gpsdb/dbf_09_2.dbf";
set newname for datafile 74 to
"/oradata/gpsdb/dbf_09_3.dbf";
set newname for datafile 75 to
"/oradata/gpsdb/dbf_10_1.dbf";
set newname for datafile 76 to
"/oradata/gpsdb/dbf_10_2.dbf";
set newname for datafile 77 to
"/oradata/gpsdb/dbf_10_3.dbf";
set newname for datafile 78 to
"/oradata/gpsdb/dbf_11_1.dbf";
set newname for datafile 79 to
"/oradata/gpsdb/dbf_11_2.dbf";
set newname for datafile 80 to
"/oradata/gpsdb/dbf_11_3.dbf";
set newname for datafile 81 to
"/oradata/gpsdb/dbf_12_1.dbf";
set newname for datafile 82 to
"/oradata/gpsdb/dbf_12_2.dbf";
set newname for datafile 83 to
"/oradata/gpsdb/dbf_12_3.dbf";
set newname for datafile 84 to
"/oradata/gpsdb/dbf_09_1_01.dbf";
set newname for datafile 85 to
"/oradata/gpsdb/wzt_tbs_27.dbf";
set newname for datafile 86 to
"/oradata/gpsdb/wzt_tbs_28.dbf";
set newname for datafile 87 to
"/oradata/gpsdb/wzt_tbs_29.dbf";
set newname for datafile 88 to
"/oradata/gpsdb/wzt_tbs_30.dbf";
set newname for datafile 89 to
"/oradata/gpsdb/wzt_tbs_31.dbf";
set newname for datafile 90 to
"/oradata/gpsdb/wzt_tbs_32.dbf";
set newname for datafile 91 to
"/oradata/gpsdb/dbf_10_1_02.dbf";
set newname for datafile 92 to
"/oradata/gpsdb/dbf_10_2_02.dbf";
set newname for datafile 93 to
"/oradata/gpsdb/dbf_10_3_02.dbf";
set newname for datafile 94 to
"/oradata/gpsdb/dbf_09_3b.dbf";
set newname for datafile 95 to
"/oradata/gpsdb/dbf_10_3_03.dbf";
set newname for datafile 96 to
"/oradata/gpsdb/dbf_11_1_02.dbf";
set newname for datafile 97 to
"/oradata/gpsdb/dbf_11_2_02.dbf";
set newname for datafile 98 to
"/oradata/gpsdb/dbf_11_3_02.dbf";
set newname for datafile 99 to
"/oradata/gpsdb/dbf_08_3c.dbf";
set newname for datafile 100 to
"/oradata/gpsdb/dbf_09_2b.dbf";
set newname for datafile 101 to
"/oradata/gpsdb/dbf_10_2_03.dbf";
set newname for datafile 102 to
"/oradata/gpsdb/dbf_11_2_12.dbf";
set newname for datafile 103 to
"/oradata/gpsdb/dbf_10_2_12.dbf";
set newname for datafile 104 to
"/oradata/gpsdb/dbf_10_3_13.dbf";
set newname for datafile 105 to
"/oradata/gpsdb/dbf_11_3_03.dbf";
set newname for datafile 106 to
"/oradata/gpsdb/dbf_12_01.dbf";
set newname for datafile 107 to
"/oradata/gpsdb/dbf_12_02.dbf";
set newname for datafile 108 to
"/oradata/gpsdb/dbf_12_03.dbf";
set newname for datafile 109 to
"/oradata/gpsdb/dbf_12_11.dbf";
set newname for datafile 110 to
"/oradata/gpsdb/dbf_12_12.dbf";
set newname for datafile 111 to
"/oradata/gpsdb/dbf_01_1.dbf";
set newname for datafile 112 to
"/oradata/gpsdb/dbf_01_2.dbf";
set newname for datafile 113 to
"/oradata/gpsdb/dbf_01_3.dbf";
set newname for datafile 114 to
"/oradata/gpsdb/dbf_02_1.dbf";
set newname for datafile 115 to
"/oradata/gpsdb/dbf_02_2.dbf";
set newname for datafile 116 to
"/oradata/gpsdb/dbf_02_3.dbf";
set newname for datafile 117 to
"/oradata/gpsdb/dbf_12_3_13.dbf";
set newname for datafile 118 to
"/oradata/gpsdb/dbf_01_01.dbf";
set newname for datafile 119 to
"/oradata/gpsdb/dbf_01_02.dbf";
set newname for datafile 120 to
"/oradata/gpsdb/dbf_01_03.dbf";
set newname for datafile 121 to
"/oradata/gpsdb/dbf_02_01.dbf";
set newname for datafile 122 to
"/oradata/gpsdb/dbf_02_02.dbf";
set newname for datafile 123 to
"/oradata/gpsdb/wzt_tbs_33.dbf";
set newname for datafile 124 to
"/oradata/gpsdb/wzt_tbs_34.dbf";
set newname for datafile 125 to
"/oradata/gpsdb/wzt_tbs_35.dbf";
set newname for datafile 126 to
"/oradata/gpsdb/wzt_tbs_36.dbf";
set newname for datafile 127 to
"/oradata/gpsdb/wzt_tbs_37.dbf";
set newname for datafile 128 to
"/oradata/gpsdb/dbf_02_03.dbf";
set newname for datafile 129 to
"/oradata/gpsdb/dbf_01_11.dbf";
set newname for datafile 130 to
"/oradata/gpsdb/dbf_01_12.dbf";
set newname for datafile 131 to
"/oradata/gpsdb/dbf_01_13.dbf";
set newname for datafile 132 to
"/oradata/gpsdb/dbf_02_11.dbf";
set newname for datafile 133 to
"/oradata/gpsdb/dbf_02_12.dbf";
set newname for datafile 134 to
"/oradata/gpsdb/dbf_02_13.dbf";
set newname for datafile 135 to
"/oradata/gpsdb/dbf_01_21.dbf";
set newname for datafile 136 to
"/oradata/gpsdb/dbf_01_22.dbf";
set newname for datafile 137 to
"/oradata/gpsdb/dbf_01_31.dbf";
set newname for datafile 138 to
"/oradata/gpsdb/dbf_01_32.dbf";
set newname for datafile 139 to
"/oradata/gpsdb/dbf_02_21.dbf";
set newname for datafile 140 to
"/oradata/gpsdb/dbf_02_31.dbf";
set newname for datafile 141 to
"/oradata/gpsdb/dbf_02_22.dbf";
set newname for datafile 142 to
"/oradata/gpsdb/dbf_02_32.dbf";
set newname for datafile 143 to
"/oradata/gpsdb/dbf_03_1";
set newname for datafile 144 to
"/oradata/gpsdb/dbf_03_2";
set newname for datafile 145 to
"/oradata/gpsdb/dbf_03_3";
set newname for datafile 146 to
"/oradata/gpsdb/dbf_04_1";
set newname for datafile 147 to
"/oradata/gpsdb/dbf_04_2";
set newname for datafile 148 to
"/oradata/gpsdb/dbf_04_3";
set newname for datafile 149 to
"/oradata/gpsdb/dbf_05_1";
set newname for datafile 150 to
"/oradata/gpsdb/dbf_05_2";
set newname for datafile 151 to
"/oradata/gpsdb/dbf_05_3";
set newname for datafile 152 to
"/oradata/gpsdb/dbf__03_01.dbf";
set newname for datafile 153 to
"/oradata/gpsdb/dbf__03_11.dbf";
set newname for datafile 154 to
"/oradata/gpsdb/dbf_03_02.dbf";
set newname for datafile 155 to
"/oradata/gpsdb/dbf_03_12.dbf";
set newname for datafile 156 to
"/oradata/gpsdb/dbf_03_03.dbf";
set newname for datafile 157 to
"/oradata/gpsdb/dbf_03_13.dbf";
set newname for datafile 158 to
"/oradata/gpsdb/dbf_12_23.dbf";
set newname for datafile 159 to
"/oradata/gpsdb/wzt_tbs_38.dbf";
set newname for datafile 160 to
"/oradata/gpsdb/wzt_tbs_39.dbf";
set newname for datafile 161 to
"/oradata/gpsdb/dbf_04_01";
set newname for datafile 162 to
"/oradata/gpsdb/dbf_04_11";
set newname for datafile 163 to
"/oradata/gpsdb/dbf_04_02";
set newname for datafile 164 to
"/oradata/gpsdb/dbf_04_12";
set newname for datafile 165 to
"/oradata/gpsdb/dbf_04_03";
set newname for datafile 166 to
"/oradata/gpsdb/dbf_04_13";
set newname for datafile 167 to
"/oradata/gpsdb/wzt_tbs_40.dbf";
set newname for datafile 168 to
"/oradata/gpsdb/wzt_tbs_41.dbf";
set newname for datafile 169 to
"/oradata/gpsdb/dbf_04_21";
set newname for datafile 170 to
"/oradata/gpsdb/wzt_tbs_42.dbf";
set newname for datafile 171 to
"/oradata/gpsdb/wzt_tbs_43.dbf";
set newname for datafile 172 to
"/oradata/gpsdb/wzt_tbs_44.dbf";
set newname for datafile 173 to
"/oradata/gpsdb/wzt_tbs_45.dbf";
set newname for datafile 174 to
"/oradata/gpsdb/dbf_05_01";
set newname for datafile 175 to
"/oradata/gpsdb/dbf_05_11";
set newname for datafile 176 to
"/oradata/gpsdb/dbf_05_02";
set newname for datafile 177 to
"/oradata/gpsdb/dbf_05_12";
set newname for datafile 178 to
"/oradata/gpsdb/dbf_05_03";
set newname for datafile 179 to
"/oradata/gpsdb/dbf_05_13";
set newname for datafile 180 to
"/oradata/gpsdb/dbf_06_11.dbf";
set newname for datafile 181 to
"/oradata/gpsdb/dbf_06_21.dbf";
set newname for datafile 182 to
"/oradata/gpsdb/dbf_06_31.dbf";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed temporary file 1 to /oradata/gpsdb/temp01.dbf in control file
renamed temporary file 2 to /oradata/gpsdb/gps_temp_01.dbf in control file
renamed temporary file 3 to /oradata/gpsdb/gps_temp_02.dbf in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 30-MAY-14
channel aux1: starting datafile backupset restore
channel aux1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oradata/gpsdb/system01.dbf
restoring datafile 00002 to /oradata/gpsdb/undotbs01.dbf
restoring datafile 00003 to /oradata/gpsdb/sysaux01.dbf
restoring datafile 00004 to /oradata/gpsdb/users01.dbf
restoring datafile 00005 to /oradata/gpsdb/undotbs02.dbf
restoring datafile 00008 to /oradata/gpsdb/wzt_tbs_03.dbf
restoring datafile 00012 to /oradata/gpsdb/wzt_tbs_06.dbf
restoring datafile 00015 to /oradata/gpsdb/wzt_tbs_09.dbf
restoring datafile 00017 to /oradata/gpsdb/dbf_130501.dbf
restoring datafile 00019 to /oradata/gpsdb/dbf_130503.dbf
restoring datafile 00024 to /oradata/gpsdb/wzt_tbs_15.dbf
restoring datafile 00027 to /oradata/gpsdb/wzt_tbs_18.dbf
restoring datafile 00033 to /oradata/gpsdb/idx_trenzhangmot_04.dbf
restoring datafile 00036 to /oradata/gpsdb/idx_trenzhangmot_07.dbf
restoring datafile 00039 to /oradata/gpsdb/idx_trenzhangmot_10.dbf
restoring datafile 00040 to /oradata/gpsdb/dbf_06_1.dbf
restoring datafile 00041 to /oradata/gpsdb/dbf_06_2.dbf
restoring datafile 00042 to /oradata/gpsdb/dbf_06_3.dbf
restoring datafile 00044 to /oradata/gpsdb/dbf_07_2.dbf
restoring datafile 00049 to /oradata/gpsdb/wzt_tbs_24.dbf
restoring datafile 00051 to /oradata/gpsdb/dbf_08_1.dbf
restoring datafile 00065 to /oradata/gpsdb/wzt_tbs_26.dbf
restoring datafile 00066 to /oradata/gpsdb/undotbs03.dbf
restoring datafile 00067 to /oradata/gpsdb/undotbs04.dbf
restoring datafile 00069 to /oradata/gpsdb/undotbs06.dbf
restoring datafile 00074 to /oradata/gpsdb/dbf_09_3.dbf
restoring datafile 00075 to /oradata/gpsdb/dbf_10_1.dbf
restoring datafile 00078 to /oradata/gpsdb/dbf_11_1.dbf
restoring datafile 00079 to /oradata/gpsdb/dbf_11_2.dbf
restoring datafile 00084 to /oradata/gpsdb/dbf_09_1_01.dbf
restoring datafile 00087 to /oradata/gpsdb/wzt_tbs_29.dbf
restoring datafile 00090 to /oradata/gpsdb/wzt_tbs_32.dbf
restoring datafile 00091 to /oradata/gpsdb/dbf_10_1_02.dbf
restoring datafile 00100 to /oradata/gpsdb/dbf_09_2b.dbf
restoring datafile 00103 to /oradata/gpsdb/dbf_10_2_12.dbf
restoring datafile 00105 to /oradata/gpsdb/dbf_11_3_03.dbf
restoring datafile 00106 to /oradata/gpsdb/dbf_12_01.dbf
restoring datafile 00108 to /oradata/gpsdb/dbf_12_03.dbf
restoring datafile 00112 to /oradata/gpsdb/dbf_01_2.dbf
restoring datafile 00114 to /oradata/gpsdb/dbf_02_1.dbf
restoring datafile 00116 to /oradata/gpsdb/dbf_02_3.dbf
restoring datafile 00117 to /oradata/gpsdb/dbf_12_3_13.dbf
restoring datafile 00122 to /oradata/gpsdb/dbf_02_02.dbf
restoring datafile 00124 to /oradata/gpsdb/wzt_tbs_34.dbf
restoring datafile 00127 to /oradata/gpsdb/wzt_tbs_37.dbf
restoring datafile 00131 to /oradata/gpsdb/dbf_01_13.dbf
restoring datafile 00136 to /oradata/gpsdb/dbf_01_22.dbf
restoring datafile 00139 to /oradata/gpsdb/dbf_02_21.dbf
restoring datafile 00142 to /oradata/gpsdb/dbf_02_32.dbf
restoring datafile 00149 to /oradata/gpsdb/dbf_05_1
restoring datafile 00151 to /oradata/gpsdb/dbf_05_3
restoring datafile 00155 to /oradata/gpsdb/dbf_03_12.dbf
restoring datafile 00156 to /oradata/gpsdb/dbf_03_03.dbf
restoring datafile 00161 to /oradata/gpsdb/dbf_04_01
restoring datafile 00164 to /oradata/gpsdb/dbf_04_12
restoring datafile 00165 to /oradata/gpsdb/dbf_04_03
restoring datafile 00168 to /oradata/gpsdb/wzt_tbs_41.dbf
restoring datafile 00170 to /oradata/gpsdb/wzt_tbs_42.dbf
restoring datafile 00176 to /oradata/gpsdb/dbf_05_02
restoring datafile 00180 to /oradata/gpsdb/dbf_06_11.dbf
channel aux1: reading from backup piece /backup/gpsbak/dbbackup/GPSDB_631_848915219.data
channel aux2: starting datafile backupset restore
channel aux2: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /oradata/gpsdb/wzt_tbs_02.dbf
restoring datafile 00010 to /oradata/gpsdb/wzt_tbs_05.dbf
restoring datafile 00014 to /oradata/gpsdb/wzt_tbs_08.dbf
restoring datafile 00020 to /oradata/gpsdb/wzt_tbs_11.dbf
restoring datafile 00021 to /oradata/gpsdb/wzt_tbs_12.dbf
restoring datafile 00022 to /oradata/gpsdb/wzt_tbs_13.dbf
restoring datafile 00025 to /oradata/gpsdb/wzt_tbs_16.dbf
restoring datafile 00028 to /oradata/gpsdb/wzt_tbs_19.dbf
restoring datafile 00030 to /oradata/gpsdb/idx_trenzhangmot_01.dbf
restoring datafile 00035 to /oradata/gpsdb/idx_trenzhangmot_06.dbf
restoring datafile 00038 to /oradata/gpsdb/idx_trenzhangmot_09.dbf
restoring datafile 00046 to /oradata/gpsdb/wzt_tbs_21.dbf
restoring datafile 00047 to /oradata/gpsdb/wzt_tbs_22.dbf
restoring datafile 00048 to /oradata/gpsdb/wzt_tbs_23.dbf
restoring datafile 00050 to /oradata/gpsdb/wzt_tbs_25.dbf
restoring datafile 00053 to /oradata/gpsdb/dbf_08_3.dbf
restoring datafile 00057 to /oradata/gpsdb/dbf_06_2b.dbf
restoring datafile 00060 to /oradata/gpsdb/dbf_07_2b.dbf
restoring datafile 00062 to /oradata/gpsdb/dbf_08_1b.dbf
restoring datafile 00063 to /oradata/gpsdb/dbf_08_2b.dbf
restoring datafile 00064 to /oradata/gpsdb/dbf_08_3b.dbf
restoring datafile 00070 to /oradata/gpsdb/undotbs07.dbf
restoring datafile 00072 to /oradata/gpsdb/dbf_09_1.dbf
restoring datafile 00080 to /oradata/gpsdb/dbf_11_3.dbf
restoring datafile 00081 to /oradata/gpsdb/dbf_12_1.dbf
restoring datafile 00085 to /oradata/gpsdb/wzt_tbs_27.dbf
restoring datafile 00088 to /oradata/gpsdb/wzt_tbs_30.dbf
restoring datafile 00093 to /oradata/gpsdb/dbf_10_3_02.dbf
restoring datafile 00094 to /oradata/gpsdb/dbf_09_3b.dbf
restoring datafile 00095 to /oradata/gpsdb/dbf_10_3_03.dbf
restoring datafile 00097 to /oradata/gpsdb/dbf_11_2_02.dbf
restoring datafile 00098 to /oradata/gpsdb/dbf_11_3_02.dbf
restoring datafile 00101 to /oradata/gpsdb/dbf_10_2_03.dbf
restoring datafile 00109 to /oradata/gpsdb/dbf_12_11.dbf
restoring datafile 00115 to /oradata/gpsdb/dbf_02_2.dbf
restoring datafile 00118 to /oradata/gpsdb/dbf_01_01.dbf
restoring datafile 00120 to /oradata/gpsdb/dbf_01_03.dbf
restoring datafile 00121 to /oradata/gpsdb/dbf_02_01.dbf
restoring datafile 00123 to /oradata/gpsdb/wzt_tbs_33.dbf
restoring datafile 00126 to /oradata/gpsdb/wzt_tbs_36.dbf
restoring datafile 00133 to /oradata/gpsdb/dbf_02_12.dbf
restoring datafile 00134 to /oradata/gpsdb/dbf_02_13.dbf
restoring datafile 00137 to /oradata/gpsdb/dbf_01_31.dbf
restoring datafile 00138 to /oradata/gpsdb/dbf_01_32.dbf
restoring datafile 00140 to /oradata/gpsdb/dbf_02_31.dbf
restoring datafile 00143 to /oradata/gpsdb/dbf_03_1
restoring datafile 00144 to /oradata/gpsdb/dbf_03_2
restoring datafile 00146 to /oradata/gpsdb/dbf_04_1
restoring datafile 00148 to /oradata/gpsdb/dbf_04_3
restoring datafile 00150 to /oradata/gpsdb/dbf_05_2
restoring datafile 00152 to /oradata/gpsdb/dbf__03_01.dbf
restoring datafile 00157 to /oradata/gpsdb/dbf_03_13.dbf
restoring datafile 00158 to /oradata/gpsdb/dbf_12_23.dbf
restoring datafile 00159 to /oradata/gpsdb/wzt_tbs_38.dbf
restoring datafile 00172 to /oradata/gpsdb/wzt_tbs_44.dbf
restoring datafile 00174 to /oradata/gpsdb/dbf_05_01
restoring datafile 00175 to /oradata/gpsdb/dbf_05_11
restoring datafile 00178 to /oradata/gpsdb/dbf_05_03
restoring datafile 00179 to /oradata/gpsdb/dbf_05_13
restoring datafile 00182 to /oradata/gpsdb/dbf_06_31.dbf
channel aux2: reading from backup piece /backup/gpsbak/dbbackup/GPSDB_632_848915220.data
channel aux3: starting datafile backupset restore
channel aux3: specifying datafile(s) to restore from backup set
restoring datafile 00006 to /oradata/gpsdb/wzt_tbs_01.dbf
restoring datafile 00009 to /oradata/gpsdb/wzt_tbs_04.dbf
restoring datafile 00011 to /oradata/gpsdb/splex_tbs_01.dbf
restoring datafile 00013 to /oradata/gpsdb/wzt_tbs_07.dbf
restoring datafile 00016 to /oradata/gpsdb/wzt_tbs_10.dbf
restoring datafile 00018 to /oradata/gpsdb/dbf_130502.dbf
restoring datafile 00023 to /oradata/gpsdb/wzt_tbs_14.dbf
restoring datafile 00026 to /oradata/gpsdb/wzt_tbs_17.dbf
restoring datafile 00029 to /oradata/gpsdb/wzt_tbs_20.dbf
restoring datafile 00031 to /oradata/gpsdb/idx_trenzhangmot_02.dbf
restoring datafile 00032 to /oradata/gpsdb/idx_trenzhangmot_03.dbf
restoring datafile 00034 to /oradata/gpsdb/idx_trenzhangmot_05.dbf
restoring datafile 00037 to /oradata/gpsdb/idx_trenzhangmot_08.dbf
restoring datafile 00043 to /oradata/gpsdb/dbf_07_1.dbf
restoring datafile 00045 to /oradata/gpsdb/dbf_07_3.dbf
restoring datafile 00052 to /oradata/gpsdb/dbf_08_2.dbf
restoring datafile 00054 to /oradata/gpsdb_flasharea_dg/dbf_08_2.dbf
restoring datafile 00055 to /oradata/gpsdb_flasharea_dg/wzt_tbs_26.dbf
restoring datafile 00056 to /oradata/gpsdb/dbf_06_1b.dbf
restoring datafile 00058 to /oradata/gpsdb/dbf_06_3b.dbf
restoring datafile 00059 to /oradata/gpsdb/dbf_07_1b.dbf
restoring datafile 00061 to /oradata/gpsdb/dbf_07_3b.dbf
restoring datafile 00068 to /oradata/gpsdb/undotbs05.dbf
restoring datafile 00071 to /oradata/gpsdb/undotbs08.dbf
restoring datafile 00073 to /oradata/gpsdb/dbf_09_2.dbf
restoring datafile 00076 to /oradata/gpsdb/dbf_10_2.dbf
restoring datafile 00077 to /oradata/gpsdb/dbf_10_3.dbf
restoring datafile 00082 to /oradata/gpsdb/dbf_12_2.dbf
restoring datafile 00083 to /oradata/gpsdb/dbf_12_3.dbf
restoring datafile 00086 to /oradata/gpsdb/wzt_tbs_28.dbf
restoring datafile 00089 to /oradata/gpsdb/wzt_tbs_31.dbf
restoring datafile 00092 to /oradata/gpsdb/dbf_10_2_02.dbf
restoring datafile 00096 to /oradata/gpsdb/dbf_11_1_02.dbf
restoring datafile 00099 to /oradata/gpsdb/dbf_08_3c.dbf
restoring datafile 00102 to /oradata/gpsdb/dbf_11_2_12.dbf
restoring datafile 00104 to /oradata/gpsdb/dbf_10_3_13.dbf
restoring datafile 00107 to /oradata/gpsdb/dbf_12_02.dbf
restoring datafile 00110 to /oradata/gpsdb/dbf_12_12.dbf
restoring datafile 00111 to /oradata/gpsdb/dbf_01_1.dbf
restoring datafile 00113 to /oradata/gpsdb/dbf_01_3.dbf
restoring datafile 00119 to /oradata/gpsdb/dbf_01_02.dbf
restoring datafile 00125 to /oradata/gpsdb/wzt_tbs_35.dbf
restoring datafile 00128 to /oradata/gpsdb/dbf_02_03.dbf
restoring datafile 00129 to /oradata/gpsdb/dbf_01_11.dbf
restoring datafile 00130 to /oradata/gpsdb/dbf_01_12.dbf
restoring datafile 00132 to /oradata/gpsdb/dbf_02_11.dbf
restoring datafile 00135 to /oradata/gpsdb/dbf_01_21.dbf
restoring datafile 00141 to /oradata/gpsdb/dbf_02_22.dbf
restoring datafile 00145 to /oradata/gpsdb/dbf_03_3
restoring datafile 00147 to /oradata/gpsdb/dbf_04_2
restoring datafile 00153 to /oradata/gpsdb/dbf__03_11.dbf
restoring datafile 00154 to /oradata/gpsdb/dbf_03_02.dbf
restoring datafile 00160 to /oradata/gpsdb/wzt_tbs_39.dbf
restoring datafile 00162 to /oradata/gpsdb/dbf_04_11
restoring datafile 00163 to /oradata/gpsdb/dbf_04_02
restoring datafile 00166 to /oradata/gpsdb/dbf_04_13
restoring datafile 00167 to /oradata/gpsdb/wzt_tbs_40.dbf
restoring datafile 00169 to /oradata/gpsdb/dbf_04_21
restoring datafile 00171 to /oradata/gpsdb/wzt_tbs_43.dbf
restoring datafile 00173 to /oradata/gpsdb/wzt_tbs_45.dbf
restoring datafile 00177 to /oradata/gpsdb/dbf_05_12
restoring datafile 00181 to /oradata/gpsdb/dbf_06_21.dbf
channel aux3: reading from backup piece /backup/gpsbak/dbbackup/GPSDB_633_848936320.data
channel aux1: restored backup piece 1
piece handle=/backup/gpsbak/dbbackup/GPSDB_631_848915219.data tag=TAG20140530T094658
channel aux1: restore complete, elapsed time: 05:20:29
channel aux3: restored backup piece 1
piece handle=/backup/gpsbak/dbbackup/GPSDB_633_848936320.data tag=TAG20140530T094658
channel aux3: restore complete, elapsed time: 05:30:34
channel aux2: restored backup piece 1
piece handle=/backup/gpsbak/dbbackup/GPSDB_632_848915220.data tag=TAG20140530T094658
channel aux2: restore complete, elapsed time: 06:47:60
Finished restore at 31-MAY-14
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy recid=184 stamp=848985474 filename=/oradata/gpsdb/system01.dbf
datafile 2 switched to datafile copy
input datafile copy recid=185 stamp=848985474 filename=/oradata/gpsdb/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=186 stamp=848985474 filename=/oradata/gpsdb/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=187 stamp=848985474 filename=/oradata/gpsdb/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=188 stamp=848985474 filename=/oradata/gpsdb/undotbs02.dbf
datafile 6 switched to datafile copy
input datafile copy recid=189 stamp=848985474 filename=/oradata/gpsdb/wzt_tbs_01.dbf
datafile 7 switched to datafile copy
input datafile copy recid=190 stamp=848985474 filename=/oradata/gpsdb/wzt_tbs_02.dbf
datafile 8 switched to datafile copy
input datafile copy recid=191 stamp=848985474 filename=/oradata/gpsdb/wzt_tbs_03.dbf
datafile 9 switched to datafile copy
input datafile copy recid=192 stamp=848985474 filename=/oradata/gpsdb/wzt_tbs_04.dbf
datafile 10 switched to datafile copy
input datafile copy recid=193 stamp=848985474 filename=/oradata/gpsdb/wzt_tbs_05.dbf
datafile 11 switched to datafile copy
input datafile copy recid=194 stamp=848985475 filename=/oradata/gpsdb/splex_tbs_01.dbf
datafile 12 switched to datafile copy
input datafile copy recid=195 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_06.dbf
datafile 13 switched to datafile copy
input datafile copy recid=196 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_07.dbf
datafile 14 switched to datafile copy
input datafile copy recid=197 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_08.dbf
datafile 15 switched to datafile copy
input datafile copy recid=198 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_09.dbf
datafile 16 switched to datafile copy
input datafile copy recid=199 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_10.dbf
datafile 17 switched to datafile copy
input datafile copy recid=200 stamp=848985475 filename=/oradata/gpsdb/dbf_130501.dbf
datafile 18 switched to datafile copy
input datafile copy recid=201 stamp=848985475 filename=/oradata/gpsdb/dbf_130502.dbf
datafile 19 switched to datafile copy
input datafile copy recid=202 stamp=848985475 filename=/oradata/gpsdb/dbf_130503.dbf
datafile 20 switched to datafile copy
input datafile copy recid=203 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_11.dbf
datafile 21 switched to datafile copy
input datafile copy recid=204 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_12.dbf
datafile 22 switched to datafile copy
input datafile copy recid=205 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_13.dbf
datafile 23 switched to datafile copy
input datafile copy recid=206 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_14.dbf
datafile 24 switched to datafile copy
input datafile copy recid=207 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_15.dbf
datafile 25 switched to datafile copy
input datafile copy recid=208 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_16.dbf
datafile 26 switched to datafile copy
input datafile copy recid=209 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_17.dbf
datafile 27 switched to datafile copy
input datafile copy recid=210 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_18.dbf
datafile 28 switched to datafile copy
input datafile copy recid=211 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_19.dbf
datafile 29 switched to datafile copy
input datafile copy recid=212 stamp=848985476 filename=/oradata/gpsdb/wzt_tbs_20.dbf
datafile 30 switched to datafile copy
input datafile copy recid=213 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_01.dbf
datafile 31 switched to datafile copy
input datafile copy recid=214 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_02.dbf
datafile 32 switched to datafile copy
input datafile copy recid=215 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_03.dbf
datafile 33 switched to datafile copy
input datafile copy recid=216 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_04.dbf
datafile 34 switched to datafile copy
input datafile copy recid=217 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_05.dbf
datafile 35 switched to datafile copy
input datafile copy recid=218 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_06.dbf
datafile 36 switched to datafile copy
input datafile copy recid=219 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_07.dbf
datafile 37 switched to datafile copy
input datafile copy recid=220 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_08.dbf
datafile 38 switched to datafile copy
input datafile copy recid=221 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_09.dbf
datafile 39 switched to datafile copy
input datafile copy recid=222 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_10.dbf
datafile 40 switched to datafile copy
input datafile copy recid=223 stamp=848985476 filename=/oradata/gpsdb/dbf_06_1.dbf
datafile 41 switched to datafile copy
input datafile copy recid=224 stamp=848985476 filename=/oradata/gpsdb/dbf_06_2.dbf
datafile 42 switched to datafile copy
input datafile copy recid=225 stamp=848985476 filename=/oradata/gpsdb/dbf_06_3.dbf
datafile 43 switched to datafile copy
input datafile copy recid=226 stamp=848985476 filename=/oradata/gpsdb/dbf_07_1.dbf
datafile 44 switched to datafile copy
input datafile copy recid=227 stamp=848985476 filename=/oradata/gpsdb/dbf_07_2.dbf
datafile 45 switched to datafile copy
input datafile copy recid=228 stamp=848985476 filename=/oradata/gpsdb/dbf_07_3.dbf
datafile 46 switched to datafile copy
input datafile copy recid=229 stamp=848985476 filename=/oradata/gpsdb/wzt_tbs_21.dbf
datafile 47 switched to datafile copy
input datafile copy recid=230 stamp=848985477 filename=/oradata/gpsdb/wzt_tbs_22.dbf
datafile 48 switched to datafile copy
input datafile copy recid=231 stamp=848985477 filename=/oradata/gpsdb/wzt_tbs_23.dbf
datafile 49 switched to datafile copy
input datafile copy recid=232 stamp=848985477 filename=/oradata/gpsdb/wzt_tbs_24.dbf
datafile 50 switched to datafile copy
input datafile copy recid=233 stamp=848985477 filename=/oradata/gpsdb/wzt_tbs_25.dbf
datafile 51 switched to datafile copy
input datafile copy recid=234 stamp=848985477 filename=/oradata/gpsdb/dbf_08_1.dbf
datafile 52 switched to datafile copy
input datafile copy recid=235 stamp=848985477 filename=/oradata/gpsdb/dbf_08_2.dbf
datafile 53 switched to datafile copy
input datafile copy recid=236 stamp=848985477 filename=/oradata/gpsdb/dbf_08_3.dbf
datafile 54 switched to datafile copy
input datafile copy recid=237 stamp=848985477 filename=/oradata/gpsdb_flasharea_dg/dbf_08_2.dbf
datafile 55 switched to datafile copy
input datafile copy recid=238 stamp=848985477 filename=/oradata/gpsdb_flasharea_dg/wzt_tbs_26.db
f
datafile 56 switched to datafile copy
input datafile copy recid=239 stamp=848985477 filename=/oradata/gpsdb/dbf_06_1b.dbf
datafile 57 switched to datafile copy
input datafile copy recid=240 stamp=848985477 filename=/oradata/gpsdb/dbf_06_2b.dbf
datafile 58 switched to datafile copy
input datafile copy recid=241 stamp=848985477 filename=/oradata/gpsdb/dbf_06_3b.dbf
datafile 59 switched to datafile copy
input datafile copy recid=242 stamp=848985477 filename=/oradata/gpsdb/dbf_07_1b.dbf
datafile 60 switched to datafile copy
input datafile copy recid=243 stamp=848985477 filename=/oradata/gpsdb/dbf_07_2b.dbf
datafile 61 switched to datafile copy
input datafile copy recid=244 stamp=848985477 filename=/oradata/gpsdb/dbf_07_3b.dbf
datafile 62 switched to datafile copy
input datafile copy recid=245 stamp=848985477 filename=/oradata/gpsdb/dbf_08_1b.dbf
datafile 63 switched to datafile copy
input datafile copy recid=246 stamp=848985477 filename=/oradata/gpsdb/dbf_08_2b.dbf
datafile 64 switched to datafile copy
input datafile copy recid=247 stamp=848985477 filename=/oradata/gpsdb/dbf_08_3b.dbf
datafile 65 switched to datafile copy
input datafile copy recid=248 stamp=848985477 filename=/oradata/gpsdb/wzt_tbs_26.dbf
datafile 66 switched to datafile copy
input datafile copy recid=249 stamp=848985477 filename=/oradata/gpsdb/undotbs03.dbf
datafile 67 switched to datafile copy
input datafile copy recid=250 stamp=848985478 filename=/oradata/gpsdb/undotbs04.dbf
datafile 68 switched to datafile copy
input datafile copy recid=251 stamp=848985478 filename=/oradata/gpsdb/undotbs05.dbf
datafile 69 switched to datafile copy
input datafile copy recid=252 stamp=848985478 filename=/oradata/gpsdb/undotbs06.dbf
datafile 70 switched to datafile copy
input datafile copy recid=253 stamp=848985478 filename=/oradata/gpsdb/undotbs07.dbf
datafile 71 switched to datafile copy
input datafile copy recid=254 stamp=848985478 filename=/oradata/gpsdb/undotbs08.dbf
datafile 72 switched to datafile copy
input datafile copy recid=255 stamp=848985478 filename=/oradata/gpsdb/dbf_09_1.dbf
datafile 73 switched to datafile copy
input datafile copy recid=256 stamp=848985478 filename=/oradata/gpsdb/dbf_09_2.dbf
datafile 74 switched to datafile copy
input datafile copy recid=257 stamp=848985478 filename=/oradata/gpsdb/dbf_09_3.dbf
datafile 75 switched to datafile copy
input datafile copy recid=258 stamp=848985478 filename=/oradata/gpsdb/dbf_10_1.dbf
datafile 76 switched to datafile copy
input datafile copy recid=259 stamp=848985478 filename=/oradata/gpsdb/dbf_10_2.dbf
datafile 77 switched to datafile copy
input datafile copy recid=260 stamp=848985478 filename=/oradata/gpsdb/dbf_10_3.dbf
datafile 78 switched to datafile copy
input datafile copy recid=261 stamp=848985478 filename=/oradata/gpsdb/dbf_11_1.dbf
datafile 79 switched to datafile copy
input datafile copy recid=262 stamp=848985478 filename=/oradata/gpsdb/dbf_11_2.dbf
datafile 80 switched to datafile copy
input datafile copy recid=263 stamp=848985478 filename=/oradata/gpsdb/dbf_11_3.dbf
datafile 81 switched to datafile copy
input datafile copy recid=264 stamp=848985478 filename=/oradata/gpsdb/dbf_12_1.dbf
datafile 82 switched to datafile copy
input datafile copy recid=265 stamp=848985478 filename=/oradata/gpsdb/dbf_12_2.dbf
datafile 83 switched to datafile copy
input datafile copy recid=266 stamp=848985478 filename=/oradata/gpsdb/dbf_12_3.dbf
datafile 84 switched to datafile copy
input datafile copy recid=267 stamp=848985478 filename=/oradata/gpsdb/dbf_09_1_01.dbf
datafile 85 switched to datafile copy
input datafile copy recid=268 stamp=848985478 filename=/oradata/gpsdb/wzt_tbs_27.dbf
datafile 86 switched to datafile copy
input datafile copy recid=269 stamp=848985478 filename=/oradata/gpsdb/wzt_tbs_28.dbf
datafile 87 switched to datafile copy
input datafile copy recid=270 stamp=848985479 filename=/oradata/gpsdb/wzt_tbs_29.dbf
datafile 88 switched to datafile copy
input datafile copy recid=271 stamp=848985479 filename=/oradata/gpsdb/wzt_tbs_30.dbf
datafile 89 switched to datafile copy
input datafile copy recid=272 stamp=848985479 filename=/oradata/gpsdb/wzt_tbs_31.dbf
datafile 90 switched to datafile copy
input datafile copy recid=273 stamp=848985479 filename=/oradata/gpsdb/wzt_tbs_32.dbf
datafile 91 switched to datafile copy
input datafile copy recid=274 stamp=848985479 filename=/oradata/gpsdb/dbf_10_1_02.dbf
datafile 92 switched to datafile copy
input datafile copy recid=275 stamp=848985479 filename=/oradata/gpsdb/dbf_10_2_02.dbf
datafile 93 switched to datafile copy
input datafile copy recid=276 stamp=848985479 filename=/oradata/gpsdb/dbf_10_3_02.dbf
datafile 94 switched to datafile copy
input datafile copy recid=277 stamp=848985479 filename=/oradata/gpsdb/dbf_09_3b.dbf
datafile 95 switched to datafile copy
input datafile copy recid=278 stamp=848985479 filename=/oradata/gpsdb/dbf_10_3_03.dbf
datafile 96 switched to datafile copy
input datafile copy recid=279 stamp=848985479 filename=/oradata/gpsdb/dbf_11_1_02.dbf
datafile 97 switched to datafile copy
input datafile copy recid=280 stamp=848985479 filename=/oradata/gpsdb/dbf_11_2_02.dbf
datafile 98 switched to datafile copy
input datafile copy recid=281 stamp=848985479 filename=/oradata/gpsdb/dbf_11_3_02.dbf
datafile 99 switched to datafile copy
input datafile copy recid=282 stamp=848985479 filename=/oradata/gpsdb/dbf_08_3c.dbf
datafile 100 switched to datafile copy
input datafile copy recid=283 stamp=848985479 filename=/oradata/gpsdb/dbf_09_2b.dbf
datafile 101 switched to datafile copy
input datafile copy recid=284 stamp=848985479 filename=/oradata/gpsdb/dbf_10_2_03.dbf
datafile 102 switched to datafile copy
input datafile copy recid=285 stamp=848985479 filename=/oradata/gpsdb/dbf_11_2_12.dbf
datafile 103 switched to datafile copy
input datafile copy recid=286 stamp=848985479 filename=/oradata/gpsdb/dbf_10_2_12.dbf
datafile 104 switched to datafile copy
input datafile copy recid=287 stamp=848985479 filename=/oradata/gpsdb/dbf_10_3_13.dbf
datafile 105 switched to datafile copy
input datafile copy recid=288 stamp=848985480 filename=/oradata/gpsdb/dbf_11_3_03.dbf
datafile 106 switched to datafile copy
input datafile copy recid=289 stamp=848985480 filename=/oradata/gpsdb/dbf_12_01.dbf
datafile 107 switched to datafile copy
input datafile copy recid=290 stamp=848985480 filename=/oradata/gpsdb/dbf_12_02.dbf
datafile 108 switched to datafile copy
input datafile copy recid=291 stamp=848985480 filename=/oradata/gpsdb/dbf_12_03.dbf
datafile 109 switched to datafile copy
input datafile copy recid=292 stamp=848985480 filename=/oradata/gpsdb/dbf_12_11.dbf
datafile 110 switched to datafile copy
input datafile copy recid=293 stamp=848985480 filename=/oradata/gpsdb/dbf_12_12.dbf
datafile 111 switched to datafile copy
input datafile copy recid=294 stamp=848985480 filename=/oradata/gpsdb/dbf_01_1.dbf
datafile 112 switched to datafile copy
input datafile copy recid=295 stamp=848985480 filename=/oradata/gpsdb/dbf_01_2.dbf
datafile 113 switched to datafile copy
input datafile copy recid=296 stamp=848985480 filename=/oradata/gpsdb/dbf_01_3.dbf
datafile 114 switched to datafile copy
input datafile copy recid=297 stamp=848985480 filename=/oradata/gpsdb/dbf_02_1.dbf
datafile 115 switched to datafile copy
input datafile copy recid=298 stamp=848985480 filename=/oradata/gpsdb/dbf_02_2.dbf
datafile 116 switched to datafile copy
input datafile copy recid=299 stamp=848985480 filename=/oradata/gpsdb/dbf_02_3.dbf
datafile 117 switched to datafile copy
input datafile copy recid=300 stamp=848985480 filename=/oradata/gpsdb/dbf_12_3_13.dbf
datafile 118 switched to datafile copy
input datafile copy recid=301 stamp=848985480 filename=/oradata/gpsdb/dbf_01_01.dbf
datafile 119 switched to datafile copy
input datafile copy recid=302 stamp=848985480 filename=/oradata/gpsdb/dbf_01_02.dbf
datafile 120 switched to datafile copy
input datafile copy recid=303 stamp=848985480 filename=/oradata/gpsdb/dbf_01_03.dbf
datafile 121 switched to datafile copy
input datafile copy recid=304 stamp=848985480 filename=/oradata/gpsdb/dbf_02_01.dbf
datafile 122 switched to datafile copy
input datafile copy recid=305 stamp=848985480 filename=/oradata/gpsdb/dbf_02_02.dbf
datafile 123 switched to datafile copy
input datafile copy recid=306 stamp=848985481 filename=/oradata/gpsdb/wzt_tbs_33.dbf
datafile 124 switched to datafile copy
input datafile copy recid=307 stamp=848985481 filename=/oradata/gpsdb/wzt_tbs_34.dbf
datafile 125 switched to datafile copy
input datafile copy recid=308 stamp=848985481 filename=/oradata/gpsdb/wzt_tbs_35.dbf
datafile 126 switched to datafile copy
input datafile copy recid=309 stamp=848985481 filename=/oradata/gpsdb/wzt_tbs_36.dbf
datafile 127 switched to datafile copy
input datafile copy recid=310 stamp=848985481 filename=/oradata/gpsdb/wzt_tbs_37.dbf
datafile 128 switched to datafile copy
input datafile copy recid=311 stamp=848985481 filename=/oradata/gpsdb/dbf_02_03.dbf
datafile 129 switched to datafile copy
input datafile copy recid=312 stamp=848985481 filename=/oradata/gpsdb/dbf_01_11.dbf
datafile 130 switched to datafile copy
input datafile copy recid=313 stamp=848985481 filename=/oradata/gpsdb/dbf_01_12.dbf
datafile 131 switched to datafile copy
input datafile copy recid=314 stamp=848985481 filename=/oradata/gpsdb/dbf_01_13.dbf
datafile 132 switched to datafile copy
input datafile copy recid=315 stamp=848985481 filename=/oradata/gpsdb/dbf_02_11.dbf
datafile 133 switched to datafile copy
input datafile copy recid=316 stamp=848985481 filename=/oradata/gpsdb/dbf_02_12.dbf
datafile 134 switched to datafile copy
input datafile copy recid=317 stamp=848985481 filename=/oradata/gpsdb/dbf_02_13.dbf
datafile 135 switched to datafile copy
input datafile copy recid=318 stamp=848985481 filename=/oradata/gpsdb/dbf_01_21.dbf
datafile 136 switched to datafile copy
input datafile copy recid=319 stamp=848985481 filename=/oradata/gpsdb/dbf_01_22.dbf
datafile 137 switched to datafile copy
input datafile copy recid=320 stamp=848985481 filename=/oradata/gpsdb/dbf_01_31.dbf
datafile 138 switched to datafile copy
input datafile copy recid=321 stamp=848985481 filename=/oradata/gpsdb/dbf_01_32.dbf
datafile 139 switched to datafile copy
input datafile copy recid=322 stamp=848985481 filename=/oradata/gpsdb/dbf_02_21.dbf
datafile 140 switched to datafile copy
input datafile copy recid=323 stamp=848985481 filename=/oradata/gpsdb/dbf_02_31.dbf
datafile 141 switched to datafile copy
input datafile copy recid=324 stamp=848985481 filename=/oradata/gpsdb/dbf_02_22.dbf
datafile 142 switched to datafile copy
input datafile copy recid=325 stamp=848985481 filename=/oradata/gpsdb/dbf_02_32.dbf
datafile 143 switched to datafile copy
input datafile copy recid=326 stamp=848985481 filename=/oradata/gpsdb/dbf_03_1
datafile 144 switched to datafile copy
input datafile copy recid=327 stamp=848985481 filename=/oradata/gpsdb/dbf_03_2
datafile 145 switched to datafile copy
input datafile copy recid=328 stamp=848985482 filename=/oradata/gpsdb/dbf_03_3
datafile 146 switched to datafile copy
input datafile copy recid=329 stamp=848985482 filename=/oradata/gpsdb/dbf_04_1
datafile 147 switched to datafile copy
input datafile copy recid=330 stamp=848985482 filename=/oradata/gpsdb/dbf_04_2
datafile 148 switched to datafile copy
input datafile copy recid=331 stamp=848985482 filename=/oradata/gpsdb/dbf_04_3
datafile 149 switched to datafile copy
input datafile copy recid=332 stamp=848985482 filename=/oradata/gpsdb/dbf_05_1
datafile 150 switched to datafile copy
input datafile copy recid=333 stamp=848985482 filename=/oradata/gpsdb/dbf_05_2
datafile 151 switched to datafile copy
input datafile copy recid=334 stamp=848985482 filename=/oradata/gpsdb/dbf_05_3
datafile 152 switched to datafile copy
input datafile copy recid=335 stamp=848985482 filename=/oradata/gpsdb/dbf__03_01.dbf
datafile 153 switched to datafile copy
input datafile copy recid=336 stamp=848985482 filename=/oradata/gpsdb/dbf__03_11.dbf
datafile 154 switched to datafile copy
input datafile copy recid=337 stamp=848985482 filename=/oradata/gpsdb/dbf_03_02.dbf
datafile 155 switched to datafile copy
input datafile copy recid=338 stamp=848985482 filename=/oradata/gpsdb/dbf_03_12.dbf
datafile 156 switched to datafile copy
input datafile copy recid=339 stamp=848985482 filename=/oradata/gpsdb/dbf_03_03.dbf
datafile 157 switched to datafile copy
input datafile copy recid=340 stamp=848985482 filename=/oradata/gpsdb/dbf_03_13.dbf
datafile 158 switched to datafile copy
input datafile copy recid=341 stamp=848985482 filename=/oradata/gpsdb/dbf_12_23.dbf
datafile 159 switched to datafile copy
input datafile copy recid=342 stamp=848985482 filename=/oradata/gpsdb/wzt_tbs_38.dbf
datafile 160 switched to datafile copy
input datafile copy recid=343 stamp=848985482 filename=/oradata/gpsdb/wzt_tbs_39.dbf
datafile 161 switched to datafile copy
input datafile copy recid=344 stamp=848985482 filename=/oradata/gpsdb/dbf_04_01
datafile 162 switched to datafile copy
input datafile copy recid=345 stamp=848985482 filename=/oradata/gpsdb/dbf_04_11
datafile 163 switched to datafile copy
input datafile copy recid=346 stamp=848985482 filename=/oradata/gpsdb/dbf_04_02
datafile 164 switched to datafile copy
input datafile copy recid=347 stamp=848985482 filename=/oradata/gpsdb/dbf_04_12
datafile 165 switched to datafile copy
input datafile copy recid=348 stamp=848985482 filename=/oradata/gpsdb/dbf_04_03
datafile 166 switched to datafile copy
input datafile copy recid=349 stamp=848985482 filename=/oradata/gpsdb/dbf_04_13
datafile 167 switched to datafile copy
input datafile copy recid=350 stamp=848985482 filename=/oradata/gpsdb/wzt_tbs_40.dbf
datafile 168 switched to datafile copy
input datafile copy recid=351 stamp=848985483 filename=/oradata/gpsdb/wzt_tbs_41.dbf
datafile 169 switched to datafile copy
input datafile copy recid=352 stamp=848985483 filename=/oradata/gpsdb/dbf_04_21
datafile 170 switched to datafile copy
input datafile copy recid=353 stamp=848985483 filename=/oradata/gpsdb/wzt_tbs_42.dbf
datafile 171 switched to datafile copy
input datafile copy recid=354 stamp=848985483 filename=/oradata/gpsdb/wzt_tbs_43.dbf
datafile 172 switched to datafile copy
input datafile copy recid=355 stamp=848985483 filename=/oradata/gpsdb/wzt_tbs_44.dbf
datafile 173 switched to datafile copy
input datafile copy recid=356 stamp=848985483 filename=/oradata/gpsdb/wzt_tbs_45.dbf
datafile 174 switched to datafile copy
input datafile copy recid=357 stamp=848985483 filename=/oradata/gpsdb/dbf_05_01
datafile 175 switched to datafile copy
input datafile copy recid=358 stamp=848985483 filename=/oradata/gpsdb/dbf_05_11
datafile 176 switched to datafile copy
input datafile copy recid=359 stamp=848985483 filename=/oradata/gpsdb/dbf_05_02
datafile 177 switched to datafile copy
input datafile copy recid=360 stamp=848985483 filename=/oradata/gpsdb/dbf_05_12
datafile 178 switched to datafile copy
input datafile copy recid=361 stamp=848985483 filename=/oradata/gpsdb/dbf_05_03
datafile 179 switched to datafile copy
input datafile copy recid=362 stamp=848985483 filename=/oradata/gpsdb/dbf_05_13
datafile 180 switched to datafile copy
input datafile copy recid=363 stamp=848985483 filename=/oradata/gpsdb/dbf_06_11.dbf
datafile 181 switched to datafile copy
input datafile copy recid=364 stamp=848985483 filename=/oradata/gpsdb/dbf_06_21.dbf
datafile 182 switched to datafile copy
input datafile copy recid=365 stamp=848985483 filename=/oradata/gpsdb/dbf_06_31.dbf
Finished Duplicate Db at 31-MAY-14
released channel: aux1
released channel: aux2
released channel: aux3
RMAN>
Recovery Manager complete.
Sat May 31 05:18:08 CST 2014
六、应用日志
注意：primary库在rman里去镜像相关归档日志；standby库startup mount下做日志的注册应用；
1)、根据sequence从primary库镜像归档日志文件到指定位置
backup as copy format='/backup/gpsbak/dbbackup/39765.log' archivelog sequence 39765 thread 2;
2)、在standby库注册日志
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39765.log';
3)、在standby库apply日志
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
4)、如果所有日志都被apply了完了，就取消日志的apply
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
5)、截取最后一批日志apply时的alert里的记录信息
Tue Jun 03 19:51:06 CST 2014
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
Tue Jun 03 19:52:24 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78800.log
Tue Jun 03 19:53:39 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78801.log
Tue Jun 03 19:54:54 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78802.log
Media Recovery Log /backup/gpsbak/dbbackup/39798.log
Tue Jun 03 19:56:08 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78803.log
Tue Jun 03 19:57:27 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78804.log
Tue Jun 03 19:58:45 CST 2014
Media Recovery Waiting for thread 1 sequence 78805
Tue Jun 03 20:03:11 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78805.log'
Tue Jun 03 20:03:11 CST 2014
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78804 to 78805
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78805.log'
Tue Jun 03 20:03:12 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78806.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78805 to 78806
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78806.log'
Tue Jun 03 20:03:16 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78805.log
Media Recovery Waiting for thread 2 sequence 39799
Tue Jun 03 20:03:20 CST 2014
db_recovery_file_dest_size of 1099246 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Jun 03 20:04:35 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39799.log'
Tue Jun 03 20:04:35 CST 2014
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39798 to 39799
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39799.log'
Tue Jun 03 20:04:37 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/39799.log
Tue Jun 03 20:05:55 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78806.log
Tue Jun 03 20:07:10 CST 2014
Media Recovery Waiting for thread 1 sequence 78807
Tue Jun 03 20:09:07 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78807.log'
Tue Jun 03 20:09:07 CST 2014
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78806 to 78807
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78807.log'
Tue Jun 03 20:09:10 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78807.log
Tue Jun 03 20:10:30 CST 2014
Media Recovery Waiting for thread 1 sequence 78808
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78808.log'
Tue Jun 03 20:30:37 CST 2014
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78807 to 78808
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78808.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78809.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78808 to 78809
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78809.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78810.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78809 to 78810
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78810.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78811.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78810 to 78811
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78811.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78812.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78811 to 78812
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78812.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78813.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78812 to 78813
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78813.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78814.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78813 to 78814
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78814.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78815.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78814 to 78815
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78815.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78816.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78815 to 78816
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78816.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78817.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78816 to 78817
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78817.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78818.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78817 to 78818
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78818.log'
Tue Jun 03 20:30:40 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78808.log
Media Recovery Waiting for thread 2 sequence 39800
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39800.log'
Tue Jun 03 20:31:02 CST 2014
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39799 to 39800
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39800.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39801.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39800 to 39801
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39801.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39802.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39801 to 39802
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39802.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39803.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39802 to 39803
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39803.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39804.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39803 to 39804
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39804.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39805.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39804 to 39805
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39805.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39806.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39805 to 39806
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39806.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39807.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39806 to 39807
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39807.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39808.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39807 to 39808
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39808.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39809.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39808 to 39809
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39809.log'
Tue Jun 03 20:31:04 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39810.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39809 to 39810
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39810.log'
Tue Jun 03 20:31:07 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/39800.log
Tue Jun 03 20:32:25 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/39801.log==>利用归档日志做介质恢复，因为归档没有信息很快，
Media Recovery Log /backup/gpsbak/dbbackup/39802.log
Media Recovery Log /backup/gpsbak/dbbackup/78809.log
Media Recovery Log /backup/gpsbak/dbbackup/39803.log
Media Recovery Log /backup/gpsbak/dbbackup/39804.log
Media Recovery Log /backup/gpsbak/dbbackup/39805.log
Media Recovery Log /backup/gpsbak/dbbackup/39806.log
Media Recovery Log /backup/gpsbak/dbbackup/78810.log
Media Recovery Log /backup/gpsbak/dbbackup/39807.log
Media Recovery Log /backup/gpsbak/dbbackup/39808.log
Media Recovery Log /backup/gpsbak/dbbackup/78811.log
Media Recovery Log /backup/gpsbak/dbbackup/78812.log
Media Recovery Log /backup/gpsbak/dbbackup/78813.log
Media Recovery Log /backup/gpsbak/dbbackup/39809.log
Media Recovery Log /backup/gpsbak/dbbackup/78814.log
Media Recovery Log /backup/gpsbak/dbbackup/78815.log
Media Recovery Log /backup/gpsbak/dbbackup/78816.log
Media Recovery Log /backup/gpsbak/dbbackup/39810.log
Media Recovery Log /backup/gpsbak/dbbackup/78817.log
Media Recovery Log /backup/gpsbak/dbbackup/78818.log
Media Recovery Waiting for thread 2 sequence 39811
Tue Jun 03 20:32:52 CST 2014
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Tue Jun 03 20:32:53 CST 2014
MRP0: Background Media Recovery cancelled with status 16037
Tue Jun 03 20:32:53 CST 2014
Errors in file /u01/app/oracle/admin/gpsdb/bdump/gpsdb_mrp0_10917.trc:
ORA-16037: user requested cancel of managed recovery operation
Recovery interrupted!
Tue Jun 03 20:32:55 CST 2014
Errors in file /u01/app/oracle/admin/gpsdb/bdump/gpsdb_mrp0_10917.trc:
ORA-16037: user requested cancel of managed recovery operation
Tue Jun 03 20:32:55 CST 2014
MRP0: Background Media Recovery process shutdown (gpsdb)
Tue Jun 03 20:32:56 CST 2014
Managed Standby Recovery Canceled (gpsdb)
Tue Jun 03 20:32:56 CST 2014
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Tue Jun 03 20:33:08 CST 2014
alter database open read only
Tue Jun 03 20:33:11 CST 2014
SMON: enabling cache recovery
Tue Jun 03 20:33:11 CST 2014
Database Characterset is AL32UTF8
Opening with internal Resource Manager plan
replication_dependency_tracking turned off (no async multimaster replication found)
Physical standby database opened for read only access.
Completed: alter database open read only==>打开数据库了
6)、这里所谓的最后一批日志，是什么呢？
primary库停应用后，数据库层面掐断oracle网络，利用alter system switch logfile；来回数次将redo日志里的信息给切到归档里，减少数据的丢失；
7)、查看归档日志应用情况及是否产生gap
v$archived_log
select thread#,sequence#,first_time,next_time,status,applied from v$archived_log;
v$archive_gap
select * from v$archive_gap;
七、数据库角色的切换
1)、结束
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;==>如果前一条无法执行成功，则强制处理
2)、切换角色
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
3)、查看切换后的信息
SQL> select name,switchover_status,open_mode,protection_mode,database_role from v$database;
NAME SWITCHOVER_STATUS OPEN_MODE PROTECTION_MODE DATABASE_ROLE
--------- -------------------- ---------- -------------------- ----------------
GPSDB SESSIONS ACTIVE READ WRITE MAXIMUM PERFORMANCE PRIMARY
4)、切换时的alert日志
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
Tue Jun 03 20:36:40 CST 2014
SKIP STANDBY LOGFILE option no longer needed for RECOVERFINISH. Option ignored
Tue Jun 03 20:36:40 CST 2014
Attempt to do a Terminal Incomplete Recovery (gpsdb)
Tue Jun 03 20:36:40 CST 2014
Stopping background process CJQ0
Tue Jun 03 20:36:40 CST 2014
Stopping background process MMNL
Tue Jun 03 20:36:41 CST 2014
Stopping background process MMON
Tue Jun 03 20:36:42 CST 2014
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Jun 03 20:36:44 CST 2014
SMON: disabling cache recovery
Tue Jun 03 20:36:45 CST 2014
Starting background process MMON
Tue Jun 03 20:36:45 CST 2014
Media Recovery Start: Managed Standby Recovery (gpsdb)
Tue Jun 03 20:36:45 CST 2014
Managed Standby Recovery not using Real Time Apply
Tue Jun 03 20:36:45 CST 2014
Starting background process MMNL
MMON started with pid=14, OS id=15129
MMNL started with pid=15, OS id=15131
Tue Jun 03 20:36:47 CST 2014
parallel recovery started with 16 processes
Media Recovery Waiting for thread 2 sequence 39811
Begin: Standby Redo Logfile archival
End: Standby Redo Logfile archival
Resetting archiving SCN from 194:4012030644 to 194:4012030410
Terminal Recovery timestamp is '06/03/2014 20:36:48'
Terminal Recovery: applying standby redo logs.
Terminal Recovery: thread 2 seq# 39811 redo required
Terminal Recovery: End-Of-Redo log allocation
Terminal Recovery: standby redo logfile 9 created '/oradata/archivelog_dest/2_0_764370486.arc'
This standby redo logfile is being created as part of the failover
operation. This standby redo logfile should be deleted after the
switchover to primary operation completes.
Tue Jun 03 20:36:48 CST 2014
Media Recovery Log /oradata/archivelog_dest/2_0_764370486.arc
Terminal Recovery: log 9 reserved for thread 2 sequence 39811
Tue Jun 03 20:36:48 CST 2014
Recovery of Online Redo Log: Thread 2 Group 9 Seq 39811 Reading mem 0
Mem# 0: /oradata/archivelog_dest/2_0_764370486.arc
Identified End-Of-Redo for thread 2 sequence 39811
Terminal Recovery: thread 1 seq# 78818 redo required
Terminal Recovery: /backup/gpsbak/dbbackup/78818.log
Terminal Recovery: Updated next available block for thread 2 sequence 39811 lno 9 to value 2
Identified End-Of-Redo for thread 2 sequence 39811
Tue Jun 03 20:36:49 CST 2014
Incomplete recovery applied all redo ever generated.
Recovery completed through change 837235685835
Tue Jun 03 20:36:49 CST 2014
Media Recovery Complete (gpsdb)
Terminal Recovery: standby redo logfile 10 created '/oradata/archivelog_dest/1_0_764370486.arc'
This standby redo logfile is being created as part of the failover
operation. This standby redo logfile should be deleted after the
switchover to primary operation completes.
Terminal Recovery: log 10 reserved for thread 1 sequence 78819
Terminal recovery recovered to last consistent point in redo stream
But it did not apply all redo; some data may be lost
Terminal Recovery: successful completion
Begin: Standby Redo Logfile archival
End: Standby Redo Logfile archival
Resetting standby activation ID 202911664 (0xc182fb0)
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
Tue Jun 03 20:37:45 CST 2014
idle dispatcher 'D000' terminated, pid = (17, 1)
Tue Jun 03 20:37:50 CST 2014
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
Tue Jun 03 20:37:50 CST 2014
ALTER DATABASE SWITCHOVER TO PRIMARY (gpsdb)
Tue Jun 03 20:37:50 CST 2014
If media recovery active, switchover will wait 900 seconds
Using STANDBY_ARCHIVE_DEST parameter default value as /oradata/archivelog_dest
Standby terminal recovery start SCN: 837235685834
RESETLOGS after complete recovery through change 837235685835
Online log /oradata/gpsdb/redo01.log: Thread 1 Group 1 was previously cleared
Online log /oradata/gpsdb/redo02.log: Thread 1 Group 2 was previously cleared
Online log /oradata/gpsdb/redo03.log: Thread 1 Group 3 was previously cleared
Online log /oradata/gpsdb/redo04.log: Thread 1 Group 4 was previously cleared
Online log /oradata/gpsdb/redo05.log: Thread 2 Group 5 was previously cleared
Online log /oradata/gpsdb/redo06.log: Thread 2 Group 6 was previously cleared
Online log /oradata/gpsdb/redo07.log: Thread 2 Group 7 was previously cleared
Online log /oradata/gpsdb/redo08.log: Thread 2 Group 8 was previously cleared
Standby became primary SCN: 837235685833
Tue Jun 03 20:37:53 CST 2014
Setting recovery target incarnation to 3
Tue Jun 03 20:37:53 CST 2014
Switchover: Complete - Database shutdown required (gpsdb)
Tue Jun 03 20:37:53 CST 2014
Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
因一套RAC库的机器需要更换机房，必须在原先机房保留一套与之一样的数据库，以便应用不断的情形做机器的搬迁:
1)、应用暂停为零最好，这种情形用goldengate做，可以做到零停机，成本太高；
2)、利用rman+dg来做，应用暂停时间大约在切应用和apply最后一批日志，因为是TB级库，如果顺利，控制在30分钟-50分钟左右；否则启用第二套方案，这里不作说明。
二、原理
采用10g RMAN duplicate方式将primary最近的备份集clone成auxiliary机器配的"standby"库，在clone完成到应用切这段时间做apply归档日志应用
注意事项：
a、standby库是理论上的备库，不是真正dg的备库；
b、primary库不自动同步日志，需要定期手工apply日志到备库上；
c、做完备库之后，应用一条最近的归档日志，open read only数据；
d、没有将停完应用的最后一批日志apply到standby库里，一定不能切换role，否则一定会丢数据；
e、停应用之后primary库的oracle网络及实例都掐断，防止有人连接；
f、切完standby为primary后，修改参数文件，去了相关参数，正常关闭启动数据，验证库有没有问题
三、primary及standby配置
1)、primary机器配置
a、双节点10.2.0.5.0版本的RAC
b、存储文件系统:ASM，47块盘做磁盘阵列
c、存储大小：大约8TB
d、数据量：3.2TB
e、最近一次备份集大小：350GB
f、无效对象：无
g、无效索引：3条，历史表，与实际生产数据没有关系
h、每周归档大约为1TB以上：归档采用压缩方式
i、redhat 5.5 x86_64
j、内存32GB,8cpu
2)、standby机器配置：
a、单实例10.2.0.5.0数据
b、存储文件系统:本地存储，30多块盘做磁盘阵列
c、存储大小：大约8.5TB
d、最近一次备份集大小：350GB
e、redhat 5.8 x86_64
f、内存194GB,8cpu
四、standby端配置
注：主库无需变动，因为不是真正上的dg，只要求做个physical standby库，手工同步日志
1)、配置密码及参数文件
create pfile='/tmp/initgpsdb.ora' from spfile;
orapwd file=orapwgpsdb password=zm_321Tl;
将产生的文件放置
/u01/app/oracle/product/10.2.0/db_1/dbs下
[oracle@gpsdb dbs]$ ll
-rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora
-rw-r--r-- 1 oracle oinstall 1179 Jun 4 10:03 initgpsdb.ora
-rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora
-rw-r----- 1 oracle oinstall 1536 May 26 15:32 orapwgpsdb
参数文件配置
[oracle@gpsdb dbs]$ more initgpsdb.ora
gpsdb.__db_cache_size=13824425984
gpsdb.__java_pool_size=33554432
gpsdb.__large_pool_size=16777216
gpsdb.__shared_pool_size=7516192768
gpsdb.__streams_pool_size=33554432
gpsdb._kghdsidx_count=3
*.audit_file_dest='/u01/app/oracle/admin/gpsdb/adump'
*.background_dump_dest='/u01/app/oracle/admin/gpsdb/bdump'
*.compatible='10.2.0.5.0'
*.control_files='/oradata/gpsdb/control1.ctl','/oradata/gpsdb/control2.ctl'
*.core_dump_dest='/u01/app/oracle/admin/gpsdb/cdump'
*.db_block_size=8192
*.db_cache_size=12884901888
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='gpsdb'
*.db_recovery_file_dest='/oradata/archivelog_dest'
*.db_recovery_file_dest_size=1152642973696
*.dispatchers='(PROTOCOL=TCP) (SERVICE=gpsdbXDB)'
*.java_pool_size=25165824
*.job_queue_processes=10
*.large_pool_size=10485760
*.log_archive_format='%t_%s_%r.arc'
*.open_cursors=300
*.pga_aggregate_target=8589934592
*.processes=500
*.remote_login_passwordfile='exclusive'
*.sessions=555
*.sga_max_size=22296920064
*.sga_target=22296920064
*.shared_pool_size=7516192768
*.streams_pool_size=33554432
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/gpsdb/udump'
*.LOG_ARCHIVE_DEST_1= 'LOCATION=/oradata/archivelog_dest VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB
_UNIQUE_NAME=gpsdb'
*.LOG_ARCHIVE_DEST_2= 'SERVICE=gpsdb_net LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_
UNIQUE_NAME=gpsdb'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.db_file_name_convert='+DATADG/gpsdb','/oradata/gpsdb','+FLASHAREA_DG/gpsdb','/oradata/gpsdb_fl
asharea_dg'
*.log_file_name_convert='+DATADG/gpsdb','/oradata/gpsdb'
*.FAL_SERVER=gpsdb_net
*.FAL_CLIENT=gpsdb
*.STANDBY_FILE_MANAGEMENT=AUTO
2)、目录
[oracle@gpsdb gpsdb]$ pwd
/u01/app/oracle/admin/gpsdb
[oracle@gpsdb gpsdb]$ ll
total 24
drwxr-x--- 2 oracle oinstall 4096 May 20 12:36 adump
drwxr-x--- 2 oracle oinstall 4096 May 20 12:41 bdump
drwxr-x--- 2 oracle oinstall 4096 May 13 12:26 cdump
drwxr-x--- 2 oracle oinstall 4096 May 13 12:27 dpdump
drwxr-x--- 2 oracle oinstall 4096 May 20 13:43 pfile
drwxr-x--- 2 oracle oinstall 4096 May 20 12:36 udump
3)、网络配置：
tnsnames.ora
##连接primary库
gpsdb_p =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.118.51)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.118.52)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gpsdb.trsen.zhang.com)
)
)
##连接stanby库
gpsdb_s =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.19.88)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gpsdb)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
listener.ora
##配置静态监听和动态监听
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME=gpsdb)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = gpsdb)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gpsdb)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
/etc/hosts配置
[oracle@gpsdb admin]$ more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
10.1.19.88 gpsdb
查看监听配置是否成功
[oracle@gpsdb admin]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 04-JUN-2014 14:57:53
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gpsdb)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 26-MAY-2014 15:09:25
Uptime 8 days 23 hr. 48 min. 27 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gpsdb)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "gpsdb" has 2 instance(s).
Instance "gpsdb", status UNKNOWN, has 1 handler(s) for this service...
Instance "gpsdb", status READY, has 1 handler(s) for this service...
Service "gpsdbXDB" has 1 instance(s).
Instance "gpsdb", status READY, has 1 handler(s) for this service...
Service "gpsdb_XPT" has 1 instance(s).
Instance "gpsdb", status READY, has 1 handler(s) for this service...
The command completed successfully
测试rman duplicate连接
[oracle@gpsdb admin]$rman target sys/zm_321Tl@gpsdb_p AUXILIARY sys/zm_321Tl@gpsdb_s
Recovery Manager: Release 10.2.0.5.0 - Production on Fri May 30 22:29:33 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: GPSDB (DBID=201808262)
connected to auxiliary database: GPSDB (not mounted)
RMAN>
五、做standby数据库
1)、脚本
[oracle@gpsdb ~]$ more duplicate.sh
#!/bin/bash
. /etc/profile
. ~/.bash_profile
date
rman target sys/zm_321Tl@gpsdb_p AUXILIARY sys/zm_321Tl@gpsdb_s <<EOF
run
{
allocate auxiliary channel aux1 device type disk;
allocate auxiliary channel aux2 device type disk;
allocate auxiliary channel aux3 device type disk;
DUPLICATE TARGET DATABASE FOR STANDBY;
}
EOF
date
2)、duplicate日志,整个过程花费将近7小时
[oracle@gpsdb ~]$ more duplicate.log
Fri May 30 22:29:33 CST 2014
Recovery Manager: Release 10.2.0.5.0 - Production on Fri May 30 22:29:33 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: GPSDB (DBID=201808262)
connected to auxiliary database: GPSDB (not mounted)
RMAN> 2> 3> 4> 5> 6> 7>
using target database control file instead of recovery catalog
allocated channel: aux1
channel aux1: sid=536 devtype=DISK
allocated channel: aux2
channel aux2: sid=535 devtype=DISK
allocated channel: aux3
channel aux3: sid=534 devtype=DISK
Starting Duplicate Db at 30-MAY-14
contents of Memory Script:
{
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script
Starting restore at 30-MAY-14
channel aux1: restoring control file
channel aux1: copied control file copy
input filename=/tmp/ctl
output filename=/oradata/gpsdb/control1.ctl
output filename=/oradata/gpsdb/control2.ctl
Finished restore at 30-MAY-14
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"/oradata/gpsdb/temp01.dbf";
set newname for tempfile 2 to
"/oradata/gpsdb/gps_temp_01.dbf";
set newname for tempfile 3 to
"/oradata/gpsdb/gps_temp_02.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/oradata/gpsdb/system01.dbf";
set newname for datafile 2 to
"/oradata/gpsdb/undotbs01.dbf";
set newname for datafile 3 to
"/oradata/gpsdb/sysaux01.dbf";
set newname for datafile 4 to
"/oradata/gpsdb/users01.dbf";
set newname for datafile 5 to
"/oradata/gpsdb/undotbs02.dbf";
set newname for datafile 6 to
"/oradata/gpsdb/wzt_tbs_01.dbf";
set newname for datafile 7 to
"/oradata/gpsdb/wzt_tbs_02.dbf";
set newname for datafile 8 to
"/oradata/gpsdb/wzt_tbs_03.dbf";
set newname for datafile 9 to
"/oradata/gpsdb/wzt_tbs_04.dbf";
set newname for datafile 10 to
"/oradata/gpsdb/wzt_tbs_05.dbf";
set newname for datafile 11 to
"/oradata/gpsdb/splex_tbs_01.dbf";
set newname for datafile 12 to
"/oradata/gpsdb/wzt_tbs_06.dbf";
set newname for datafile 13 to
"/oradata/gpsdb/wzt_tbs_07.dbf";
set newname for datafile 14 to
"/oradata/gpsdb/wzt_tbs_08.dbf";
set newname for datafile 15 to
"/oradata/gpsdb/wzt_tbs_09.dbf";
set newname for datafile 16 to
"/oradata/gpsdb/wzt_tbs_10.dbf";
set newname for datafile 17 to
"/oradata/gpsdb/dbf_130501.dbf";
set newname for datafile 18 to
"/oradata/gpsdb/dbf_130502.dbf";
set newname for datafile 19 to
"/oradata/gpsdb/dbf_130503.dbf";
set newname for datafile 20 to
"/oradata/gpsdb/wzt_tbs_11.dbf";
set newname for datafile 21 to
"/oradata/gpsdb/wzt_tbs_12.dbf";
set newname for datafile 22 to
"/oradata/gpsdb/wzt_tbs_13.dbf";
set newname for datafile 23 to
"/oradata/gpsdb/wzt_tbs_14.dbf";
set newname for datafile 24 to
"/oradata/gpsdb/wzt_tbs_15.dbf";
set newname for datafile 25 to
"/oradata/gpsdb/wzt_tbs_16.dbf";
set newname for datafile 26 to
"/oradata/gpsdb/wzt_tbs_17.dbf";
set newname for datafile 27 to
"/oradata/gpsdb/wzt_tbs_18.dbf";
set newname for datafile 28 to
"/oradata/gpsdb/wzt_tbs_19.dbf";
set newname for datafile 29 to
"/oradata/gpsdb/wzt_tbs_20.dbf";
set newname for datafile 30 to
"/oradata/gpsdb/idx_trenzhangmot_01.dbf";
set newname for datafile 31 to
"/oradata/gpsdb/idx_trenzhangmot_02.dbf";
set newname for datafile 32 to
"/oradata/gpsdb/idx_trenzhangmot_03.dbf";
set newname for datafile 33 to
"/oradata/gpsdb/idx_trenzhangmot_04.dbf";
set newname for datafile 34 to
"/oradata/gpsdb/idx_trenzhangmot_05.dbf";
set newname for datafile 35 to
"/oradata/gpsdb/idx_trenzhangmot_06.dbf";
set newname for datafile 36 to
"/oradata/gpsdb/idx_trenzhangmot_07.dbf";
set newname for datafile 37 to
"/oradata/gpsdb/idx_trenzhangmot_08.dbf";
set newname for datafile 38 to
"/oradata/gpsdb/idx_trenzhangmot_09.dbf";
set newname for datafile 39 to
"/oradata/gpsdb/idx_trenzhangmot_10.dbf";
set newname for datafile 40 to
"/oradata/gpsdb/dbf_06_1.dbf";
set newname for datafile 41 to
"/oradata/gpsdb/dbf_06_2.dbf";
set newname for datafile 42 to
"/oradata/gpsdb/dbf_06_3.dbf";
set newname for datafile 43 to
"/oradata/gpsdb/dbf_07_1.dbf";
set newname for datafile 44 to
"/oradata/gpsdb/dbf_07_2.dbf";
set newname for datafile 45 to
"/oradata/gpsdb/dbf_07_3.dbf";
set newname for datafile 46 to
"/oradata/gpsdb/wzt_tbs_21.dbf";
set newname for datafile 47 to
"/oradata/gpsdb/wzt_tbs_22.dbf";
set newname for datafile 48 to
"/oradata/gpsdb/wzt_tbs_23.dbf";
set newname for datafile 49 to
"/oradata/gpsdb/wzt_tbs_24.dbf";
set newname for datafile 50 to
"/oradata/gpsdb/wzt_tbs_25.dbf";
set newname for datafile 51 to
"/oradata/gpsdb/dbf_08_1.dbf";
set newname for datafile 52 to
"/oradata/gpsdb/dbf_08_2.dbf";
set newname for datafile 53 to
"/oradata/gpsdb/dbf_08_3.dbf";
set newname for datafile 54 to
"/oradata/gpsdb_flasharea_dg/dbf_08_2.dbf";
set newname for datafile 55 to
"/oradata/gpsdb_flasharea_dg/wzt_tbs_26.dbf";
set newname for datafile 56 to
"/oradata/gpsdb/dbf_06_1b.dbf";
set newname for datafile 57 to
"/oradata/gpsdb/dbf_06_2b.dbf";
set newname for datafile 58 to
"/oradata/gpsdb/dbf_06_3b.dbf";
set newname for datafile 59 to
"/oradata/gpsdb/dbf_07_1b.dbf";
set newname for datafile 60 to
"/oradata/gpsdb/dbf_07_2b.dbf";
set newname for datafile 61 to
"/oradata/gpsdb/dbf_07_3b.dbf";
set newname for datafile 62 to
"/oradata/gpsdb/dbf_08_1b.dbf";
set newname for datafile 63 to
"/oradata/gpsdb/dbf_08_2b.dbf";
set newname for datafile 64 to
"/oradata/gpsdb/dbf_08_3b.dbf";
set newname for datafile 65 to
"/oradata/gpsdb/wzt_tbs_26.dbf";
set newname for datafile 66 to
"/oradata/gpsdb/undotbs03.dbf";
set newname for datafile 67 to
"/oradata/gpsdb/undotbs04.dbf";
set newname for datafile 68 to
"/oradata/gpsdb/undotbs05.dbf";
set newname for datafile 69 to
"/oradata/gpsdb/undotbs06.dbf";
set newname for datafile 70 to
"/oradata/gpsdb/undotbs07.dbf";
set newname for datafile 71 to
"/oradata/gpsdb/undotbs08.dbf";
set newname for datafile 72 to
"/oradata/gpsdb/dbf_09_1.dbf";
set newname for datafile 73 to
"/oradata/gpsdb/dbf_09_2.dbf";
set newname for datafile 74 to
"/oradata/gpsdb/dbf_09_3.dbf";
set newname for datafile 75 to
"/oradata/gpsdb/dbf_10_1.dbf";
set newname for datafile 76 to
"/oradata/gpsdb/dbf_10_2.dbf";
set newname for datafile 77 to
"/oradata/gpsdb/dbf_10_3.dbf";
set newname for datafile 78 to
"/oradata/gpsdb/dbf_11_1.dbf";
set newname for datafile 79 to
"/oradata/gpsdb/dbf_11_2.dbf";
set newname for datafile 80 to
"/oradata/gpsdb/dbf_11_3.dbf";
set newname for datafile 81 to
"/oradata/gpsdb/dbf_12_1.dbf";
set newname for datafile 82 to
"/oradata/gpsdb/dbf_12_2.dbf";
set newname for datafile 83 to
"/oradata/gpsdb/dbf_12_3.dbf";
set newname for datafile 84 to
"/oradata/gpsdb/dbf_09_1_01.dbf";
set newname for datafile 85 to
"/oradata/gpsdb/wzt_tbs_27.dbf";
set newname for datafile 86 to
"/oradata/gpsdb/wzt_tbs_28.dbf";
set newname for datafile 87 to
"/oradata/gpsdb/wzt_tbs_29.dbf";
set newname for datafile 88 to
"/oradata/gpsdb/wzt_tbs_30.dbf";
set newname for datafile 89 to
"/oradata/gpsdb/wzt_tbs_31.dbf";
set newname for datafile 90 to
"/oradata/gpsdb/wzt_tbs_32.dbf";
set newname for datafile 91 to
"/oradata/gpsdb/dbf_10_1_02.dbf";
set newname for datafile 92 to
"/oradata/gpsdb/dbf_10_2_02.dbf";
set newname for datafile 93 to
"/oradata/gpsdb/dbf_10_3_02.dbf";
set newname for datafile 94 to
"/oradata/gpsdb/dbf_09_3b.dbf";
set newname for datafile 95 to
"/oradata/gpsdb/dbf_10_3_03.dbf";
set newname for datafile 96 to
"/oradata/gpsdb/dbf_11_1_02.dbf";
set newname for datafile 97 to
"/oradata/gpsdb/dbf_11_2_02.dbf";
set newname for datafile 98 to
"/oradata/gpsdb/dbf_11_3_02.dbf";
set newname for datafile 99 to
"/oradata/gpsdb/dbf_08_3c.dbf";
set newname for datafile 100 to
"/oradata/gpsdb/dbf_09_2b.dbf";
set newname for datafile 101 to
"/oradata/gpsdb/dbf_10_2_03.dbf";
set newname for datafile 102 to
"/oradata/gpsdb/dbf_11_2_12.dbf";
set newname for datafile 103 to
"/oradata/gpsdb/dbf_10_2_12.dbf";
set newname for datafile 104 to
"/oradata/gpsdb/dbf_10_3_13.dbf";
set newname for datafile 105 to
"/oradata/gpsdb/dbf_11_3_03.dbf";
set newname for datafile 106 to
"/oradata/gpsdb/dbf_12_01.dbf";
set newname for datafile 107 to
"/oradata/gpsdb/dbf_12_02.dbf";
set newname for datafile 108 to
"/oradata/gpsdb/dbf_12_03.dbf";
set newname for datafile 109 to
"/oradata/gpsdb/dbf_12_11.dbf";
set newname for datafile 110 to
"/oradata/gpsdb/dbf_12_12.dbf";
set newname for datafile 111 to
"/oradata/gpsdb/dbf_01_1.dbf";
set newname for datafile 112 to
"/oradata/gpsdb/dbf_01_2.dbf";
set newname for datafile 113 to
"/oradata/gpsdb/dbf_01_3.dbf";
set newname for datafile 114 to
"/oradata/gpsdb/dbf_02_1.dbf";
set newname for datafile 115 to
"/oradata/gpsdb/dbf_02_2.dbf";
set newname for datafile 116 to
"/oradata/gpsdb/dbf_02_3.dbf";
set newname for datafile 117 to
"/oradata/gpsdb/dbf_12_3_13.dbf";
set newname for datafile 118 to
"/oradata/gpsdb/dbf_01_01.dbf";
set newname for datafile 119 to
"/oradata/gpsdb/dbf_01_02.dbf";
set newname for datafile 120 to
"/oradata/gpsdb/dbf_01_03.dbf";
set newname for datafile 121 to
"/oradata/gpsdb/dbf_02_01.dbf";
set newname for datafile 122 to
"/oradata/gpsdb/dbf_02_02.dbf";
set newname for datafile 123 to
"/oradata/gpsdb/wzt_tbs_33.dbf";
set newname for datafile 124 to
"/oradata/gpsdb/wzt_tbs_34.dbf";
set newname for datafile 125 to
"/oradata/gpsdb/wzt_tbs_35.dbf";
set newname for datafile 126 to
"/oradata/gpsdb/wzt_tbs_36.dbf";
set newname for datafile 127 to
"/oradata/gpsdb/wzt_tbs_37.dbf";
set newname for datafile 128 to
"/oradata/gpsdb/dbf_02_03.dbf";
set newname for datafile 129 to
"/oradata/gpsdb/dbf_01_11.dbf";
set newname for datafile 130 to
"/oradata/gpsdb/dbf_01_12.dbf";
set newname for datafile 131 to
"/oradata/gpsdb/dbf_01_13.dbf";
set newname for datafile 132 to
"/oradata/gpsdb/dbf_02_11.dbf";
set newname for datafile 133 to
"/oradata/gpsdb/dbf_02_12.dbf";
set newname for datafile 134 to
"/oradata/gpsdb/dbf_02_13.dbf";
set newname for datafile 135 to
"/oradata/gpsdb/dbf_01_21.dbf";
set newname for datafile 136 to
"/oradata/gpsdb/dbf_01_22.dbf";
set newname for datafile 137 to
"/oradata/gpsdb/dbf_01_31.dbf";
set newname for datafile 138 to
"/oradata/gpsdb/dbf_01_32.dbf";
set newname for datafile 139 to
"/oradata/gpsdb/dbf_02_21.dbf";
set newname for datafile 140 to
"/oradata/gpsdb/dbf_02_31.dbf";
set newname for datafile 141 to
"/oradata/gpsdb/dbf_02_22.dbf";
set newname for datafile 142 to
"/oradata/gpsdb/dbf_02_32.dbf";
set newname for datafile 143 to
"/oradata/gpsdb/dbf_03_1";
set newname for datafile 144 to
"/oradata/gpsdb/dbf_03_2";
set newname for datafile 145 to
"/oradata/gpsdb/dbf_03_3";
set newname for datafile 146 to
"/oradata/gpsdb/dbf_04_1";
set newname for datafile 147 to
"/oradata/gpsdb/dbf_04_2";
set newname for datafile 148 to
"/oradata/gpsdb/dbf_04_3";
set newname for datafile 149 to
"/oradata/gpsdb/dbf_05_1";
set newname for datafile 150 to
"/oradata/gpsdb/dbf_05_2";
set newname for datafile 151 to
"/oradata/gpsdb/dbf_05_3";
set newname for datafile 152 to
"/oradata/gpsdb/dbf__03_01.dbf";
set newname for datafile 153 to
"/oradata/gpsdb/dbf__03_11.dbf";
set newname for datafile 154 to
"/oradata/gpsdb/dbf_03_02.dbf";
set newname for datafile 155 to
"/oradata/gpsdb/dbf_03_12.dbf";
set newname for datafile 156 to
"/oradata/gpsdb/dbf_03_03.dbf";
set newname for datafile 157 to
"/oradata/gpsdb/dbf_03_13.dbf";
set newname for datafile 158 to
"/oradata/gpsdb/dbf_12_23.dbf";
set newname for datafile 159 to
"/oradata/gpsdb/wzt_tbs_38.dbf";
set newname for datafile 160 to
"/oradata/gpsdb/wzt_tbs_39.dbf";
set newname for datafile 161 to
"/oradata/gpsdb/dbf_04_01";
set newname for datafile 162 to
"/oradata/gpsdb/dbf_04_11";
set newname for datafile 163 to
"/oradata/gpsdb/dbf_04_02";
set newname for datafile 164 to
"/oradata/gpsdb/dbf_04_12";
set newname for datafile 165 to
"/oradata/gpsdb/dbf_04_03";
set newname for datafile 166 to
"/oradata/gpsdb/dbf_04_13";
set newname for datafile 167 to
"/oradata/gpsdb/wzt_tbs_40.dbf";
set newname for datafile 168 to
"/oradata/gpsdb/wzt_tbs_41.dbf";
set newname for datafile 169 to
"/oradata/gpsdb/dbf_04_21";
set newname for datafile 170 to
"/oradata/gpsdb/wzt_tbs_42.dbf";
set newname for datafile 171 to
"/oradata/gpsdb/wzt_tbs_43.dbf";
set newname for datafile 172 to
"/oradata/gpsdb/wzt_tbs_44.dbf";
set newname for datafile 173 to
"/oradata/gpsdb/wzt_tbs_45.dbf";
set newname for datafile 174 to
"/oradata/gpsdb/dbf_05_01";
set newname for datafile 175 to
"/oradata/gpsdb/dbf_05_11";
set newname for datafile 176 to
"/oradata/gpsdb/dbf_05_02";
set newname for datafile 177 to
"/oradata/gpsdb/dbf_05_12";
set newname for datafile 178 to
"/oradata/gpsdb/dbf_05_03";
set newname for datafile 179 to
"/oradata/gpsdb/dbf_05_13";
set newname for datafile 180 to
"/oradata/gpsdb/dbf_06_11.dbf";
set newname for datafile 181 to
"/oradata/gpsdb/dbf_06_21.dbf";
set newname for datafile 182 to
"/oradata/gpsdb/dbf_06_31.dbf";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed temporary file 1 to /oradata/gpsdb/temp01.dbf in control file
renamed temporary file 2 to /oradata/gpsdb/gps_temp_01.dbf in control file
renamed temporary file 3 to /oradata/gpsdb/gps_temp_02.dbf in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 30-MAY-14
channel aux1: starting datafile backupset restore
channel aux1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oradata/gpsdb/system01.dbf
restoring datafile 00002 to /oradata/gpsdb/undotbs01.dbf
restoring datafile 00003 to /oradata/gpsdb/sysaux01.dbf
restoring datafile 00004 to /oradata/gpsdb/users01.dbf
restoring datafile 00005 to /oradata/gpsdb/undotbs02.dbf
restoring datafile 00008 to /oradata/gpsdb/wzt_tbs_03.dbf
restoring datafile 00012 to /oradata/gpsdb/wzt_tbs_06.dbf
restoring datafile 00015 to /oradata/gpsdb/wzt_tbs_09.dbf
restoring datafile 00017 to /oradata/gpsdb/dbf_130501.dbf
restoring datafile 00019 to /oradata/gpsdb/dbf_130503.dbf
restoring datafile 00024 to /oradata/gpsdb/wzt_tbs_15.dbf
restoring datafile 00027 to /oradata/gpsdb/wzt_tbs_18.dbf
restoring datafile 00033 to /oradata/gpsdb/idx_trenzhangmot_04.dbf
restoring datafile 00036 to /oradata/gpsdb/idx_trenzhangmot_07.dbf
restoring datafile 00039 to /oradata/gpsdb/idx_trenzhangmot_10.dbf
restoring datafile 00040 to /oradata/gpsdb/dbf_06_1.dbf
restoring datafile 00041 to /oradata/gpsdb/dbf_06_2.dbf
restoring datafile 00042 to /oradata/gpsdb/dbf_06_3.dbf
restoring datafile 00044 to /oradata/gpsdb/dbf_07_2.dbf
restoring datafile 00049 to /oradata/gpsdb/wzt_tbs_24.dbf
restoring datafile 00051 to /oradata/gpsdb/dbf_08_1.dbf
restoring datafile 00065 to /oradata/gpsdb/wzt_tbs_26.dbf
restoring datafile 00066 to /oradata/gpsdb/undotbs03.dbf
restoring datafile 00067 to /oradata/gpsdb/undotbs04.dbf
restoring datafile 00069 to /oradata/gpsdb/undotbs06.dbf
restoring datafile 00074 to /oradata/gpsdb/dbf_09_3.dbf
restoring datafile 00075 to /oradata/gpsdb/dbf_10_1.dbf
restoring datafile 00078 to /oradata/gpsdb/dbf_11_1.dbf
restoring datafile 00079 to /oradata/gpsdb/dbf_11_2.dbf
restoring datafile 00084 to /oradata/gpsdb/dbf_09_1_01.dbf
restoring datafile 00087 to /oradata/gpsdb/wzt_tbs_29.dbf
restoring datafile 00090 to /oradata/gpsdb/wzt_tbs_32.dbf
restoring datafile 00091 to /oradata/gpsdb/dbf_10_1_02.dbf
restoring datafile 00100 to /oradata/gpsdb/dbf_09_2b.dbf
restoring datafile 00103 to /oradata/gpsdb/dbf_10_2_12.dbf
restoring datafile 00105 to /oradata/gpsdb/dbf_11_3_03.dbf
restoring datafile 00106 to /oradata/gpsdb/dbf_12_01.dbf
restoring datafile 00108 to /oradata/gpsdb/dbf_12_03.dbf
restoring datafile 00112 to /oradata/gpsdb/dbf_01_2.dbf
restoring datafile 00114 to /oradata/gpsdb/dbf_02_1.dbf
restoring datafile 00116 to /oradata/gpsdb/dbf_02_3.dbf
restoring datafile 00117 to /oradata/gpsdb/dbf_12_3_13.dbf
restoring datafile 00122 to /oradata/gpsdb/dbf_02_02.dbf
restoring datafile 00124 to /oradata/gpsdb/wzt_tbs_34.dbf
restoring datafile 00127 to /oradata/gpsdb/wzt_tbs_37.dbf
restoring datafile 00131 to /oradata/gpsdb/dbf_01_13.dbf
restoring datafile 00136 to /oradata/gpsdb/dbf_01_22.dbf
restoring datafile 00139 to /oradata/gpsdb/dbf_02_21.dbf
restoring datafile 00142 to /oradata/gpsdb/dbf_02_32.dbf
restoring datafile 00149 to /oradata/gpsdb/dbf_05_1
restoring datafile 00151 to /oradata/gpsdb/dbf_05_3
restoring datafile 00155 to /oradata/gpsdb/dbf_03_12.dbf
restoring datafile 00156 to /oradata/gpsdb/dbf_03_03.dbf
restoring datafile 00161 to /oradata/gpsdb/dbf_04_01
restoring datafile 00164 to /oradata/gpsdb/dbf_04_12
restoring datafile 00165 to /oradata/gpsdb/dbf_04_03
restoring datafile 00168 to /oradata/gpsdb/wzt_tbs_41.dbf
restoring datafile 00170 to /oradata/gpsdb/wzt_tbs_42.dbf
restoring datafile 00176 to /oradata/gpsdb/dbf_05_02
restoring datafile 00180 to /oradata/gpsdb/dbf_06_11.dbf
channel aux1: reading from backup piece /backup/gpsbak/dbbackup/GPSDB_631_848915219.data
channel aux2: starting datafile backupset restore
channel aux2: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /oradata/gpsdb/wzt_tbs_02.dbf
restoring datafile 00010 to /oradata/gpsdb/wzt_tbs_05.dbf
restoring datafile 00014 to /oradata/gpsdb/wzt_tbs_08.dbf
restoring datafile 00020 to /oradata/gpsdb/wzt_tbs_11.dbf
restoring datafile 00021 to /oradata/gpsdb/wzt_tbs_12.dbf
restoring datafile 00022 to /oradata/gpsdb/wzt_tbs_13.dbf
restoring datafile 00025 to /oradata/gpsdb/wzt_tbs_16.dbf
restoring datafile 00028 to /oradata/gpsdb/wzt_tbs_19.dbf
restoring datafile 00030 to /oradata/gpsdb/idx_trenzhangmot_01.dbf
restoring datafile 00035 to /oradata/gpsdb/idx_trenzhangmot_06.dbf
restoring datafile 00038 to /oradata/gpsdb/idx_trenzhangmot_09.dbf
restoring datafile 00046 to /oradata/gpsdb/wzt_tbs_21.dbf
restoring datafile 00047 to /oradata/gpsdb/wzt_tbs_22.dbf
restoring datafile 00048 to /oradata/gpsdb/wzt_tbs_23.dbf
restoring datafile 00050 to /oradata/gpsdb/wzt_tbs_25.dbf
restoring datafile 00053 to /oradata/gpsdb/dbf_08_3.dbf
restoring datafile 00057 to /oradata/gpsdb/dbf_06_2b.dbf
restoring datafile 00060 to /oradata/gpsdb/dbf_07_2b.dbf
restoring datafile 00062 to /oradata/gpsdb/dbf_08_1b.dbf
restoring datafile 00063 to /oradata/gpsdb/dbf_08_2b.dbf
restoring datafile 00064 to /oradata/gpsdb/dbf_08_3b.dbf
restoring datafile 00070 to /oradata/gpsdb/undotbs07.dbf
restoring datafile 00072 to /oradata/gpsdb/dbf_09_1.dbf
restoring datafile 00080 to /oradata/gpsdb/dbf_11_3.dbf
restoring datafile 00081 to /oradata/gpsdb/dbf_12_1.dbf
restoring datafile 00085 to /oradata/gpsdb/wzt_tbs_27.dbf
restoring datafile 00088 to /oradata/gpsdb/wzt_tbs_30.dbf
restoring datafile 00093 to /oradata/gpsdb/dbf_10_3_02.dbf
restoring datafile 00094 to /oradata/gpsdb/dbf_09_3b.dbf
restoring datafile 00095 to /oradata/gpsdb/dbf_10_3_03.dbf
restoring datafile 00097 to /oradata/gpsdb/dbf_11_2_02.dbf
restoring datafile 00098 to /oradata/gpsdb/dbf_11_3_02.dbf
restoring datafile 00101 to /oradata/gpsdb/dbf_10_2_03.dbf
restoring datafile 00109 to /oradata/gpsdb/dbf_12_11.dbf
restoring datafile 00115 to /oradata/gpsdb/dbf_02_2.dbf
restoring datafile 00118 to /oradata/gpsdb/dbf_01_01.dbf
restoring datafile 00120 to /oradata/gpsdb/dbf_01_03.dbf
restoring datafile 00121 to /oradata/gpsdb/dbf_02_01.dbf
restoring datafile 00123 to /oradata/gpsdb/wzt_tbs_33.dbf
restoring datafile 00126 to /oradata/gpsdb/wzt_tbs_36.dbf
restoring datafile 00133 to /oradata/gpsdb/dbf_02_12.dbf
restoring datafile 00134 to /oradata/gpsdb/dbf_02_13.dbf
restoring datafile 00137 to /oradata/gpsdb/dbf_01_31.dbf
restoring datafile 00138 to /oradata/gpsdb/dbf_01_32.dbf
restoring datafile 00140 to /oradata/gpsdb/dbf_02_31.dbf
restoring datafile 00143 to /oradata/gpsdb/dbf_03_1
restoring datafile 00144 to /oradata/gpsdb/dbf_03_2
restoring datafile 00146 to /oradata/gpsdb/dbf_04_1
restoring datafile 00148 to /oradata/gpsdb/dbf_04_3
restoring datafile 00150 to /oradata/gpsdb/dbf_05_2
restoring datafile 00152 to /oradata/gpsdb/dbf__03_01.dbf
restoring datafile 00157 to /oradata/gpsdb/dbf_03_13.dbf
restoring datafile 00158 to /oradata/gpsdb/dbf_12_23.dbf
restoring datafile 00159 to /oradata/gpsdb/wzt_tbs_38.dbf
restoring datafile 00172 to /oradata/gpsdb/wzt_tbs_44.dbf
restoring datafile 00174 to /oradata/gpsdb/dbf_05_01
restoring datafile 00175 to /oradata/gpsdb/dbf_05_11
restoring datafile 00178 to /oradata/gpsdb/dbf_05_03
restoring datafile 00179 to /oradata/gpsdb/dbf_05_13
restoring datafile 00182 to /oradata/gpsdb/dbf_06_31.dbf
channel aux2: reading from backup piece /backup/gpsbak/dbbackup/GPSDB_632_848915220.data
channel aux3: starting datafile backupset restore
channel aux3: specifying datafile(s) to restore from backup set
restoring datafile 00006 to /oradata/gpsdb/wzt_tbs_01.dbf
restoring datafile 00009 to /oradata/gpsdb/wzt_tbs_04.dbf
restoring datafile 00011 to /oradata/gpsdb/splex_tbs_01.dbf
restoring datafile 00013 to /oradata/gpsdb/wzt_tbs_07.dbf
restoring datafile 00016 to /oradata/gpsdb/wzt_tbs_10.dbf
restoring datafile 00018 to /oradata/gpsdb/dbf_130502.dbf
restoring datafile 00023 to /oradata/gpsdb/wzt_tbs_14.dbf
restoring datafile 00026 to /oradata/gpsdb/wzt_tbs_17.dbf
restoring datafile 00029 to /oradata/gpsdb/wzt_tbs_20.dbf
restoring datafile 00031 to /oradata/gpsdb/idx_trenzhangmot_02.dbf
restoring datafile 00032 to /oradata/gpsdb/idx_trenzhangmot_03.dbf
restoring datafile 00034 to /oradata/gpsdb/idx_trenzhangmot_05.dbf
restoring datafile 00037 to /oradata/gpsdb/idx_trenzhangmot_08.dbf
restoring datafile 00043 to /oradata/gpsdb/dbf_07_1.dbf
restoring datafile 00045 to /oradata/gpsdb/dbf_07_3.dbf
restoring datafile 00052 to /oradata/gpsdb/dbf_08_2.dbf
restoring datafile 00054 to /oradata/gpsdb_flasharea_dg/dbf_08_2.dbf
restoring datafile 00055 to /oradata/gpsdb_flasharea_dg/wzt_tbs_26.dbf
restoring datafile 00056 to /oradata/gpsdb/dbf_06_1b.dbf
restoring datafile 00058 to /oradata/gpsdb/dbf_06_3b.dbf
restoring datafile 00059 to /oradata/gpsdb/dbf_07_1b.dbf
restoring datafile 00061 to /oradata/gpsdb/dbf_07_3b.dbf
restoring datafile 00068 to /oradata/gpsdb/undotbs05.dbf
restoring datafile 00071 to /oradata/gpsdb/undotbs08.dbf
restoring datafile 00073 to /oradata/gpsdb/dbf_09_2.dbf
restoring datafile 00076 to /oradata/gpsdb/dbf_10_2.dbf
restoring datafile 00077 to /oradata/gpsdb/dbf_10_3.dbf
restoring datafile 00082 to /oradata/gpsdb/dbf_12_2.dbf
restoring datafile 00083 to /oradata/gpsdb/dbf_12_3.dbf
restoring datafile 00086 to /oradata/gpsdb/wzt_tbs_28.dbf
restoring datafile 00089 to /oradata/gpsdb/wzt_tbs_31.dbf
restoring datafile 00092 to /oradata/gpsdb/dbf_10_2_02.dbf
restoring datafile 00096 to /oradata/gpsdb/dbf_11_1_02.dbf
restoring datafile 00099 to /oradata/gpsdb/dbf_08_3c.dbf
restoring datafile 00102 to /oradata/gpsdb/dbf_11_2_12.dbf
restoring datafile 00104 to /oradata/gpsdb/dbf_10_3_13.dbf
restoring datafile 00107 to /oradata/gpsdb/dbf_12_02.dbf
restoring datafile 00110 to /oradata/gpsdb/dbf_12_12.dbf
restoring datafile 00111 to /oradata/gpsdb/dbf_01_1.dbf
restoring datafile 00113 to /oradata/gpsdb/dbf_01_3.dbf
restoring datafile 00119 to /oradata/gpsdb/dbf_01_02.dbf
restoring datafile 00125 to /oradata/gpsdb/wzt_tbs_35.dbf
restoring datafile 00128 to /oradata/gpsdb/dbf_02_03.dbf
restoring datafile 00129 to /oradata/gpsdb/dbf_01_11.dbf
restoring datafile 00130 to /oradata/gpsdb/dbf_01_12.dbf
restoring datafile 00132 to /oradata/gpsdb/dbf_02_11.dbf
restoring datafile 00135 to /oradata/gpsdb/dbf_01_21.dbf
restoring datafile 00141 to /oradata/gpsdb/dbf_02_22.dbf
restoring datafile 00145 to /oradata/gpsdb/dbf_03_3
restoring datafile 00147 to /oradata/gpsdb/dbf_04_2
restoring datafile 00153 to /oradata/gpsdb/dbf__03_11.dbf
restoring datafile 00154 to /oradata/gpsdb/dbf_03_02.dbf
restoring datafile 00160 to /oradata/gpsdb/wzt_tbs_39.dbf
restoring datafile 00162 to /oradata/gpsdb/dbf_04_11
restoring datafile 00163 to /oradata/gpsdb/dbf_04_02
restoring datafile 00166 to /oradata/gpsdb/dbf_04_13
restoring datafile 00167 to /oradata/gpsdb/wzt_tbs_40.dbf
restoring datafile 00169 to /oradata/gpsdb/dbf_04_21
restoring datafile 00171 to /oradata/gpsdb/wzt_tbs_43.dbf
restoring datafile 00173 to /oradata/gpsdb/wzt_tbs_45.dbf
restoring datafile 00177 to /oradata/gpsdb/dbf_05_12
restoring datafile 00181 to /oradata/gpsdb/dbf_06_21.dbf
channel aux3: reading from backup piece /backup/gpsbak/dbbackup/GPSDB_633_848936320.data
channel aux1: restored backup piece 1
piece handle=/backup/gpsbak/dbbackup/GPSDB_631_848915219.data tag=TAG20140530T094658
channel aux1: restore complete, elapsed time: 05:20:29
channel aux3: restored backup piece 1
piece handle=/backup/gpsbak/dbbackup/GPSDB_633_848936320.data tag=TAG20140530T094658
channel aux3: restore complete, elapsed time: 05:30:34
channel aux2: restored backup piece 1
piece handle=/backup/gpsbak/dbbackup/GPSDB_632_848915220.data tag=TAG20140530T094658
channel aux2: restore complete, elapsed time: 06:47:60
Finished restore at 31-MAY-14
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy recid=184 stamp=848985474 filename=/oradata/gpsdb/system01.dbf
datafile 2 switched to datafile copy
input datafile copy recid=185 stamp=848985474 filename=/oradata/gpsdb/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=186 stamp=848985474 filename=/oradata/gpsdb/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=187 stamp=848985474 filename=/oradata/gpsdb/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=188 stamp=848985474 filename=/oradata/gpsdb/undotbs02.dbf
datafile 6 switched to datafile copy
input datafile copy recid=189 stamp=848985474 filename=/oradata/gpsdb/wzt_tbs_01.dbf
datafile 7 switched to datafile copy
input datafile copy recid=190 stamp=848985474 filename=/oradata/gpsdb/wzt_tbs_02.dbf
datafile 8 switched to datafile copy
input datafile copy recid=191 stamp=848985474 filename=/oradata/gpsdb/wzt_tbs_03.dbf
datafile 9 switched to datafile copy
input datafile copy recid=192 stamp=848985474 filename=/oradata/gpsdb/wzt_tbs_04.dbf
datafile 10 switched to datafile copy
input datafile copy recid=193 stamp=848985474 filename=/oradata/gpsdb/wzt_tbs_05.dbf
datafile 11 switched to datafile copy
input datafile copy recid=194 stamp=848985475 filename=/oradata/gpsdb/splex_tbs_01.dbf
datafile 12 switched to datafile copy
input datafile copy recid=195 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_06.dbf
datafile 13 switched to datafile copy
input datafile copy recid=196 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_07.dbf
datafile 14 switched to datafile copy
input datafile copy recid=197 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_08.dbf
datafile 15 switched to datafile copy
input datafile copy recid=198 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_09.dbf
datafile 16 switched to datafile copy
input datafile copy recid=199 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_10.dbf
datafile 17 switched to datafile copy
input datafile copy recid=200 stamp=848985475 filename=/oradata/gpsdb/dbf_130501.dbf
datafile 18 switched to datafile copy
input datafile copy recid=201 stamp=848985475 filename=/oradata/gpsdb/dbf_130502.dbf
datafile 19 switched to datafile copy
input datafile copy recid=202 stamp=848985475 filename=/oradata/gpsdb/dbf_130503.dbf
datafile 20 switched to datafile copy
input datafile copy recid=203 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_11.dbf
datafile 21 switched to datafile copy
input datafile copy recid=204 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_12.dbf
datafile 22 switched to datafile copy
input datafile copy recid=205 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_13.dbf
datafile 23 switched to datafile copy
input datafile copy recid=206 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_14.dbf
datafile 24 switched to datafile copy
input datafile copy recid=207 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_15.dbf
datafile 25 switched to datafile copy
input datafile copy recid=208 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_16.dbf
datafile 26 switched to datafile copy
input datafile copy recid=209 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_17.dbf
datafile 27 switched to datafile copy
input datafile copy recid=210 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_18.dbf
datafile 28 switched to datafile copy
input datafile copy recid=211 stamp=848985475 filename=/oradata/gpsdb/wzt_tbs_19.dbf
datafile 29 switched to datafile copy
input datafile copy recid=212 stamp=848985476 filename=/oradata/gpsdb/wzt_tbs_20.dbf
datafile 30 switched to datafile copy
input datafile copy recid=213 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_01.dbf
datafile 31 switched to datafile copy
input datafile copy recid=214 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_02.dbf
datafile 32 switched to datafile copy
input datafile copy recid=215 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_03.dbf
datafile 33 switched to datafile copy
input datafile copy recid=216 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_04.dbf
datafile 34 switched to datafile copy
input datafile copy recid=217 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_05.dbf
datafile 35 switched to datafile copy
input datafile copy recid=218 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_06.dbf
datafile 36 switched to datafile copy
input datafile copy recid=219 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_07.dbf
datafile 37 switched to datafile copy
input datafile copy recid=220 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_08.dbf
datafile 38 switched to datafile copy
input datafile copy recid=221 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_09.dbf
datafile 39 switched to datafile copy
input datafile copy recid=222 stamp=848985476 filename=/oradata/gpsdb/idx_trenzhangmot_10.dbf
datafile 40 switched to datafile copy
input datafile copy recid=223 stamp=848985476 filename=/oradata/gpsdb/dbf_06_1.dbf
datafile 41 switched to datafile copy
input datafile copy recid=224 stamp=848985476 filename=/oradata/gpsdb/dbf_06_2.dbf
datafile 42 switched to datafile copy
input datafile copy recid=225 stamp=848985476 filename=/oradata/gpsdb/dbf_06_3.dbf
datafile 43 switched to datafile copy
input datafile copy recid=226 stamp=848985476 filename=/oradata/gpsdb/dbf_07_1.dbf
datafile 44 switched to datafile copy
input datafile copy recid=227 stamp=848985476 filename=/oradata/gpsdb/dbf_07_2.dbf
datafile 45 switched to datafile copy
input datafile copy recid=228 stamp=848985476 filename=/oradata/gpsdb/dbf_07_3.dbf
datafile 46 switched to datafile copy
input datafile copy recid=229 stamp=848985476 filename=/oradata/gpsdb/wzt_tbs_21.dbf
datafile 47 switched to datafile copy
input datafile copy recid=230 stamp=848985477 filename=/oradata/gpsdb/wzt_tbs_22.dbf
datafile 48 switched to datafile copy
input datafile copy recid=231 stamp=848985477 filename=/oradata/gpsdb/wzt_tbs_23.dbf
datafile 49 switched to datafile copy
input datafile copy recid=232 stamp=848985477 filename=/oradata/gpsdb/wzt_tbs_24.dbf
datafile 50 switched to datafile copy
input datafile copy recid=233 stamp=848985477 filename=/oradata/gpsdb/wzt_tbs_25.dbf
datafile 51 switched to datafile copy
input datafile copy recid=234 stamp=848985477 filename=/oradata/gpsdb/dbf_08_1.dbf
datafile 52 switched to datafile copy
input datafile copy recid=235 stamp=848985477 filename=/oradata/gpsdb/dbf_08_2.dbf
datafile 53 switched to datafile copy
input datafile copy recid=236 stamp=848985477 filename=/oradata/gpsdb/dbf_08_3.dbf
datafile 54 switched to datafile copy
input datafile copy recid=237 stamp=848985477 filename=/oradata/gpsdb_flasharea_dg/dbf_08_2.dbf
datafile 55 switched to datafile copy
input datafile copy recid=238 stamp=848985477 filename=/oradata/gpsdb_flasharea_dg/wzt_tbs_26.db
f
datafile 56 switched to datafile copy
input datafile copy recid=239 stamp=848985477 filename=/oradata/gpsdb/dbf_06_1b.dbf
datafile 57 switched to datafile copy
input datafile copy recid=240 stamp=848985477 filename=/oradata/gpsdb/dbf_06_2b.dbf
datafile 58 switched to datafile copy
input datafile copy recid=241 stamp=848985477 filename=/oradata/gpsdb/dbf_06_3b.dbf
datafile 59 switched to datafile copy
input datafile copy recid=242 stamp=848985477 filename=/oradata/gpsdb/dbf_07_1b.dbf
datafile 60 switched to datafile copy
input datafile copy recid=243 stamp=848985477 filename=/oradata/gpsdb/dbf_07_2b.dbf
datafile 61 switched to datafile copy
input datafile copy recid=244 stamp=848985477 filename=/oradata/gpsdb/dbf_07_3b.dbf
datafile 62 switched to datafile copy
input datafile copy recid=245 stamp=848985477 filename=/oradata/gpsdb/dbf_08_1b.dbf
datafile 63 switched to datafile copy
input datafile copy recid=246 stamp=848985477 filename=/oradata/gpsdb/dbf_08_2b.dbf
datafile 64 switched to datafile copy
input datafile copy recid=247 stamp=848985477 filename=/oradata/gpsdb/dbf_08_3b.dbf
datafile 65 switched to datafile copy
input datafile copy recid=248 stamp=848985477 filename=/oradata/gpsdb/wzt_tbs_26.dbf
datafile 66 switched to datafile copy
input datafile copy recid=249 stamp=848985477 filename=/oradata/gpsdb/undotbs03.dbf
datafile 67 switched to datafile copy
input datafile copy recid=250 stamp=848985478 filename=/oradata/gpsdb/undotbs04.dbf
datafile 68 switched to datafile copy
input datafile copy recid=251 stamp=848985478 filename=/oradata/gpsdb/undotbs05.dbf
datafile 69 switched to datafile copy
input datafile copy recid=252 stamp=848985478 filename=/oradata/gpsdb/undotbs06.dbf
datafile 70 switched to datafile copy
input datafile copy recid=253 stamp=848985478 filename=/oradata/gpsdb/undotbs07.dbf
datafile 71 switched to datafile copy
input datafile copy recid=254 stamp=848985478 filename=/oradata/gpsdb/undotbs08.dbf
datafile 72 switched to datafile copy
input datafile copy recid=255 stamp=848985478 filename=/oradata/gpsdb/dbf_09_1.dbf
datafile 73 switched to datafile copy
input datafile copy recid=256 stamp=848985478 filename=/oradata/gpsdb/dbf_09_2.dbf
datafile 74 switched to datafile copy
input datafile copy recid=257 stamp=848985478 filename=/oradata/gpsdb/dbf_09_3.dbf
datafile 75 switched to datafile copy
input datafile copy recid=258 stamp=848985478 filename=/oradata/gpsdb/dbf_10_1.dbf
datafile 76 switched to datafile copy
input datafile copy recid=259 stamp=848985478 filename=/oradata/gpsdb/dbf_10_2.dbf
datafile 77 switched to datafile copy
input datafile copy recid=260 stamp=848985478 filename=/oradata/gpsdb/dbf_10_3.dbf
datafile 78 switched to datafile copy
input datafile copy recid=261 stamp=848985478 filename=/oradata/gpsdb/dbf_11_1.dbf
datafile 79 switched to datafile copy
input datafile copy recid=262 stamp=848985478 filename=/oradata/gpsdb/dbf_11_2.dbf
datafile 80 switched to datafile copy
input datafile copy recid=263 stamp=848985478 filename=/oradata/gpsdb/dbf_11_3.dbf
datafile 81 switched to datafile copy
input datafile copy recid=264 stamp=848985478 filename=/oradata/gpsdb/dbf_12_1.dbf
datafile 82 switched to datafile copy
input datafile copy recid=265 stamp=848985478 filename=/oradata/gpsdb/dbf_12_2.dbf
datafile 83 switched to datafile copy
input datafile copy recid=266 stamp=848985478 filename=/oradata/gpsdb/dbf_12_3.dbf
datafile 84 switched to datafile copy
input datafile copy recid=267 stamp=848985478 filename=/oradata/gpsdb/dbf_09_1_01.dbf
datafile 85 switched to datafile copy
input datafile copy recid=268 stamp=848985478 filename=/oradata/gpsdb/wzt_tbs_27.dbf
datafile 86 switched to datafile copy
input datafile copy recid=269 stamp=848985478 filename=/oradata/gpsdb/wzt_tbs_28.dbf
datafile 87 switched to datafile copy
input datafile copy recid=270 stamp=848985479 filename=/oradata/gpsdb/wzt_tbs_29.dbf
datafile 88 switched to datafile copy
input datafile copy recid=271 stamp=848985479 filename=/oradata/gpsdb/wzt_tbs_30.dbf
datafile 89 switched to datafile copy
input datafile copy recid=272 stamp=848985479 filename=/oradata/gpsdb/wzt_tbs_31.dbf
datafile 90 switched to datafile copy
input datafile copy recid=273 stamp=848985479 filename=/oradata/gpsdb/wzt_tbs_32.dbf
datafile 91 switched to datafile copy
input datafile copy recid=274 stamp=848985479 filename=/oradata/gpsdb/dbf_10_1_02.dbf
datafile 92 switched to datafile copy
input datafile copy recid=275 stamp=848985479 filename=/oradata/gpsdb/dbf_10_2_02.dbf
datafile 93 switched to datafile copy
input datafile copy recid=276 stamp=848985479 filename=/oradata/gpsdb/dbf_10_3_02.dbf
datafile 94 switched to datafile copy
input datafile copy recid=277 stamp=848985479 filename=/oradata/gpsdb/dbf_09_3b.dbf
datafile 95 switched to datafile copy
input datafile copy recid=278 stamp=848985479 filename=/oradata/gpsdb/dbf_10_3_03.dbf
datafile 96 switched to datafile copy
input datafile copy recid=279 stamp=848985479 filename=/oradata/gpsdb/dbf_11_1_02.dbf
datafile 97 switched to datafile copy
input datafile copy recid=280 stamp=848985479 filename=/oradata/gpsdb/dbf_11_2_02.dbf
datafile 98 switched to datafile copy
input datafile copy recid=281 stamp=848985479 filename=/oradata/gpsdb/dbf_11_3_02.dbf
datafile 99 switched to datafile copy
input datafile copy recid=282 stamp=848985479 filename=/oradata/gpsdb/dbf_08_3c.dbf
datafile 100 switched to datafile copy
input datafile copy recid=283 stamp=848985479 filename=/oradata/gpsdb/dbf_09_2b.dbf
datafile 101 switched to datafile copy
input datafile copy recid=284 stamp=848985479 filename=/oradata/gpsdb/dbf_10_2_03.dbf
datafile 102 switched to datafile copy
input datafile copy recid=285 stamp=848985479 filename=/oradata/gpsdb/dbf_11_2_12.dbf
datafile 103 switched to datafile copy
input datafile copy recid=286 stamp=848985479 filename=/oradata/gpsdb/dbf_10_2_12.dbf
datafile 104 switched to datafile copy
input datafile copy recid=287 stamp=848985479 filename=/oradata/gpsdb/dbf_10_3_13.dbf
datafile 105 switched to datafile copy
input datafile copy recid=288 stamp=848985480 filename=/oradata/gpsdb/dbf_11_3_03.dbf
datafile 106 switched to datafile copy
input datafile copy recid=289 stamp=848985480 filename=/oradata/gpsdb/dbf_12_01.dbf
datafile 107 switched to datafile copy
input datafile copy recid=290 stamp=848985480 filename=/oradata/gpsdb/dbf_12_02.dbf
datafile 108 switched to datafile copy
input datafile copy recid=291 stamp=848985480 filename=/oradata/gpsdb/dbf_12_03.dbf
datafile 109 switched to datafile copy
input datafile copy recid=292 stamp=848985480 filename=/oradata/gpsdb/dbf_12_11.dbf
datafile 110 switched to datafile copy
input datafile copy recid=293 stamp=848985480 filename=/oradata/gpsdb/dbf_12_12.dbf
datafile 111 switched to datafile copy
input datafile copy recid=294 stamp=848985480 filename=/oradata/gpsdb/dbf_01_1.dbf
datafile 112 switched to datafile copy
input datafile copy recid=295 stamp=848985480 filename=/oradata/gpsdb/dbf_01_2.dbf
datafile 113 switched to datafile copy
input datafile copy recid=296 stamp=848985480 filename=/oradata/gpsdb/dbf_01_3.dbf
datafile 114 switched to datafile copy
input datafile copy recid=297 stamp=848985480 filename=/oradata/gpsdb/dbf_02_1.dbf
datafile 115 switched to datafile copy
input datafile copy recid=298 stamp=848985480 filename=/oradata/gpsdb/dbf_02_2.dbf
datafile 116 switched to datafile copy
input datafile copy recid=299 stamp=848985480 filename=/oradata/gpsdb/dbf_02_3.dbf
datafile 117 switched to datafile copy
input datafile copy recid=300 stamp=848985480 filename=/oradata/gpsdb/dbf_12_3_13.dbf
datafile 118 switched to datafile copy
input datafile copy recid=301 stamp=848985480 filename=/oradata/gpsdb/dbf_01_01.dbf
datafile 119 switched to datafile copy
input datafile copy recid=302 stamp=848985480 filename=/oradata/gpsdb/dbf_01_02.dbf
datafile 120 switched to datafile copy
input datafile copy recid=303 stamp=848985480 filename=/oradata/gpsdb/dbf_01_03.dbf
datafile 121 switched to datafile copy
input datafile copy recid=304 stamp=848985480 filename=/oradata/gpsdb/dbf_02_01.dbf
datafile 122 switched to datafile copy
input datafile copy recid=305 stamp=848985480 filename=/oradata/gpsdb/dbf_02_02.dbf
datafile 123 switched to datafile copy
input datafile copy recid=306 stamp=848985481 filename=/oradata/gpsdb/wzt_tbs_33.dbf
datafile 124 switched to datafile copy
input datafile copy recid=307 stamp=848985481 filename=/oradata/gpsdb/wzt_tbs_34.dbf
datafile 125 switched to datafile copy
input datafile copy recid=308 stamp=848985481 filename=/oradata/gpsdb/wzt_tbs_35.dbf
datafile 126 switched to datafile copy
input datafile copy recid=309 stamp=848985481 filename=/oradata/gpsdb/wzt_tbs_36.dbf
datafile 127 switched to datafile copy
input datafile copy recid=310 stamp=848985481 filename=/oradata/gpsdb/wzt_tbs_37.dbf
datafile 128 switched to datafile copy
input datafile copy recid=311 stamp=848985481 filename=/oradata/gpsdb/dbf_02_03.dbf
datafile 129 switched to datafile copy
input datafile copy recid=312 stamp=848985481 filename=/oradata/gpsdb/dbf_01_11.dbf
datafile 130 switched to datafile copy
input datafile copy recid=313 stamp=848985481 filename=/oradata/gpsdb/dbf_01_12.dbf
datafile 131 switched to datafile copy
input datafile copy recid=314 stamp=848985481 filename=/oradata/gpsdb/dbf_01_13.dbf
datafile 132 switched to datafile copy
input datafile copy recid=315 stamp=848985481 filename=/oradata/gpsdb/dbf_02_11.dbf
datafile 133 switched to datafile copy
input datafile copy recid=316 stamp=848985481 filename=/oradata/gpsdb/dbf_02_12.dbf
datafile 134 switched to datafile copy
input datafile copy recid=317 stamp=848985481 filename=/oradata/gpsdb/dbf_02_13.dbf
datafile 135 switched to datafile copy
input datafile copy recid=318 stamp=848985481 filename=/oradata/gpsdb/dbf_01_21.dbf
datafile 136 switched to datafile copy
input datafile copy recid=319 stamp=848985481 filename=/oradata/gpsdb/dbf_01_22.dbf
datafile 137 switched to datafile copy
input datafile copy recid=320 stamp=848985481 filename=/oradata/gpsdb/dbf_01_31.dbf
datafile 138 switched to datafile copy
input datafile copy recid=321 stamp=848985481 filename=/oradata/gpsdb/dbf_01_32.dbf
datafile 139 switched to datafile copy
input datafile copy recid=322 stamp=848985481 filename=/oradata/gpsdb/dbf_02_21.dbf
datafile 140 switched to datafile copy
input datafile copy recid=323 stamp=848985481 filename=/oradata/gpsdb/dbf_02_31.dbf
datafile 141 switched to datafile copy
input datafile copy recid=324 stamp=848985481 filename=/oradata/gpsdb/dbf_02_22.dbf
datafile 142 switched to datafile copy
input datafile copy recid=325 stamp=848985481 filename=/oradata/gpsdb/dbf_02_32.dbf
datafile 143 switched to datafile copy
input datafile copy recid=326 stamp=848985481 filename=/oradata/gpsdb/dbf_03_1
datafile 144 switched to datafile copy
input datafile copy recid=327 stamp=848985481 filename=/oradata/gpsdb/dbf_03_2
datafile 145 switched to datafile copy
input datafile copy recid=328 stamp=848985482 filename=/oradata/gpsdb/dbf_03_3
datafile 146 switched to datafile copy
input datafile copy recid=329 stamp=848985482 filename=/oradata/gpsdb/dbf_04_1
datafile 147 switched to datafile copy
input datafile copy recid=330 stamp=848985482 filename=/oradata/gpsdb/dbf_04_2
datafile 148 switched to datafile copy
input datafile copy recid=331 stamp=848985482 filename=/oradata/gpsdb/dbf_04_3
datafile 149 switched to datafile copy
input datafile copy recid=332 stamp=848985482 filename=/oradata/gpsdb/dbf_05_1
datafile 150 switched to datafile copy
input datafile copy recid=333 stamp=848985482 filename=/oradata/gpsdb/dbf_05_2
datafile 151 switched to datafile copy
input datafile copy recid=334 stamp=848985482 filename=/oradata/gpsdb/dbf_05_3
datafile 152 switched to datafile copy
input datafile copy recid=335 stamp=848985482 filename=/oradata/gpsdb/dbf__03_01.dbf
datafile 153 switched to datafile copy
input datafile copy recid=336 stamp=848985482 filename=/oradata/gpsdb/dbf__03_11.dbf
datafile 154 switched to datafile copy
input datafile copy recid=337 stamp=848985482 filename=/oradata/gpsdb/dbf_03_02.dbf
datafile 155 switched to datafile copy
input datafile copy recid=338 stamp=848985482 filename=/oradata/gpsdb/dbf_03_12.dbf
datafile 156 switched to datafile copy
input datafile copy recid=339 stamp=848985482 filename=/oradata/gpsdb/dbf_03_03.dbf
datafile 157 switched to datafile copy
input datafile copy recid=340 stamp=848985482 filename=/oradata/gpsdb/dbf_03_13.dbf
datafile 158 switched to datafile copy
input datafile copy recid=341 stamp=848985482 filename=/oradata/gpsdb/dbf_12_23.dbf
datafile 159 switched to datafile copy
input datafile copy recid=342 stamp=848985482 filename=/oradata/gpsdb/wzt_tbs_38.dbf
datafile 160 switched to datafile copy
input datafile copy recid=343 stamp=848985482 filename=/oradata/gpsdb/wzt_tbs_39.dbf
datafile 161 switched to datafile copy
input datafile copy recid=344 stamp=848985482 filename=/oradata/gpsdb/dbf_04_01
datafile 162 switched to datafile copy
input datafile copy recid=345 stamp=848985482 filename=/oradata/gpsdb/dbf_04_11
datafile 163 switched to datafile copy
input datafile copy recid=346 stamp=848985482 filename=/oradata/gpsdb/dbf_04_02
datafile 164 switched to datafile copy
input datafile copy recid=347 stamp=848985482 filename=/oradata/gpsdb/dbf_04_12
datafile 165 switched to datafile copy
input datafile copy recid=348 stamp=848985482 filename=/oradata/gpsdb/dbf_04_03
datafile 166 switched to datafile copy
input datafile copy recid=349 stamp=848985482 filename=/oradata/gpsdb/dbf_04_13
datafile 167 switched to datafile copy
input datafile copy recid=350 stamp=848985482 filename=/oradata/gpsdb/wzt_tbs_40.dbf
datafile 168 switched to datafile copy
input datafile copy recid=351 stamp=848985483 filename=/oradata/gpsdb/wzt_tbs_41.dbf
datafile 169 switched to datafile copy
input datafile copy recid=352 stamp=848985483 filename=/oradata/gpsdb/dbf_04_21
datafile 170 switched to datafile copy
input datafile copy recid=353 stamp=848985483 filename=/oradata/gpsdb/wzt_tbs_42.dbf
datafile 171 switched to datafile copy
input datafile copy recid=354 stamp=848985483 filename=/oradata/gpsdb/wzt_tbs_43.dbf
datafile 172 switched to datafile copy
input datafile copy recid=355 stamp=848985483 filename=/oradata/gpsdb/wzt_tbs_44.dbf
datafile 173 switched to datafile copy
input datafile copy recid=356 stamp=848985483 filename=/oradata/gpsdb/wzt_tbs_45.dbf
datafile 174 switched to datafile copy
input datafile copy recid=357 stamp=848985483 filename=/oradata/gpsdb/dbf_05_01
datafile 175 switched to datafile copy
input datafile copy recid=358 stamp=848985483 filename=/oradata/gpsdb/dbf_05_11
datafile 176 switched to datafile copy
input datafile copy recid=359 stamp=848985483 filename=/oradata/gpsdb/dbf_05_02
datafile 177 switched to datafile copy
input datafile copy recid=360 stamp=848985483 filename=/oradata/gpsdb/dbf_05_12
datafile 178 switched to datafile copy
input datafile copy recid=361 stamp=848985483 filename=/oradata/gpsdb/dbf_05_03
datafile 179 switched to datafile copy
input datafile copy recid=362 stamp=848985483 filename=/oradata/gpsdb/dbf_05_13
datafile 180 switched to datafile copy
input datafile copy recid=363 stamp=848985483 filename=/oradata/gpsdb/dbf_06_11.dbf
datafile 181 switched to datafile copy
input datafile copy recid=364 stamp=848985483 filename=/oradata/gpsdb/dbf_06_21.dbf
datafile 182 switched to datafile copy
input datafile copy recid=365 stamp=848985483 filename=/oradata/gpsdb/dbf_06_31.dbf
Finished Duplicate Db at 31-MAY-14
released channel: aux1
released channel: aux2
released channel: aux3
RMAN>
Recovery Manager complete.
Sat May 31 05:18:08 CST 2014
六、应用日志
注意：primary库在rman里去镜像相关归档日志；standby库startup mount下做日志的注册应用；
1)、根据sequence从primary库镜像归档日志文件到指定位置
backup as copy format='/backup/gpsbak/dbbackup/39765.log' archivelog sequence 39765 thread 2;
2)、在standby库注册日志
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39765.log';
3)、在standby库apply日志
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
4)、如果所有日志都被apply了完了，就取消日志的apply
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
5)、截取最后一批日志apply时的alert里的记录信息
Tue Jun 03 19:51:06 CST 2014
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
Tue Jun 03 19:52:24 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78800.log
Tue Jun 03 19:53:39 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78801.log
Tue Jun 03 19:54:54 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78802.log
Media Recovery Log /backup/gpsbak/dbbackup/39798.log
Tue Jun 03 19:56:08 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78803.log
Tue Jun 03 19:57:27 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78804.log
Tue Jun 03 19:58:45 CST 2014
Media Recovery Waiting for thread 1 sequence 78805
Tue Jun 03 20:03:11 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78805.log'
Tue Jun 03 20:03:11 CST 2014
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78804 to 78805
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78805.log'
Tue Jun 03 20:03:12 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78806.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78805 to 78806
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78806.log'
Tue Jun 03 20:03:16 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78805.log
Media Recovery Waiting for thread 2 sequence 39799
Tue Jun 03 20:03:20 CST 2014
db_recovery_file_dest_size of 1099246 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Jun 03 20:04:35 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39799.log'
Tue Jun 03 20:04:35 CST 2014
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39798 to 39799
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39799.log'
Tue Jun 03 20:04:37 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/39799.log
Tue Jun 03 20:05:55 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78806.log
Tue Jun 03 20:07:10 CST 2014
Media Recovery Waiting for thread 1 sequence 78807
Tue Jun 03 20:09:07 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78807.log'
Tue Jun 03 20:09:07 CST 2014
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78806 to 78807
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78807.log'
Tue Jun 03 20:09:10 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78807.log
Tue Jun 03 20:10:30 CST 2014
Media Recovery Waiting for thread 1 sequence 78808
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78808.log'
Tue Jun 03 20:30:37 CST 2014
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78807 to 78808
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78808.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78809.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78808 to 78809
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78809.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78810.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78809 to 78810
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78810.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78811.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78810 to 78811
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78811.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78812.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78811 to 78812
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78812.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78813.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78812 to 78813
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78813.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78814.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78813 to 78814
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78814.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78815.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78814 to 78815
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78815.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78816.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78815 to 78816
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78816.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78817.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78816 to 78817
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78817.log'
Tue Jun 03 20:30:37 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78818.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 1 from sequence 78817 to 78818
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/78818.log'
Tue Jun 03 20:30:40 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/78808.log
Media Recovery Waiting for thread 2 sequence 39800
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39800.log'
Tue Jun 03 20:31:02 CST 2014
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39799 to 39800
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39800.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39801.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39800 to 39801
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39801.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39802.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39801 to 39802
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39802.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39803.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39802 to 39803
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39803.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39804.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39803 to 39804
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39804.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39805.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39804 to 39805
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39805.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39806.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39805 to 39806
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39806.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39807.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39806 to 39807
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39807.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39808.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39807 to 39808
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39808.log'
Tue Jun 03 20:31:02 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39809.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39808 to 39809
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39809.log'
Tue Jun 03 20:31:04 CST 2014
ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39810.log'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Resynchronizing thread 2 from sequence 39809 to 39810
Completed: ALTER DATABASE REGISTER LOGFILE '/backup/gpsbak/dbbackup/39810.log'
Tue Jun 03 20:31:07 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/39800.log
Tue Jun 03 20:32:25 CST 2014
Media Recovery Log /backup/gpsbak/dbbackup/39801.log==>利用归档日志做介质恢复，因为归档没有信息很快，
Media Recovery Log /backup/gpsbak/dbbackup/39802.log
Media Recovery Log /backup/gpsbak/dbbackup/78809.log
Media Recovery Log /backup/gpsbak/dbbackup/39803.log
Media Recovery Log /backup/gpsbak/dbbackup/39804.log
Media Recovery Log /backup/gpsbak/dbbackup/39805.log
Media Recovery Log /backup/gpsbak/dbbackup/39806.log
Media Recovery Log /backup/gpsbak/dbbackup/78810.log
Media Recovery Log /backup/gpsbak/dbbackup/39807.log
Media Recovery Log /backup/gpsbak/dbbackup/39808.log
Media Recovery Log /backup/gpsbak/dbbackup/78811.log
Media Recovery Log /backup/gpsbak/dbbackup/78812.log
Media Recovery Log /backup/gpsbak/dbbackup/78813.log
Media Recovery Log /backup/gpsbak/dbbackup/39809.log
Media Recovery Log /backup/gpsbak/dbbackup/78814.log
Media Recovery Log /backup/gpsbak/dbbackup/78815.log
Media Recovery Log /backup/gpsbak/dbbackup/78816.log
Media Recovery Log /backup/gpsbak/dbbackup/39810.log
Media Recovery Log /backup/gpsbak/dbbackup/78817.log
Media Recovery Log /backup/gpsbak/dbbackup/78818.log
Media Recovery Waiting for thread 2 sequence 39811
Tue Jun 03 20:32:52 CST 2014
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Tue Jun 03 20:32:53 CST 2014
MRP0: Background Media Recovery cancelled with status 16037
Tue Jun 03 20:32:53 CST 2014
Errors in file /u01/app/oracle/admin/gpsdb/bdump/gpsdb_mrp0_10917.trc:
ORA-16037: user requested cancel of managed recovery operation
Recovery interrupted!
Tue Jun 03 20:32:55 CST 2014
Errors in file /u01/app/oracle/admin/gpsdb/bdump/gpsdb_mrp0_10917.trc:
ORA-16037: user requested cancel of managed recovery operation
Tue Jun 03 20:32:55 CST 2014
MRP0: Background Media Recovery process shutdown (gpsdb)
Tue Jun 03 20:32:56 CST 2014
Managed Standby Recovery Canceled (gpsdb)
Tue Jun 03 20:32:56 CST 2014
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Tue Jun 03 20:33:08 CST 2014
alter database open read only
Tue Jun 03 20:33:11 CST 2014
SMON: enabling cache recovery
Tue Jun 03 20:33:11 CST 2014
Database Characterset is AL32UTF8
Opening with internal Resource Manager plan
replication_dependency_tracking turned off (no async multimaster replication found)
Physical standby database opened for read only access.
Completed: alter database open read only==>打开数据库了
6)、这里所谓的最后一批日志，是什么呢？
primary库停应用后，数据库层面掐断oracle网络，利用alter system switch logfile；来回数次将redo日志里的信息给切到归档里，减少数据的丢失；
7)、查看归档日志应用情况及是否产生gap
v$archived_log
select thread#,sequence#,first_time,next_time,status,applied from v$archived_log;
v$archive_gap
select * from v$archive_gap;
七、数据库角色的切换
1)、结束
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;==>如果前一条无法执行成功，则强制处理
2)、切换角色
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
3)、查看切换后的信息
SQL> select name,switchover_status,open_mode,protection_mode,database_role from v$database;
NAME SWITCHOVER_STATUS OPEN_MODE PROTECTION_MODE DATABASE_ROLE
--------- -------------------- ---------- -------------------- ----------------
GPSDB SESSIONS ACTIVE READ WRITE MAXIMUM PERFORMANCE PRIMARY
4)、切换时的alert日志
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
Tue Jun 03 20:36:40 CST 2014
SKIP STANDBY LOGFILE option no longer needed for RECOVERFINISH. Option ignored
Tue Jun 03 20:36:40 CST 2014
Attempt to do a Terminal Incomplete Recovery (gpsdb)
Tue Jun 03 20:36:40 CST 2014
Stopping background process CJQ0
Tue Jun 03 20:36:40 CST 2014
Stopping background process MMNL
Tue Jun 03 20:36:41 CST 2014
Stopping background process MMON
Tue Jun 03 20:36:42 CST 2014
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Jun 03 20:36:44 CST 2014
SMON: disabling cache recovery
Tue Jun 03 20:36:45 CST 2014
Starting background process MMON
Tue Jun 03 20:36:45 CST 2014
Media Recovery Start: Managed Standby Recovery (gpsdb)
Tue Jun 03 20:36:45 CST 2014
Managed Standby Recovery not using Real Time Apply
Tue Jun 03 20:36:45 CST 2014
Starting background process MMNL
MMON started with pid=14, OS id=15129
MMNL started with pid=15, OS id=15131
Tue Jun 03 20:36:47 CST 2014
parallel recovery started with 16 processes
Media Recovery Waiting for thread 2 sequence 39811
Begin: Standby Redo Logfile archival
End: Standby Redo Logfile archival
Resetting archiving SCN from 194:4012030644 to 194:4012030410
Terminal Recovery timestamp is '06/03/2014 20:36:48'
Terminal Recovery: applying standby redo logs.
Terminal Recovery: thread 2 seq# 39811 redo required
Terminal Recovery: End-Of-Redo log allocation
Terminal Recovery: standby redo logfile 9 created '/oradata/archivelog_dest/2_0_764370486.arc'
This standby redo logfile is being created as part of the failover
operation. This standby redo logfile should be deleted after the
switchover to primary operation completes.
Tue Jun 03 20:36:48 CST 2014
Media Recovery Log /oradata/archivelog_dest/2_0_764370486.arc
Terminal Recovery: log 9 reserved for thread 2 sequence 39811
Tue Jun 03 20:36:48 CST 2014
Recovery of Online Redo Log: Thread 2 Group 9 Seq 39811 Reading mem 0
Mem# 0: /oradata/archivelog_dest/2_0_764370486.arc
Identified End-Of-Redo for thread 2 sequence 39811
Terminal Recovery: thread 1 seq# 78818 redo required
Terminal Recovery: /backup/gpsbak/dbbackup/78818.log
Terminal Recovery: Updated next available block for thread 2 sequence 39811 lno 9 to value 2
Identified End-Of-Redo for thread 2 sequence 39811
Tue Jun 03 20:36:49 CST 2014
Incomplete recovery applied all redo ever generated.
Recovery completed through change 837235685835
Tue Jun 03 20:36:49 CST 2014
Media Recovery Complete (gpsdb)
Terminal Recovery: standby redo logfile 10 created '/oradata/archivelog_dest/1_0_764370486.arc'
This standby redo logfile is being created as part of the failover
operation. This standby redo logfile should be deleted after the
switchover to primary operation completes.
Terminal Recovery: log 10 reserved for thread 1 sequence 78819
Terminal recovery recovered to last consistent point in redo stream
But it did not apply all redo; some data may be lost
Terminal Recovery: successful completion
Begin: Standby Redo Logfile archival
End: Standby Redo Logfile archival
Resetting standby activation ID 202911664 (0xc182fb0)
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
Tue Jun 03 20:37:45 CST 2014
idle dispatcher 'D000' terminated, pid = (17, 1)
Tue Jun 03 20:37:50 CST 2014
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
Tue Jun 03 20:37:50 CST 2014
ALTER DATABASE SWITCHOVER TO PRIMARY (gpsdb)
Tue Jun 03 20:37:50 CST 2014
If media recovery active, switchover will wait 900 seconds
Using STANDBY_ARCHIVE_DEST parameter default value as /oradata/archivelog_dest
Standby terminal recovery start SCN: 837235685834
RESETLOGS after complete recovery through change 837235685835
Online log /oradata/gpsdb/redo01.log: Thread 1 Group 1 was previously cleared
Online log /oradata/gpsdb/redo02.log: Thread 1 Group 2 was previously cleared
Online log /oradata/gpsdb/redo03.log: Thread 1 Group 3 was previously cleared
Online log /oradata/gpsdb/redo04.log: Thread 1 Group 4 was previously cleared
Online log /oradata/gpsdb/redo05.log: Thread 2 Group 5 was previously cleared
Online log /oradata/gpsdb/redo06.log: Thread 2 Group 6 was previously cleared
Online log /oradata/gpsdb/redo07.log: Thread 2 Group 7 was previously cleared
Online log /oradata/gpsdb/redo08.log: Thread 2 Group 8 was previously cleared
Standby became primary SCN: 837235685833
Tue Jun 03 20:37:53 CST 2014
Setting recovery target incarnation to 3
Tue Jun 03 20:37:53 CST 2014
Switchover: Complete - Database shutdown required (gpsdb)
Tue Jun 03 20:37:53 CST 2014
Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
===========================
相关交流信息
QQ群: 330218614
Email: 623009431@qq.com
Blog: http://blog.csdn.net/trsenzhang
============================
0 0
- TB级别库迁移操作
- TB级别数据排序问题
- SQL Server TB 级别数据库文件快速初始化
- 48小时迁移2TB数据库
- TB
- 二、整库迁移操作
- 使用RESTful EhCache服务器实现TB级级别缓存
- 业务60TB数据迁移-降本开始！
- Oracle schema 级别的数据迁移
- Oracle schema 级别的数据迁移
- 大磁盘（超过2TB）阵列的部署以及使用rsync的数据迁移方案
- MSP430下TB产生两路PWM波的操作
- 双链表内部迁移操作
- 10. 数据库迁移操作
- openstack虚拟机迁移操作
- 为什么国内的网盘公司都在 TB 的级别上竞争，成本会不会太高？
- 为什么国内的网盘公司都在 TB 的级别上竞争，成本会不会太高？
- 为什么国内的网盘公司都在 TB 的级别上竞争，成本会不会太高？
- ACM-树状数组之敌兵布阵——hdu1166
- [PHP]去掉CodeIgniter URL中的index.php
- svn的恢复到指定版本操作
- Springmvc表单实体映射
- iOS的主要框架介绍
- TB级别库迁移操作
- 如何熟悉一个开源项目？
- Linux下tempfs及/dev/shm原理与应用
- 黑马程序员_交通灯管理系统
- 使用通配符增强泛型
- 深入理解Java虚拟机
- [Teamcenter 2007 开发实战] 获取错误或提示信息
- Introduction to Probability (4) Counting
- javascript的简单介绍及其经典例子(1)
