Unix Technical Forum

Setting up Oracle Database for Production

This is a discussion on Setting up Oracle Database for Production within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hello all, I am a beginner in Oracle DBA. I need to setup a oracle database for the production ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database > Oracle Miscellaneous

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-08-2008, 08:19 AM
mjyothi@gmail.com
 
Posts: n/a
Default Setting up Oracle Database for Production

Hello all,

I am a beginner in Oracle DBA.
I need to setup a oracle database for the production Environment.

I have browsed through the net and oracle site. The basic things to
consider will be
1) to set it up in Archive log mode
2) Multiplex the Redo log files
3) Multiplex the control files. (Better to have one in every location
of the Multiplex Redo log file)
4) Redo log files and ARchive logs should be on separate disks
5) Datafiles and Redologs need to be on separate disks


Now i have a Oracle server with a single raid system , c:\ is about 6gb
and d:\ is approx 54 gb.
I installed the oracle server on D:\
and will install the database also on the D:\

I will place the Red log members one on the C:\ and one on the D:\
and the control files one on the c:\ and the other on D:\

Now when it comes to placing the Archive log files, since i have only
two drives c:\ and D:\, i want to place it on the network on different
Location

Questions
-----------
1) is this the right approach to setting up the Production environment
2)I used DBCA to create the database and the DBCA does not allow to
give Network path in the ARchive log destinations file path. (any
suggestions how to place th archive log on the network in a differnent
system).
3) Does any one of you have a template of production qualifications for
Oracle.

Thanks in advance
Regards
Jyothi

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:22 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com