Hi David Barbour, Good Morning. Production backup completed but in production backup logs it show different filesystem SQL> select a.db_name, a.dbinc_key, a.db_key, b.db_key, b.db_id from dbinc a, db b where a.db_key = b.db_key and b.db_id = 20152227; GCKP 7864531 7864403 786440320152227 GCKP 7864404 7864403 786440320152227 regards, Naga On Sat, Jan 3, 2009 at 12:21 AM, David Barbour <david.barbour1@xxxxxxxxx>wrote: > Does the "production" backup complete or do you get an error? > > My guess is you've got a problem in your catalog. What happens when you run > this against your catalog database: > > select a.db_name, a.dbinc_key, a.db_key, b.db_key, b.db_id from dbinc a, db > b where a.db_key = b.db_key and b.db_id = 20152227 > > Check Metalink Note #*419144.1* > > > On Fri, Jan 2, 2009 at 8:49 AM, Mercadante, Thomas F (LABOR) < > Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote: > >> 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. >> > >