Re: Rman Backup Issue

From: David Barbour <david.barbour1_at_gmail.com>
Date: Mon, 5 Jan 2009 12:23:23 -0500
Message-ID: <69eafc3f0901050923p62c59593x3ec27341bae7e602_at_mail.gmail.com>

Okay, I'm not a Veritas guy - we use Tivoli Storage Manager - but when i refresh our QA system, I switch the nodename on the QA database to the PRD nodename to access the backup. When I'm done, I need to switch it back. Anything like that going on here?

Also, just for grins and giggles did you select from dba_data_files as Tom suggested?

On Mon, Jan 5, 2009 at 5:21 AM, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:

> 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 - 11:23:23 CST