=============== ERROR MESSAGESTACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-03002: failure of restore command at04/02/2015 13:37:05
RMAN-06509: only SPFILE or control file canbe restored from AUTOBACKUP
RMAN>
看到打开都报错了,所以试试直接open打开吧
SQL> SQL> alter database open resetlogs
3,然后exp导出表数据,imp导入到生产环境
导出:exp system/manager@myoracle file=/tmp/qd.dmp tables=(hr_resume_qingdao) system是用户名,manager 是密码,myoracle 是数据库名。
传输数据:scp /tmp/qd.dmp 192.168.120.217:/tmp/
导入:imp username/pwd[@sid] file=/tmp/ qd.dmp tables=( hr_resume_qingdao)
4,一些报错记录
找到数据文件
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01200: actual file size of 128679 issmaller than correct size of 340480
blocks
ORA-01110: data file 2:'/home/oradata/powerdes/sysaux01.dbf'
解决方法:
dd if=/dev/zeroof=/home/oradata/powerdes/sysaux01.dbf bs=8192 count=1 seek=340480
?