Re: Rman Backup Issue

From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Fri, 2 Jan 2009 18:27:41 +0530
Message-ID: <e921f8570901020457t661de132mb7f90587fb841ea_at_mail.gmail.com>

Hi,

Thanks for your reply.

Below are the information

Did you use rman duplicate command or just a file based cope and create controlfile?
No. I have restored datafiles from tape using RMAN and manually created the controlfile and applied archive logs.

Does the QC database have same Name as production?
No. I have changed the QC database name once i have completed the restoration

Did you register the QC database in the recovery catalog?
Yes i have changed the dbid of my QC database and registered it in rman catalog

Which database does the TNSNAMES entry GCKP point to?

tnsping GCKP

TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on 02-JAN-2009 07:54:24

Used parameter files:
/var/opt/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sunkbk85.gonda.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = GCKP)))
OK (0 msec)

On Fri, Jan 2, 2009 at 6:06 PM, Jack van Zanen <jack_at_vanzanen.com> wrote:

Did you use rman duplicate command or just a file based cope and create controlfile?
Does the QC database have same Name as production?

Did you register the QC database in the recovery catalog?

Which database does the TNSNAMES entry GCKP point to?

Jack

2009/1/2 Nagaraj S <nagaraj.chk_at_gmail.com>

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.

--
Jack van Zanen

-------------------------
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies.
Thank you for your cooperation

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 02 2009 - 06:57:41 CST

This message: [ Message body ]
Next message: Rajesh.Rao_at_jpmchase.com: "Leap Second cause Cluster crashes for anyone?"
Previous message: Nagaraj S: "Rman Backup Issue"
In reply to: Jack van Zanen: "Re: Rman Backup Issue"
Next in thread: David Barbour: "Re: Rman Backup Issue"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message