Meng Fangtao
<m.fangtao@gene To: Multiple recipients of list
ORACLE-L
sis.co.nz> <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).