RE: rman backup

2004-01-19 Thread Rich Holland
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: Tuesday, October 28, 2003 3:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: rman backup AK When you have RMAN back up archived logs, IIRC, in a recovery RMAN first restores those

Table recovery from RMAN backup

2003-12-12 Thread jaysingh1
Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat

Re: Table recovery from RMAN backup

2003-12-12 Thread Andy Rivenes
Take a look at TSPITR (tablespace point in time recovery), I believe that's how it's performed as I've never tried it. Essentially RMAN creates a temporary database, recovers the objects in the tablespace targeted for recovery, and then you can recover the data in the object(s) in question. At

Re: Table recovery from RMAN backup

2003-12-12 Thread Mladen Gogala
Jay, if it is 9.2.0.4 and if you have undo_retention set, you can do a flashback query. If not, you must recover the database to the specific time, you cannot recover just a single table. You should probably read the TSPITR recovery chapter in Rob Freeman's book. I have, a long time ago, but I've

RE: Table recovery from RMAN backup

2003-12-12 Thread Josh Collier
Metalink Note:223543.1 has good information on how to recover just a single table using a modified TSPITR. I performed this operation successful on a data warehouse. Josh -Original Message- Sent: Friday, December 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Jay, if it is

Re: Table recovery from RMAN backup

2003-12-12 Thread jaysingh1
Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami - Original Message - Date: Friday, December 12, 2003 11:34 am Take a look at TSPITR (tablespace point

Re: Table recovery from RMAN backup

2003-12-12 Thread Tanel Poder
Hi! I believe flashback query works only on existing tables, you can query deleted data from it for example, but you can't see dropped tables with it. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 12, 2003 6:59 PM Jay,

Re: Table recovery from RMAN backup

2003-12-12 Thread Simon . Anderson
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Table recovery from RMAN backup Hi! I believe flashback query works only on existing tables, you can query deleted data from it for example, but you can't see dropped tables with it. Tanel. -- Please

Re: Table recovery from RMAN backup

2003-12-12 Thread Andy Rivenes
The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I

Re: Table recovery from RMAN backup

2003-12-12 Thread Mladen Gogala
Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for useful examples and explanations. Robert's very clear and to the point style of

Re: Table recovery from RMAN backup

2003-12-12 Thread Joe Testa
Mladen I'll send you $10 payment fee via paypal :) joe Mladen Gogala wrote: Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for

Re: Table recovery from RMAN backup

2003-12-12 Thread Ron Rogers
Sami, While you are purchasing the reading material also look at the 101 series as excellent references. Oracle Performance tuning 101, Oracle dba 101, Oracle backup and recovery 101.There are a lot of excellent references on the market and a lot of authors participate on this list. You can

Re: Table recovery from RMAN backup

2003-12-12 Thread Michael Thomas
My Question: I just tried to locate the web site for Joe's scripts, and I got an error or something. Wasssup? My Contribution (xmas season and all...): http://www.secunia.com/internet_explorer_address_bar_spoofing_test Is it too early to wish merry xmas to all? Thanks in advance. Regards, Mike

rman backup

2003-10-28 Thread AK
We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible

RE: rman backup

2003-10-28 Thread DENNIS WILLIAMS
recovery times. You will see that RMAN will not complete its recovery if the archived logs are not available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We take daily rman backup

Re: rman backup

2003-10-28 Thread Mladen Gogala
take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run

Re: rman backup

2003-10-28 Thread AK
recipients of list ORACLE-L We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell

RE: rman backup

2003-10-28 Thread Ruth Gramolini
: Tuesday, October 28, 2003 12:44 PMTo: Multiple recipients of list ORACLE-LSubject: rman backup We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using

RE: rman backup

2003-10-28 Thread DENNIS WILLIAMS
logs are not available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now

RE: AW: RMAN Backup to tape or disk (SAN) ???

2003-09-18 Thread Craig Munday
Hi, If I remember correctly MMLs like Veritas and/or Legato let you rebuild the indexes if you have the tape in hand - It can be slow but I thought it could be done. Regard, Craig. At 09:46 AM 8/05/2003 -0800, Stephen Lee wrote: One consideration with MML if this is a case of a tornado

Re: Checking RMAN backup results

2003-09-17 Thread Yechiel Adar
,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- Sent: Wednesday, September 10, 2003 11:13 AM Subject: Checking RMAN backup results Before I reinvent the wheel, I thought I'd ping the list to see how other folks are validating their RMAN backups

RE: Checking RMAN backup results

2003-09-17 Thread Paula_Stankus
Title: RE: Checking RMAN backup results Alghough I use the RMAN catalog and so backup success/failure can be seen from there. I find it easiest to write out a log of the entire backup process in my calling script to a specific directory /dblogs/backups All my backup scripts are written

RE: Checking RMAN backup results

2003-09-17 Thread Mercadante, Thomas F
Message- Sent: Wednesday, September 10, 2003 11:13 AM Subject: Checking RMAN backup results Before I reinvent the wheel, I thought I'd ping the list to see how other folks are validating their RMAN backups. In other words, when your backup_full script runs, do you just parse

FWD: Checking RMAN backup results

2003-09-16 Thread Bruce A. Bergman
PROTECTED] SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- Sent: Wednesday, September 10, 2003 11:13 AM Subject: Checking RMAN backup results Before I reinvent the wheel, I thought I'd ping the list to see how

RE: RMAN backup and recovery scenarios

2003-09-04 Thread DENNIS WILLIAMS
and refresh myself now and then. - Oracle9i RMAN Backup Recovery by Robert Freeman - I found Oracle 101 Backup Recovery (Smith and Haisley) helpful to get started. About half of it is RMAN. It has very simple tutorials that you can follow step-by-step to understand the basic RMAN

RE: RMAN backup and recovery scenarios

2003-09-04 Thread Ruth Gramolini
, September 04, 2003 2:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup and recovery scenarios Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L

RE: RMAN backup and recovery scenarios

2003-09-04 Thread Freeman Robert - IL
My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter devoted to case studies and RMAN. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/4/2003 11:44 AM Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1

RE: RMAN backup and recovery scenarios

2003-09-04 Thread GovindanK
the internals etc. Go thru Recovery principles, Case Studies by Rama Velpuri. (Add RF's book too). Try doing the same with Standby too. HTH GovindanK My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter devoted to case studies and RMAN. RF -Original Message

Re: RE: RMAN backup and recovery scenarios

2003-09-04 Thread Prem Khanna J
Thanx Dennis,Robert,and Ruth. I'm going thro' Roberts's book now. as Robert said, it has a dedicated chapter for that. ...and i'm trying all the scenarios one by one . but just thought, i could some more inputs from you Gurus. thanx a lot guys. I will continue with the book. Regards, Jp. --

RMAN backup and recovery scenarios

2003-09-03 Thread Prem Khanna J
Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RMAN Backup piece being placed in wrong directory

2003-08-14 Thread Stefick Ronald S Contr ESC/HRIDD
Title: Message OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{set archivelog destination to 'D:\backup\oracle\Hotbackup';set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak';backup database

RE: RMAN Backup piece being placed in wrong directory

2003-08-14 Thread Freeman Robert - IL
Good point Tom RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/7/2003 1:29 PM Ronald, It looks like just the archivelog was not going into the correct directory, right? But then you did *not* include a format clause for the archivelog. Looking at the

RE: RMAN Backup piece being placed in wrong directory

2003-08-14 Thread Freeman Robert - IL
Syntax error: backup database format = 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; add the = after the format and it should run. RMAN is trying to help you by ignoring this error and proceeding to backup the database to the default location. RF -Original

FW: RMAN Backup piece being placed in wrong directory

2003-08-10 Thread Stefick Ronald S Contr ESC/HRIDD
Title: Message Robert? Dennis? Anyone? -Original Message-From: Stefick Ronald S Contr ESC/HRIDD Sent: Thursday, August 07, 2003 9:24 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN Backup piece being placed in wrong directory OS: Win2K DB: 8.1.7.4 All, Here is what

RE: RMAN Backup piece being placed in wrong directory

2003-08-08 Thread Stefick Ronald S Contr ESC/HRIDD
: Multiple recipients of list ORACLE-LSubject: RE: RMAN Backup piece being placed in wrong directory Ronald, It looks like just the archivelog was not going into the correct directory, right? But then you did *not* include a format clause for the archivelog. Looking at the docs

RE: RMAN Backup piece being placed in wrong directory

2003-08-07 Thread Mercadante, Thomas F
Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 1:15 PMTo: Multiple recipients of list ORACLE-LSubject: FW: RMAN Backup piece being placed in wrong directory Robert? Dennis? Anyone? -Original Message-From: Stefick Ronald S Contr ESC

RMAN backup with MULTIPLE CHANNELS ......

2003-02-20 Thread Janardhana Babu Donga
Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why

RE: RMAN backup with MULTIPLE CHANNELS ......

2003-02-20 Thread DENNIS WILLIAMS
changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels

RE: RMAN backup with MULTIPLE CHANNELS ......

2003-02-20 Thread Janardhana Babu Donga
RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced

RE: RMAN backup with MULTIPLE CHANNELS ......

2003-02-20 Thread Jared . Still
of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup with MULTIPLE CHANNELS .. Dennis, Thanks for your reply. Iam taking tape backup with 3 channels as we have multiple tape drives. I don't know where the bottleneck is. In the RMAN output I see it is using all

RE: RMAN backup with MULTIPLE CHANNELS ......

2003-02-20 Thread Janardhana Babu Donga
: Subject:RE: RMAN backup with MULTIPLE CHANNELS .. Dennis, Thanks for your reply. Iam taking tape backup with 3 channels as we have multiple tape drives. I don't know where the bottleneck is. In the RMAN output I see it is using all the three channels simultaneously with 10 datafiles per

RE: RMAN backup with MULTIPLE CHANNELS ......

2003-02-20 Thread Binley Lim
% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount

RE: RMAN backup with MULTIPLE CHANNELS ......

2003-02-20 Thread Mandar A. Ghosalkar
ORACLE-L Subject: RMAN backup with MULTIPLE CHANNELS .. Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates

RE: RMAN backup with MULTIPLE CHANNELS ......

2003-02-20 Thread Jared . Still
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup with MULTIPLE CHANNELS .. Jared, Please let me know what info you need. I would collect it from my Netbackup administrator and let you know. Thanks, -- Babu -Original

RE: RMAN backup with MULTIPLE CHANNELS ......

2003-02-20 Thread Janardhana Babu Donga
ORACLE-L Subject: RMAN backup with MULTIPLE CHANNELS .. Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output

RMAN backup/restore to disk on 600G - terabyte Databases?? SPEED?

2003-01-30 Thread Spears, Brian
Hi, I looking at implementing RMAN backup and recovery to disk (fast disk) on a high avail. system...so recovery time is crucial.. Anybody know how fast I might restore a full backup of a 600gig to a Terabyte database. The machine probably will have 10+ cpus HP machine and EMC disk

RE: RMAN backup/restore to disk on 600G - terabyte Databases?? SP

2003-01-30 Thread Koivu, Lisa
Title: RE: RMAN backup/restore to disk on 600G - terabyte Databases?? SPEED? Brian, If time is of the essence and you have EMC BCV's, look at Time Finder. I believe that's EMC's piece of software that allows you to sync and split a third mirror. That will be much faster for recovery than

RE: RMAN backup/restore to disk on 600G - terabyte Databases?? SP

2003-01-30 Thread Muqthar Ahmed
; Thanks Muqthar Ahmed DBA -Original Message- Sent: Thursday, January 30, 2003 11:21 AM To: Multiple recipients of list ORACLE-L SPEED? Hi, I looking at implementing RMAN backup and recovery to disk (fast disk) on a high avail. system...so recovery time is crucial.. Anybody know how

RE: RMAN backup - basic Qs

2003-01-17 Thread Mercadante, Thomas F
I stand corrected. thanks Robert. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 16, 2003 3:20 PM To: Multiple recipients of list ORACLE-L RMAN does no compression on any blocks with data. The only compression that occurs that blocks above the

RE: RMAN backup - basic Qs

2003-01-17 Thread Deshpande, Kirti
Also, RMAN can do incremental backups, copying only the blocks that changed since last backup. More about all this in Oracle Manuals and in Robert's book. - Kirti -Original Message- Sent: Thursday, January 16, 2003 10:04 PM To: Multiple recipients of list ORACLE-L Maria -

RMAN backup - basic Qs

2003-01-16 Thread VIVEK_SHARMA
Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: RMAN backup - basic Qs

2003-01-16 Thread Mercadante, Thomas F
No. Because Rman is not placing the tablespaces in a HOT BACKUP mode. Rman is simply reading the blocks, compressing them, and writing them to tape. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 16, 2003 12:35 PM To: Multiple recipients of

Re: RMAN backup - basic Qs

2003-01-16 Thread Ruth Gramolini
Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple

RE: RMAN backup - basic Qs

2003-01-16 Thread Freeman Robert - IL
RMAN does no compression on any blocks with data. The only compression that occurs that blocks above the HWM are not included. No compression of data occurs, and in fact empty blocks can and are backed up by RMAN. RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts

RE: RMAN backup - basic Qs

2003-01-16 Thread Chris Stephens
Title: RE: RMAN backup - basic Qs what happens when a 'snapshot too old' situation occurs??...how can RMAN produce a valid backup in that case? many i'm missing something. -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 1:54 PM

RE: RMAN backup - basic Qs

2003-01-16 Thread Jared . Still
of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup - basic Qs what happens when a 'snapshot too old' situation occurs??...how can RMAN produce a valid backup in that case? many i'm missing something. -Original Message- Sent: Thursday, January 16, 2003

RE: RMAN backup - basic Qs

2003-01-16 Thread Rajesh . Rao
To better answer the original question, my understanding of this difference is as under: Why do you put the tablespace in backup mode during normal hot backups without RMAN? This is to avoid backing up split blocks. Say, you have a database with a block size of 16K. And that a block is in the

Re: RMAN backup - basic Qs

2003-01-16 Thread Maria Aurora VT de la Vega
does this make RMAN hot backups faster or slower than when backing up file in backup mode? [EMAIL PROTECTED] wrote: To better answer the original question, my understanding of this difference is as under: Why do you put the tablespace in backup mode during normal hot backups without RMAN?

RE: RMAN backup - basic Qs

2003-01-16 Thread DENNIS WILLIAMS
Maria - Definitely faster. Often hot backups can generate additional redo. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 16, 2003 9:24 PM To: Multiple recipients of list ORACLE-L does this make RMAN hot backups faster or

Restoring DB from specific RMAN backup set.

2002-12-19 Thread Paul Heely
How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset

Re: Restoring DB from specific RMAN backup set.

2002-12-19 Thread Ruth Gramolini
the documentation and if that doesn't help, open a TAR,' HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 10:39 AM How can I restore a database from a specific RMAN backup set? We have a database running

RE: Restoring DB from specific RMAN backup set.

2002-12-19 Thread DENNIS WILLIAMS
of list ORACLE-L How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB ID

RE: Restoring DB from specific RMAN backup set.

2002-12-19 Thread Paul Heely
To: Multiple recipients of list ORACLE-L How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc

RE: Restoring DB from specific RMAN backup set.

2002-12-19 Thread Jared . Still
:RE: Restoring DB from specific RMAN backup set. Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode. The database is being backed up using RMAN: I.e. set ORACLE_SID=DB2 rman target / catalog rman@otherdb shutdown immediate; startup mount; backup

RE: Restoring DB from specific RMAN backup set.

2002-12-19 Thread Paul Heely
: Subject:RE: Restoring DB from specific RMAN backup set. Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode. The database is being backed up using RMAN: I.e. set ORACLE_SID=DB2 rman target / catalog rman@otherdb shutdown immediate

RE: Restoring DB from specific RMAN backup set.

2002-12-19 Thread Whittle Jerome Contr NCI
Title: RE: Restoring DB from specific RMAN backup set. Jared, LOL. Sounds like Abbot and Costello doing the DBA version of 'Who's on First'. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: [EMAIL PROTECTED

RE: Restoring DB from specific RMAN backup set.

2002-12-19 Thread John Weatherman
10:17 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Restoring DB from specific RMAN backup set. Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode

Re: Problem doing RMAN backup of Clone?

2002-11-27 Thread Doug C
, and new dbid) HTH Mike Hand Polaroid Corp. -Original Message- Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so

Re: Problem doing RMAN backup of Clone?

2002-11-26 Thread Ruth Gramolini
-Original Message- Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please

RE: Problem doing RMAN backup of Clone?

2002-11-26 Thread Ron Yount
To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Jack van Zanen
Create the clone using RMAN duplicate command. Than it gets new ID -Original Message- Sent: maandag 25 november 2002 4:14 To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Koivu, Lisa
Title: RE: Problem doing RMAN backup of Clone? Hi Doug, I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 5259 Coconut Creek

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Jeremiah Wilton
of the database. Have you tried that? -Original Message- From: Doug C [SMTP: ] Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? -- Please see the official

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Farnsworth, Dave
Title: RE: Problem doing RMAN backup of Clone? Good to hear from you Lisa!! Welcome Back!! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, November 25, 2002 7:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Problem doing RMAN backup

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Hand, Michael T
-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug ** @@ This transmission is intended only for use by the addressee(s) named herein and may contain

Re: Problem doing RMAN backup of Clone?

2002-11-25 Thread orafaq
you tried that? -Original Message- From: Doug C [SMTP: ] Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? -- Please see the official ORACLE-L

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Stephen Lee
database. 2. Use a different schema in the same catalog database (for example rman_prod and rman_test schemas). 3. Don't use a catalog, and rely entirely on the control files as your catalog. -Original Message- Someone has just told me you can't do an RMAN backup of a clone because

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Freeman, Robert
) use the procedure sys.dbms_backup_restore.zerodbid. This is documented in page 395 of my RMAN Backup and Recovery book. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah

Problem doing RMAN backup of Clone?

2002-11-24 Thread Doug C
Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat

Re: RMAN backup

2002-11-18 Thread Ruth Gramolini
Subject: Re: RMAN backup How about switching to incremental (from "full") backups? Even if all youdo are level-0 backups?My understanding of the difference between a "full" and a "level-0" backup(besides the obvious impact on any subsequent level-n incre

RE: RMAN backup

2002-11-18 Thread DENNIS WILLIAMS
Joe - Which type of RMAN backup are you doing? If you are doing RMAN datafile backups, then the size of your datafiles matter. If you are using the RMAN backup command, you are creating RMAN backup pieces. RMAN backup pieces contain parts of several data files, and you can't control that. You can

Re: RMAN backup

2002-11-16 Thread Tim Gorman
How about switching to incremental (from full) backups? Even if all you do are level-0 backups? My understanding of the difference between a full and a level-0 backup (besides the obvious impact on any subsequent level-n incremental backups) is that level-0 backups only back up database blocks

Re: RMAN backup

2002-11-16 Thread Joe Testa
Tim, i'd be glad to hear someone else verify your statement as my understanding is the the only difference between full and level 0 is that full cannot be used as part of an incremental strategy, other than that they both back up the ever used blocks. Anyone else care to jump in on this one?

RE: RMAN backup

2002-11-16 Thread Ron/Sarah Yount
Joe Tim, It is accurate to state the both full and level 0 have the same impact on the database, and both backup all used blocks. It is also accurate that a full backup cannot be used as a piece of an incremental strategy. Although there may be rare instances (no pun intended :-) ) when you

RMAN backup

2002-11-15 Thread Rajesh . Rao
Hello All, Is resizing the datafiles the only way of reducing the size of an RMAN full backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the size of the backup has grown considerably. There's one large table which we were considering truncating. But looks like that would not

RE: Oracle9i RMAN Backup and Recovery

2002-10-11 Thread Freeman, Robert
of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle9i RMAN Backup and Recovery Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http

Oracle9i RMAN Backup and Recovery

2002-10-10 Thread Freeman, Robert
Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy! Robert Robert G. Freeman - Oracle OCP Oracle

RE: Oracle9i RMAN Backup and Recovery

2002-10-10 Thread Deshpande, Kirti
Congratulations, Robert!! Looking forward to receiving my copy... - Kirti -Original Message- Sent: Thursday, October 10, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample

RE: Oracle9i RMAN Backup and Recovery

2002-10-10 Thread Freeman, Robert
9:59 AM To: Multiple recipients of list ORACLE-L Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy

Re: Oracle9i RMAN Backup and Recovery

2002-10-10 Thread Jared . Still
Backup and Recovery Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy! Robert Robert G. Freeman

RE: Should I post a preview of Oracle9i RMAN Backup and Recovery

2002-09-27 Thread Abdul Aleem
Sure, do post it Aleem -Original Message- Sent: Friday, September 27, 2002 1:31 AM To: Multiple recipients of list ORACLE-L Subject:Should I post a preview of Oracle9i RMAN Backup and Recovery Hand I was wondering if anyone would be interested in me posting one chapter

RE: Should I post a preview of Oracle9i RMAN Backup and Recovery Hand

2002-09-27 Thread Alexandre Gorbatchev
One more vote for it -Original Message- Robert Sent: Thursday, September 26, 2002 10:31 PM To: Multiple recipients of list ORACLE-L Hand I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't

Re: Should I post a preview of Oracle9i RMAN Backup and Recovery

2002-09-27 Thread Joe Testa
yea i'm interested by all means. joe Freeman, Robert wrote: I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So

Re: Should I post a preview of Oracle9i RMAN Backup and Recovery

2002-09-27 Thread Joe Testa
yea i'm interested by all means. joe Freeman, Robert wrote: I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So

Re: Should I post a preview of Oracle9i RMAN Backup and Recovery Hand

2002-09-27 Thread Ruth Gramolini
Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too

RE: Should I post a preview of Oracle9i RMAN Backup and Recovery

2002-09-27 Thread Freeman, Robert
: Thursday, September 26, 2002 4:30 PM I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks

Re: Should I post a preview of Oracle9i RMAN Backup and Recovery Hand

2002-09-27 Thread BigP
recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 4:30 PM I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like

RE: Should I post a preview of Oracle9i RMAN Backup and Recovery

2002-09-27 Thread Wong, Bing
one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long

Should I post a preview of Oracle9i RMAN Backup and Recovery Hand

2002-09-26 Thread Freeman, Robert
I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you

RE: Should I post a preview of Oracle9i RMAN Backup and Recovery

2002-09-26 Thread DENNIS WILLIAMS
be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long

  1   2   >