Sqlplus / as sysdba
查看归档模式是否开启 归档路径 archive log list;
查看快速恢复区内存大小 show parameter db_recovery;
更改快速恢复区大小 alter system set db_recovery_file_dest_size=4G;
调整归档路径 alter system set db_recovery_file_dest=‘/u01/app/oracle/fast_recovery_area’;
查看路径更新大小路径是否成功:show parameter db_recovery
Shutdown immediate
在mount状态开启归档模式 Startup mount
Alter databse archivelog;
重启数据库 Alter database open
Archivelog log list
•链接到rman环境 rman target /
•链接到rman环境 rman target sys/oracle@数据库名 catalog rc_admin/rc_admin@数据库名2
•显示当前rman环境下的参数配置 show all
•开启备份优化 CONFIGURE BACKUP OPTIMIZATION ON;
•开启控制文件备份 CONFIGURE CONTROLFILE AUTOBACKUP ON;
•设置并行磁盘备份 CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
Show all;