Home » RDBMS Server » Backup & Recovery » Moving database with RMAN requires archive logs? (Oracle 10g, 10.2.01 Linux to 10.2.0.4 Windows)
Moving database with RMAN requires archive logs? [message #390570] Sat, 07 March 2009 10:57 Go to next message
crb0r
Messages: 3
Registered: March 2009
Location: Kitchener, ON
Junior Member
Hi everyone,

I'm trying to move an Oracle database from Linux (10.2.0.1) to Windows (10.2.0.4) using RMAN and CONVERT DATABASE (http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/dbxptrn.htm).

The basic procedure is to open the database read-only, then use RMAN to create a converted copy on the Linux machine. I then SCP the data/init file/transport script to the Windows machine, change the paths, and attempt to bring the database online.

The script fails at this point:

SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'C:\ORACLE\PRODUCT\10.2.0\DB_1\ORADATA\BHP\SYSTEM01.DBF'


Archive logs were not enabled on the source server, and even if they were, they would presumably only apply to the source database, not the copy (with a new name) that was created by CONVERT DATABASE.

It seems to me the best thing to do here would be to have the database shut down before running the CONVERT, so it's guaranteed to be consistent, but I can't connect with RMAN if it is!

Anyone got any suggestions here?

Regards,
Craig
Re: Moving database with RMAN requires archive logs? [message #390609 is a reply to message #390570] Sun, 08 March 2009 10:27 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
Hi,

You should do that when database is in mount status.

In your case, it is actually require the online logs to make the database in consistent.

Regards,
Alex
Re: Moving database with RMAN requires archive logs? [message #390610 is a reply to message #390570] Sun, 08 March 2009 10:34 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I'm trying to move an Oracle database from Linux (10.2.0.1) to Windows (10.2.0.4)
Changing OS & Oracle version in a single move is VERY ambitious; which some might classify as unwise.

First make it work, then make it fancy.
Re: Moving database with RMAN requires archive logs? [message #390611 is a reply to message #390570] Sun, 08 March 2009 10:56 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
It should be sufficient enough for the database to be in READ ONLY mode, but I don't think Oracle supports duplicating between different patchset levels. That isn't to say that it isn't doable, but you may encounter the type of errors you are receiving.
Re: Moving database with RMAN requires archive logs? [message #390612 is a reply to message #390610] Sun, 08 March 2009 11:06 Go to previous messageGo to next message
crb0r
Messages: 3
Registered: March 2009
Location: Kitchener, ON
Junior Member
Fair enough; part of the reason for doing this was to move some unnecessary databases so we could upgrade the machine from 10.2.0.1 to 10.2.0.4.

I ended up moving the DB with expdp/impdp but had hoped it would be easier.
Re: Moving database with RMAN requires archive logs? [message #390753 is a reply to message #390612] Mon, 09 March 2009 11:10 Go to previous messageGo to next message
sstraube
Messages: 3
Registered: July 2008
Junior Member
You could have done: recover database [using backup controlfile] until cancel.
When it asks for more logs you can type CANCEL.
Follow this with: Alter database open resetlogs
and you will have a accessible database.

Anyway, I read you chose for another way to get passed this problem. I figure I offer this solution in case other people run into the same problem.
Re: Moving database with RMAN requires archive logs? [message #390778 is a reply to message #390753] Mon, 09 March 2009 13:50 Go to previous message
crb0r
Messages: 3
Registered: March 2009
Location: Kitchener, ON
Junior Member
Thanks, I will actually try that and let you know how it goes. (I think I tried something similar, but not exactly as you suggest.)
Previous Topic: rman backup:restoring to new host
Next Topic: DB name is changed in Catalog DB
Goto Forum:
  


Current Time: Sat Dec 10 18:26:08 CST 2016

Total time taken to generate the page: 0.09362 seconds