SYS@D1123 SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

SYS@D1123 SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SYS@D1123 SQL> create pfile from spfile;

File created.

D:\app\oradata>pscp -r D1123 oracle@myhost:/oracle/app/oracle/oradata
O1_MF_G6XOV8SW_.CTL       | 9520 kB | 4760.0 kB/s | ETA: 00:00:00 | 100%
O1_MF_G6XOVR6V_.CTL       | 9520 kB | 9520.0 kB/s | ETA: 00:00:00 | 100%
O1_MF_SYSAUX_G6XOOTMZ_.DB | 522248 kB | 5934.6 kB/s | ETA: 00:00:00 | 100%
O1_MF_SYSTEM_G6XOOTKC_.DB | 727048 kB | 5770.2 kB/s | ETA: 00:00:00 | 100%
O1_MF_TEMP_G6XOW6MO_.TMP  | 29704 kB | 4950.7 kB/s | ETA: 00:00:00 | 100%
O1_MF_UNDOTBS1_G6XOOTNB_. | 76808 kB | 5908.3 kB/s | ETA: 00:00:00 | 100%
O1_MF_USERS_G6XOOTO0_.DBF | 5128 kB | 5128.0 kB/s | ETA: 00:00:00 | 100%
O1_MF_1_G6XOVVNX_.LOG     | 51200 kB | 6400.1 kB/s | ETA: 00:00:00 | 100%
O1_MF_2_G6XOVY1L_.LOG     | 51200 kB | 5688.9 kB/s | ETA: 00:00:00 | 100%
O1_MF_3_G6XOVZ15_.LOG     | 51200 kB | 5688.9 kB/s | ETA: 00:00:00 | 100%

[oracle@myhost D1123]$ vi genren.sql
[oracle@myhost D1123]$ mkdir -p /oracle/app/oracle/admin/D1123/adump
[oracle@myhost D1123]$ vi `dbhome`/dbs/initD1123.ora
[oracle@myhost D1123]$ vi /etc/oratab
[oracle@myhost D1123]$
[oracle@myhost D1123]$
[oracle@myhost D1123]$ . oraenv
ORACLE_SID = [oimrep] ? D1123
The Oracle base remains unchanged with value /oracle/app/oracle
[oracle@myhost D1123]$ orapwd file=`dbhome`/dbs/orapw$ORACLE_SID force=y password=manager
[oracle@myhost D1123]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Feb 21 20:11:15 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 5110898688 bytes
Fixed Size                  2262088 bytes
Variable Size            1006635960 bytes
Database Buffers         4093640704 bytes
Redo Buffers                8359936 bytes
Database mounted.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
D:\APP\ORADATA\D1123\DATAFILE\O1_MF_SYSTEM_G6XOOTKC_.DBF
D:\APP\ORADATA\D1123\DATAFILE\O1_MF_SYSAUX_G6XOOTMZ_.DBF
D:\APP\ORADATA\D1123\DATAFILE\O1_MF_UNDOTBS1_G6XOOTNB_.DBF
D:\APP\ORADATA\D1123\DATAFILE\O1_MF_USERS_G6XOOTO0_.DBF

SQL> alter database backup controlfile to trace;
SQL> exit
[oracle@myhost trace]$ cd /oracle/app/oracle/diag/rdbms/d1123/D1123/trace
[oracle@myhost trace]$ ls -latr
...
-rw-r-----  1 oracle oinstall   896 Feb 21 20:11 D1123_mman_14246.trc
drwxr-xr-x  2 oracle oinstall  4096 Feb 21 20:41 .
-rw-r-----  1 oracle oinstall   163 Feb 21 20:41 D1123_ora_15051.trm
-rw-r-----  1 oracle oinstall  6744 Feb 21 20:41 D1123_ora_15051.trc
-rw-r-----  1 oracle oinstall 20525 Feb 21 20:41 alert_D1123.log
[oracle@myhost trace]$ cp D1123_ora_15051.trc /tmp/mkctl.sql
[oracle@myhost trace]$ vi /tmp/mkctl.sql
[oracle@myhost trace]$ cat /tmp/mkctl.sql
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "D1123" NORESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/oracle/app/oracle/oradata/D1123/ONLINELOG/O1_MF_1_G6XOVVNX_.LOG'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/oracle/app/oracle/oradata/D1123/ONLINELOG/O1_MF_2_G6XOVY1L_.LOG'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/oracle/app/oracle/oradata/D1123/ONLINELOG/O1_MF_3_G6XOVZ15_.LOG'  SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/oracle/app/oracle/oradata/D1123/DATAFILE/O1_MF_SYSTEM_G6XOOTKC_.DBF',
  '/oracle/app/oracle/oradata/D1123/DATAFILE/O1_MF_SYSAUX_G6XOOTMZ_.DBF',
  '/oracle/app/oracle/oradata/D1123/DATAFILE/O1_MF_UNDOTBS1_G6XOOTNB_.DBF',
  '/oracle/app/oracle/oradata/D1123/DATAFILE/O1_MF_USERS_G6XOOTO0_.DBF'
CHARACTER SET AL32UTF8
;
SQL> create spfile from pfile;

File created.
-- так как у меня OMF файлы, то удаляю параметр controlfile для создания controlfile
-- если non-OMF то этого делать не нужно

SQL> startup nomount
...
SQL> alter system reset control_files scope=spfile;

System altered.

SQL> shutdown abort
ORACLE instance shut down.
SQL> !
[oracle@myhost trace]$ rm -f /oracle/app/oracle/oradata/D1123/CONTROLFILE/O1_MF_G6XOV*
[oracle@myhost trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Feb 21 20:50:11 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> @ /tmp/mkctl
ORA-01081: cannot start already-running ORACLE - shut it down first

Control file created.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/oracle/app/oracle/oradata/D1123/DATAFILE/O1_MF_SYSTEM_G6XOOTKC_.DBF
/oracle/app/oracle/oradata/D1123/DATAFILE/O1_MF_SYSAUX_G6XOOTMZ_.DBF
/oracle/app/oracle/oradata/D1123/DATAFILE/O1_MF_UNDOTBS1_G6XOOTNB_.DBF
/oracle/app/oracle/oradata/D1123/DATAFILE/O1_MF_USERS_G6XOOTO0_.DBF

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/oracle/app/oracle/oradata/D1123/ONLINELOG/O1_MF_2_G6XOVY1L_.LOG
/oracle/app/oracle/oradata/D1123/ONLINELOG/O1_MF_1_G6XOVVNX_.LOG
/oracle/app/oracle/oradata/D1123/ONLINELOG/O1_MF_3_G6XOVZ15_.LOG

SQL> set line 150
SQL> select * from (select 
	hxfil file#
	,fhscn checkpoint_change#
	,fhafs Absolute_Fuzzy_SCN 
from x$kcvfh
union all
select 
	999999
	,to_char(current_scn,'999999999999999')
	,log_mode
from v$database
)
order by 1;
     FILE# CHECKPOINT_CHANGE#                               ABSOLUTE_FUZZY_SCN
---------- ------------------------------------------------ ------------------------------------------------
         1 1047603                                          0
         2 1047603                                          0
         3 1047603                                          0
         4 1047603                                          0
    999999                0                                 NOARCHIVELOG
SQL> alter database open upgrade;

Database altered.

SQL> @ ?/rdbms/admin/catupgrd.sql

...