DB復制問題

显示全部楼层 · 2005-12-9 15:18:04

今天做復制﹐發現恢復過去了﹐但是在啟動時候報錯﹐具體如下

RMAN> run{
2> allocate auxiliary channel auxc device type disk;
3> duplicate target database to aux1
4> until scn 50933
5> pfile='/tmp/aux1/initaux1.ora';
6> }
allocated channel: auxc
channel auxc: sid=12 devtype=DISK
Starting Duplicate Db at 09-DEC-05
printing stored script: Memory Script
{
set until scn50933;
set newname for datafile1 to
"/tmp/aux1/system01.dbf";
set newname for datafile2 to
"/tmp/aux1/undotbs01.dbf";
set newname for datafile3 to
"/tmp/aux1/indx01.dbf";
set newname for datafile4 to
"/tmp/aux1/tools01.dbf";
set newname for datafile5 to
"/tmp/aux1/users01.dbf";
set newname for datafile6 to
"/tmp/aux1/TEST01.dbf";
restore
check readonly
clone database
;
}
executing script: 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
Starting restore at 09-DEC-05
channel auxc: starting datafile backupset restore
channel auxc: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /tmp/aux1/indx01.dbf
restoring datafile 00005 to /tmp/aux1/users01.dbf
restoring datafile 00006 to /tmp/aux1/TEST01.dbf
channel auxc: restored backup piece 1
piece handle=/orabackup/TESTDB_1_1_1.rbck tag=TAG20051208T183910 params=NULL
channel auxc: restore complete
channel auxc: starting datafile backupset restore
channel auxc: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /tmp/aux1/system01.dbf
channel auxc: restored backup piece 1
piece handle=/orabackup/TESTDB_2_1_1.rbck tag=TAG20051208T183910 params=NULL
channel auxc: restore complete
channel auxc: starting datafile backupset restore
channel auxc: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /tmp/aux1/undotbs01.dbf
restoring datafile 00004 to /tmp/aux1/tools01.dbf
channel auxc: restored backup piece 1
piece handle=/orabackup/TESTDB_3_1_1.rbck tag=TAG20051208T183910 params=NULL
channel auxc: restore complete
Finished restore at 09-DEC-05
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "aux1" RESETLOGS ARCHIVELOG
MAXLOGFILES5
MAXLOGMEMBERS3
MAXDATAFILES100
MAXINSTANCES 1
MAXLOGHISTORY454
LOGFILE
GROUP1 ( '/tmp/aux1/redo01.log' ) SIZE104857600REUSE,
GROUP2 ( '/tmp/aux1/redo02.log' ) SIZE104857600REUSE,
GROUP3 ( '/tmp/aux1/redo03.log' ) SIZE104857600REUSE
DATAFILE
'/tmp/aux1/system01.dbf'
CHARACTER SET ZHT16BIG5

printing stored script: Memory Script
{
switch clone datafile all;
}
executing script: Memory Script
datafile 2 switched to datafile copy
input datafilecopy recid=1 stamp=576601843 filename=/tmp/aux1/undotbs01.dbf
datafile 3 switched to datafile copy
input datafilecopy recid=2 stamp=576601843 filename=/tmp/aux1/indx01.dbf
datafile 4 switched to datafile copy
input datafilecopy recid=3 stamp=576601843 filename=/tmp/aux1/tools01.dbf
datafile 5 switched to datafile copy
input datafilecopy recid=4 stamp=576601843 filename=/tmp/aux1/users01.dbf
datafile 6 switched to datafile copy
input datafilecopy recid=5 stamp=576601843 filename=/tmp/aux1/TEST01.dbf
printing stored script: Memory Script
{
set until scn50933;
recover
clone database
delete archivelog
;
}
executing script: Memory Script
executing command: SET until clause
Starting recover at 09-DEC-05
starting media recovery
channel auxc: starting archive log restore to default destination
channel auxc: restoring archive log
archive log thread=1 sequence=4
channel auxc: restored backup piece 1
piece handle=/orabackup/TESTDB_5_1_1.rbck tag=TAG20051208T184257 params=NULL
channel auxc: restore complete
archive log filename=/u/oracle/product/920/dbs/arch1_4.dbf thread=1 sequence=4
channel clone_default: deleting archive log(s)
archive log filename=/u/oracle/product/920/dbs/arch1_4.dbf recid=1 stamp=5766018
46
media recovery complete
Finished recover at 09-DEC-05
printing stored script: Memory Script
{
shutdown clone;
startup clone nomount pfile= '/tmp/aux1/initaux1.ora';
}
executing script: Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/09/2005 15:18:04
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-01078: failure in processing system parameters

千问 · 2005-12-9 15:18:04

Failure during processing of INIT.ORA parameters during system startup.
应用初始化参数文件时有问题；检查bdump下的日志，看看是否有错误记载；

千问 · 2005-12-9 15:18:04

估计是路径有问题