苏州晶体公司网站,网站排名优化各公司的,做视频网站的备案要求吗,英语学习软件因客户需要测试#xff0c;使用生产环境的rman备份在虚拟机恢复中#xff0c;忘记调整redo位置#xff0c;打开时报错及处理过程。
SQL alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00344: unable to re-create online …因客户需要测试使用生产环境的rman备份在虚拟机恢复中忘记调整redo位置打开时报错及处理过程。
SQL alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00344: unable to re-create online log /oradata/ORCL/ONLINELOG/group_1.log ORA-27040: file create error, unable to create file Linux-x86_64 Error: 2: No such file or directory Additional information: 1 SQL select group#,bytes/1024/1024||M,status from v$log; GROUP# BYTES/1024/1024||M STATUS ---------- ----------------------------------------- ---------------- 1 500M CLEARING 2 500M CLEARING_CURRENT 3 500M CLEARING 4 500M CLEARING_CURRENT
SQL alter database clear logfile group 1;
Database altered.
SQL alter database clear logfile group 2;
Database altered.
SQL alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-00392: log 4 of thread 2 is being cleared, operation not allowed ORA-00312: online log 4 thread 2: /oradata/ORCL/ONLINELOG/group_4.log SQL alter database clear logfile group 3;
Database altered.
SQL alter database clear logfile group 4;
Database altered.
SQL select group#,bytes/1024/1024||M,status from v$log; GROUP# BYTES/1024/1024||M STATUS ---------- ----------------------------------------- ---------------- 1 500M UNUSED 2 500M CURRENT 3 500M UNUSED 4 500M CURRENT SQL alter database open resetlogs;
Database altered. 得到的教训必须按照步骤流程做事
