yeah GCKP is production database. My QC Db name is GCK2Q SQL> select dbid,name from v$database; 2038866705 GCK2Q On Fri, Jan 2, 2009 at 7:00 PM, Jack van Zanen <jack@xxxxxxxxxxxx> wrote: > GCKP is production right? > what is the DBID and NAME of the QC database (v$database). > > jack > > 2009/1/2 Nagaraj S <nagaraj.chk@xxxxxxxxx> > >> Hi, >> >> Thanks for your reply. >> Below are the information >> >> Did you use rman duplicate command or just a file based cope and create >> controlfile? >> No. I have restored datafiles from tape using RMAN and manually created >> the controlfile and applied archive logs. >> >> Does the QC database have same Name as production? >> No. I have changed the QC database name once i have completed the >> restoration >> >> Did you register the QC database in the recovery catalog? >> Yes i have changed the dbid of my QC database and registered it in rman >> catalog >> >> Which database does the TNSNAMES entry GCKP point to? >> >> tnsping GCKP >> >> TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on >> 02-JAN-2009 07:54:24 >> >> Copyright (c) 1997, 2006, Oracle. All rights reserved. >> >> Used parameter files: >> /var/opt/oracle/sqlnet.ora >> >> Used TNSNAMES adapter to resolve the alias >> Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = >> sunkbk85.gonda.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) >> (SERVICE_NAME = GCKP))) >> OK (0 msec) >> >> >> >> On Fri, Jan 2, 2009 at 6:06 PM, Jack van Zanen <jack@xxxxxxxxxxxx> wrote: >> >>> Did you use rman duplicate command or just a file based cope and create >>> controlfile? Does the QC database have same Name as production? >>> Did you register the QC database in the recovery catalog? >>> Which database does the TNSNAMES entry GCKP point to? >>> >>> Jack >>> >>> >>> 2009/1/2 Nagaraj S <nagaraj.chk@xxxxxxxxx> >>> >>> Hi Gurus... >>>> >>>> Good Morning. I need help on the below issue. >>>> >>>> I did an refresh of production data to QC database. Once the refresh >>>> gets completed i can notice Production RMAN backup using QC datafile system >>>> when it gets backued up >>>> >>>> From the PRODUCTION RMAN log below are the information >>>> >>>> ----------------------------------------- >>>> connected to target database: GCKP (DBID=20152227) >>>> >>>> connected to recovery catalog database >>>> >>>> allocated channel: tape1 >>>> channel tape1: sid=1257 devtype=SBT_TAPE >>>> channel tape1: VERITAS NetBackup for Oracle - Release 5.1 (2006110403) >>>> sent command to channel: tape1 >>>> >>>> allocated channel: tape2 >>>> channel tape2: sid=2689 devtype=SBT_TAPE >>>> channel tape2: VERITAS NetBackup for Oracle - Release 5.1 (2006110403) >>>> sent command to channel: tape2 >>>> >>>> Starting backup at 31-DEC-08 >>>> channel tape1: starting incremental level 0 datafile backupset >>>> channel tape1: specifying datafile(s) in backupset >>>> input datafile fno=00068 >>>> name=/DATA/QC/ORACLE/datafiles/data13/we_data00.dbf >>>> input datafile fno=00101 >>>> name=/DATA/QC/ORACLE/datafiles/data09/st_data00.dbf >>>> input datafile fno=00093 >>>> name=/DATA/QC/ORACLE/datafiles/indexes04/undo03.dbf >>>> >>>> But /DATA/QC/ORACLE/datafiles/data13/ filesystem were present on QC >>>> Server not on production server. Please guide me if am wrong any were. >>>> >>> >>> >>> >>> -- >>> Jack van Zanen >>> >>> ------------------------- >>> This e-mail and any attachments may contain confidential material for the >>> sole use of the intended recipient. If you are not the intended recipient, >>> please be aware that any disclosure, copying, distribution or use of this >>> e-mail or any attachment is prohibited. If you have received this e-mail in >>> error, please contact the sender and delete all copies. >>> Thank you for your cooperation >>> >> >> > > > -- > Jack van Zanen > > ------------------------- > This e-mail and any attachments may contain confidential material for the > sole use of the intended recipient. If you are not the intended recipient, > please be aware that any disclosure, copying, distribution or use of this > e-mail or any attachment is prohibited. If you have received this e-mail in > error, please contact the sender and delete all copies. > Thank you for your cooperation >