如何做RMAN热备份的恢复 我是用恢复目录做备份的。现在把备份拷贝到其他电脑上做恢复。现在我不是很清楚,Rman到底是从哪里的备份做恢复??? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 以下是我的备份脚本 { allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; allocate channel c4 type disk; allocate channel c5 type disk; allocate channel c6 type disk; backup tablespace idxspace, system, tools, rbs, temp, users, indx, drsys, webspace filesperset = 1format '/full_db_bk/idx_%d_%s_%p_%t' include current controlfile tag = 'EXCEPT_DATSPACE_FULL'; sql 'alter system archive log current'; release channel c1; release channel c2; release channel c3; release channel c4; release channel c5; release channel c6;} 你这在'/full_db_bk/idx_%d_%s_%p_%t'上备份了以上数据文件和control文件,把这些文件可以拷贝到另外的机器上相同的目录,通过RMAN来恢复。 你这在'/full_db_bk/idx_%d_%s_%p_%t'上备份了以上数据文件和control文件,把这些文件可以拷贝到另外的机器上相同的目录,通过RMAN来恢复。由于要恢复control file,要先在nomount的状态下,恢复controlfile先,然后到mount状态,恢复这些datafile。 restore spfile from ...restore controlfilemount datbase;restore databaserecover database; OK,恢复成功。但还是有些异常情况的。例如:RMAN> recover database ;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00558: error encountered while parsing input commandsRMAN-01005: syntax error: found "recover": expecting one of: "allocate, alter, "RMAN-01007: at line 1 column 1 file: standard input输入recover database,就出现以上错误了。跳过这一步后,输入RMAN> alter database open resetlogs 数据库成功打开。现在正常使用了。谢谢各位的帮助和支持。 ora_01704:string literal too long错误 15分求解一台电脑上三个库的数据同步更新问题 structured complex objects(构造的复杂对象) Insert批量数据问题 oracle存储过程触发器问题高手帮忙啊! oracle 用户的只读权限 数据库复制问题 重分答谢解决此问题者 在SQL puls80 有关批量提交SQL语句的问题 mySql使用存储过程批量存取 Oracle权限的叠加 求助:java.sql.SQLException: ORA-00932: inconsistent datatypes: expected %s got %s
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
allocate channel c5 type disk;
allocate channel c6 type disk;
backup
tablespace idxspace, system, tools, rbs, temp, users, indx, drsys, webspace
filesperset = 1
format '/full_db_bk/idx_%d_%s_%p_%t'
include current controlfile
tag = 'EXCEPT_DATSPACE_FULL';
sql 'alter system archive log current';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
release channel c6;
}
你这在'/full_db_bk/idx_%d_%s_%p_%t'上备份了以上数据文件和control文件,把这些文件可以拷贝到另外的机器上相同的目录,通过RMAN来恢复。
你这在'/full_db_bk/idx_%d_%s_%p_%t'上备份了以上数据文件和control文件,把这些文件可以拷贝到另外的机器上相同的目录,通过RMAN来恢复。由于要恢复control file,要先在nomount的状态下,恢复controlfile先,然后到mount状态,恢复这些datafile。
recover database;
但还是有些异常情况的。
例如:
RMAN> recover database ;RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "recover": expecting one of: "allocate, alter, "
RMAN-01007: at line 1 column 1 file: standard input
输入recover database,就出现以上错误了。跳过这一步后,输入RMAN> alter database open resetlogs 数据库成功打开。现在正常使用了。谢谢各位的帮助和支持。