Logical and physical Structure

[gdia44]

Hello,

This is my first post to this forum.

I'm working through an exercise where I am required to 'design and describe' the logical and physical structure for a case study.

I've made quite good progress so far.

For logical part I have done the following:

1. ERD diagram
2. Database sizing of all the tables
3. Have talked about the tablespaces that I'm going to need and how big they are going to be
4. Talked about the what block size I'm going to be using

However for the physical side I'm a little confused about what I should be doing. I found another post on this forum which states the physical structures as:

Datafiles - This I understand, I could easily state how big these should be.

Control Files
Redo Log files
Archive log files
Parameter Files
Alert and trace log files
backup files

I'm not sure how I can 'design' these features - aren't these just created automatically when the database is created.

Perhaps I'm missing something obvious here, hopefully someone can point me in the right direction.

[debasisdas]

Your question is too much theoritical and is beyond the scope of this discussion . Please follow some good book for the purpose. Else you can easily find all that by investing some time in web-searching.