Control file information - Revision history

George2 at 14:11, 19 June 2015

2015-06-19T14:11:59Z

2015-06-19T14:11:02Z

2015-06-19T14:10:16Z

2015-06-19T13:15:15Z

2015-06-19T13:12:48Z

2015-06-19T13:12:39Z

2015-06-19T13:12:22Z

2015-06-19T13:12:13Z

2015-06-19T13:11:57Z

2015-06-19T13:10:59Z

@@ Line 38: / Line 38: @@
 Example:
-ALTER DATABASE BACKUP CONTROLFILE TO ‘/a02/oradata/backup/control.bkp’;
+Now use an SQL statement to produce a trace file (write a SQL script to the trace file) that can be edited and used to reproduce the control file.<br>
-Now use an SQL statement to produce a trace file (write a SQL script to the trace file) that can be edited and used to reproduce the control file.
+ALTER DATABASE BACKUP CONTROLFILE TO TRACE;<br>
-−
-−
-−
 ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

@@ Line 28: / Line 28: @@
 Checkpoint information -  recorded as checkpoints are made.<br>
-'''Backup Control Files and Creating Additional Control Files
+'''Backup Control Files and Creating Additional Control Files '''<br>
-'''
+Oracle recommends backup of control files every time the physical database structure changes including:<br>
-Oracle recommends backup of control files every time the physical database structure changes including:
+*        Adding, dropping, or renaming datafiles.
-·        Adding, dropping, or renaming datafiles.
+*        Adding or dropping a tablespace, or altering the read/write state of a tablespace.
-·        Adding or dropping a tablespace, or altering the read/write state of a tablespace.
+*        Adding or dropping redo log files or groups.
-·        Adding or dropping redo log files or groups.

← Older revision		Revision as of 14:10, 19 June 2015
Line 27:		Line 27:
	Current log sequence number - recorded when log switches occur.<br>		Current log sequence number - recorded when log switches occur.<br>
	Checkpoint information - recorded as checkpoints are made.<br>		Checkpoint information - recorded as checkpoints are made.<br>
		+
		+	'''Backup Control Files and Creating Additional Control Files
		+	'''
		+	Oracle recommends backup of control files every time the physical database structure changes including:
		+	· Adding, dropping, or renaming datafiles.
		+	· Adding or dropping a tablespace, or altering the read/write state of a tablespace.
		+	· Adding or dropping redo log files or groups.
		+
		+
		+	Use the ALTER DATABASE BACKUP CONTROL file statement to backup control files.
		+
		+	Example:
		+
		+	ALTER DATABASE BACKUP CONTROLFILE TO ‘/a02/oradata/backup/control.bkp’;
		+
		+	Now use an SQL statement to produce a trace file (write a SQL script to the trace file) that can be edited and used to reproduce the control file.
		+
		+
		+
		+	ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

← Older revision		Revision as of 13:15, 19 June 2015
Line 12:		Line 12:
	* MAXDATAFILES		* MAXDATAFILES
	* MAXINSTANCES		* MAXINSTANCES
		+
		+	'''Contents of a Control File'''<br>
		+
		+	Control files record the following information:<br>
		+
		+	Database name recorded as specified by the initialization parameter DB_NAME or the name used in the CREATE DATABASE statement.<br>
		+	Database identifier recorded when the database is created.<br>
		+	Time stamp of database creation.<br>
		+	Names and locations of datafiles and online redo log files. This information is updated if a datafile or redo log is added to, renamed in, or dropped from the database.<br>
		+	Tablespace information. This information is updated as tablespaces are added or dropped.<br>
		+	Redo log history - recorded during log switches.<br>
		+	Location and status of archived logs - recorded when archiving occurs.<br>
		+	Location and status of backups - recorded by the Recovery Manager utility.<br>
		+	Current log sequence number - recorded when log switches occur.<br>
		+	Checkpoint information - recorded as checkpoints are made.<br>

@@ Line 3: / Line 3: @@
 V$CONTROLFILE_RECORD_SECTION -   Provides  information about the control file record sections.<BR>
->show parameters control_file<br>
+> show parameters control_file<br>
 While control files are small, the size of the file can be significantly influenced by the following CREATE DATABASE or CREATE CONTROLFILE command parameters if they have large values. <br>

@@ Line 9: / Line 9: @@
 *      MAXLOGFILES
 *      MAXLOGMEMBERS
-*       MAXLOGHISTORY
+*      MAXLOGHISTORY
-*       MAXDATAFILES
+*      MAXDATAFILES
-*       MAXINSTANCES
+*      MAXINSTANCES

← Older revision		Revision as of 13:10, 19 June 2015
Line 4:		Line 4:

	show parameters control_file<br>		show parameters control_file<br>
		+
		+	While control files are small, the size of the file can be significantly influenced by the following CREATE DATABASE or CREATE CONTROLFILE command parameters if they have large values. <br>
		+
		+	- MAXLOGFILES
		+	- MAXLOGMEMBERS
		+	o MAXLOGHISTORY
		+	o MAXDATAFILES
		+	o MAXINSTANCES