今天给一表空间联机备份,出现了
ORA-01123: cannot start online backup; media recovery not enabled
检查发现是由于数据库处于非归档模式。
SQL> alter tablespace ex181 begin backup;
alter tablespace ex181 begin backup
*
ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oracle/archive2
Oldest online log sequence 11
Current log sequence 13
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 79694068 bytes
Database Buffers 83886080 bytes
Redo Buffers 2973696 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 /oracle/archive2
Oldest online log sequence 11
Next log sequence to archive 13
Current log sequence 13