rman
5icode.top
https://5icode.top
https://5icode.top
展开
-
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status- 未完待续
RMAN> delete obsolete;RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1using channel ORA_DISK_1using channel ORA_DISK_2Deleting the following obsol原创 2015-01-30 00:25:02 · 1275 阅读 · 0 评论 -
nomount 状态 编录也能查看备份信息--控制文件丢失也是nomount状态?
[oracle@Slave1Hadoop51 ~]$ rman target sys/ml123456@db01 catalog rcowner/rcowner@db02Recovery Manager: Release 10.2.0.1.0 - Production on Sat Feb 7 00:06:24 2015Copyright (c) 1982, 2005, O原创 2015-02-07 00:31:23 · 624 阅读 · 0 评论 -
恢复编录-前奏曲
RMAN> delete noprompt backup;allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=120 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=159 devtype=DISKallocated channel: ORA_DISK原创 2015-02-05 23:42:15 · 717 阅读 · 0 评论 -
找回被转移的备份文件 delete expired ;catalog
RMAN> list backup of tablespace users;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- -----------原创 2015-02-03 23:04:10 · 887 阅读 · 0 评论 -
常用rman命令
device type diskRMAN> validate device type disk backupset 37;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =====原创 2015-02-04 00:14:00 · 682 阅读 · 0 评论 -
report need backup redundancy 1 tablespace users;删除"过期"备份
RMAN> report need backup redundancy 1 tablespace users;Report of files with less than 1 redundant backupsFile #bkps Name---- ----- -----------------------------------------------------4 0原创 2015-02-03 00:17:03 · 712 阅读 · 0 评论 -
could not translate tablespace name "TEST_TBS"
RMAN> list backup of tablespace TEST_TBS;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571:原创 2015-02-01 15:27:41 · 962 阅读 · 0 评论 -
report need backup备份冗余度
RMAN> delete backup;using channel ORA_DISK_1using channel ORA_DISK_2List of Backup PiecesBP Key BS Key Pc# Cp# Status Device Type Piece Name------- ------- --- --- ----------- ----------原创 2015-02-02 22:20:20 · 1109 阅读 · 0 评论 -
rman 进度条--待续 定时计划
RMAN> list copy;List of Archived Log CopiesKey Thrd Seq S Low Time Name------- ---- ------- - --------- ----1 1 1 A 31-AUG-14 /u01/oracle/11G/dbs/arch1_1_857057445.dbf2原创 2015-02-02 21:28:28 · 560 阅读 · 0 评论 -
backup 的路径
RMAN> show2> all;RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defau原创 2015-02-01 15:41:55 · 1196 阅读 · 0 评论 -
rm手动直接删除oracle的备份片段,用list backup查还显示出来
RMAN> list backup;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------64原创 2015-02-01 13:53:46 · 1013 阅读 · 0 评论 -
rman 屏幕日志 输出到文件
RMAN> rman log /home/oracle/nosetdesc/logs/rman_log.txt;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============原创 2015-02-01 13:14:10 · 2359 阅读 · 0 评论 -
rman 归档日志 crosscheck
RMAN> list backup of copy;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ================原创 2015-02-01 14:10:58 · 1978 阅读 · 0 评论 -
to mismatched status. Use CROSSCHECK command to fix status
RMAN> show all;RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # default原创 2015-02-01 12:32:10 · 1749 阅读 · 0 评论 -
ORA-19571: archived-log recid 31 stamp 858722423 not found in control file
所有归档日志镜像复制,报错了!!!RMAN> run{allocate channel 3 device type disk;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =======原创 2015-01-29 23:54:28 · 2854 阅读 · 0 评论 -
归档 及 日志 路径
SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination /u01/oracle/11G/dbs/archOldest online log sequence 2Next log sequence to原创 2016-06-28 08:48:46 · 827 阅读 · 0 评论