ORA-01861: literal does not match format string
3.ORA-01861: literal does not match format string
RMAN> recover database until time '2022-07-15 11:41:52' skip forever tablespace ysprod:SYSTEM, ysprod:SYSAUX, ysprod:UNDOTBS1, ysprod:USERS, ysprod:admin;

Starting recover at 15-JUL-22
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/15/2022 14:22:47
ORA-01861: literal does not match format string

RMAN> alter session set NLS_DATE_FORMAT = 'yyyy-mm-dd HH24:MI:SS';

Statement processed

RMAN> recover database until time '2022-07-15 11:41:52' skip forever tablespace ysprod:SYSTEM, ysprod:SYSAUX, ysprod:UNDOTBS1, ysprod:USERS, ysprod:admin;

Starting recover at 15-JUL-22
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_DISK_1

Executing: alter database datafile 14 offline drop
Executing: alter database datafile 15 offline drop
Executing: alter database datafile 16 offline drop
Executing: alter database datafile 17 offline drop
Executing: alter database datafile 18 offline drop
starting media recovery

archived log for thread 1 with sequence 14 is already on disk as file /data/orcl/redo02.log
archived log for thread 1 with sequence 15 is already on disk as file /data/orcl/redo03.log
archived log for thread 1 with sequence 16 is already on disk as file /data/orcl/redo01.log
channel ORA_SBT_TAPE_1: starting archived log restore to default destination
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=12
channel ORA_SBT_TAPE_1: restoring archived log
archived log thread=1 sequence=13
channel ORA_SBT_TAPE_1: reading from backup piece 361_ORCL_2512jjjk_1_1
channel ORA_SBT_TAPE_1: piece handle=361_ORCL_2512jjjk_1_1 tag=TAG20220714T152124
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:01
archived log file name=/opt/oracle12c/archivelog/1_12_1109714423.dbf thread=1 sequence=12
archived log file name=/opt/oracle12c/archivelog/1_13_1109714423.dbf thread=1 sequence=13
archived log file name=/data/orcl/redo02.log thread=1 sequence=14
archived log file name=/data/orcl/redo03.log thread=1 sequence=15
archived log file name=/data/orcl/redo01.log thread=1 sequence=16
media recovery complete, elapsed time: 00:00:06
Finished recover at 15-JUL-22
暂无评论

发送评论 编辑评论


				
|´・ω・)ノ
ヾ(≧∇≦*)ゝ
(☆ω☆)
(╯‵□′)╯︵┴─┴
 ̄﹃ ̄
(/ω\)
∠( ᐛ 」∠)_
(๑•̀ㅁ•́ฅ)
→_→
୧(๑•̀⌄•́๑)૭
٩(ˊᗜˋ*)و
(ノ°ο°)ノ
(´இ皿இ`)
⌇●﹏●⌇
(ฅ´ω`ฅ)
(╯°A°)╯︵○○○
φ( ̄∇ ̄o)
ヾ(´・ ・`。)ノ"
( ง ᵒ̌皿ᵒ̌)ง⁼³₌₃
(ó﹏ò。)
Σ(っ °Д °;)っ
( ,,´・ω・)ノ"(´っω・`。)
╮(╯▽╰)╭
o(*////▽////*)q
>﹏<
( ๑´•ω•) "(ㆆᴗㆆ)
😂
😀
😅
😊
🙂
🙃
😌
😍
😘
😜
😝
😏
😒
🙄
😳
😡
😔
😫
😱
😭
💩
👻
🙌
🖕
👍
👫
👬
👭
🌚
🌝
🙈
💊
😶
🙏
🍦
🍉
😣
Source: github.com/k4yt3x/flowerhd
颜文字
Emoji
小恐龙
花!
上一篇
下一篇