Re: duplicate database by using RMAN
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 30 Apr 2010 07:46:19 -0700 (PDT)
Message-ID: <68e76832-5605-4289-ab9d-df64721ba3d7_at_s29g2000yqd.googlegroups.com>
On Apr 29, 12:31 pm, keekee <moongee..._at_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
Date: Fri, 30 Apr 2010 07:46:19 -0700 (PDT)
Message-ID: <68e76832-5605-4289-ab9d-df64721ba3d7_at_s29g2000yqd.googlegroups.com>
On Apr 29, 12:31 pm, keekee <moongee..._at_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 -- Received on Fri Apr 30 2010 - 09:46:19 CDT