I just completed a restore of the DB to another box as a backup. But I'm getting an error when I try to open the database. Can someone help me out?
starting media recovery
channel c1: starting archive log restore to default destination
channel c1: restoring archive log
archive log thread=1 sequence=12076
channel c1: reading from backup piece D:\ORACLE_BACKUP\ORA_DF736444810_S1580_S1
channel c1: restored backup piece 1
piece handle=D:\ORACLE_BACKUP\ORA_DF736444810_S1580_S1 tag=TAG20101130T155909
channel c1: restore complete, elapsed time: 00:00:17
archive log filename=+DATA/ts/arc12076_0591973331.001 thread=1 sequence=12076
media recovery complete, elapsed time: 00:00:01
Finished recover at 01-DEC-10
released channel: c1
RMAN> EXIT
Recovery Manager complete.
C:\Users\Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Dec 1 17:33:59 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> connect / as sysdba
Connected.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1317011456 bytes
Fixed Size 1292348 bytes
Variable Size 956303300 bytes
Database Buffers 352321536 bytes
Redo Buffers 7094272 bytes
SQL> alter database mount;
Database altered.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery