alter database rename file '/data/dblog/redo08.log10' to '/data/oracledata/oradata/mvbox/redo10.log';
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';
还原库搭建完成.
凡事豫则立,不豫则废
我一定要牢记一点,
不要相信自己的技术,
尽量完善各种预案,一旦遇到技术难题,不能解决.
最后一定要切的过来,不丢数据.
永远不因为数据丢失的问题道歉.