Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 3700 invoked from network); 21 Dec 2007 07:43:07 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 21 Dec 2007 07:43:06 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B48317DDDF4; Fri, 21 Dec 2007 08:43:05 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26599-04; Fri, 21 Dec 2007 08:43:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B91987DDDAA; Fri, 21 Dec 2007 08:43:04 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 21 Dec 2007 07:55:40 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D68197DCD92 for ; Fri, 21 Dec 2007 07:55:39 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14166-04 for ; Fri, 21 Dec 2007 07:55:39 -0500 (EST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.227]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4DDBA7DCDA7 for ; Fri, 21 Dec 2007 07:55:39 -0500 (EST) Received: by nz-out-0506.google.com with SMTP id s18so158099nze.1 for ; Fri, 21 Dec 2007 04:55:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=DolIzdanWLB7LOAzU9FBll1sCpc1tIHTyA5yXMTUIdk=; b=MxLpgmZeHQPXQFlEXEOEsHcew5TIykdHsGOlKcoTpEV765p1wyxwHnUyCpc4FN+vt1ivwWRFEtflhBlFfvkOuaH752lFCZu5z9JY22cGDOLyikN/CoZFwhyxhqn+Kn7Y3ZVzOKNl5ukdnWbM4ghUmNyDiSkp1tS1i61uw5ZKHLg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=FImxI6Kw2nKTHUmXd5GhMlXqF1/YuWxuTvryvO8nw/su9MGKOdTGEVixZ41WDDk7C0x0xxXU9FdUephWq8lD96ZQ8ZkJHtIe7zUpqz5w2xrotRIb7TsAXUw5F4731liFVZ8v6GFsNZg/xWXEC9XyVBGY66Rb1JYFjYKYmWusPT0= Received: by 10.142.142.16 with SMTP id p16mr565559wfd.86.1198241738588; Fri, 21 Dec 2007 04:55:38 -0800 (PST) Received: by 10.142.14.20 with HTTP; Fri, 21 Dec 2007 04:55:38 -0800 (PST) Message-ID: <8b53b96c0712210455t43b0d1f4s40ea5a7c7a0ebe5a@mail.gmail.com> Date: Fri, 21 Dec 2007 18:25:38 +0530 From: "Avadhani mys" To: oracle-l Subject: Rman Duplicating Error--Strange Though MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_81_31282702.1198241738589" X-archive-position: 4078 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: avadhanimys@gmail.com Precedence: normal Reply-to: avadhanimys@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_81_31282702.1198241738589 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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; } ======================================== ------=_Part_81_31282702.1198241738589 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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;
}

========================================

------=_Part_81_31282702.1198241738589-- -- http://www.freelists.org/webpage/oracle-l