duplicate database by using RMAN

From: keekee <moongeegee_at_gmail.com>
Date: Thu, 29 Apr 2010 09:31:54 -0700 (PDT)
Message-ID: <ac848b63-81c6-4c73-8e03-07ca394aaede_at_d19g2000yqf.googlegroups.com>

Hi, Please help.
I use Window XP with 10g 10.2.0.1.0

After I am done the RMAN as below:

RMAN> RUN
{
SET NEWNAME FOR DATAFILE 1 TO 'C:\oracle\product\10.2.0\db_1\ORCL\sys \O1_MF_SYSTEM_2KC457M1_.DBF';
....
....
....

\product\10.2.0\db_1\ORCL\usr\O1_MF_DIMS_DAT_5NDQLP73_.DBF'; DUPLICATE TARGET DATABASE TO ORCL
PFILE = C:\oracle\product\10.2.0\initdw.ora NOFILENAMECHECK
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\db_1\ORCL\rdo \O1_MF_1_2KC3YZ0H_.LOG',
'C:\oracle\product\10.2.0\db_1\ORCL\

......
.....
....

}

The did the following procedures. How do I start with the databse I just used RMAN copy over into my system.

SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 612368384 bytes Fixed Size 1250428 bytes
Variable Size 184552324 bytes
Database Buffers 419430400 bytes
Redo Buffers 7135232 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> select OPEN_RESETLOGS from v$database;

OPEN_RESETL

---

REQUIRED SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

SQL> startup mount;
ORACLE instance started. <= I "startup mount" again, and I did not get errors.

Total System Global Area 612368384 bytes Fixed Size 1250428 bytes
Variable Size 184552324 bytes
Database Buffers 419430400 bytes
Redo Buffers 7135232 bytes
Database mounted.
SQL> select OPEN_RESETLOGS from v$database;

OPEN_RESETL

---

NOT ALLOWED Received on Thu Apr 29 2010 - 11:31:54 CDT