ORA-38760: This database instance failed to turn on flashback database

Issue

ORA-38760: Thisdatabase instance failed to turn on flashback database

Background

         数据库的Flashback是打开的，测试冷备和恢复

SQL> select * from v$version;   BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE       11.2.0.3.0        Production TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production

 

SQL> select flashback_on from v$database;   FLASHBACK_ON ------------------ YES

Process

Backup script:

#!/bin/bash sqlplus / as sysdba <<EOF shutdown immediate; ho cp /u01/app/oracle/oradata/orcl/control01.ctl /rmp/backup/controlfile/contril01.ctl ho cp /u01/app/oracle/fast_recovery_area/orcl/control02.ctl /rmp/backup/controlfile/control02.ctl ho cp /u01/app/oracle/oradata/orcl/*.dbf /rmp/backup/datafile/ ho cp /u01/app/ora