免费发布网页的网站,广州站电话,网站描述怎么修改吗,做网站如何16:00:05 SQL alter database open; alter database open * 第 1 行出现错误: ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项
16:00:49 SQL startup ORA-01081: 无法启动已在运行的 ORACLE - 请首先关闭它 16:02:56 SQL shutdown immediate O…16:00:05 SQL alter database open; alter database open * 第 1 行出现错误: ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项
16:00:49 SQL startup ORA-01081: 无法启动已在运行的 ORACLE - 请首先关闭它 16:02:56 SQL shutdown immediate ORA-01109: 数据库未打开
已经卸载数据库。 ORACLE 例程已经关闭。 16:03:16 SQL startup mount ORACLE 例程已经启动。
Total System Global Area 3390558208 bytes Fixed Size 2180464 bytes Variable Size 1946159760 bytes Database Buffers 1426063360 bytes Redo Buffers 16154624 bytes 数据库装载完毕。 16:03:30 SQL recover database using backup controlfile ORA-00279: 更改 4013730 (在 06/24/2020 15:44:42 生成) 对于线程 1 是必需的 ORA-00289: 建议: D:\APP\BOOKSALES\ORACLE_LOG\B\ARCHIVEARC0000000141_1042457284.0001 ORA-00280: 更改 4013730 (用于线程 1) 在序列 #141 中
16:04:05 指定日志: {suggested | filename | AUTO | CANCEL} D:\app\oradata\orcl\redo03.log ORA-00279: 更改 4014060 (在 06/24/2020 15:44:45 生成) 对于线程 1 是必需的 ORA-00289: 建议: D:\APP\BOOKSALES\ORACLE_LOG\B\ARCHIVEARC0000000142_1042457284.0001 ORA-00280: 更改 4014060 (用于线程 1) 在序列 #142 中 ORA-00278: 此恢复不再需要日志文件 ‘D:\app\oradata\orcl\redo03.log’
16:10:00 指定日志: {suggested | filename | AUTO | CANCEL} D:\app\oradata\orcl\redo02.log ORA-00310: archived log contains sequence 140; sequence 142 required ORA-00334: archived log: ‘D:\APP\ORADATA\ORCL\REDO02.LOG’ 16:10:14 SQL alter database open resetlogs; alter database open resetlogs * 第 1 行出现错误: ORA-01113: 文件 1 需要介质恢复 ORA-01110: 数据文件 1: ‘D:\APP\ORADATA\ORCL\SYSTEM01.DBF’
16:11:09 SQL recover datafile ‘D:\APP\ORADATA\ORCL\SYSTEM01.DBF’ ORA-00283: 恢复会话因错误而取消 ORA-01610: 使用 BACKUP CONTROLFILE 选项的恢复必须已完成
16:12:19 SQL alter database open; alter database open * 第 1 行出现错误: ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项
16:12:36 SQL alter database open resetlogs; alter database open resetlogs * 第 1 行出现错误: ORA-01113: 文件 1 需要介质恢复 ORA-01110: 数据文件 1: ‘D:\APP\ORADATA\ORCL\SYSTEM01.DBF’
16:12:41 SQL shutdown immediate; ORA-01109: 数据库未打开 已经卸载数据库。 ORACLE 例程已经关闭。 16:13:44 SQL recover datafile ‘D:\APP\ORADATA\ORCL\SYSTEM01.DBF’; ORA-01034: ORACLE not available 进程 ID: 18184 会话 ID: 96 序列号: 3
16:14:01 SQL startup ORACLE 例程已经启动。
Total System Global Area 3390558208 bytes Fixed Size 2180464 bytes Variable Size 1946159760 bytes Database Buffers 1426063360 bytes Redo Buffers 16154624 bytes 数据库装载完毕。 ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项
16:15:27 SQL alter database open resetlogs; alter database open resetlogs * 第 1 行出现错误: ORA-01113: 文件 1 需要介质恢复 ORA-01110: 数据文件 1: ‘D:\APP\ORADATA\ORCL\SYSTEM01.DBF’
16:15:42 SQL show user USER 为 “SYS” 16:16:14 SQL startup mount ORA-01081: 无法启动已在运行的 ORACLE - 请首先关闭它 16:16:23 SQL recover datafile ‘D:\APP\ORADATA\ORCL\SYSTEM01.DBF’; ORA-00283: 恢复会话因错误而取消 ORA-01610: 使用 BACKUP CONTROLFILE 选项的恢复必须已完成
16:16:45 SQL recover database using backup controlfile until cancel; ORA-00279: 更改 4014060 (在 06/24/2020 15:44:45 生成) 对于线程 1 是必需的 ORA-00289: 建议: D:\APP\BOOKSALES\ORACLE_LOG\B\ARCHIVEARC0000000142_1042457284.0001 ORA-00280: 更改 4014060 (用于线程 1) 在序列 #142 中
16:17:28 指定日志: {suggested | filename | AUTO | CANCEL} D:\APP\BOOKSALES\ORACLE_LOG\B\ARCHIVEARC0000000142_1042457284.0001 ORA-00308: cannot open archived log ‘D:\APP\BOOKSALES\ORACLE_LOG\B\ARCHIVEARC0000000142_1042457284.0001’ ORA-27041: unable to open file OSD-04002: ???? O/S-Error: (OS 2) ?????????
16:18:36 指定日志: {suggested | filename | AUTO | CANCEL} suggested ORA-00308: cannot open archived log ‘suggested’ ORA-27041: unable to open file OSD-04002: ???? O/S-Error: (OS 2) ????????? 16:19:08 指定日志: {suggested | filename | AUTO | CANCEL} auto ORA-00308: cannot open archived log ‘D:\APP\BOOKSALES\ORACLE_LOG\B\ARCHIVEARC0000000142_1042457284.0001’ ORA-27041: unable to open file OSD-04002: ???? O/S-Error: (OS 2) ?????????
ORA-00308: cannot open archived log ‘D:\APP\BOOKSALES\ORACLE_LOG\B\ARCHIVEARC0000000142_1042457284.0001’ ORA-27041: unable to open file OSD-04002: ???? O/S-Error: (OS 2) ?????????
ORA-10879: error signaled in parallel recovery slave ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: ‘D:\APP\ORADATA\ORCL\SYSTEM01.DBF’
16:19:17 SQL recover database using backup controlfile until cancel; ORA-00275: 已经开始介质恢复
16:20:51 SQL alter database open resetlogs; alter database open resetlogs * 第 1 行出现错误: ORA-01194: 文件 1 需要更多的恢复来保持一致性 ORA-01110: 数据文件 1: ‘D:\APP\ORADATA\ORCL\SYSTEM01.DBF’
16:21:14 SQL alter system set_allow_resetlogs_corruptiontrue scopespfile;
系统已更改。
16:26:43 SQL startup force ORACLE 例程已经启动。
Total System Global Area 3390558208 bytes Fixed Size 2180464 bytes Variable Size 1946159760 bytes Database Buffers 1426063360 bytes Redo Buffers 16154624 bytes 数据库装载完毕。 ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项
16:27:14 SQL select *from dba_users; select *from dba_users * 第 1 行出现错误: ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询
16:27:31 SQL recover database using backup controlfile until cancel; ORA-00279: 更改 4014060 (在 06/24/2020 15:44:45 生成) 对于线程 1 是必需的 ORA-00289: 建议: D:\APP\BOOKSALES\ORACLE_LOG\B\ARCHIVEARC0000000142_1042457284.0001 ORA-00280: 更改 4014060 (用于线程 1) 在序列 #142 中
16:28:17 指定日志: {suggested | filename | AUTO | CANCEL} suggested ORA-00308: cannot open archived log ‘suggested’ ORA-27041: unable to open file OSD-04002: ???? O/S-Error: (OS 2) ?????????
16:29:11 指定日志: {suggested | filename | AUTO | CANCEL} auto ORA-00308: cannot open archived log ‘D:\APP\BOOKSALES\ORACLE_LOG\B\ARCHIVEARC0000000142_1042457284.0001’ ORA-27041: unable to open file OSD-04002: ???? O/S-Error: (OS 2) ?????????
ORA-00308: cannot open archived log ‘D:\APP\BOOKSALES\ORACLE_LOG\B\ARCHIVEARC0000000142_1042457284.0001’ ORA-27041: unable to open file OSD-04002: ???? O/S-Error: (OS 2) ?????????
ORA-10879: error signaled in parallel recovery slave ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: ‘D:\APP\ORADATA\ORCL\SYSTEM01.DBF’
16:29:18 SQL cancel SP2-0042: 未知命令 “cancel” - 其余行忽略。
16:29:43 SQL show user USER 为 “SYS” 16:29:49 SQL alter database open resetlogs; 数据库已更改。
