Rman Duplicating Error--Strange Though
- From: "Avadhani mys" <avadhanimys@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 21 Dec 2007 18:25:38 +0530
Hi All,
There was a request to refresh production database to Test database and the
version is 10gR1, Now we are getting the following strange error in
Production database Alertlog, I searched in google and Metalink no help, If
any one knows please help, But our Production system is up and running..fine
My question is why the error is popping up in production database when we
are no way connected to Prod database and we when we are Restoring from
Catalog database.Please help me to understand from your expertise.
Alert
=======================
alter database recover datafile list clear
Thu Dec 20 20:47:03 2007
Completed: alter database recover datafile list clear
Thu Dec 20 20:47:03 2007
alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12
Completed: alter database recover datafile list
1 , 2 , 3 ,
Thu Dec 20 20:47:03 2007
alter database recover if needed
start until time 'DEC 17 2007 22:09:50'
Media Recovery Start
Thu Dec 20 20:47:03 2007
Media Recovery failed with error 1124
ORA-283 signalled during: alter database recover if needed
============================================
Script
=========================================
connect catalog rman/manager@Catalog
connect target sys/xxxxxx@Prod
connect auxiliary /
run {
set until time "to_date('Dec 17 2007 22:09:50','Mon DD YYYY HH24:MI:SS')";
set newname for datafile 1 to '/u01/oradata/DBID/system01.dbf';
set newname for datafile 2 to '/u02/oradata/DBID/sie_idx02.dbf';
set newname for datafile 3 to '/u01/oradata/DBID/sysaux01.dbf';
set newname for datafile 4 to '/u01/oradata/DBID/achi_data01.dbf';
set newname for datafile 5 to '/u02/oradata/DBID/achi_idx01.dbf';
set newname for datafile 6 to '/u01/oradata/DBID/users01.dbf';
set newname for datafile 7 to '/u01/oradata/DBID/siedata01.dbf';
set newname for datafile 8 to '/u02/oradata/DBID/undotbs01.dbf';
set newname for datafile 9 to '/u02/oradata/DBID/tools01.dbf';
set newname for datafile 10 to '/u01/oradata/DBID/sie02.dbf';
set newname for datafile 11 to '/u02/oradata/DBID/ddata01.dbf';
duplicate target database to DBID logfile
group 1 ('/u01/oradata/DBID/log01a.dbf','/u02/oradata/DBID/log1b.dbf') size
250m reuse,
group 2 ('/u01/oradata/DBID/log02a.dbf','/u02/oradata/DBID/log2b.dbf') size
250m reuse,
group 3 ('/u01/oradata/DBID/log03a.dbf','/u02/oradata/DBID/log3b.dbf') size
250m reuse;
recover clone database until time "to_date('Dec 2007 22:09:50','Mon DD YYYY
HH24:MI:SS')";
alter clone database open resetlogs;
}
========================================
Other related posts:
