Here we are going to see, different types of database creation method,
1. Create a database using manual Method
2. Creating a database using dbca method
3. Creating a database using OMF(Oracle Managed Files) method
Create a database using manual Method
Open dbs location and create Pfile here,
db_name='orcl'
memory_target=300M
processes = 150
audit_file_dest='/u01/app/oracle/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (/u01/app/oracle/oradata/orcl/ora_control1,/u01/app/oracle/flash_recovery_area/orcl/ ora_control2)
compatible ='11.2.0'
Set the environment variable by export var,
Then startup the orcl database like below,
Check the files, status like below,
Check the fuzzy and checkpoint
Fuzzy should be no, and checkpoint should be same for all the datafiles
Check the sequence number for the current log file same
Creating a database using dbca method
Type dbca and open the wizard,
Enable archive log mode,
Creating database using OMF(Oracle Managed Files) method
Create a pfile with below parameters,
db_name=OMF
memory_target=300M
control_files = (‘/u01/app/oracle/oradata/OMF’,‘/u01/app/oracle/flash_recovery_area/OMF’)
db_create_file_dest=/u01/app/oracle/oradata/
db_create_online_log_dest_1=/u01/app/oracle/oradata/
db_create_online_log_dest_2=/u01/app/oracle/OMF/
db_recovery_file_dest=/u01/app/oracle/flash_recovery_area/
db_recovery_file_dest_size=1G
Thank you for reading!!. Please follow up on the next post for learning database operations.