oracle:+操作手记--RMAN

最新推荐文章于 2021-04-13 12:49:58 发布

Dojo的频道

最新推荐文章于 2021-04-13 12:49:58 发布

阅读量1.4k

点赞数

分类专栏： oracle与c++开发文章标签： oracle thread object disk file centos

本文链接：https://blog.csdn.net/lzx_bupt/article/details/6852453

版权

本文记录了使用RMAN备份Oracle数据库的归档日志，并在CentOS上创建Catalog数据库的过程。通过RMAN命令，完成了全部归档日志的备份，删除了旧的归档日志，并创建了Catalog表空间和用户，授权并连接到Catalog数据库进行管理。

摘要由CSDN通过智能技术生成

记录备用：

********************备份全部的归档日志****************************

RMAN> backup archivelog all format '/oracle/mercury/recovery/ar_%U' delete all input;

Starting backup at 09-OCT-11
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=31 RECID=1 STAMP=764075161
input archived log thread=1 sequence=32 RECID=2 STAMP=764075240
input archived log thread=1 sequence=33 RECID=3 STAMP=764075252
input archived log thread=1 sequence=34 RECID=4 STAMP=764075422
input archived log thread=1 sequence=35 RECID=5 STAMP=764075531
input archived log thread=1 sequence=36 RECID=6 STAMP=764075807
channel ORA_DISK_1: starting piece 1 at 09-OCT-11
channel ORA_DISK_1: finished piece 1 at 09-OCT-11
piece handle=/oracle/mercury/recovery/ar_06molnp0_1_1 tag=TAG20111009T111648 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/oracle/mercury/recovery/MERCURY/archivelog/2011_10_09/o1_mf_1_31_793g2hvm_.arc RECID=1 STAMP=764075161
archived log file name=/oracle/mercury/recovery/MERCURY/archivelog/2011_10_09/o1_mf_1_32_793g58pn_.arc RECID=2 STAMP=764075240
archived log file name=/oracle/mercury/recovery/MERCURY/archivelog/2011_10_09/o1_mf_1_33_793g