Experienced / Expert level questions & answers
Ques 1. What is Mirrored on-line Redo Log?
A mirrored on-line redo log consists of copies of on-line redo log files physically located on separate disks, changes made to one member of the group are made to all members.
Ques 2. What is a Redo Log?
The set of Redo Log files YSDATE,UID,USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.
Ques 3. What does a Control file Contain?
A Control file records the physical structure of the database. It contains the following information.
Database Name
Names and locations of a database's files and redolog files.
Time stamp of database creation.
Most helpful rated by users:
- What are the components of physical database structure of Oracle database?
- What are the components of logical database structure of Oracle database?
- What is a tablespace?
- What is SYSTEM tablespace and when is it created?
- Explain the relationship among database, tablespace and data file?