Cancel flash Oracle database recovery zone operations

The following articles mainly describe how to cancel the recovery zone of the transient Oracle database. We hope you can play a role in the actual operation of canceling the rollback zone of the transient Oracle database. The following describes the specific content of the article. Do not miss it.

Set db_recovery_file_dest to null to disable the flash recovery zone.

If flashback database is enabled, you cannot cancel flashing back to the recovery zone.

 
 

  
  
SQL> alter system set db_recovery_file_dest='';   
  
  
alter system set db_recovery_file_dest='' 
  
  
* 
 
 

Row 3 has an error:

ORA-02097: The parameter cannot be modified because the specified value is invalid

ORA-38775: Unable to disable quick recovery zone-Flashback database enabled

Therefore, you must disable the flashback database before canceling the flashback recovery zone.

 
 

  
  
SQL> shutdown immediate;  
 
 

The database has been closed. The Oracle database has been uninstalled.

The Oracle routine has been disabled.

 
 

  
  
SQL> startup mount;  
 
 

The Oracle routine has been started.

 
 

  
  
Total System Global Area 142606336 bytes  
  
  
Fixed Size 1247732 bytes  
  
  
Variable Size 83887628 bytes  
  
  
Database Buffers 50331648 bytes  
  
  
Redo Buffers 7139328 bytes 
 
 

The database has been loaded.

 
 

  
  
SQL>alter database flashback off;  
 
 

The Oracle database has been changed.

 
 

  
  
SQL> alter database open;  
 
 

The database has been changed.

 
 

  
  
SQL> alter system set db_recovery_file_dest='';  
 
 

The system has been changed.

4. Content of the flash recovery area

All recovery-related files can be stored in the Flash recovery zone.

 
 

  
  
SQL>select file_type from v$flash_recovery_area_usage;   
  
  
FILE_TYPE  
  
  
CONTROLFILE  
  
  
ONLINELOG  
  
  
ARCHIVELOG  
  
  
BACKUPPIECE  
  
  
IMAGECOPY  
  
  
FLASHBACKLOG 
 
 

You have selected 6 rows.

The above view shows that the flash recovery zone can be used for storage and management, including controfile, online redo logfile, archive logfile, rman backuppiece, rman image copy, and flashback log. The above content is an introduction to the Oracle database recovery zone. I hope you will have some gains.