RMAN-06031 無(wú)法轉(zhuǎn)換數(shù)據(jù)庫(kù)關(guān)鍵字
數(shù)據(jù)庫(kù):oracle 19.3
系統(tǒng):Windows 11
問(wèn)題描述:rman命令show all時(shí)報(bào)錯(cuò)RMAN-06031,如下所示:
RMAN> show all;
db_unique_name 為 ORCL 的數(shù)據(jù)庫(kù)的 RMAN 配置參數(shù)為:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: 位于 06/11/2022 11:29:22 的 show 命令失敗
RMAN-20021: 數(shù)據(jù)庫(kù)尚未設(shè)置
RMAN-06031: 無(wú)法轉(zhuǎn)換數(shù)據(jù)庫(kù)關(guān)鍵字
提示很明確,無(wú)法轉(zhuǎn)換數(shù)據(jù)庫(kù)關(guān)鍵字,造成此異常通常是因?yàn)樽址脑?
查看數(shù)據(jù)庫(kù)字符集:
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
--------------------------------------------------------------------------------
SIMPLIFIED CHINESE_CHINA.AL32UTF8
修改注冊(cè)表regedit中NLS_LANG值,將其修改為SIMPLIFIED CHINESE_CHINA.ZHS16GBK.
此后正常顯示.
RMAN> show all;
使用目標(biāo)數(shù)據(jù)庫(kù)控制文件替代恢復(fù)目錄
db_unique_name 為 ORCL 的數(shù)據(jù)庫(kù)的 RMAN 配置參數(shù)為:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\ORACLE19C\DATABASE\SNCFORCL.ORA'; # default
