利用RMAN把ORACLE 10G 64位降级为32位(二)
:08 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: itspfdb (not mounted)
RMAN> restore controlfile from '/u01/app/oracle/backup/c-4014947212-20130919-01';
RMAN> exit
Recovery Manager complete.
--还原数据库
[oracle@itspf ~]$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Sep 26 02:09:44 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: itspfdb (not mounted)
RMAN>
alter database mount;
RMAN> restore database
--恢复数据库。
SQL>startup mount;
--在其中可能有需要几个归档文件，可以把原库当天备份的归档文件拷贝过来 选择AUTO
SQL>recover database using BACKUP CONTROLFILE until cancel;
SQL>alter database open resetlogs;
SQL>shutdown immediate
-- 进行降级后的操作
SQL>Shutdown immediate
SQL>startup migrate
SQL>@$ORACLE_HOME/rdbms/admin/utlirp.sql;
SQL>Shutdown immediate
SQL>Startup
SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql;
SQL>Shutdown immediate
SQL>Startup