primary :
执行备份:
run{allocat channel ch1 type disk;
backup full format='/oracle/arch/rman/full_backup_%s' database include current controlfile for standby plus archivelog delete input;
release channel ch1;
}
生成备份文件:
full_backup_1200
full_backup_1201
full_backup_1202
full_backup_1203将备份文件拷贝到STANDBY 对应的目录下:
restore controlfile from '这里应该是上面 备份文件中的哪个呢? '
请问这时候怎么解析处理controlfile 文件呢?
谢谢
执行备份:
run{allocat channel ch1 type disk;
backup full format='/oracle/arch/rman/full_backup_%s' database include current controlfile for standby plus archivelog delete input;
release channel ch1;
}
生成备份文件:
full_backup_1200
full_backup_1201
full_backup_1202
full_backup_1203将备份文件拷贝到STANDBY 对应的目录下:
restore controlfile from '这里应该是上面 备份文件中的哪个呢? '
请问这时候怎么解析处理controlfile 文件呢?
谢谢
创建 standby 控制文件,复制到备用库的相应位置
执行备份:
run{allocat channel ch1 type disk;
backup full format='/oracle/arch/rman/full_backup_%s' database include current controlfile for standby plus archivelog delete input;
release channel ch1;
}
生成备份文件:
full_backup_1200
full_backup_1201
full_backup_1202
full_backup_1203将备份文件拷贝到STANDBY 对应的目录下:
restore controlfile from '这里应该是上面 备份文件中的哪个呢? '
请问这时候怎么解析处理controlfile 文件呢?
难道 我这句话backup full format='/oracle/arch/rman/full_backup_%s' database include current controlfile for standby plus archivelog delete input;
并没有备份出控制文件码?
==============================================================
在主库的 rman 中执行 list backupset 命令查看control file 在哪个 backup set 中
LIST BACKUPSET
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1202 Full 86G DISK 00:17:02 27-FEB-13
BP Key: 4614 Status: AVAILABLE Tag: TAG20130227T180105
Piece Name: '/oracle/arch/rman/full_backup_glife_1202
Controlfile Included: Ckp SCN: 3667319629 Ckp time: 27-FEB-13
List of Datafiles in backup set 1202
File LV Type Ckp SCN Ckp Time Name我把备份拷贝到STANDBY上
RMAN> restore controlfile from 'oracle/arch/rman/full_backup_1202';Starting restore at 28-FEB-13using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/28/2013 14:00:40
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
你确定这个路径oracle/arch/rman/full_backup_1202是对的?
LIST BACKUPSET
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1202 Full 86G DISK 00:17:02 27-FEB-13
BP Key: 4614 Status: AVAILABLE Tag: TAG20130227T180105
Piece Name: '/oracle/arch/rman/full_backup_glife_1202 Controlfile Included: Ckp SCN: 3667319629 Ckp time: 27-FEB-13
List of Datafiles in backup set 1202
File LV Type Ckp SCN Ckp Time Name
在STANDBY 上也是这个目录。