| Moving database with RMAN requires archive logs? [message #390570] |
Sat, 07 March 2009 10:57  |
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 #390753 is a reply to message #390612] |
Mon, 09 March 2009 11:10  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
