ORA-01967: invalid option for CREATE CONTROLFILE
Cause: An invalid CREATE CONTROLFILE option is present.
Action: Specify only valid CREATE CONTROLFILE options.
Cause: An invalid CREATE CONTROLFILE option is present.
Action: Specify only valid CREATE CONTROLFILE options.
first shutdown database > shutdown immediate;
ReplyDeletethen start again >startup
now run controlfile query it can be created successfully
but you need to again shutdown and startup database
at the time of startup RESETLOGS OR NORESETLOGS error will show.
now just type after that : alter database open resetlogs;
again shutdown and startup and yupp your done..! thanx
for reference click below link
https://oracle-techno.blogspot.com/2018/08/ora-01967-invalid-option-for-create.html