数据库每天通过TSM RMAN备份到另一台服务器上,归档文件在/archive目录下。
今天测试恢复数据时,备份的数据恢复都很正常,但当恢复到备份后新生成的归档文件时报如下错误:
unable to find archive log
archive log thread=1 sequence=×××××××××
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/25/2008 14:20:50
RMAN-06054: media recovery requesting unknown log: thread 1 scn ××××××××
而报错说的archivelog文件明明就在该/archive目录下。恢复步骤如下:
rman nocatalog target /
RMAN> run {
allocate channel d1 type 'sbt_tape';
allocate channel d2 type 'sbt_tape';
set until time "TO_DATE('2008-12-25 13:00:00','YYYY-MM-DD HH24:MI:SS')";
restore database;
recover database;
alter database open resetlogs;
release channel d2;
release channel d1;
}请高手释疑。
今天测试恢复数据时,备份的数据恢复都很正常,但当恢复到备份后新生成的归档文件时报如下错误:
unable to find archive log
archive log thread=1 sequence=×××××××××
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/25/2008 14:20:50
RMAN-06054: media recovery requesting unknown log: thread 1 scn ××××××××
而报错说的archivelog文件明明就在该/archive目录下。恢复步骤如下:
rman nocatalog target /
RMAN> run {
allocate channel d1 type 'sbt_tape';
allocate channel d2 type 'sbt_tape';
set until time "TO_DATE('2008-12-25 13:00:00','YYYY-MM-DD HH24:MI:SS')";
restore database;
recover database;
alter database open resetlogs;
release channel d2;
release channel d1;
}请高手释疑。
解决方案 »
- 查询结果自动去除了重复行?
- plsqldeveloper: tns could not resolve the identifier specified,求大侠帮我看一下
- sql中用where判断就
- windows下通过ie访问不到linux环境下的oracle em
- oracle 请问如何查询并修改数据
- FILE_DIR的文件路径动态设定可以吗
- Decode 怎样嵌套使用?
- 这个存储过程怎么错了?
- 请问,在使用select时关于view的速度问题
- 能不能通过设置 Oracle,使得sql语句中不用 to_date 进行日期转换就可以执行?
- 大表关联查询的效率问题?
- sqlserver2000 移植到 Oracle9i 自增列问题
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)';
set until scn=14737892769;
restore database;
recover database;
alter database open resetlogs;
}