Home -> Mailing Lists -> Oracle-L -> Re: Rman Backup Issue

Re: Rman Backup Issue

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Fri, 2 Jan 2009 23:36:09 +1100
Message-ID: <77a615a70901020436k794d1c7fm34dc2a3169e797a2_at_mail.gmail.com> 

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_at_gmail.com>


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 





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


Received on Fri Jan 02 2009 - 06:36:09 CST












Original text of this message