ORA-00257:归档程序错误,在释放之前仅限于内部连接

ORA-00257:归档程序错误,在释放之前仅限于内部连接
新建，保存为bat
rman cmdfile= D:\数据\清理归档.txt
新建，清理归档.txt
connect target zxjz_sd/kingo123
run{
crosscheck backup;
delete expired backup;
delete obsolete;
crosscheck archivelog all;
delete expired archivelog all;
DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-7’;
crosscheck archivelog all;
}

ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务
修改listener.ora
#listener.ora Network Configuration File:D:\Oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
#Generated by Oracle configuration tools.

SID_LIST_LISTENER=
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = AJSJZX)
(ORACLE_HOME =D:\oracle\product\10.2.0\db_1)
(SID_NAME = AJSJZX)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 20.12.50.1)(PORT = 1521))
)
)

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist的解决办法
https://blog.csdn.net/HL141916/article/details/84133222
命令行:
sqlplus / as sysdba
startup pfile=“D:\oracle\product\10.2.0\db_1\database\init.ora”(检查一下是否有这个文件，有数字把数字去掉)

归档日志文件查询使用率：
select * from v$flash_recovery_area_usage;
ARCHIVED LOG的使用率
归档日志扩容：
切换成spfile启动：
SQL>create spfile from pfile;（文件位置要对应不然报错）
SQL>shutdown immediate;
SQL>startup;
SQL>alter system set db_recovery_file_dest_size=8G scope=both;