This information is stored in control file in oracle. This file contains information binary logs (archive logs in oracle called bin logs in MySQL). It also contains memory settings for the instance and information about remote host for replication of data. It contains information about location of data, archive, redo and other log files. MySQL Database consists of following files:. These logs contains all the transactions including redo statements which are applied to or can be applied to the database. It is a group of redo log files to one or more offline destinations, known collectively as the archived redo log. It’s the main purpose is to recover the database. Names format and location of these files are defined in init.ora file. It stores the data which includes user data and undo data. It holds the information of each and every data file, redo log file locations and backup information starting time and ending time It also contains memory settings for the instance and remote locations. Oracle database consist of following files Physical file architecture comparison is given below, I hope it will be very useful for Oracle or MySQL database administrators who want to learn either of these databases. For Oracle database administrator, when it comes to learn new technology it always starts from comparison with respect to physical or logical architecture.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |