RE: A RMAN question

Hi Yechiel,

Of course I do use a RMAN catalog on server B to backup the cloned database.

The scenario I described was because I am wondering whether RMAN will be happy taking a second incremental backup the next day after the controlfiles of the target database were overwritten overnight.

Please read my earlier mail keeping in mind that a RMAN catalog database is being
used.

I would b thankful for any advice on this.

Regards,
Samir

Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : samir.sarkar_at_nottingham.sema.slb.com

            ssarkar2_at_slb.com
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018

-----Original Message-----
Sent: 21 March 2002 13:38
To: Multiple recipients of list ORACLE-L

Hello Samir

I do not work with RMAN but I THINK that you have a conceptual error in your logic.
Since you do not have a catalog RMAN use the control files as catalog. When you want to restore RMAN will not find the data on the full backup in the control files. You will have only the data on the last incremental backup.
How can you restore?

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: SARKAR, Samir [SMTP:Samir.SARKAR_at_nottingham.sema.slb.com]
> Sent: Thu, March 21, 2002 10:38 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: A RMAN question
>
> Hi Dennis,
>
> Thanks for replying. I guess I have not been able to make my question
> clear.
> You see, I need to backup only the cloned database on server B and NOT the
>
> database on server A. My scenario is as follows :
>
> The main db on server A is a partitioned data warehouse system and we r
> planning to copy over the data files and the control files every night to
> the cloned db on server B. Thereafter, we will b taking a RMAN backup of
> the
> cloned db on server B only.
> As I said, RMAN writes the backup info on the target database's control
> files
> when it takes the backup. I also said that we plan to take a full backup
> on
>
> Sundays and incremental backup on the other days.
>
> My confusion was :
>
> Say, RMAN takes a backup of the database on the cloned db on server B
> on a Monday. On MOnday night as per procedure, the control files and
> the database files from the main db on server A are copied over to server
>
> B. On Tuesday, will RMAN b happy taking the incremental backup again
> of the cloned db on server B even though it finds that the control files
> r different than the ones it wrote the backup info to the previous day ??
> Or will it get confused and prompt for a FULL backup ??
>
> Any ideas from anybody would b appreciated a lot.
>
> Regards,
> Samir
>
>
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email : samir.sarkar_at_nottingham.sema.slb.com
> ssarkar2_at_slb.com
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
>
>
> -----Original Message-----
> Sent: 20 March 2002 19:16
> To: Multiple recipients of list ORACLE-L
>
>
> Samir - We have found that each Oracle database has an internal ID. This
> ID
> doesn't change when you clone it as you describe. RMAN uses this ID, and
> will become confused if it sees two databases that are identical. One way
> around this is to run two RMAN catalogs. I have not considered it an
> advantage to use RMAN with the control file (non-catalog) option, so I
> haven't considered all the ramifications there.
> Have you looked at the RMAN DUPLICATE command to clone the database?
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Wednesday, March 20, 2002 10:14 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi All,
>
> Though I have been using RMAN for quite a while now, I would like to ask
> for
> a clarification
> here.
>
> We have a production database with partitioning options on server A. We
> copy over the files
> (including the control files) of the prod database each night to a server
> B.
> We will then be using
> RMAN to backup the database on server. We intend to take a Full backup on
> Sundays and Incrementals
> on all weekdays.
> I know that when we take a RMAN backup, it writes information about that
> task to the target database's
> control files which is precisely why we need not have a catalog database
> necessarily.
>
> My question is when RMAN takes a backup once, will it return an error when
> tries to take an
> incremental backup a second time since we have replaced the control files
> overnight ?? I mean,
> will RMAN be happy with taking an INCREMENTAL backup of the database even
> if
> it finds that the
> control files on which it had written the backup info the previous night
> have been replaced with a
> new set of control files ?? Will it prompt for a full backup ???
>
> Any help will be greatly appreciated.
>
> Regards,
> Samir
>
> Samir Sarkar
> Oracle DBA
> SchlumbergerSema
> Email : samir.sarkar_at_nottingham.sema.slb.com
> ssarkar2_at_slb.com
> Phone : +44 (0) 115 - 957 6028
> EPABX : +44 (0) 115 - 957 6418 Ext. 76028
> Fax : +44 (0) 115 - 957 6018
>
>
>
> __________________________________________________________________________
> _
> This email is confidential and intended solely for the use of the
> individual to whom it is addressed. Any views or opinions presented are
> solely those of the author and do not necessarily represent those of
> SchlumbergerSema.
> If you are not the intended recipient, be advised that you have received
> this
> email in error and that any use, dissemination, forwarding, printing, or
> copying of this email is strictly prohibited.
>
> If you have received this email in error please notify the
> SchlumbergerSema
> Helpdesk by telephone on +44 (0) 121 627 5600.
> __________________________________________________________________________
> _
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: SARKAR, Samir
> INET: Samir.SARKAR_at_nottingham.sema.slb.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: SARKAR, Samir
> INET: Samir.SARKAR_at_nottingham.sema.slb.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: adary_at_mehish.co.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SARKAR, Samir
  INET: Samir.SARKAR_at_nottingham.sema.slb.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).