做时间点的不完全恢复，总提示无效月份？

显示全部楼层 · 2005-2-4 16:05:12

我在.profile（solaris机器）文件中明明设置了NLS_DATE_FORMAT="YYYY/MM/DD hh24:mi:ss"，但：
RMAN> run{
2> set until time '2005/02/04 16:05:12';
3>restore database;
4>recover database;
5> }
正在执行命令: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 02/04/2005 18:08:13
ORA-01861: 文字与格式字符串不匹配。
后又试过：
RMAN>run{
2> set until time '02/04/2005 16:05:12';
3> restore database;
4>recover database;
5> }
正在执行命令: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 02/04/2005 18:10:27
ORA-01843: 无效的月份
还试过很多种方法：'2005-02-04 16:05:12' ， '2005/02/04 16:05:12'都提示无效月份，或文字与格式字符串不匹配，该怎么办呀？

千问 · 2005-2-4 16:05:12

看以下格式
SELECT SYSDATE FROM DUAL；

千问 · 2005-2-4 16:05:12

rman> run {
set until time "to_date('2005/02/04 20:55:12','yyyy/mm/dd hh24:mi:ss')";
restore database;
recover database;
}

千问 · 2005-2-4 16:05:12

配置好你的NLS_DATE_FORMAT环境变量
需要和你set until time '02/04/2005 16:05:12';中的格式一致
NLS_DATE_FORMAT='mm/dd/yyyy hh24Lmi:ss';
export NLS_DATE_FORMAT
windows中的修改注册表，或者你用alter session,反正改成一致就可以了
你可以用select sysdate from dual来确认一下

千问 · 2005-2-4 16:05:12

谢谢各位的关注，我的问题已解决，按照AndyChan说的，
set until time "to_date('2005/02/04 20:55:12','yyyy/mm/dd hh24:mi:ss')";
就解决了。

千问 · 2005-2-4 16:05:12

日期的格式不出错，可是又出现一个问题，我在这个时间点前没有做数据库的全备份，但是做了0级备份，以及归档日志的备份，这时再做时间点的不完全恢复应该可以吧，但总出现很多数据文件找不到的错误。
难道只有数据库的全备份才能做不完全恢复么？（0级备份＋归档日志）就不可以做不完全恢复么？

千问 · 2005-2-4 16:05:12

最初由 bingcha320 发布
[B]日期的格式不出错，可是又出现一个问题，我在这个时间点前没有做数据库的全备份，但是做了0级备份，以及归档日志的备份，这时再做时间点的不完全恢复应该可以吧，但总出现很多数据文件找不到的错误。
难道只有数据库的全备份才能做不完全恢复么？（0级备份＋归档日志）就不可以做不完全恢复么？ [/B]

0級備份其實就相當於全備份，只是它多了，可以做增量備份的基礎而已。
所以0級備份以及归档日志的备份是可以做不完全恢復的。

千问 · 2005-2-4 16:05:12

哦，我想起来了，做0级备份的时候，我是这样做的，是不是归档日志也一起备份了，
run{
allocate channel dev1 type disk;
allocate channel dev2 type disk;
allocate channel dev3 type disk;
backup incremental level 0 tag ‘dbL0’ format ‘/fy/dbL0%u_%s_%p’
database skip readonly; #备份时，跳过只读表空间
sql ‘alter system archive log current’;
backup filesperset 3 format ‘/fy/arch%u_%s_%p’
archivelog all delete input; #备份归档可选，可以单独定期备份
release channel dev1;
release channel dev2;
release channel dev3;
}

千问 · 2005-2-4 16:05:12

我只运行了上面的那一个教本，应该是（0级备份＋归档日志）吧，
但为什么我在做时间点的不完全恢复时，提示：
RMAN> run{
2> set until time "to_date('2005/02/04 16:05:12','yyyy/mm/dd hh24:mi:ss')";
3> restore database;
4>recover database;
5> }
正在执行命令: SET until clause
启动 restore 于 05-2月 -05
使用通道 ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/05/2005 10:08:34
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 31 found to restore
RMAN-06023: no backup or copy of datafile 30 found to restore
RMAN-06023: no backup or copy of datafile 29 found to restore
RMAN-06023: no backup or copy of datafile 28 found to restore
RMAN-06023: no backup or copy of datafile 27 found to restore
RMAN-06023: no backup or copy of datafile 26 found to restore
RMAN-06023: no backup or copy of datafile 25 found to restore
RMAN-06023: no backup or copy of datafile 24 found to restore
RMAN-06023: no backup or copy of datafile 23 found to restore
RMAN-06023: no backup or copy of datafile 22 found to restore
RMAN-06023: no backup or copy of datafile 21 found to restore
RMAN-06023: no backup or copy of datafile 20 found to restore
RMAN-06023: no backup or copy of datafile 19 found to restore
RMAN-06023: no backup or copy of datafile 18 found to restore
RMAN-06023: no backup or copy of datafile 17 found to restore
RMAN-06023: no backup or copy of datafile 16 found to restore
RMAN-06023: no backup or copy of datafile 15 found to restore
RMAN-06023: no backup or copy of datafile 14 found to restore
RMAN-06023: no backup or copy of datafile 13 found to restore
RMAN-06023: no backup or copy of datafile 12 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

千问 · 2005-2-4 16:05:12

你這個0級備份是在'2005/02/04 16:05:12'之前做的嗎？我估計不是。
你可以現在再從新做一次測試。