100字范文,内容丰富有趣,生活中的好帮手!
100字范文 > oracle 删除已备份归档 通过RMAN联机全库备份 包括控制文件 归档日志文件 备份成

oracle 删除已备份归档 通过RMAN联机全库备份 包括控制文件 归档日志文件 备份成

时间:2020-08-30 14:46:44

相关推荐

oracle 删除已备份归档 通过RMAN联机全库备份 包括控制文件 归档日志文件 备份成

RMAN> backup as backupset full database format ‘/u01/app/backup/db_%U.rmn‘ include current controlfile plus archivelog delete all input;

Starting backup at 10-OCT-16

current log archived

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=143 device type=DISK

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=11 RECID=6 STAMP=924895260

channel ORA_DISK_1: starting piece 1 at 10-OCT-16

channel ORA_DISK_1: finished piece 1 at 10-OCT-16

piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/0bri1i0t_1_1 tag=TAG1010T192101 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_11_924890639.dbf RECID=6 STAMP=924895260

Finished backup at 10-OCT-16

Starting backup at 10-OCT-16

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/ORA11GR2/system01.dbf

input datafile file number=00002 name=/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf

input datafile file number=00005 name=/u01/app/oracle/oradata/ORA11GR2/example01.dbf

input datafile file number=00003 name=/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf

input datafile file number=00004 name=/u01/app/oracle/oradata/ORA11GR2/users01.dbf

channel ORA_DISK_1: starting piece 1 at 10-OCT-16

channel ORA_DISK_1: finished piece 1 at 10-OCT-16

piece handle=/u01/app/backup/db_0cri1i0v_1_1.rmn tag=TAG1010T192103 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:05:42

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

including current SPFILE in backup set

channel ORA_DISK_1: starting piece 1 at 10-OCT-16

channel ORA_DISK_1: finished piece 1 at 10-OCT-16

piece handle=/u01/app/backup/db_0dri1ibl_1_1.rmn tag=TAG1010T192103 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 10-OCT-16

Starting backup at 10-OCT-16

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=12 RECID=7 STAMP=924895610

channel ORA_DISK_1: starting piece 1 at 10-OCT-16

channel ORA_DISK_1: finished piece 1 at 10-OCT-16

piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/0eri1ibq_1_1 tag=TAG1010T192650 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

channel ORA_DISK_1: deleting archived log(s)

archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_12_924890639.dbf RECID=7 STAMP=924895610

Finished backup at 10-OCT-16

原文:/tomatoes-/p/5947603.html

oracle 删除已备份归档 通过RMAN联机全库备份 包括控制文件 归档日志文件 备份成功后 删除已备份的归档日志。...

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。