Rman Duplicating Error--Strange Though

From: Avadhani mys <avadhanimys_at_gmail.com>
Date: Fri, 21 Dec 2007 18:25:38 +0530
Message-ID: <8b53b96c0712210455t43b0d1f4s40ea5a7c7a0ebe5a@mail.gmail.com>

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_at_Catalog
connect target sys/xxxxxx_at_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;
}

---

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 21 2007 - 06:55:38 CST