这俩SQL>mount状态
改名(1)
SQL> alter database rename file '/u01/oradata/oradb/redo03.log' to '/u01/oradata/redo03.rdo';Database altered.
改回原名(2)
SQL> alter database rename file '/u01/oradata/redo03.rdo' to '/u01/oradata/oradb/redo03.log';Database altered.
打开数据库到open 说有错:
SQL> alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 7956
Session ID: 1 Serial number: 5
2 3 4 5 6 7改成名(1)
SQL> alter database rename file '/u01/oradata/oradb/redo03.log'to '/u01/oradata/redo03.rdo' ;
ERROR:
ORA-03114: not connected to ORACLE重新连mount接后,改成名(1)
SQL> alter database rename file '/u01/oradata/oradb/redo03.log'to '/u01/oradata/redo03.rdo' ;SQL> alter database open;Database altered.
改名(1)
SQL> alter database rename file '/u01/oradata/oradb/redo03.log' to '/u01/oradata/redo03.rdo';Database altered.
改回原名(2)
SQL> alter database rename file '/u01/oradata/redo03.rdo' to '/u01/oradata/oradb/redo03.log';Database altered.
打开数据库到open 说有错:
SQL> alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 7956
Session ID: 1 Serial number: 5
2 3 4 5 6 7改成名(1)
SQL> alter database rename file '/u01/oradata/oradb/redo03.log'to '/u01/oradata/redo03.rdo' ;
ERROR:
ORA-03114: not connected to ORACLE重新连mount接后,改成名(1)
SQL> alter database rename file '/u01/oradata/oradb/redo03.log'to '/u01/oradata/redo03.rdo' ;SQL> alter database open;Database altered.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货