今天在执行begin backup的时候，发生了如下错误

SQL> alter tablespace users begin backup;

alter tablespace users begin backup

*

ERROR at line 1:

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

查询相关文档之后，原因是数据库没有启动归档.

[@more@]

今天在执行begin backup的时候，发生了如下错误

SQL> alter tablespace users begin backup;

alter tablespace users begin backup

*

ERROR at line 1:

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

查询相关文档之后，原因是数据库没有启动归档.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 432013312 bytes

Fixed Size 2021344 bytes

Variable Size 134219808 bytes

Database Buffers 293601280 bytes

Redo Buffers 2170880 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> alter system set log_archive_dest_1='location="/u01/arch"';

System altered.

SQL> alter tablespace users begin backup;

Tablespace altered.

启动归档日志之后，就可以使用alter tablespace users begin backup;

ITPub博客

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