Database Backup and Recovery (MOSC)

MOSC Banner

ORA-01110 when restoring from 32bit host to 64bit host as per doc id 467676.1

edited Jun 12, 2015 6:00AM in Database Backup and Recovery (MOSC) 16 commentsAnswered ✓


I'm geting ORA-01110: data file 2: 'C:\...\SYSAUX01.DBF' when running the recover database command. Does anyone know solve this error?

Oracle allows hot backups, I am now concerned about how unstable the product is.

I am upgrading from 32bit to 64bit as per steps in DOC ID 467676.1

At step 1) I took backup, step 2) recovered to new machine. Details below.

1)
I took successful hot database backup of db in archive mode. It is 32bit 11.2.0.4 Windows 7 Enterprise SP1 Virtual machine.

run {                                                                                    
allocate channel c1 type disk format 'C:\somelocation\c01\bkup_%d_%U';  
sql 'alter system archive log current';                                               
crosscheck archivelog all;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center