What could be the reason for this error?

You executed the following command to perform a backup of the USERS tablespace:
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
What could be the reason for this error?

You executed the following command to perform a backup of the USERS tablespace:
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
What could be the reason for this error?

A.
The MTTR Advisor is disabled.

B.
The database is in NOARCHIVELOG mode.

C.
The tablespace is already in backup mode.

D.
The Flash Recovery Area is not configured.

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

jean

jean

NOARCHIVELOG mode protects a database from instance failure, but not from media failure.

Reply

ajay

ajay

FOR database hot backup, the database must be set to archivelog mode.

If you are not archivelog mode, you must shutdown the database, and modify the state of starting to mount.

So B is the correct answer.

Reply