Question about Oracle RDBMS - help me please?

Hi,

I get constantly confused about Oracle. What is a database and an instance? Which of these stores the "real information"? And what about the redo logs, etc? Can someone help me clarify these please? Many Thinks.

4 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Oracle Database is Oracle Files + Oracle Memory (known as SGA)

    Oracle Instance is Oracle Memory (known as SGA)

    Both store real information

    Oracle database files consists of

    1. Datafile (file that store your records)

    2. Redolog file (and archived redo log files, to undo and redo database changes)

    3. controlfiles (to keep track of oracle status, condition)

    4. and other files (binary file - sqlplus, exp/imp, parameter file - setting of the database, alert files - database activity including error)

    http://e-dba.blogspot.com

  • hyun
    Lv 4
    4 years ago

    Unix isn't a prerequisite for discovering Oracle RDBMS. you need to use homestead windows OS with Oracle RDBMS. here you may get Oracle understanding yet no longer able to apply the OS functionalities greater effectively. In unix, you are able to write an effective shell script for oracle,time table a script in crontab, able to set atmosphere variables for dissimilar databases by skill of working a single shell script, swap between diff clients, and many issues are there. in case you pick to benefit Oracle alongside with OS, initiate utilising unix OS with Oracle RDBMS.

  • Anonymous
    1 decade ago

    Redo-log files are used to record all changes made to the data for use in backup and recovery.

    This link shud help

    http://www.devx.com/dbzone/Article/20713

  • 4 years ago

    What is in a RDBS?

Still have questions? Get your answers by asking now.