Tuesday, July 29, 2014

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

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

ORA-01123: cannot start online backup; media recovery not enabled.
SQL>alter tablespace users begin backup;

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


Check whether the database in archive log by SYS user may be database running on without archive log

SQL> ARCHIVE LOG LIST;

Database is in non archive mode

We need to change archive mode

SQL>shutdown immediate;

SQL>startup mount;

SQL>alter database archivelog;

SQL>Alter database open;

then you can BEGIN BACKUP command

No comments:

Post a Comment