Prev: which RAC node I am connected to
Next: 10.2.0.5 Patchset (Finally!) Out
From: keekee on 29 Apr 2010 12:31
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
From: Mark D Powell on 30 Apr 2010 10:46
On Apr 29, 12:31 pm, keekee <moongee...(a)gmail.com> wrote:
> 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

Check out the following reference to make sure you did not miss any
needed commands

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#BRADV010

I think you need to rename spfile parameters or provide the pfile name
to be used, you should define at least two online redo logs, probably
want to rename datafiles.

HTH -- Mark D Powell --
 | 
Pages: 1
Prev: which RAC node I am connected to
Next: 10.2.0.5 Patchset (Finally!) Out