Re: Rman Backup Issue

From: David Barbour <david.barbour1_at_gmail.com>
Date: Fri, 2 Jan 2009 13:51:25 -0500
Message-ID: <69eafc3f0901021051v6f847e8bvd2b5faad69a80a66_at_mail.gmail.com>

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 Fri Jan 02 2009 - 12:51:25 CST