RE: Rman Backup Issue

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <nagaraj.chk@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 2 Jan 2009 08:49:29 -0500

Nagaraj,

 

Hate to ask a stupid question but what does the following query running
on the production database show:  Also run the same query on the QC
database.

 

Select file_name from dba_data_files;


tom

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nagaraj S
Sent: Friday, January 02, 2009 7:25 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Rman Backup Issue

 

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.

Other related posts: