异常断电： Oracle服务启动后，发生异常：[ORA-01033: ORACLE正在初始化或关闭]。

介质恢复

sqlplus / as sysdba;
shutdown immediate;
startup
alter database open resetlogs;
recover database using backup controlfile;
C:\app\Administrator\oradata\BpayerDB\REDO01.LOG

alter database open resetlogs;

修改归档日志空间大小

sqlplus / as sysdba  
shutdown abort     ----关闭进程  
startup mount       ---- 装载数据库  
select * from v$recovery_file_dest; ---查询归档日志  
alter system set db_recovery_file_dest_size=20737418240; --设置归档日志空间为20G  
Exit ---到这里空间大小已经设置完成  

常用命令

lsnrctl start
lsnrctl stop
lsnrctl status

net stop OracleServiceBpayerDB
net start OracleServiceBpayerDB

#在cmd中进入sql
sqlplus / as sysdba

新建实例后 创建表空间和用户并授权

create tablespace NNC_DATA01 DATAFILE 'C:\Oracle\oradata\dbnc\nnc_data01.dbf'
SIZE 500M autoextend on next 50M extent management local uniform size 256k;

create tablespace NNC_INDEX01 DATAFILE 'C:\Oracle\oradata\dbnc\nnc_index01.dbf'
SIZE 500M autoextend on next 50M extent management local uniform size 128k;

create user BpayerRCDB identified by oracle default tablespace NNC_DATA01 
temporary tablespace temp;

grant connect,dba to BpayerRCDB;

参考链接：Oracle ORA-01033: ORACLE initialization or shutdown in progress 错误解决办法Windows版（手贱强制重启电脑的后果）
记一次修复Oracle数据库的异常：[ORA-01033: ORACLE正在初始化或关闭]