ORA-01152 when restoring from RMAN backupset in NOARCHIVELOG mode
Hi all, I got the error ORA-01152 when I tried restoring an Oracle 10g R1 database from an RMAN backupset into a new server. The error returned when it reached to the level of opening the database in resetlogs. Following is what I did in RMAN: set ORACLE_HOME=D:\oracle\product\10.1.0\db_1 set ORACLE_SID=DAWA set PATH=D:\oracle\product\10.1.0\db_1\bin;%PATH% cd %ORACLE_HOME%\bin rman target sys/mypassword Recovery Manager: Release 10.2.0.1.0 - Production on Tue Feb 13 00:36:55 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database (not started) RMAN> startup nomount pfile=X:\temp\DawaPFILE.ORA connected to target database (not started) Oracle instance started Total System Global Area 1048576000 bytes Fixed Size 792200 bytes Variable Size 551807352 bytes Database Buffers 494927872 bytes Redo Buffers 1048576 bytes RMAN> restore controlfile from <font color="navy">'X:\temp\Flash_Rec\DAWA\AUTOBACKUP\2011_07_16\O1_</font> MF_S_756655133_7226R018_.BKP<font color="navy">';</font> Starting restore at 19-JUL-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=270 devtype=DISK channel ORA_DISK_1: restoring controlfile channel ORA_DISK_1: restore complete output filename=D:\ORACLE\ORADATA\DAWA\CONTROL01.CTL output filename=D:\ORACLE\ORADATA\DAWA\CONTROL02.CTL output filename=D:\ORACLE\ORADATA\DAWA\CONTROL03.CTL Finished restore at 17-AUG-11 alter database mount; database mounted catalog backuppiece <font color="navy">'X:\temp\PUMHJATD_1_1'</font>; catalog backuppiece <font color="navy">'X:\temp\PTMHJ91Q_1_1'</font>; <font color="darkgreen">/* Rename the Redologfiles,so that they can be created |
0