Re: Rman Backup Issue

From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Mon, 5 Jan 2009 15:51:01 +0530
Message-ID: <e921f8570901050221p11b430ecjd8d2035c05b634c5_at_mail.gmail.com>



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_at_gmail.com>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_at_labor.state.ny.us> 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_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org] *On Behalf Of *Nagaraj S
>> *Sent:* Friday, January 02, 2009 7:25 AM
>> *To:* oracle-l_at_freelists.org
>> *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.
>>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 05 2009 - 04:21:01 CST

Original text of this message