ITPub博客

首页 > 数据库 > Oracle > ORA-01123: cannot start online backup; media recovery not enabled

ORA-01123: cannot start online backup; media recovery not enabled

原创 Oracle 作者:flhs 时间:2005-12-16 13:17:26 0 删除 编辑

Problem:

SQL> alter tablespace xxxxxxx begin backup;

alter tablespace xxxxxxxx begin backup

ORA-01123: cannot start online backup; media recovery not enabled


SQL> archive log list
Database log mode No Archive Mode
Automatic archival Enabled
Archive destination /disk01/archive/xxxxx
Oldest online log sequence 84
Current log sequence 86

[@more@]

Solution:

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1310284300 bytes
Fixed Size 457228 bytes
Variable Size 234881024 bytes
Database Buffers 1073741824 bytes
Redo Buffers 1204224 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /disk01/archive/xxxxx
Oldest online log sequence 84
Next log sequence to archive 86
Current log sequence 86

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/43132/viewspace-811792/,如需转载,请注明出处,否则将追究法律责任。

上一篇: oracle sql 函数
请登录后发表评论 登录
全部评论
  • 博文量
    54
  • 访问量
    220432