Re: Moving a 10g database to 11g with rman backup

You're trying to do too many steps as one. You need to do the following (at a very high level):

1. Install 10g to same version as you have on the old server (look up cloning an Oracle Home)
2. Ensure you have created a pfile from spfile and copied your *.ora files from the DBS & Network/Admin directories on the old server to the same locations on the new. ==>>> BE sure to comment out in the PFILE any deprecated parameters (look at the errors you got) AND rename the SPFILE to something like a ".orig" extension so Oracle does not try to startup with the spfile.
3. Copy the original data files directly to the new server (with the Source DB shut down or in "Backup" mode) *OR*
4. Do the backup on the old server/copy to new server
5. USING the 10G Executables If 2B, then restore & recover db, then open resetlogs.
6. USING the 11G Executables, Perform the upgrade using dbua or if you know all the steps it does you can do them manually.

I've done upgrades over 100 times starting all the way back from 7.3 to 11.2.

Jim
Certified Oracle DBA
Oracle Certified Specialist
Oracle Trainer

On Friday, September 21, 2012 6:03:02 PM UTC-5, jbe..._at_gmail.com wrote:
> Hello,
>
> Following Doc ID 369644.1, I'm trying to restore a 10g database into a 11g database ( version 11.2.0.1.0), which is in other server.
>
>
>
> What I did on 11g server:
>
> - Generate full rman backup of 10g database
>
> - Copy pfile, control file and full rman backup from 10g to 11g
>
>
>
> C:\> oradim -new -sid BDSPROD -intpwd bdsprod
>
> C:\> SET ORACLE_SID=BDSPROD
>
> C:\> rman
>
> RMAN> connect target sys
>
> RMAN> SET DBID=367107039
>
> RMAN> STARTUP force nomount PFILE=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora
>
> RMAN> restore controlfile from 'C:\app\oracle\product\11.2.0\dbhome_1\database\CTRLFILE_BDSPROD.CTL';
>
> RMAN> alter database mount;
>
> RMAN> crosscheck backupset;
>
> RMAN> delete expired backupset;
>
> RMAN> catalog start with 'D:\RMAN_bdsprod\';
>
> RMAN> restore database;
>
> RMAN> recover database;
>
>
>
> After this step, I followed Doc ID 558408.1
>
> SQL> connect sys/bdsprod as sysdba
>
> Connected.
>
> SQL> alter database open resetlogs upgrade;
>
>
>
> Now, how can I startup database? It seems that only way is doing:
>
> SQL> STARTUP upgrade PFILE=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora;
>
>
>
> In that way, only sysdba can connect to database.
>
> Other ways like just "startup" or "startup pfile=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora;" it gets errors.
>
> Is there any way to start 11g database?
>
>
>
> SQL> startup PFILE=C:\app\oracle\product\11.2.0\dbhome_1\database\PFILE_bdsprod.ora;
>
> ORA-32006: BACKGROUND_DUMP_DEST initialization parameter has been deprecated
>
> ORA-32006: USER_DUMP_DEST initialization parameter has been deprecated
>
> ORACLE instance started.
>
> Total System Global Area 709836800 bytes
>
> Fixed Size 2179136 bytes
>
> Variable Size 201330624 bytes
>
> Database Buffers 499122176 bytes
>
> Redo Buffers 7204864 bytes
>
> Database mounted.
>
> ORA-01092: ORACLE instance terminated. Disconnection forced
>
> ORA-00704: bootstrap process failure
>
> ORA-39700: database must be opened with UPGRADE option
>
> Process ID: 12712
>
> Session ID: 5 Serial number: 3
>
>
>
> SQL> startup
>
> ORA-01078: failure in processing system parameters
>
> LRM-00109: could not open parameter file 'C:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\
>
> DATABASE\INITBDSPROD.ORA'
Received on Wed Oct 03 2012 - 17:49:47 CEST