Following Doc ID 369644.1, I'm trying to restore a 10g database into a 11g database ( version 22.214.171.124.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\databas\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'