在Oracle 19c中创建还原点报如下错误：http://www.cndba.cn/dave/article/4699http://www.cndba.cn/dave/article/4699http://www.cndba.cn/dave/article/4699

SQL> create restore point cdb_grp_before_upgrade1 guarantee flashback database;
create restore point cdb_grp_before_upgrade1 guarantee flashback database
*
ERROR at line 1:
ORA-38784: Cannot create restore point 'CDB_GRP_BEFORE_UPGRADE1'.
ORA-38785: Media recovery must be enabled for guaranteed restore point.

这里ORA-38785: Media recovery must be enabled 描述是比较隐晦的，实际上就是数据库没有启动归档。

http://www.cndba.cn/dave/article/4699

http://www.cndba.cn/dave/article/4699

我们启动归档再次创建成功，随笔记之：http://www.cndba.cn/dave/article/4699http://www.cndba.cn/dave/article/4699

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch
Oldest online log sequence     56
Current log sequence           58
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1543500824 bytes
Fixed Size                  9135128 bytes
Variable Size            1174405120 bytes
Database Buffers          352321536 bytes
Redo Buffers                7639040 bytes
Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 DAVE                           READ WRITE NO
         4 USTC                           READ WRITE NO
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT

SQL> alter system set db_recovery_file_dest='/u01/app/oracle/fast_recovery_area' scope=both;

System altered.

SQL>  create restore point cdb_grp_before_upgrade1 guarantee flashback database;

Restore point created.

SQL>

版权声明：本文为博主原创文章，未经博主允许不得转载。