Home » RDBMS Server » Backup & Recovery » rman duplicate (Windows XP 10g 10.2.0.1)
rman duplicate [message #453545] Thu, 29 April 2010 10:12 Go to next message
keekee
Messages: 19
Registered: April 2010
Junior Member
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

Report message to a moderator

Re: rman duplicate [message #453547 is a reply to message #453545] Thu, 29 April 2010 10:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Check the concerned databases alert_sid.log.
Post the relevant errors.

Report message to a moderator

Re: rman duplicate [message #453548 is a reply to message #453547] Thu, 29 April 2010 10:25 Go to previous messageGo to next message
keekee
Messages: 19
Registered: April 2010
Junior Member
I cannot find alert_sid.log file.

Thanks

Report message to a moderator

Re: rman duplicate [message #453550 is a reply to message #453548] Thu, 29 April 2010 10:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Right-click on the root directory of disk -> search -> alert*.log

Regards
Michel

Report message to a moderator

Re: rman duplicate [message #453557 is a reply to message #453550] Thu, 29 April 2010 11:37 Go to previous messageGo to next message
keekee
Messages: 19
Registered: April 2010
Junior Member
that what I did. I did a search on my c:\drive, but I cannot find
it.
Thanks

Report message to a moderator

Re: rman duplicate [message #453558 is a reply to message #453557] Thu, 29 April 2010 11:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results from following command

SET

Report message to a moderator

Re: rman duplicate [message #453560 is a reply to message #453557] Thu, 29 April 2010 11:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
keekee wrote on Thu, 29 April 2010 18:37
that what I did. I did a search on my c:\drive, but I cannot find
it.
Thanks

Note that I said "alert*.log" when you said "alert_sid.log".
Which one did you try?
Do it on all drives.

Regards
Michel

[Updated on: Thu, 29 April 2010 11:51]

Report message to a moderator

Re: rman duplicate [message #453570 is a reply to message #453560] Thu, 29 April 2010 13:00 Go to previous message
keekee
Messages: 19
Registered: April 2010
Junior Member
Thank you very much.
I finally found the alert log file.
I upload the file. Please find the attached file alert_orcl.log
And please help.
Thanks

[Updated on: Thu, 29 April 2010 13:25]

Report message to a moderator

Previous Topic: Archive files deleted during HOT backup
Next Topic: Sid name
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 04:47:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.