rman异地恢复数据库
---------
startup nomount;
set dbid 1826890219
restore spfile from '/data0/rman/c-1826890219-20080710-01';
set dbid 1826890219
restore spfile from '/data0/rman/c-1826890219-20080710-01';
shutdown immediate
startup nomount
startup nomount
restore controlfile from '/data0/rman/c-1826890219-20080710-01';
restore database;
recover database;
alter database open resetlogs;
restore database;
recover database;
alter database open resetlogs;
-------------
遇到问题：
RMAN> restore database;
Starting restore at 03-FEB-11
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/03/2011 12:01:02
ORA-06550: line 1, column 166:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
RMAN-06031: could not translate database keyword
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/03/2011 12:01:02
ORA-06550: line 1, column 166:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
RMAN-06031: could not translate database keyword
oracle@localhost /backup/oracle/rman_backup/data$env | grep LANG
LANG=en_US.UTF-8
oracle@localhost /backup/oracle/rman_backup/data$export LANG=NLS_LANG=american_america.ZHS16GBK
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13177610/viewspace-687005/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
