Re: Rman Backup Issue
Date: Fri, 2 Jan 2009 18:27:41 +0530
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?
TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on 02-JAN-2009 07:54:24
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
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)
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>
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
Received on Fri Jan 02 2009 - 06:57:41 CST