10 rows selected.

alter database rename file '/data/oracledata/oradata/mvbox/redo04.log1' to '/data/oracledata/oradata/mvbox/redo1.log';

Database altered.

alter database rename file '/data/dblog/redo04.log2' to '/data/oracledata/oradata/mvbox/redo2.log';

Database altered.

alter database rename file '/data/oracledata/oradata/mvbox/redo05.log3' to '/data/oracledata/oradata/mvbox/redo3.log';

Database altered.

alter database rename file '/data/dblog/redo05.log4' to '/data/oracledata/oradata/mvbox/redo4.log';

Database altered.

alter database rename file '/data/oracledata/oradata/mvbox/redo06.log5' to '/data/oracledata/oradata/mvbox/redo5.log';

Database altered.

alter database rename file '/data/dblog/redo06.log6' to '/data/oracledata/oradata/mvbox/redo6.log';

Database altered.

alter database rename file '/data/oracledata/oradata/mvbox/redo07.log7' to '/data/oracledata/oradata/mvbox/redo7.log';

Database altered.

alter database rename file '/data/dblog/redo07.log8' to '/data/oracledata/oradata/mvbox/redo8.log';

Database altered.

alter database rename file '/data/oracledata/oradata/mvbox/redo08.log9' to '/data/oracledata/oradata/mvbox/redo9.log';

Database altered.

SQL> alter database rename file '/data/dblog/redo08.log10' to '/data/oracledata/oradata/mvbox/redo10.log';

Database altered.

SQL> alter database open resetlogs;

Database altered.

SQL>

? ? 现在数据库虽然已经拉起来了,但是注意还有临时表空间。
? 给默认临时表空间增加一个数据文件.
? 然后删除其他数据文件,重新添加
? (备份不包括临时表空间,所以拉起之后,临时表空间需要另外处理一下)

ALTER TABLESPACE TEMP
ADD TEMPFILE '/data/oracledata/oradata/mvbox/temp03.dbf'
SIZE 4G?
AUTOEXTEND ON
NEXT 128M
MAXSIZE 30G;

ALTER TABLESPACE TEMP DROP TEMPFILE '/dbdata/oracledata/mvbox/temp01.dbf';
ALTER TABLESPACE TEMP DROP TEMPFILE '/dbdata/oracledata/mvbox/temp02.dbf';

还原库搭建完成.

凡事豫则立,不豫则废
我一定要牢记一点,
不要相信自己的技术,
尽量完善各种预案,一旦遇到技术难题,不能解决.
最后一定要切的过来,不丢数据.
永远不因为数据丢失的问题道歉.