ORACLE数据库灾难恢复

一：RMAN恢复

.1 创建测试用户，授权，分配测试表空间，给测试数据
–创建测试用户：
SQL> alter session set container=PRODPDB;

Session altered.

SQL>
SQL> show con_name;

CON_NAME

PRODPDB

SQL> create user pdbwjh identified by pdbwjh;

User created.

–授权：

参考

https://blog.51cto.com/u_13631369/6252422

二：Expdp逻辑恢复

三：闪回恢复

3.1 查看闪回区状态及信息

archive log list;
select open_mode,flashback_on from v$database; 查看是否开启归档
show parameter db_recovery;
show parameter flashback; 查看闪回区信息

修改归档路径和归档大小

SQL> alter system set db_recovery_file_dest='/u01/app/oracle/flashback_area' scope =both;
System altered.
SQL> alter system set db_recovery_file_dest_size=30g scope=spfile;
System altered.
SQL> alter system set db_flashback_retention_target=10080 scope=both;
System altered.

检查flash recovery area的使用情况，查看archivelog

SQL> set linesize 200
SQL> set pagesize 80
SQL> 
SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;FILE_TYPE        PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES     CON_ID
----------------------- ------------------ ------------------------- --------------- ----------
CONTROL FILE                 0               0           0          0
REDO LOG                 0               0           0          0
ARCHIVED LOG                 0               0           0          0
BACKUP PIECE                   .06               0           1          0
IMAGE COPY                 0               0           0          0
FLASHBACK LOG                   1.3               0           2          0
FOREIGN ARCHIVED LOG             0               0           0          0
AUXILIARY DATAFILE COPY          0               0           0          08 rows selected.

参考

https://www.modb.pro/db/454178
https://www.cnblogs.com/Memory-Python/p/10837023.html
https://blog.csdn.net/wanghui5767260/article/details/20993843