oracle 11.2.0.4使用rman删除归档日志

最新推荐文章于 2024-03-23 16:37:19 发布
最新推荐文章于 2024-03-23 16:37:19 发布
阅读量822 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_40908896/article/details/90266597
版权

oracle 11.2.0.4使用rman删除归档日志

#查看归档日志路径：（我这里默认放在闪回恢复区）
在这里插入图片描述
#查看闪回恢复区使用情况：
SELECT * FROM V$RECOVERY_AREA_USAGE;
在这里插入图片描述
#进入目录查看归档日志：
在这里插入图片描述
#统计归档文件大小，发现1月22日之前的归档日志为空文件夹：
在这里插入图片描述

#使用rman检查归档日志，发现能系统中能看到最早的日志日期为2019年1月22日的：

RMAN> crosscheck archivelog all;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=43 device type=DISK
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_12_g4fr278v_.arc RECID=9 STAMP=998241607
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_13_g4fr27rx_.arc RECID=10 STAMP=998241607
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_14_g4fr2b94_.arc RECID=11 STAMP=998241610
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_15_g4fr2bgk_.arc RECID=12 STAMP=998241610
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_16_g4fr2bob_.arc RECID=13 STAMP=998241610
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_17_g4fr2gvp_.arc RECID=14 STAMP=998241614
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_02_09/o1_mf_1_18_g5xl1wt4_.arc RECID=15 STAMP=999808333
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_02_15/o1_mf_1_19_g6fkhwx2_.arc RECID=16 STAMP=1000332033
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_02_19/o1_mf_1_20_g6qv3fv5_.arc RECID=17 STAMP=1000669560
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_06/o1_mf_1_21_g7zmkpm9_.arc RECID=18 STAMP=1002231738
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_22_g83nf5tv_.arc RECID=19 STAMP=1002363694
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_23_g83ot8jx_.arc RECID=20 STAMP=1002365148
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_24_g83otpcm_.arc RECID=21 STAMP=1002365170
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_25_g83ov11j_.arc RECID=22 STAMP=1002365178
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_26_g83ow4wx_.arc RECID=23 STAMP=1002365203
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_27_g83owpl3_.arc RECID=24 STAMP=1002365220
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_28_g83owy9m_.arc RECID=25 STAMP=1002365223
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_29_g83oyzp7_.arc RECID=26 STAMP=1002365288
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_30_g83ozh4m_.arc RECID=27 STAMP=1002365301
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_31_g83ozvlj_.arc RECID=28 STAMP=1002365309
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_32_g83q0c4n_.arc RECID=29 STAMP=1002366356
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_33_g83q0hly_.arc RECID=30 STAMP=1002366360
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_16/o1_mf_1_34_g8so2voj_.arc RECID=31 STAMP=1003085281
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_28/o1_mf_1_35_g9rh3gko_.arc RECID=32 STAMP=1004094958
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_29/o1_mf_1_36_g9wch1lo_.arc RECID=33 STAMP=1004222332
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_04_09/o1_mf_1_37_gbs9d6sh_.arc RECID=34 STAMP=1005170442
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_05_13/o1_mf_1_38_gfly5067_.arc RECID=35 STAMP=1008194486
validation succeeded for archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_05_16/o1_mf_1_39_gft3shr7_.arc RECID=36 STAMP=1008429618
Crosschecked 28 objects

#使用list archvielog all 查看日志，最早日期为1月22日的日志：
RMAN> list archivelog all;

List of Archived Log Copies for database with db_unique_name ORCL

=====================================================================

Key Thrd Seq S Low Time

10 1 13 A 22-JAN-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_13_g4fr27rx_.arc

11 1 14 A 22-JAN-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_14_g4fr2b94_.arc

12 1 15 A 22-JAN-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_15_g4fr2bgk_.arc

13 1 16 A 22-JAN-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_16_g4fr2bob_.arc

14 1 17 A 22-JAN-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_17_g4fr2gvp_.arc

15 1 18 A 22-JAN-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_02_09/o1_mf_1_18_g5xl1wt4_.arc

16 1 19 A 09-FEB-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_02_15/o1_mf_1_19_g6fkhwx2_.arc

17 1 20 A 15-FEB-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_02_19/o1_mf_1_20_g6qv3fv5_.arc

18 1 21 A 19-FEB-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_06/o1_mf_1_21_g7zmkpm9_.arc

19 1 22 A 06-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_22_g83nf5tv_.arc

20 1 23 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_23_g83ot8jx_.arc

21 1 24 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_24_g83otpcm_.arc

22 1 25 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_25_g83ov11j_.arc

23 1 26 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_26_g83ow4wx_.arc

24 1 27 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_27_g83owpl3_.arc

25 1 28 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_28_g83owy9m_.arc

26 1 29 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_29_g83oyzp7_.arc

27 1 30 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_30_g83ozh4m_.arc

28 1 31 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_31_g83ozvlj_.arc

29 1 32 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_32_g83q0c4n_.arc

30 1 33 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_33_g83q0hly_.arc

31 1 34 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_16/o1_mf_1_34_g8so2voj_.arc

32 1 35 A 16-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_28/o1_mf_1_35_g9rh3gko_.arc

33 1 36 A 28-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_29/o1_mf_1_36_g9wch1lo_.arc

34 1 37 A 29-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_04_09/o1_mf_1_37_gbs9d6sh_.arc

35 1 38 A 09-APR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_05_13/o1_mf_1_38_gfly5067_.arc

36 1 39 A 13-MAY-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_05_16/o1_mf_1_39_gft3shr7_.arc

37 1 40 A 16-MAY-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_05_16/o1_mf_1_40_gft562h5_.arc

#在数据库中查看归档日志信息，也显示最早的日志为1月22日：

select * from V$ARCHIVED_LOG；
在这里插入图片描述

SQL> show parameter CONTROL_FILE_RECORD_KEEP_TIME

NAME TYPE VALUE

control_file_record_keep_time integer 7

#删除当前时间60天以前归档的日志：
RMAN> delete archivelog all completed before ‘sysdate-60’;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=43 device type=DISK
List of Archived Log Copies for database with db_unique_name ORCL

===================================================================

Key Thrd Seq S Low Time

10 1 13 A 22-JAN-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_13_g4fr27rx_.arc

11 1 14 A 22-JAN-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_14_g4fr2b94_.arc

12 1 15 A 22-JAN-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_15_g4fr2bgk_.arc

13 1 16 A 22-JAN-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_16_g4fr2bob_.arc

14 1 17 A 22-JAN-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_17_g4fr2gvp_.arc

15 1 18 A 22-JAN-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_02_09/o1_mf_1_18_g5xl1wt4_.arc

16 1 19 A 09-FEB-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_02_15/o1_mf_1_19_g6fkhwx2_.arc

17 1 20 A 15-FEB-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_02_19/o1_mf_1_20_g6qv3fv5_.arc

18 1 21 A 19-FEB-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_06/o1_mf_1_21_g7zmkpm9_.arc

19 1 22 A 06-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_22_g83nf5tv_.arc

20 1 23 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_23_g83ot8jx_.arc

21 1 24 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_24_g83otpcm_.arc

22 1 25 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_25_g83ov11j_.arc

23 1 26 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_26_g83ow4wx_.arc

24 1 27 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_27_g83owpl3_.arc

25 1 28 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_28_g83owy9m_.arc

26 1 29 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_29_g83oyzp7_.arc

27 1 30 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_30_g83ozh4m_.arc

28 1 31 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_31_g83ozvlj_.arc

29 1 32 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_32_g83q0c4n_.arc

30 1 33 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_33_g83q0hly_.arc

31 1 34 A 08-MAR-19
Name: /home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_16/o1_mf_1_34_g8so2voj_.arc

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_13_g4fr27rx_.arc RECID=10 STAMP=998241607
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_14_g4fr2b94_.arc RECID=11 STAMP=998241610
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_15_g4fr2bgk_.arc RECID=12 STAMP=998241610
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_16_g4fr2bob_.arc RECID=13 STAMP=998241610
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_01_22/o1_mf_1_17_g4fr2gvp_.arc RECID=14 STAMP=998241614
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_02_09/o1_mf_1_18_g5xl1wt4_.arc RECID=15 STAMP=999808333
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_02_15/o1_mf_1_19_g6fkhwx2_.arc RECID=16 STAMP=1000332033
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_02_19/o1_mf_1_20_g6qv3fv5_.arc RECID=17 STAMP=1000669560
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_06/o1_mf_1_21_g7zmkpm9_.arc RECID=18 STAMP=1002231738
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_22_g83nf5tv_.arc RECID=19 STAMP=1002363694
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_23_g83ot8jx_.arc RECID=20 STAMP=1002365148
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_24_g83otpcm_.arc RECID=21 STAMP=1002365170
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_25_g83ov11j_.arc RECID=22 STAMP=1002365178
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_26_g83ow4wx_.arc RECID=23 STAMP=1002365203
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_27_g83owpl3_.arc RECID=24 STAMP=1002365220
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_28_g83owy9m_.arc RECID=25 STAMP=1002365223
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_29_g83oyzp7_.arc RECID=26 STAMP=1002365288
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_30_g83ozh4m_.arc RECID=27 STAMP=1002365301
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_31_g83ozvlj_.arc RECID=28 STAMP=1002365309
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_32_g83q0c4n_.arc RECID=29 STAMP=1002366356
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_08/o1_mf_1_33_g83q0hly_.arc RECID=30 STAMP=1002366360
deleted archived log
archived log file name=/home/oracle/app/fast_recovery_area/ORCL/archivelog/2019_03_16/o1_mf_1_34_g8so2voj_.arc RECID=31 STAMP=1003085281
Deleted 22 objects

#再次查看归档目录：
在这里插入图片描述
#查看闪回恢复区使用情况：
在这里插入图片描述
#删除空的目录：
[root@linux_64 archivelog]# rm -rf 2018_12*
[root@linux_64 archivelog]# rm -rf 2019_01*
[root@linux_64 archivelog]# rm -rf 2019_02*
[root@linux_64 archivelog]# rm -rf 2019_03_0*
[root@linux_64 archivelog]# rm -rf 2019_03_16

[root@linux_64 archivelog]# du -sh *
300K 2019_03_28
26M 2019_03_29
49M 2019_04_09
50M 2019_05_13
24M 2019_05_16

Steam noodle
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
【oracle运维】oracle 删除归档日志（rman 方式删除存储于ASM的归档日志）
ludengfu的博客
05-10 1510
定时删除归档日志
rman打开oracle归档日志,Oracle RMAN清除归档日志
weixin_35825858的博客
04-03 121
[python]robin@SZDB:~> export ORACLE_SID=GOBO1robin@SZDB:~> rman target /Recovery Manager: Release 10.2.0.3.0 - Production on Thu Jul 11 17:07:00 2013Copyright (c) 1982, 2005, Oracle. All rights...
Oracle 11g 备份任务报RMAN-06820错误案例分享
最新发布
PWY13148的专栏
03-23 341
基于Oracle 11.2.0.4 版本搭建ADG主备架构的高可用环境，并将定时备份脚本部署在备节点上。检查备份日志发现数据文件备份异常，但是归档日志备份成功
Oracle 删除归档
JANE_ZDr的博客
09-18 4505
如何正确地删除Archivelog？Archivelog并不能直接得从OS层直接物理删除，因为archivelog的相关信息是记录在controlfile中的，当物理删除后不会改变controlfile的设置，并且在查询相关的动态视图(例如v$archived_log)时，该部分日志仍然标注为存在，也就是说Oracle并不认为这些日志被删除了，所以在删除archivelog的时候，需要我们在其他地方做一些设置。 一、使用RMAN清除物理删除后的记录 可以使用RMAN来删除archivelog，具体可..
Oracle数据库存储满了，清理归档日志
weixin_43181554的博客
06-09 841
Oracle内存满了，删归档日志
fast recovery area oracle,如何处理fast_recovery_area无剩余空间
weixin_28697921的博客
04-05 448
一、打开数据库报错[oracle@node1 ora11g]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 19 15:42:04 2011Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to an idle instan...
Oracle 11.2.0.4到Oracle 19.3 PDB XTTS迁移方案测试.doc
05-17
Oracle 11.2.0.4 到 Oracle 19.3 PDB XTTS 迁移方案测试 Oracle 11.2.0.4 到 Oracle 19.3 PDB XTTS 迁移方案测试是将 Oracle 11.2.0.4 版本迁移到 Oracle 19.3 PDB XTTS 环境中的一个迁移项目。该项目的目的是将表...
异机迁移oracle 11.2.0.4单机至12cR2 RAC
12-14
异机迁移Oracle数据库是一个复杂的过程，特别是从Oracle 11.2.0.4单机环境迁移到12c Release 2 (12.2.0.1)的Real Application Clusters (RAC)环境。这个过程涉及到多个步骤，包括备份、恢复、参数配置以及系统升级。...
Oracle Linux 6.5 服务器 安装 Oracle 11.2.0.4 数据库
07-13
在Oracle Linux 6.5环境下安装Oracle 11.2.0.4数据库涉及多个关键步骤，主要包括系统配置、核心参数调整以及用户和权限管理。首先，确保满足基本的硬件需求，如至少1GB的物理内存和至少5GB的硬盘空间，并且交换分区...
1.2 oracle 11.2.0.4常用操作说明书_20200709_v0.1.doc
09-24
在Oracle数据库管理中，11.2.0.4版本是一个重要的里程碑，它提供了丰富的功能和优化，以支持日常的数据库运维工作。本操作说明书主要涵盖了几个关键的管理任务，包括数据备份、表空间管理和作业（JOB）的创建。 ...
ORACLE 11g从 11.2.0.1升级到11.2.0.4 详细实战教程
12-16
查看当前oracle版本，确定是比较旧的11.2.0.1 [oracle@hch_test_121_90 ~]$ rlwrap sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 17 15:20:45 2017 Copyright (c) 1982, 2009, Oracle....
rman常用命令
kevinyu998的博客
08-08 203
查看时间段需要恢复的归档。
Oracle RMAN 清除归档日志
king_harry的专栏
11-23 947
在开发环境及UAT环境经常碰到需要清除归档日志的情形，对于这个问题方法有很多。可以直接使用rm方式清除归档日志，也可以使用find命令来查找符合条件的记录来清除归档日志，或者直接写个shell脚本来搞定。这样在DEV或者UAT还可以，但是在Prod环境还是建议使用RMAN提供的命令来搞定比较妥当。因为rm，find方式删除了实际的归档日志也释放了空间，但对应的存储在控制文件中的归档信息并没有彻底清
解决Oracle archive log 日志已满问题
weixin_34204722的博客
01-25 706
一、背景今天接到开发电话，说Oracle远程连不上了，可能是archivelog满了。我登陆Oracle试了下，提示ORA-00257: archiver error. Connect internal only, until freed。考虑到前些天已经扩大了硬盘空间，应该是archive log大小已经达到Oracle中对archive log大小的限制。而DBA已经放假...
Oracle归档日志满了怎么办
热门推荐
小楼一夜听春雨，深巷明朝卖杏花
12-27 2万+
归档满了 如果服务器进不去查看pfile文件，在pfile文件里面有归档除存放的路径 *.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'     如果服务器本地可以进去，就可以查看归档目录 SQL> archive log list; Database log mode        Archive Mod...
mode+oracle+余数,处理fast_recovery_area无剩余空间案例
weixin_39551103的博客
04-05 80
一、打开数据库报错[oracle@node1 ora11g]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Mon Dec 19 15:42:04 2011Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to an idle instan...
delete archivelog all completed before 和delete archivelog until time 的区别
文档搬运工
03-22 5027
今天在一个数据库上，删除归档的时候，发现使用命令delete archivelog all completed before 'sysdate-7';并不能删除掉7天前的归档。比如1月份的归档还是存在的。 使用catalog start with，将归档重新注册后，还是删除不掉 。 但是，使用delete archivelog until time 'sysdate-7' ;命令，就可以删除掉。 查询了这两个语句的区别。带complete的语句，主要是删除已备份过的归档，没有备份备份的归档，不会被删除
rman删除归档日志命令集
conglueh193642的博客
04-02 725
1.用RMAN连接目标DB： 　RMANtargetsys/*****@orcl 　2.在RMAN命令窗口中，输入如下...
rman 在11.2.0.3 和11.2.0.4之间操作
05-25
在11.2.0.3和11.2.0.4之间进行操作时，需要注意以下几点： 1. 版本差异：11.2.0.3和11.2.0.4之间存在一些差异，包括一些新增的功能、修复的问题等。在进行操作时需要注意版本差异，避免因版本不兼容而导致的问题。 2. 升级：如果需要将数据库从11.2.0.3升级到11.2.0.4，需要先进行升级操作。在升级过程中，需要备份数据库和相关配置文件，并确保升级过程中没有出现错误。 3. 数据迁移：如果需要将数据从11.2.0.3迁移到11.2.0.4，可以使用Oracle Data Pump或其他数据迁移工具进行操作。在进行数据迁移时，需要注意数据的一致性和完整性，并确保迁移过程中没有出现数据丢失等问题。 4. 代码兼容性：如果存在自定义的PL/SQL代码或其他应用程序代码，需要确保代码在11.2.0.4中能够正常运行，并进行必要的更改和测试。 总之，在进行11.2.0.3和11.2.0.4之间的操作时，需要仔细考虑版本差异、升级、数据迁移和代码兼容性等问题，以确保操作的成功和稳定性。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值