-------------------------------------------------------RMAN复制数据库(使用恢复目录库)-------------------------------------------------------
计划把172.19.201.240上的SGPMDB复制到172.19.4.1服务器，目录结构相同
首先改变172.19.201.240上的SGPMDB为归档模式
改变非归档模式到归档模式:
1)SQL>SHUTDOWN NORMAL/IMMEDIATE;
2)SQL>STARTUP MOUNT;
3)SQL>ALTER DATABASE ARCHIVELOG;
4)SQL>ALTER DATABASE OPEN;
5)SQL>做一次完全备份,因为非归档日志模式下产生的备份日志对于归档模式已经不可用了.这一步非非常重要!
在172.19.201.240和172.19.4.1全都配置TNS，注意：SID的长度不能超过8位，如果超过，超过部分不能识别。
SGTESTA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 172.19.4.1)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = SGTESTA)
)
)
SGPMDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.201.240)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SGPMDB)
)
)
DBRMAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.201.240)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbrman)
)
)
----------------------------------创建恢复目录数据库并且注册好源库------------------------------------
在240的服务器上，用dbca创建dbrman数据库，建好后：
create tablespace catalog_tbs
DATAFILE '/app/oracle/base/oradata/dbrman/catalog_tbs.dbf' SIZE 1000M REUSE
AUTOEXTEND ON NEXT 200M EXTENT MANAGEMENT LOCAL ;
CREATE USER rman IDENTIFIED BY rman DEFAULT TABLESPACE catalog_tbs;
GRANT connect,resource,recovery_catalog_owner TO rman;
使用RMAN连接的恢复目录
rman catalog=rman/rman
在RMAN 提示符下执行create catalog命令
create catalog tablespace catalog_tbs;
在恢复目录中注册数据库
export ORACLE_SID=SGPMDB
rman target=sys/sys_240_sgpmdb catalog=rman/rman@DBRMAN
使用恢复目录注册数据库
RMAN>register database;
-------------------------------------目标库上准备pfile和密码文件，nomount启动辅助实例-------------------------------
新建和源库上一样的目录结构
在4.1的目标机器上，用oracle用户建密码文件
orapwd FILE=/app/oracle/base/product/10.2.0/db_1/dbs/orapwdSGTESTA PASSWORD=oracle ENTRIES=30
新建initSGTESTA.ora文件
DB_NAME=SGTESTA
db_block_size=8192
compatible＝10.2.0.3.0
shared_pool_size=500M
db_file_name_convert('SGPMDB','SGTESTA') ;
log_file_name_convert('SGPMDB','SGTESTA') ;
--nomount AUXILIARY数据库
export ORACLE_SID=SGTESTA
sqlplus / as sysdba
STARTUP NOMOUNT PFILE='/app/oracle/base/admin/SGTESTA/pfile/initSGTESTA.ora';
创建SPFILE后重新启动
create spfile='/app/oracle/base/product/10.2.0/db_1/dbs/spfileSGTESTA.ora' from pfile='/app/oracle/base/admin/SGTESTA/pfile/initSGTESTA.ora' ;
SQL> startup force nomount
--启动catalog数据库
export ORACLE_SID=dbrman
sqlplus / as sysdba
startup
--下面是连接CATALOG以及TARGET数据库来DUPLICATE TARGET数据库到AUXILIARY,在辅助实例库上登录rman
export ORACLE_SID=SGTESTA
rman TARGET sys/sys_release4144_sgpmdb@SGPMDB_201_240 CATALOG rman/rman@DBRMAN AUXILIARY sys/oracle
Recovery Manager: Release 10.2.0.4.0 - Production on Mon Aug 3 16:43:43 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: SGPMDB (DBID=3784337228)
connected to recovery catalog database
connected to auxiliary database: SGTESTA (not mounted)
或者分别连接三个，是一样的
export ORACLE_SID=SGTESTA
RMAN> connect target sys/sys_release4144_sgpmdb@SGPMDB_201_240
connected to target database: SGPMDB (DBID=3784337228)
RMAN> connect auxiliary sys/oracle
connected to auxiliary database: SGPMDB (nomount)
RMAN> connect catalog rman/rman@DBRMAN
connected to recovery catalog database
备份命令
run {
allocate channel ch1 device type disk maxpiecesize=10g;
sql 'alter system archive log current';
change archivelog all crosscheck;
backup full database tag=sgpmdbfullbk
format '/app/oracle/base/admin/SGPMDB/arch/%d_db_%t_%s_%p'
plus archivelog format '/app/oracle/base/admin/SGPMDB/arch/%d_arch_%t_%s_%p' delete all input;
backup current controlfile
format '/app/oracle/base/admin/SGPMDB/arch/%d_ctlfile_%t_%s_%p';
release channel ch1;
}
备份的时候用archive log list 查看当前的logseq号，并且记录下来
用scp命令拷贝数据文件，归档日志，控制文件备份（必须和目标数据库路径完全一致）。
在RMAN里面综合用list backup 以及在/app/oracle/base/admin/SGPMDB/arch目录里面看时间戳
Piece Name: /app/oracle/base/admin/SGPMDB/arch/SGPMDB_arch_693938700_22_1
Piece Name: /app/oracle/base/admin/SGPMDB/arch/SGPMDB_arch_693938891_23_1
piece handle=/app/oracle/base/admin/SGPMDB/arch/SGPMDB_arch_693939137_24_1 tag=TAG20090803T164451 comment=NONE
piece handle=/app/oracle/base/admin/SGPMDB/arch/SGPMDB_arch_693939342_25_1 tag=TAG20090803T164451 comment=NONE
piece handle=/app/oracle/base/admin/SGPMDB/arch/SGPMDB_db_693939538_26_1 tag=SGPMDBFULLBK comment=NONE
piece handle=/app/oracle/base/admin/SGPMDB/arch/SGPMDB_db_693940293_27_1 tag=SGPMDBFULLBK comment=NONE
piece handle=/app/oracle/base/admin/SGPMDB/arch/SGPMDB_arch_693940302_28_1 tag=TAG20090803T171142 comment=NONE
piece handle=/app/oracle/base/admin/SGPMDB/arch/SGPMDB_ctlfile_693940305_29_1 tag=TAG20090803T171145 comment=NONE
复制命令
RUN
{
set until logseq 9963 thread 1 ;
ALLOCATE AUXILIARY CHANNEL ch1 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux3 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE TO SGTESTA nofilenamecheck;
}
RMAN> RUN
2> {
3> set until logseq 9963 thread 1 ;
4> ALLOCATE AUXILIARY CHANNEL ch1 DEVICE TYPE DISK;
5> ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
6> ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
7> ALLOCATE AUXILIARY CHANNEL aux3 DEVICE TYPE DISK;
8> DUPLICATE TARGET DATABASE TO SGTESTA nofilenamecheck;
9> }
executing command: SET until clause
allocated channel: ch1
channel ch1: sid=36 devtype=DISK
allocated channel: aux1
channel aux1: sid=35 devtype=DISK
allocated channel: aux2
channel aux2: sid=34 devtype=DISK
allocated channel: aux3
channel aux3: sid=33 devtype=DISK
Starting Duplicate Db at 03-AUG-09
contents of Memory Script:
{
set until scn 10110023328185;
set newname for datafile 1 to
"/app/oracle/base/oradata/SGTESTA/system01.dbf";
set newname for datafile 2 to
"/app/oracle/base/oradata/SGTESTA/undotbs01.dbf";
set newname for datafile 3 to
"/app/oracle/base/oradata/SGTESTA/sysaux01.dbf";
set newname for datafile 4 to
"/app/oracle/base/oradata/SGTESTA/users01.dbf";
set newname for datafile 5 to
"/app/oracle/base/oradata/SGTESTA/DATA_A001.DBF";
set newname for datafile 6 to
"/app/oracle/base/oradata/SGTESTA/DATA_C001.DBF";
set newname for datafile 7 to
"/app/oracle/base/oradata/SGTESTA/DATA_D001.DBF";
set newname for datafile 8 to
"/app/oracle/base/oradata/SGTESTA/DATA_M001.DBF";
set newname for datafile 9 to
"/app/oracle/base/oradata/SGTESTA/DATA_R001.DBF";
set newname for datafile 10 to
"/app/oracle/base/oradata/SGTESTA/DATA_O001.DBF";
set newname for datafile 11 to
"/app/oracle/base/oradata/SGTESTA/DATA_E001.DBF";
set newname for datafile 12 to
"/app/oracle/base/oradata/SGTESTA/DATA_G001.DBF";
set newname for datafile 13 to
"/app/oracle/base/oradata/SGTESTA/DATA_P001.DBF";
set newname for datafile 14 to
"/app/oracle/base/oradata/SGTESTA/DATA_S001.DBF";
set newname for datafile 15 to
"/app/oracle/base/oradata/SGTESTA/IDX_A001.DBF";
set newname for datafile 16 to
"/app/oracle/base/oradata/SGTESTA/IDX_C001.DBF";
set newname for datafile 17 to
"/app/oracle/base/oradata/SGTESTA/IDX_D001.DBF";
set newname for datafile 18 to
"/app/oracle/base/oradata/SGTESTA/IDX_M001.DBF";
set newname for datafile 19 to
"/app/oracle/base/oradata/SGTESTA/IDX_R001.DBF";
set newname for datafile 20 to
"/app/oracle/base/oradata/SGTESTA/IDX_O001.DBF";
set newname for datafile 21 to
"/app/oracle/base/oradata/SGTESTA/IDX_E001.DBF";
set newname for datafile 22 to
"/app/oracle/base/oradata/SGTESTA/IDX_G001.DBF";
set newname for datafile 23 to
"/app/oracle/base/oradata/SGTESTA/IDX_P001.DBF";
set newname for datafile 24 to
"/app/oracle/base/oradata/SGTESTA/IDX_S001.DBF";
set newname for datafile 25 to
"/app/oracle/base/oradata/SGTESTA/DATA_MAN001.DBF";
set newname for datafile 26 to
"/app/oracle/base/oradata/SGTESTA/IDX_MAN001.DBF";
set newname for datafile 27 to
"/app/oracle/base/oradata/SGTESTA/DATA_SGPM.DBF";
set newname for datafile 28 to
"/app/oracle/base/oradata/SGTESTA/DATA_Y.DBF";
set newname for datafile 29 to
"/app/oracle/base/oradata/SGTESTA/IDX_Y.DBF";
set newname for datafile 30 to
"/app/oracle/base/oradata/SGTESTA/DATA_OUT.DBF";
set newname for datafile 31 to
"/app/oracle/base/oradata/SGTESTA/IDX_OUT.DBF";
set newname for datafile 32 to
"/app/oracle/base/oradata/SGTESTA/DATA_ARC001.DBF";
set newname for datafile 33 to
"/app/oracle/base/oradata/SGTESTA/IDX_ARC001.DBF";
set newname for datafile 34 to
"/app/oracle/base/oradata/SGTESTA/pa_data01.dbf";
set newname for datafile 35 to
"/app/oracle/base/oradata/SGTESTA/pa_index01.dbf";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
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 03-AUG-09
channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /app/oracle/base/oradata/SGTESTA/system01.dbf
restoring datafile 00002 to /app/oracle/base/oradata/SGTESTA/undotbs01.dbf
restoring datafile 00003 to /app/oracle/base/oradata/SGTESTA/sysaux01.dbf
restoring datafile 00004 to /app/oracle/base/oradata/SGTESTA/users01.dbf
restoring datafile 00005 to /app/oracle/base/oradata/SGTESTA/DATA_A001.DBF
restoring datafile 00006 to /app/oracle/base/oradata/SGTESTA/DATA_C001.DBF
restoring datafile 00007 to /app/oracle/base/oradata/SGTESTA/DATA_D001.DBF
restoring datafile 00008 to /app/oracle/base/oradata/SGTESTA/DATA_M001.DBF
restoring datafile 00009 to /app/oracle/base/oradata/SGTESTA/DATA_R001.DBF
restoring datafile 00010 to /app/oracle/base/oradata/SGTESTA/DATA_O001.DBF
restoring datafile 00011 to /app/oracle/base/oradata/SGTESTA/DATA_E001.DBF
restoring datafile 00012 to /app/oracle/base/oradata/SGTESTA/DATA_G001.DBF
restoring datafile 00013 to /app/oracle/base/oradata/SGTESTA/DATA_P001.DBF
restoring datafile 00014 to /app/oracle/base/oradata/SGTESTA/DATA_S001.DBF
restoring datafile 00015 to /app/oracle/base/oradata/SGTESTA/IDX_A001.DBF
restoring datafile 00016 to /app/oracle/base/oradata/SGTESTA/IDX_C001.DBF
restoring datafile 00017 to /app/oracle/base/oradata/SGTESTA/IDX_D001.DBF
restoring datafile 00018 to /app/oracle/base/oradata/SGTESTA/IDX_M001.DBF
restoring datafile 00019 to /app/oracle/base/oradata/SGTESTA/IDX_R001.DBF
restoring datafile 00020 to /app/oracle/base/oradata/SGTESTA/IDX_O001.DBF
restoring datafile 00021 to /app/oracle/base/oradata/SGTESTA/IDX_E001.DBF
restoring datafile 00022 to /app/oracle/base/oradata/SGTESTA/IDX_G001.DBF
restoring datafile 00023 to /app/oracle/base/oradata/SGTESTA/IDX_P001.DBF
restoring datafile 00024 to /app/oracle/base/oradata/SGTESTA/IDX_S001.DBF
restoring datafile 00025 to /app/oracle/base/oradata/SGTESTA/DATA_MAN001.DBF
restoring datafile 00026 to /app/oracle/base/oradata/SGTESTA/IDX_MAN001.DBF
restoring datafile 00027 to /app/oracle/base/oradata/SGTESTA/DATA_SGPM.DBF
restoring datafile 00028 to /app/oracle/base/oradata/SGTESTA/DATA_Y.DBF
restoring datafile 00029 to /app/oracle/base/oradata/SGTESTA/IDX_Y.DBF
restoring datafile 00030 to /app/oracle/base/oradata/SGTESTA/DATA_OUT.DBF
restoring datafile 00031 to /app/oracle/base/oradata/SGTESTA/IDX_OUT.DBF
restoring datafile 00032 to /app/oracle/base/oradata/SGTESTA/DATA_ARC001.DBF
restoring datafile 00033 to /app/oracle/base/oradata/SGTESTA/IDX_ARC001.DBF
restoring datafile 00034 to /app/oracle/base/oradata/SGTESTA/pa_data01.dbf
restoring datafile 00035 to /app/oracle/base/oradata/SGTESTA/pa_index01.dbf
channel ch1: reading from backup piece /app/oracle/base/product/10.2.0/db_1/dbs/0kkk7b4i_1_1
channel ch1: restored backup piece 1
piece handle=/app/oracle/base/product/10.2.0/db_1/dbs/0kkk7b4i_1_1 tag=TAG20090715T174904
channel ch1: restore complete, elapsed time: 00:57:55
Finished restore at 03-AUG-09
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "SGTESTA" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 4672
LOGFILE
GROUP 1 ( '/app/oracle/base/oradata/SGTESTA/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/app/oracle/base/oradata/SGTESTA/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/app/oracle/base/oradata/SGTESTA/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/app/oracle/base/oradata/SGTESTA/system01.dbf'
CHARACTER SET UTF8
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=693957595 filename=/app/oracle/base/oradata/SGTESTA/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=693957595 filename=/app/oracle/base/oradata/SGTESTA/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=693957595 filename=/app/oracle/base/oradata/SGTESTA/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/DATA_A001.DBF
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/DATA_C001.DBF
datafile 7 switched to datafile copy
input datafile copy recid=6 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/DATA_D001.DBF
datafile 8 switched to datafile copy
input datafile copy recid=7 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/DATA_M001.DBF
datafile 9 switched to datafile copy
input datafile copy recid=8 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/DATA_R001.DBF
datafile 10 switched to datafile copy
input datafile copy recid=9 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/DATA_O001.DBF
datafile 11 switched to datafile copy
input datafile copy recid=10 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/DATA_E001.DBF
datafile 12 switched to datafile copy
input datafile copy recid=11 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/DATA_G001.DBF
datafile 13 switched to datafile copy
input datafile copy recid=12 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/DATA_P001.DBF
datafile 14 switched to datafile copy
input datafile copy recid=13 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/DATA_S001.DBF
datafile 15 switched to datafile copy
input datafile copy recid=14 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/IDX_A001.DBF
datafile 16 switched to datafile copy
input datafile copy recid=15 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/IDX_C001.DBF
datafile 17 switched to datafile copy
input datafile copy recid=16 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/IDX_D001.DBF
datafile 18 switched to datafile copy
input datafile copy recid=17 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/IDX_M001.DBF
datafile 19 switched to datafile copy
input datafile copy recid=18 stamp=693957596 filename=/app/oracle/base/oradata/SGTESTA/IDX_R001.DBF
datafile 20 switched to datafile copy
input datafile copy recid=19 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/IDX_O001.DBF
datafile 21 switched to datafile copy
input datafile copy recid=20 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/IDX_E001.DBF
datafile 22 switched to datafile copy
input datafile copy recid=21 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/IDX_G001.DBF
datafile 23 switched to datafile copy
input datafile copy recid=22 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/IDX_P001.DBF
datafile 24 switched to datafile copy
input datafile copy recid=23 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/IDX_S001.DBF
datafile 25 switched to datafile copy
input datafile copy recid=24 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/DATA_MAN001.DBF
datafile 26 switched to datafile copy
input datafile copy recid=25 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/IDX_MAN001.DBF
datafile 27 switched to datafile copy
input datafile copy recid=26 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/DATA_SGPM.DBF
datafile 28 switched to datafile copy
input datafile copy recid=27 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/DATA_Y.DBF
datafile 29 switched to datafile copy
input datafile copy recid=28 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/IDX_Y.DBF
datafile 30 switched to datafile copy
input datafile copy recid=29 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/DATA_OUT.DBF
datafile 31 switched to datafile copy
input datafile copy recid=30 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/IDX_OUT.DBF
datafile 32 switched to datafile copy
input datafile copy recid=31 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/DATA_ARC001.DBF
datafile 33 switched to datafile copy
input datafile copy recid=32 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/IDX_ARC001.DBF
datafile 34 switched to datafile copy
input datafile copy recid=33 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/pa_data01.dbf
datafile 35 switched to datafile copy
input datafile copy recid=34 stamp=693957597 filename=/app/oracle/base/oradata/SGTESTA/pa_index01.dbf
contents of Memory Script:
{
set until scn 10110023328185;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 03-AUG-09
starting media recovery
channel ch1: starting archive log restore to default destination
channel aux1: starting archive log restore to default destination
channel aux2: starting archive log restore to default destination
channel ch1: restoring archive log
archive log thread=1 sequence=9814
channel aux1: restoring archive log
archive log thread=1 sequence=9859
channel aux2: restoring archive log
archive log thread=1 sequence=9911
channel ch1: restoring archive log
archive log thread=1 sequence=9815
channel aux1: restoring archive log
archive log thread=1 sequence=9860
channel aux2: restoring archive log
archive log thread=1 sequence=9912
channel ch1: restoring archive log
archive log thread=1 sequence=9816
channel aux1: restoring archive log
archive log thread=1 sequence=9861
channel aux2: restoring archive log
archive log thread=1 sequence=9913
channel ch1: restoring archive log
archive log thread=1 sequence=9823
channel aux1: restoring archive log
archive log thread=1 sequence=9862
channel aux2: restoring archive log
archive log thread=1 sequence=9914
channel ch1: restoring archive log
archive log thread=1 sequence=9824
channel aux1: restoring archive log
archive log thread=1 sequence=9863
channel aux2: restoring archive log
archive log thread=1 sequence=9915
channel ch1: restoring archive log
archive log thread=1 sequence=9825
channel aux1: restoring archive log
archive log thread=1 sequence=9864
channel aux2: restoring archive log
archive log thread=1 sequence=9916
channel ch1: restoring archive log
archive log thread=1 sequence=9826
channel aux1: restoring archive log
archive log thread=1 sequence=9865
channel aux2: restoring archive log
archive log thread=1 sequence=9917
channel ch1: restoring archive log
archive log thread=1 sequence=9827
channel aux1: restoring archive log
archive log thread=1 sequence=9866
channel aux2: restoring archive log
archive log thread=1 sequence=9918
channel ch1: restoring archive log
archive log thread=1 sequence=9828
channel aux1: restoring archive log
archive log thread=1 sequence=9867
channel aux2: restoring archive log
archive log thread=1 sequence=9919
channel ch1: restoring archive log
archive log thread=1 sequence=9829
channel aux1: restoring archive log
archive log thread=1 sequence=9868
channel aux2: restoring archive log
archive log thread=1 sequence=9920
channel ch1: restoring archive log
archive log thread=1 sequence=9830
channel aux1: restoring archive log
archive log thread=1 sequence=9869
channel aux2: restoring archive log
archive log thread=1 sequence=9921
channel ch1: restoring archive log
archive log thread=1 sequence=9831
channel aux1: restoring archive log
archive log thread=1 sequence=9870
channel aux2: restoring archive log
archive log thread=1 sequence=9922
channel ch1: restoring archive log
archive log thread=1 sequence=9832
channel aux1: restoring archive log
archive log thread=1 sequence=9871
channel aux2: restoring archive log
archive log thread=1 sequence=9923
channel ch1: restoring archive log
archive log thread=1 sequence=9833
channel aux1: restoring archive log
archive log thread=1 sequence=9872
channel aux2: restoring archive log
archive log thread=1 sequence=9924
channel ch1: restoring archive log
archive log thread=1 sequence=9834
channel aux1: restoring archive log
archive log thread=1 sequence=9873
channel aux2: restoring archive log
archive log thread=1 sequence=9925
channel ch1: restoring archive log
archive log thread=1 sequence=9835
channel aux1: restoring archive log
archive log thread=1 sequence=9874
channel aux2: restoring archive log
archive log thread=1 sequence=9926
channel ch1: restoring archive log
archive log thread=1 sequence=9836
channel aux1: restoring archive log
archive log thread=1 sequence=9875
channel aux2: restoring archive log
archive log thread=1 sequence=9927
channel ch1: restoring archive log
archive log thread=1 sequence=9837
channel aux1: restoring archive log
archive log thread=1 sequence=9876
channel aux2: restoring archive log
archive log thread=1 sequence=9928
channel ch1: restoring archive log
archive log thread=1 sequence=9838
channel aux1: restoring archive log
archive log thread=1 sequence=9877
channel aux2: restoring archive log
archive log thread=1 sequence=9929
channel ch1: restoring archive log
archive log thread=1 sequence=9839
channel aux1: restoring archive log
archive log thread=1 sequence=9878
channel aux2: restoring archive log
archive log thread=1 sequence=9930
channel ch1: restoring archive log
archive log thread=1 sequence=9840
channel aux1: restoring archive log
archive log thread=1 sequence=9879
channel aux2: restoring archive log
archive log thread=1 sequence=9931
channel ch1: restoring archive log
archive log thread=1 sequence=9841
channel aux1: restoring archive log
archive log thread=1 sequence=9880
channel aux2: restoring archive log
archive log thread=1 sequence=9932
channel ch1: restoring archive log
archive log thread=1 sequence=9842
channel aux1: restoring archive log
archive log thread=1 sequence=9881
channel aux2: restoring archive log
archive log thread=1 sequence=9933
channel ch1: restoring archive log
archive log thread=1 sequence=9843
channel aux1: restoring archive log
archive log thread=1 sequence=9882
channel aux2: restoring archive log
archive log thread=1 sequence=9934
channel ch1: restoring archive log
archive log thread=1 sequence=9844
channel aux1: restoring archive log
archive log thread=1 sequence=9883
channel aux2: restoring archive log
archive log thread=1 sequence=9935
channel ch1: restoring archive log
archive log thread=1 sequence=9845
channel aux1: restoring archive log
archive log thread=1 sequence=9884
channel aux2: restoring archive log
archive log thread=1 sequence=9936
channel ch1: restoring archive log
archive log thread=1 sequence=9846
channel aux1: restoring archive log
archive log thread=1 sequence=9885
channel aux2: restoring archive log
archive log thread=1 sequence=9937
channel ch1: restoring archive log
archive log thread=1 sequence=9847
channel aux1: restoring archive log
archive log thread=1 sequence=9886
channel aux2: restoring archive log
archive log thread=1 sequence=9938
channel ch1: restoring archive log
archive log thread=1 sequence=9848
channel aux1: restoring archive log
archive log thread=1 sequence=9887
channel aux2: restoring archive log
archive log thread=1 sequence=9939
channel ch1: restoring archive log
archive log thread=1 sequence=9849
channel aux1: restoring archive log
archive log thread=1 sequence=9888
channel aux2: restoring archive log
archive log thread=1 sequence=9940
channel ch1: restoring archive log
archive log thread=1 sequence=9850
channel aux1: restoring archive log
archive log thread=1 sequence=9889
channel aux2: restoring archive log
archive log thread=1 sequence=9941
channel ch1: restoring archive log
archive log thread=1 sequence=9851
channel aux1: restoring archive log
archive log thread=1 sequence=9890
channel aux2: restoring archive log
archive log thread=1 sequence=9942
channel ch1: restoring archive log
archive log thread=1 sequence=9852
channel aux1: restoring archive log
archive log thread=1 sequence=9891
channel aux2: restoring archive log
archive log thread=1 sequence=9943
channel ch1: restoring archive log
archive log thread=1 sequence=9853
channel aux1: restoring archive log
archive log thread=1 sequence=9892
channel aux2: restoring archive log
archive log thread=1 sequence=9944
channel ch1: restoring archive log
archive log thread=1 sequence=9854
channel aux1: restoring archive log
archive log thread=1 sequence=9893
channel aux2: restoring archive log
archive log thread=1 sequence=9945
channel ch1: restoring archive log
archive log thread=1 sequence=9855
channel aux1: restoring archive log
archive log thread=1 sequence=9894
channel aux2: restoring archive log
archive log thread=1 sequence=9946
channel ch1: restoring archive log
archive log thread=1 sequence=9856
channel aux1: restoring archive log
archive log thread=1 sequence=9895
channel aux2: restoring archive log
archive log thread=1 sequence=9947
channel ch1: restoring archive log
archive log thread=1 sequence=9857
channel aux1: restoring archive log
archive log thread=1 sequence=9896
channel aux2: restoring archive log
archive log thread=1 sequence=9948
channel ch1: restoring archive log
archive log thread=1 sequence=9858
channel ch1: reading from backup piece /app/oracle/base/admin/SGPMDB/arch/SGPMDB_arch_693938891_23_1
channel aux1: restoring archive log
archive log thread=1 sequence=9897
channel aux2: restoring archive log
archive log thread=1 sequence=9949
channel aux1: restoring archive log
archive log thread=1 sequence=9898
channel aux2: restoring archive log
archive log thread=1 sequence=9950
channel aux1: restoring archive log
archive log thread=1 sequence=9899
channel aux2: restoring archive log
archive log thread=1 sequence=9951
channel aux1: restoring archive log
archive log thread=1 sequence=9900
channel aux2: restoring archive log
archive log thread=1 sequence=9952
channel aux1: restoring archive log
archive log thread=1 sequence=9901
channel aux2: restoring archive log
archive log thread=1 sequence=9953
channel aux1: restoring archive log
archive log thread=1 sequence=9902
channel aux2: restoring archive log
archive log thread=1 sequence=9954
channel aux1: restoring archive log
archive log thread=1 sequence=9903
channel aux2: restoring archive log
archive log thread=1 sequence=9955
channel aux1: restoring archive log
archive log thread=1 sequence=9904
channel aux2: restoring archive log
archive log thread=1 sequence=9956
channel aux1: restoring archive log
archive log thread=1 sequence=9905
channel aux2: restoring archive log
archive log thread=1 sequence=9957
channel aux1: restoring archive log
archive log thread=1 sequence=9906
channel aux2: restoring archive log
archive log thread=1 sequence=9958
channel aux1: restoring archive log
archive log thread=1 sequence=9907
channel aux2: restoring archive log
archive log thread=1 sequence=9959
channel aux1: restoring archive log
archive log thread=1 sequence=9908
channel aux2: restoring archive log
archive log thread=1 sequence=9960
channel aux1: restoring archive log
archive log thread=1 sequence=9909
channel aux2: restoring archive log
archive log thread=1 sequence=9961
channel aux1: restoring archive log
archive log thread=1 sequence=9910
channel aux1: reading from backup piece /app/oracle/base/admin/SGPMDB/arch/SGPMDB_arch_693939137_24_1
channel aux2: restoring archive log
archive log thread=1 sequence=9962
channel aux2: reading from backup piece /app/oracle/base/admin/SGPMDB/arch/SGPMDB_arch_693939342_25_1
channel ch1: restored backup piece 1
piece handle=/app/oracle/base/admin/SGPMDB/arch/SGPMDB_arch_693938891_23_1 tag=TAG20090803T164451
channel ch1: restore complete, elapsed time: 00:04:56
archive log filename=/app/oracle/base/product/10.2.0/db_1/dbs/arch1_9814_652109004.dbf thread=1 sequence=9814
channel clone_default: deleting archive log(s)
archive log filename=/app/oracle/base/product/10.2.0/db_1/dbs/arch1_9814_652109004.dbf recid=25 stamp=693957697
archive log filename=/app/oracle/base/product/10.2.0/db_1/dbs/arch1_9815_652109004.dbf thread=1 sequence=9815
channel clone_default: deleting archive log(s)
archive log filename=/app/oracle/base/product/10.2.0/db_1/dbs/arch1_9815_652109004.dbf recid=42 stamp=693957733
archive log filename=/app/oracle/base/product/10.2.0/db_1/dbs/arch1_9816_652109004.dbf thread=1 sequence=9816
channel clone_default: deleting archive log(s)
archive log filename=/app/oracle/base/product/10.2.0/db_1/dbs/arch1_9816_652109004.dbf recid=10 stamp=693957660
unable to find archive log
archive log thread=1 sequence=9817
released channel: ch1
released channel: aux1
released channel: aux2
released channel: aux3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/03/2009 22:07:01
RMAN-03015: error occurred in stored script Memory Script
RMAN-06054: media recovery requesting unknown log: thread 1 seq 9817 lowscn 10109672261341
SQL> alter database open resetlogs ;
ALTER TABLESPACE TEMP ADD TEMPFILE '/app/oracle/base/oradata/SGTESTA/temp01.dbf'
SIZE 48234496 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
创建
create pfile='/app/oracle/base/admin/SGTESTA/pfile/pfileSGTESTA' from spfile ;
接着shutdown immediate，然后
拷贝并修改控制文件名称和位置，
cd /app/oracle/base/product/10.2.0/db_1/dbs
cp ./cntrlSGTESTA.dbf /app/oracle/base/oradata/SGTESTA/control01.ctl
cp ./cntrlSGTESTA.dbf /app/oracle/base/oradata/SGTESTA/control02.ctl
cp ./cntrlSGTESTA.dbf /app/oracle/base/oradata/SGTESTA/control03.ctl
在pfile里面指明control_files='/app/oracle/base/oradata/SGTESTA/control01.ctl','/app/oracle/base/oradata/SGTESTA/control02.ctl','/app/oracle/base/oradata/SGTESTA/control03.ctl'
最后用pfile启动，并且创建spfile
startup pfile='/app/oracle/base/admin/SGTESTA/pfile/pfileSGTESTA' ;
create spfile from pfile='/app/oracle/base/admin/SGTESTA/pfile/pfileSGTESTA' ;
一切OK !