备案控制台
探索云世界
开发者社区 数据库 文章 正文

Oracle rman备份保留策略，归档删除策略及delete命令的使用

2022-06-09 1523
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： oracle rman备份保留策略、归档策略的使用及对delete命令的影响

今日学习Oracle rman备份保留策略，归档删除策略，发现delete obsolete命令不考虑归档删除策略，只遵从备份保留策略，delete archive log 只遵从归档删除策略，不考虑备份保留策略，实验验证一下。

1 数据库环境
1.1 数据库版本
SQL> select * from v$version;

BANNER

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
1.2 数据库日志模式
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Next log sequence to archive 3
Current log sequence 3

1.3 rman参数配置
RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL11G are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl11g.f'; # default
2 设置备份保留策略及归档删除策略
2.1 保留策略采用默认设置，保留一个有效备份。
2.2 设置归档删除策略为备份到磁盘设备两次
RMAN> configure archivelog deletion policy to backed up 2 times to device type disk;

old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
new RMAN configuration parameters are successfully stored

3 验证delete obsolete命令
3.1 备份归档日志
RMAN> backup archivelog all;
3.2 检查以下废弃的备份及文件
RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle

Backup Set 1 03-AUG-19
Backup Piece 1 03-AUG-19 /home/oracle/backup/c_ORCL11G_20190803_1
Backup Set 2 03-AUG-19
Backup Piece 2 03-AUG-19 /home/oracle/backup/ctl_04u899pu_20190803_4;

上面两个备份时以前的控制文件备份

3.3 切换日志，产生几个归档
RMAN> sql 'alter system switch logfile';

sql statement: alter system switch logfile
3.4 做一个数据库全备
RMAN> back up database;
3.5 检查以下废弃的文件
RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle

Archive Log 3 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_5_gl9cvbtm_.arc
Archive Log 1 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_8_gmqbfowj_.arc
Archive Log 2 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_9_gmqbjrmd_.arc
Archive Log 5 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_7_gl9df4p5_.arc
Archive Log 6 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_4_gl9clfkz_.arc
Archive Log 4 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_6_gl9cxkm7_.arc
Archive Log 7 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_10_gmqgf8cl_.arc
Archive Log 8 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_8_gmqgf8jr_.arc
Archive Log 9 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_9_gmqgf905_.arc
Backup Set 1 03-AUG-19
Backup Piece 1 03-AUG-19 /home/oracle/backup/c_ORCL11G_20190803_1
Backup Set 2 03-AUG-19
Backup Piece 2 03-AUG-19 /home/oracle/backup/ctl_04u899pu_20190803_4;
Archive Log 13 03-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_03/o1_mf_1_1_gnb29x1t_.arc
Backup Set 3 03-AUG-19
Backup Piece 3 03-AUG-19 /home/oracle/backup/c_ORCL11G_%l_20190803_6
Archive Log 14 04-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_04/o1_mf_1_1_gnfccmyr_.arc
Archive Log 15 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_2_gnvx3c6q_.arc
Archive Log 16 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_3_gnvxwrj5_.arc
Backup Set 4 10-AUG-19
Backup Piece 4 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxws3s_.bkp
Backup Set 5 10-AUG-19
Backup Piece 5 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxwt66_.bkp
Archive Log 17 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_4_gnvy7rm9_.arc
Backup Set 6 10-AUG-19
Backup Piece 6 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxwv8t_.bkp
Archive Log 18 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_5_gnvy9x45_.arc
Archive Log 19 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_6_gnvyb315_.arc

从输出来看，数据库全备之前产生的归档日志及其备份都被标识为废弃文件

3.6 删除废弃的文件
RMAN> delete noprompt obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle

Archive Log 3 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_5_gl9cvbtm_.arc
Archive Log 1 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_8_gmqbfowj_.arc
Archive Log 2 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_9_gmqbjrmd_.arc
Archive Log 5 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_7_gl9df4p5_.arc
Archive Log 6 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_4_gl9clfkz_.arc
Archive Log 4 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_6_gl9cxkm7_.arc
Archive Log 7 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_10_gmqgf8cl_.arc
Archive Log 8 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_8_gmqgf8jr_.arc
Archive Log 9 27-JUL-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_9_gmqgf905_.arc
Backup Set 1 03-AUG-19
Backup Piece 1 03-AUG-19 /home/oracle/backup/c_ORCL11G_20190803_1
Backup Set 2 03-AUG-19
Backup Piece 2 03-AUG-19 /home/oracle/backup/ctl_04u899pu_20190803_4;
Archive Log 13 03-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_03/o1_mf_1_1_gnb29x1t_.arc
Backup Set 3 03-AUG-19
Backup Piece 3 03-AUG-19 /home/oracle/backup/c_ORCL11G_%l_20190803_6
Archive Log 14 04-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_04/o1_mf_1_1_gnfccmyr_.arc
Archive Log 15 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_2_gnvx3c6q_.arc
Archive Log 16 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_3_gnvxwrj5_.arc
Backup Set 4 10-AUG-19
Backup Piece 4 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxws3s_.bkp
Backup Set 5 10-AUG-19
Backup Piece 5 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxwt66_.bkp
Archive Log 17 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_4_gnvy7rm9_.arc
Backup Set 6 10-AUG-19
Backup Piece 6 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxwv8t_.bkp
Archive Log 18 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_5_gnvy9x45_.arc
Archive Log 19 10-AUG-19 /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_6_gnvyb315_.arc
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_5_gl9cvbtm_.arc RECID=3 STAMP=1014719046
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_8_gmqbfowj_.arc RECID=1 STAMP=1014719046
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_9_gmqbjrmd_.arc RECID=2 STAMP=1014719046
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_7_gl9df4p5_.arc RECID=5 STAMP=1014719047
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_4_gl9clfkz_.arc RECID=6 STAMP=1014719047
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_09/o1_mf_1_6_gl9cxkm7_.arc RECID=4 STAMP=1014719047
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_10_gmqgf8cl_.arc RECID=7 STAMP=1014720040
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_8_gmqgf8jr_.arc RECID=8 STAMP=1014720040
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_07_27/o1_mf_1_9_gmqgf905_.arc RECID=9 STAMP=1014720041
deleted backup piece
backup piece handle=/home/oracle/backup/c_ORCL11G_20190803_1 RECID=1 STAMP=1015326317
deleted backup piece
backup piece handle=/home/oracle/backup/ctl_04u899pu_20190803_4; RECID=2 STAMP=1015326527
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_03/o1_mf_1_1_gnb29x1t_.arc RECID=13 STAMP=1015330237
deleted backup piece
backup piece handle=/home/oracle/backup/c_ORCL11G_%l_20190803_6 RECID=3 STAMP=1015326746
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_04/o1_mf_1_1_gnfccmyr_.arc RECID=14 STAMP=1015437812
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_2_gnvx3c6q_.arc RECID=15 STAMP=1015914731
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_3_gnvxwrj5_.arc RECID=16 STAMP=1015915544
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxws3s_.bkp RECID=4 STAMP=1015915545
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxwt66_.bkp RECID=5 STAMP=1015915546
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_4_gnvy7rm9_.arc RECID=17 STAMP=1015915896
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_annnn_TAG20190810T064544_gnvxwv8t_.bkp RECID=6 STAMP=1015915547
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_5_gnvy9x45_.arc RECID=18 STAMP=1015915965
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_6_gnvyb315_.arc RECID=19 STAMP=1015915971
Deleted 22 objects
数据库备份之前产生的备份集及归档日志都被删除了，检查以下现有备份文件及归档日志，没有归档日志，备份集只剩一下数据库全备的：

RMAN> list backup;

List of Backup Sets

BS Key Type LV Size Device Type Elapsed Time Completion Time

7 Full 1.03G DISK 00:00:27 10-AUG-19

    BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20190810T065316
    Piece Name: /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_nnndf_TAG20190810T065316_gnvybw9j_.bkp

List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1028593 10-AUG-19 /u01/app/oracle/oradata/orcl11g/system01.dbf
2 Full 1028593 10-AUG-19 /u01/app/oracle/oradata/orcl11g/sysaux01.dbf
3 Full 1028593 10-AUG-19 /u01/app/oracle/oradata/orcl11g/undotbs01.dbf
4 Full 1028593 10-AUG-19 /u01/app/oracle/oradata/orcl11g/users01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

8 Full 9.67M DISK 00:00:01 10-AUG-19

    BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20190810T065316
    Piece Name: /u01/app/oracle/fast_recovery_area/ORCL11G/backupset/2019_08_10/o1_mf_ncsnf_TAG20190810T065316_gnvyd0dg_.bkp

SPFILE Included: Modification time: 10-AUG-19
SPFILE db_unique_name: ORCL11G
Control File Included: Ckp SCN: 1028605 Ckp time: 10-AUG-19
RMAN> list archivelog all;

specification does not match any archived log in the repository

4 验证delete archivelog命令
4.1 更改归档删除策略为None，归档删除策略为未经备份的归档日志也可以删除。
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO None;

old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
new RMAN configuration parameters are successfully stored

4.2 产生几个归档日志
RMAN> sql 'alter system switch logfile';

sql statement: alter system switch logfile

RMAN> sql 'alter system switch logfile';

sql statement: alter system switch logfile

RMAN> sql 'alter system switch logfile';

sql statement: alter system switch logfile

RMAN>
RMAN> list archivelog all;

List of Archived Log Copies for database with db_unique_name ORCL11G

Key Thrd Seq S Low Time

20 1 7 A 10-AUG-19

    Name: /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_7_gnvzpxgh_.arc

21 1 8 A 10-AUG-19

    Name: /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_8_gnvzq4ch_.arc

22 1 9 A 10-AUG-19

    Name: /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_9_gnvzq9jc_.arc

4.3 系统中没有obsolete文件
RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found

4.4 删除归档日志
RMAN> delete noprompt archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK

List of Archived Log Copies for database with db_unique_name ORCL11G

Key Thrd Seq S Low Time

20 1 7 A 10-AUG-19

    Name: /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_7_gnvzpxgh_.arc

21 1 8 A 10-AUG-19

    Name: /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_8_gnvzq4ch_.arc

22 1 9 A 10-AUG-19

    Name: /u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_9_gnvzq9jc_.arc

deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_7_gnvzpxgh_.arc RECID=20 STAMP=1015917405
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_8_gnvzq4ch_.arc RECID=21 STAMP=1015917412
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL11G/archivelog/2019_08_10/o1_mf_1_9_gnvzq9jc_.arc RECID=22 STAMP=1015917417
Deleted 3 objects

RMAN>

删除了刚才产生的归档日志，这些归档日志是当前备份保留策略所需要的，也没有备份。可见，delete archivelog命令并不考虑数据库备份策略。

5 结论
从上面的实验上来看，delete archivelog命令只遵循归档日志删除策略，delete obsolete命令只遵循备份保留策略，因此，在使用时要注意二者的相互影响，即delete obsolete 命令可以破坏归档日志删除策略，delete archivelog 可以破坏备份保留策略，在使用脚本自动备份时，要仔细分析和验证，避免造成意外的结果，而在dataguard环境尤其要谨慎使用delete obsolete 命令，避免删除未传输的日志。

文章标签：
日志服务
SQL
关系型数据库
Linux
Oracle
数据库
关键词：
Oracle数据库一键上云rman
Oracle数据库一键上云备份
Oracle数据库一键上云命令
Oracle数据库一键上云策略
Oracle数据库一键上云归档
相关实践学习
日志服务之使用Nginx模式采集日志
本文介绍如何通过日志服务控制台创建Nginx模式的Logtail配置快速采集Nginx日志并进行多维度分析。
云深知何处
目录
相关文章
三分钟热度的鱼
|
1月前
|
Oracle 关系型数据库 分布式数据库
PolarDB常见问题之PolarDB(Oracle兼容版) 执行命令报错如何解决
PolarDB是阿里云推出的下一代关系型数据库，具有高性能、高可用性和弹性伸缩能力，适用于大规模数据处理场景。本汇总囊括了PolarDB使用中用户可能遭遇的一系列常见问题及解答，旨在为数据库管理员和开发者提供全面的问题指导，确保数据库平稳运行和优化使用体验。
三分钟热度的鱼
66 1
度假的小鱼
|
6月前
|
Oracle 关系型数据库 数据库
9-2 Oracle数据库（表）的逻辑备份与恢复 --导出与导入
9-2 Oracle数据库（表）的逻辑备份与恢复 --导出与导入
度假的小鱼
86 1
SarPro
|
13天前
|
SQL Oracle 关系型数据库
【Oracle】玩转Oracle数据库（七）：RMAN恢复管理器
【Oracle】玩转Oracle数据库（七）：RMAN恢复管理器
SarPro
40 5
讓丄帝愛伱
|
5月前
|
Oracle Java 关系型数据库
oracle实现主键自增长及自动生成策略
oracle实现主键自增长及自动生成策略
讓丄帝愛伱
198 0
Zh.晨光
|
7月前
|
SQL Oracle 关系型数据库
Oracle杂谈二 SQL*PLUS命令的使用大全
Oracle杂谈二 SQL*PLUS命令的使用大全
Zh.晨光
30 0
snowofsummer
|
2月前
|
Oracle 关系型数据库
oracle 19c 搭建dataguard 简要命令
通过service 完成dg 搭建。
snowofsummer
49 0
疯狂的猿
|
3月前
|
SQL 存储 Oracle
oracle如何定期备份数据库sql文件
【1月更文挑战第7天】oracle如何定期备份数据库sql文件
疯狂的猿
58 8
飞翔的佩奇
|
3月前
|
SQL Oracle 关系型数据库
Linux环境下oracle切换用户并查询数据库命令
Linux环境下oracle切换用户并查询数据库命令
飞翔的佩奇
53 0
坚持学习永不言弃
|
4月前
|
SQL Oracle 关系型数据库
Oracle 常用命令大全
Oracle 常用命令大全
坚持学习永不言弃
73 0
前方一片光明
|
8月前
|
Oracle 关系型数据库 数据库
通过数据泵expdp、impdp方式备份与还原（导出与导入）Oracle数据库
通过数据泵expdp、impdp方式备份与还原（导出与导入）Oracle数据库
前方一片光明
363 0

热门文章

最新文章

  • 1
    【Oracle】玩转Oracle数据库（一）：装上去，飞起来！
  • 2
    【Oracle】玩转Oracle数据库（七）：RMAN恢复管理器
  • 3
    【Oracle】玩转Oracle数据库（二）：体系结构、存储结构与各类参数
  • 4
    Oracle的PL/SQL游标属性：数据的“导航仪”与“仪表盘”
  • 5
    oracle 访问控制
  • 6
    Oracle的三重奏：密码文件、警告文件与跟踪文件
  • 7
    Oracle 12c的自动数据优化（ADO）与热图：数据管理的“瘦身”与“透视”艺术
  • 8
    Oracle的PL/SQL表达式：数据的魔法公式
  • 9
    Oracle日志文件：数据王国的“记事本”
  • 10
    Oracle数据区：数据王国的黄金地段
  • 1
    Oracle数据守卫（DG）：数据的“守护者”与“时光机”
    10
  • 2
    Oracle 12c的内存列存储：数据的“闪电侠”
    14
  • 3
    Oracle 12c的多重索引：数据的“多维导航仪”
    8
  • 4
    Oracle 12c的自动数据优化（ADO）与热图：数据管理的“瘦身”与“透视”艺术
    13
  • 5
    Oracle 12c多租户架构：数据管理的“摩天大楼”
    12
  • 6
    Oracle数据泵：数据迁移的魔法棒
    5
  • 7
    Oracle中的触发器与序列：自增列的魔法组合
    10
  • 8
    Oracle的PL/SQL游标属性：数据的“导航仪”与“仪表盘”
    27
  • 9
    Oracle的PL/SQL循环语句：数据的“旋转木马”与“无限之旅”
    10
  • 10
    Oracle的PL/SQL条件控制：数据的“红绿灯”与“分岔路”
    12

    • 相关电子书

    更多
  • PostgresChina2018_樊文凯_ORACLE数据库和应用异构迁移最佳实践
  • PostgresChina2018_王帅_从Oracle到PostgreSQL的数据迁移
  • Oracle云上最佳实践

    • 相关实验场景

    更多
  • PolarDB的Online DDL功能验证实验
  • 快照备份与恢复
  • PolarDB MySQL从表回收站中恢复误删的表

    • 推荐镜像

    更多
  • oracle
  • mysql
  • arch4edu
    • 下一篇
    部署LAMP环境（Alibaba Cloud Linux 3）