Re: Rman Backup Issue

  • From: "Nagaraj S" <nagaraj.chk@xxxxxxxxx>
  • To: "Jack van Zanen" <jack@xxxxxxxxxxxx>
  • Date: Fri, 2 Jan 2009 19:07:48 +0530

yeah GCKP is production database.

My QC Db name is GCK2Q

SQL> select dbid,name from v$database;
2038866705 GCK2Q

On Fri, Jan 2, 2009 at 7:00 PM, Jack van Zanen <jack@xxxxxxxxxxxx> wrote:

> GCKP is production right?
> what is the DBID and NAME of the QC database (v$database).
>
> jack
>
> 2009/1/2 Nagaraj S <nagaraj.chk@xxxxxxxxx>
>
>> 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
>>
>> Copyright (c) 1997, 2006, Oracle.  All rights reserved.
>>
>> 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@xxxxxxxxxxxx> 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@xxxxxxxxx>
>>>
>>>  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
>>>
>>
>>
>
>
> --
> 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
>

Other related posts: