Create new control file oracle 11gr2

Here is an example of a new control file for Oracle 11gR2:

# Control File for Oracle 11gR2

# File name: init.ora
# Created on: [current date and time]

# Database name
db_name = "MYDB"

# Database character set
db_char = "AL32UTF8"

# National character set
nchar = "AL16UTF16"

# Default temporary tablespace
temp_tablespace = "TEMP"

# Default permanent tablespace
default_tablespace = "USERS"

# Control file location
control_files = ("init.ora", "control01.ctl", "control02.ctl")

# Archive log destination
log_archive_dest = "LOCATION=/oracle/archivelog"

# Redo log size
log_file_size = 100M

# Redo log groups
log_groups = 2

# Redo log members
log_members = 2

# Archive log mode
log_archive_mode = "FORCE"

# Flashback database
flashback_database = "ON"

# Flashback retention
flashback_retention = 7

# Undo management
undo_management = "AUTO"

# Undo retention
undo_retention = 900

# Database block size
db_block_size = 8192

# Database block heap size
db_block_heap_size = 1048576

# Database file multiplexing
file_multiplexing = "ON"

# Database file names
db_files = ("MYDB01.dbf", "MYDB02.dbf", "MYDB03.dbf")

# Database file sizes
db_file_sizes = (100M, 100M, 100M)

# Database file autoextend
db_file_autoextend = "ON"

# Database file autoextend size
db_file_autoextend_size = 10M

# Database file maxsize
db_file_maxsize = 1000M

# Oracle Net configuration
net_config = "LISTENER = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))"

# Oracle Net service name
net_service_name = "MYDB"

# Oracle Net service description
net_service_description = "MYDB Service"

Note:

• The db_name parameter specifies the name of the database.
• The db_char and nchar parameters specify the character sets used by the database.
• The temp_tablespace and default_tablespace parameters specify the default temporary and permanent tablespaces.
• The control_files parameter specifies the locations of the control files.
• The log_archive_dest parameter specifies the destination for archived redo logs.
• The log_file_size and log_groups parameters specify the size and number of redo log groups.
• The log_members parameter specifies the number of redo log members.
• The log_archive_mode parameter specifies the archive log mode.
• The flashback_database and flashback_retention parameters specify the flashback database and retention settings.
• The undo_management and undo_retention parameters specify the undo management and retention settings.
• The db_block_size and db_block_heap_size parameters specify the database block size and heap size.
• The file_multiplexing parameter specifies whether file multiplexing is enabled.
• The db_files and db_file_sizes parameters specify the names and sizes of the database files.
• The db_file_autoextend and db_file_autoextend_size parameters specify whether and how the database files are autoextended.
• The db_file_maxsize parameter specifies the maximum size of the database files.
• The net_config and net_service_name parameters specify the Oracle Net configuration and service name.
• The net_service_description parameter specifies the service description.

Please note that this is just an example and you should adjust the parameters according to your specific Oracle database configuration and requirements.