RE: RMAN - Some basic Qs.

2003-04-03 Thread Gaja Krishna Vaidyanatha
Vivek, Answers to your questions embedded. You may want to read up on the manuals for more details. BTW, you don't have to copy my e-mail id in your replies, given that I belong to the list, just as many others. I am trying to avoid getting 2 copies of every e-mail that you send. Cheers, Gaja

RE: RMAN - Some basic Qs.

2003-04-02 Thread VIVEK_SHARMA
Gaja , Good indeed to see you back on the List . My Qs. in CAPITALS below :- -Original Message- Sent: Wednesday, April 02, 2003 2:14 AM To: Multiple recipients of list ORACLE-L All, The primary reason why RMAN does not generate excessive redo is because because it does not put the

RMAN - Some basic Qs.

2003-04-01 Thread VIVEK_SHARMA
Qs.1 Why is NO excessive Redo Generated wsing RMAN Backups unlike HOT Backups when taking backup of an OPEN Database which is undergoing User Transactions ? (Or am i mistaken ?) Qs.2 How does RMAN manage Incremental Database Backups ? What is the Concept behing it ? Qs.3 How does RMAN Check

RE: RMAN - Some basic Qs.

2003-04-01 Thread Goulet, Dick
1: RMAN does not generate excessive redo because it does not use the 'alter tablespace ... begin backup' command. It instead coordinates with dbwr, somehow, to be sure it is getting a consistent view of the tablespace. 2: The concept of an incremental backup is that you only backup the

RE: RMAN - Some basic Qs.

2003-04-01 Thread DENNIS WILLIAMS
Vivek 1. RMAN works on an entirely different principle than hot backups. Much more transparent to the database. 2. RMAN incremental backups work by checking if a block has changed since the last incremental backup of the current level or lower. So only changed blocks get backed up on an

RE: RMAN - Some basic Qs.

2003-04-01 Thread Spears, Brian
No excessive Redo ...one of RMans new features.. I will have to write a book here to give you good answers... I would suggest reading the really good cheat sheet on technet on Backup and recovery...they are very good and complete.. If not that just search google for RMAN faq and you

Re: RMAN - Some basic Qs.

2003-04-01 Thread Bong
I need help, I have a procedure to insert xml data into a table. The xml data is store in CLOB, and i user xml parser and DOM to get the value and insert into table. If the file is is under 1 MB, everything is OK. But when the xml size is larger than 1 mb i'll get error message ORA-29532: Java

RE: RMAN - Some basic Qs.

2003-04-01 Thread Ed Bittel
Qs.4 Is it easy to integrate 3rd part tools like Legato etc with RMAN for enabling taking of backups onto backup devices OR does it need an extensive setup ? I found it to be fairly easy to get RMAN working with Legato NetWorker. We had to go through a few hoops to get it working on a Veritas

RE: RMAN - Some basic Qs.

2003-04-01 Thread mail2gkatteri
Answer 1: RMAN keeps track of increasing SCNs of any changing datablock within the datafile being backedup. Hence not much redo. Answers to other questions have been posted by others. HTH GovindanK |XXX| |You should treat

RE: RMAN - Some basic Qs.

2003-04-01 Thread Gaja Krishna Vaidyanatha
All, The primary reason why RMAN does not generate excessive redo is because because it does not put the tablespace in hot backup mode. Thus any blocks belonging to a given tablespace that are modified before the END BACKUP command is processed, do not require block-level before and after images.

Re: RMAN - Some basic Qs.

2003-04-01 Thread AK
In case of hot backup scn at then time of starting backup is frozen in datafile header , and is refreshed at the time of end backup .what happens in RMAN ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 12:43 PM All,