Re: Questions for Oracle creation & Backup

                                                                                       
         
                    Meng Fangtao                                                       
         
                    <m.fangtao_at_gene        To:     Multiple recipients of list 
ORACLE-L         
                    sis.co.nz>             <ORACLE-L_at_fatcity.com>                      
         
                    Sent by:               cc:                                         
         
                    root_at_fatcity.co        Subject:     Questions for Oracle creation 
& Backup  
                    m                                                                  
         
                                                                                       
         
                                                                                       
         
                    25-Jun-2001                                                        
         
                    12:45 PM                                                           
         
                    Please respond                                                     
         
                    to ORACLE-L                                                        
         
                                                                                       
         
                    Sender Info:                                                       
         
                    No Sender Info                                                     
         
                    found in the                                                       
         
                    address Book                                                       
         
                                                                                       
         
                                                                                       
         

Dear Sir/Madam,

   We will migrate Mysql to Oracle soon. Now I have some questions. 1. We have 5 databases in one instance in Mysql. Do we need to create 5 databases
in Oracle, or only one? We have to start 5 instances and assign different sizes of RAM to them If we create 5 databases.

         There are two ways of doing this. One is as explained by you the other is to create diffrent tablespaces and schema's for each of the applications and use only one instance.

2. How do you do daily backup for Oracle? Do you use RMAN and recovery catalog ? The Oracle version we purchase is standard edition. Does It support incremenetal backup?

           No at my work place we do not have any RMAN work. Guess they dont believe in

    using this tool so we use the old, tried and tested method of offline and online backups using the host commands .

3. How do you deal with archived redo log at daytime? Is the archived redo log written into a tape or disk?

          Well we have a separate backup plan for archived redo logs. They are backed up and purged. The frequency of the backup is done based upon the frequency of the archiving.

Thanks in advance.

Meng

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Meng Fangtao
  INET: m.fangtao_at_genesis.co.nz

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).



______________________________________________________________________________________

Visit us at www.singaporeair.com.
______________________________________________________________________________________

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Ravinder_Bahadur_at_singaporeair.com.sg

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).