hzdxw的专栏

欢迎大家的来访,希望积极评论,共同进步!!!

归档 及 日志 路径

SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/oracle/11G/dbs/arch...

2016-06-28 08:48:46

阅读数 414

评论数 0

nomount 状态 编录也能查看备份信息--控制文件丢失也是nomount状态?

[oracle@Slave1Hadoop51 ~]$ rman target sys/ml123456@db01 catalog rcowner/rcowner@db02 Recovery Manager: Release 10.2.0.1.0 - Production on Sat F...

2015-02-07 00:31:23

阅读数 443

评论数 0

恢复编录-前奏曲

RMAN> delete noprompt backup; allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=120 devtype=DISK allocated channel: ORA_DISK_2 channel ORA_DI...

2015-02-05 23:42:15

阅读数 582

评论数 0

常用rman命令

device type disk RMAN> validate device type disk backupset 37; RMAN-00571: =========================================================== RMAN-00...

2015-02-04 00:14:00

阅读数 455

评论数 0

找回被转移的备份文件 delete expired ;catalog

RMAN> list backup of tablespace users; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion T...

2015-02-03 23:04:10

阅读数 787

评论数 0

report need backup redundancy 1 tablespace users;删除"过期"备份

RMAN> report need backup redundancy 1 tablespace users; Report of files with less than 1 redundant backups File #bkps Name ---- ----- -----------...

2015-02-03 00:17:03

阅读数 553

评论数 0

report need backup备份冗余度

RMAN> delete backup; using channel ORA_DISK_1 using channel ORA_DISK_2 List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Pie...

2015-02-02 22:20:20

阅读数 745

评论数 0

rman 进度条--待续 定时计划

RMAN> list copy; List of Archived Log Copies Key Thrd Seq S Low Time Name ------- ---- ------- - --------- ---- 1 1 1 A ...

2015-02-02 21:28:28

阅读数 439

评论数 0

backup 的路径

RMAN> show 2> all; RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF;...

2015-02-01 15:41:55

阅读数 837

评论数 0

could not translate tablespace name "TEST_TBS"

RMAN> list backup of tablespace TEST_TBS; RMAN-00571: =========================================================== RMAN-00569: =============== ER...

2015-02-01 15:27:41

阅读数 643

评论数 0

rman 归档日志 crosscheck

RMAN> list backup of copy; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STAC...

2015-02-01 14:10:58

阅读数 912

评论数 0

rm手动直接删除oracle的备份片段,用list backup查还显示出来

RMAN> list backup; List of Backup Sets =================== BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ...

2015-02-01 13:53:46

阅读数 575

评论数 0

rman 屏幕日志 输出到文件

RMAN> rman log /home/oracle/nosetdesc/logs/rman_log.txt; RMAN-00571: =========================================================== RMAN-00569: ===...

2015-02-01 13:14:10

阅读数 1610

评论数 0

to mismatched status. Use CROSSCHECK command to fix status

RMAN> show all; RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # def...

2015-02-01 12:32:10

阅读数 1160

评论数 0

RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status- 未完待续

RMAN> delete obsolete; RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 using channel ORA_DISK_1...

2015-01-30 00:25:02

阅读数 877

评论数 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-0056...

2015-01-29 23:54:28

阅读数 2211

评论数 0

提示
确定要删除当前文章?
取消 删除