77.You executed the following command to perform a backup of the USERS tablespace: SQL> ALTER TABLES

最新推荐文章于 2024-02-27 10:57:15 发布

原创最新推荐文章于 2024-02-27 10:57:15 发布 · 968 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#1z0-052

1z0-052 专栏收录该内容

187 篇文章

订阅专栏

本文探讨了在尝试对USERStablespace进行在线备份时遇到ORA-01123错误的原因。该错误提示表明无法开始在线备份，因为未启用介质恢复。文章通过查询归档模式状态发现数据库处于NOARCHIVELOG模式，这是导致错误的根本原因。

77.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.
答案：B
解析：非归档模式下不能在线备份
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 77
Current log sequence 79
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