Home » RDBMS Server » Backup & Recovery » RMAN Backup oracle 10g to be restored on oracle 11g (3 merged) (Oracle 11g (11.2.0.3), Linux)
RMAN Backup oracle 10g to be restored on oracle 11g (3 merged) [message #562278] Tue, 31 July 2012 02:14 Go to next message
harshkejriwal
Messages: 8
Registered: April 2012
Junior Member
I have the RMAN full database backup of oracle 10g (10.2.0.3) on Sun Solaris OS which i want to restore on oracle 11g (11.2.0.3) on Linux OS. The backup pieces was transferred to oracle 11g server manually in binary mode.

-rwxrwxr-x 1 mepc dba   36356096 Jul 16 14:49 snapcf_MEPC.f
-rwxrwxr-x 1 mepc dba  166028800 Jul 16 15:29 MEPC_full_backup_MEPC_nnnbkn9f_1_1
-rwxrwxr-x 1 mepc dba  169567744 Jul 16 15:29 MEPC_full_backup_MEPC_nmnbkn9f_1_1
-rwxrwxr-x 1 mepc dba  164813824 Jul 16 15:39 MEPC_full_backup_MEPC_nonbkn9f_1_1
-rwxrwxr-x 1 mepc dba  144025600 Jul 16 16:06 MEPC_full_backup_MEPC_nqnbkn9f_1_1
-rwxrwxr-x 1 mepc dba  168576512 Jul 16 16:09 MEPC_full_backup_MEPC_npnbkn9f_1_1
-rwxrwxr-x 1 mepc dba  168649216 Jul 16 17:33 MEPC_full_backup_MEPC_o5nbkpvv_1_1
-rwxrwxr-x 1 mepc dba  162847232 Jul 16 17:34 MEPC_full_backup_MEPC_o6nbkpvv_1_1
-rwxrwxr-x 1 mepc dba  167351808 Jul 16 17:35 MEPC_full_backup_MEPC_o7nbkpvv_1_1
-rwxrwxr-x 1 mepc dba  166838272 Jul 16 17:36 MEPC_full_backup_MEPC_o8nbkpvv_1_1
-rwxrwxr-x 1 mepc dba  166876160 Jul 16 17:37 MEPC_full_backup_MEPC_o9nbkpvv_1_1
-rwxrwxr-x 1 mepc dba  327606272 Jul 16 17:54 MEPC_full_backup_MEPC_o4nbknav_1_1
-rwxrwxr-x 1 mepc dba  549658624 Jul 16 18:26 MEPC_full_backup_MEPC_o2nbknav_1_1
-rwxrwxr-x 1 mepc dba  162984448 Jul 16 18:28 MEPC_full_backup_MEPC_oanbkpvv_1_1
-rwxrwxr-x 1 mepc dba  163567616 Jul 16 18:29 MEPC_full_backup_MEPC_obnbkpvv_1_1
-rwxrwxr-x 1 mepc dba  161380352 Jul 16 18:29 MEPC_full_backup_MEPC_ocnbkpvv_1_1
-rwxrwxr-x 1 mepc dba 1072275456 Jul 18 13:52 MEPC_full_backup_MEPC_o3nbknav_1_1
-rwxrwxr-x 1 mepc dba 1813348352 Jul 18 17:00 MEPC_full_backup_MEPC_o1nbknav_1_1
-rwxrwxr-x 1 mepc dba   36438016 Jul 25 15:45 controlfile_bkup_MEPC_c-1469445140-20120522-09


the backup is taken in above format. I know the ORACLE_SID and dbid of the database from which the backup has been taken.

whenever i tried the following command
mepc@tcstctmatson:/mepc_backup/May22fullbkp$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 31 12:14:54 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: MEPC (DBID=1595278680)

RMAN> shutdown;
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

RMAN> startup nomount;

connected to target database (not started)
Oracle instance started

Total System Global Area    1071333376 bytes

Fixed Size                     1349732 bytes
Variable Size                620758940 bytes
Database Buffers             444596224 bytes
Redo Buffers                   4628480 bytes

RMAN> restore spfile to '$ORACLE_HOME/dbs/initMEPC.ora' from autobackup db_recovery_file_dest='/mepc_backup/May22fullbkp' db_name='MEPC';



the following error was notified

Starting restore at 31-JUL-12
using channel ORA_DISK_1

recovery area destination: /mepc_backup/May22fullbkp
database name (or database unique name) used for search: MEPC
channel ORA_DISK_1: no AUTOBACKUPS found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120731
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120730
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120729
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120728
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120727
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120726
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120725
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/31/2012 12:22:06
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece


i tried recovering the rman backup through catalog also and the following error was notified

List of Files Which Where Not Cataloged
=======================================
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_nonbkn9f_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_obnbkpvv_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_ocnbkpvv_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o7nbkpvv_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o9nbkpvv_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_nmnbkn9f_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_nnnbkn9f_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o3nbknav_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o6nbkpvv_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/controlfile_bkup_MEPC_c-1469445140-20120522-09
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_npnbkn9f_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_oanbkpvv_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_nqnbkn9f_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o1nbknav_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o5nbkpvv_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/snapcf_MEPC.f
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o2nbknav_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o4nbknav_1_1
  RMAN-07517: Reason: The file header is corrupted
File Name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o8nbkpvv_1_1
  RMAN-07517: Reason: The file header is corrupted


the file is not corrupted as i checked the checksum on both the servers and it is same.

Please help me how can i restore the RMAN oracle 10g backup in Oracle 11g and let me know where i am going wrong.

Regards,
Harsh

Re: RMAN Backup oracle 10g to be restored on oracle 11g [message #562287 is a reply to message #562278] Tue, 31 July 2012 02:44 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
AFAIK, you cannot directly restore a database in another version, you have to restore it in the same version and then upgrade the database.

Regards
Michel
Re: RMAN Backup oracle 10g to be restored on oracle 11g [message #562297 is a reply to message #562287] Tue, 31 July 2012 03:05 Go to previous messageGo to next message
harshkejriwal
Messages: 8
Registered: April 2012
Junior Member
Hello Michel,

As per the document
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/compat003.htm

the lower version of RMAN client is compatible with higher version or the target database and the backup was taken through RMAN. Can there be any way out where the RMAN client is able to read the backups?

Regards,
Harsh
Re: RMAN Backup oracle 10g to be restored on oracle 11g [message #562299 is a reply to message #562297] Tue, 31 July 2012 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a 11.1 documentation, check in 11.2 as this is your version.

The first error tells it does not find an autobackup of the spfile in the files you copy. Are you sure you have an autobakcup of this spfile in the last 7 days?
The second error may be related to the fact the RMAN catalog is not at the same level than the RMAN binary.

Regards
Michel
Re: RMAN Backup oracle 10g to be restored on oracle 11g [message #562303 is a reply to message #562299] Tue, 31 July 2012 03:39 Go to previous messageGo to next message
harshkejriwal
Messages: 8
Registered: April 2012
Junior Member
Hi Michel,

The spfile is included in the 'controlfile_bkup_MEPC_c-1469445140-20120522-09' backup.The Backup was taken on May 22,2012 and i also executed the command

RMAN> restore spfile to '$ORACLE_HOME/dbs/initMEPC.ora' from autobackup db_recovery_file_dest='/mepc_backup/May22fullbkp' db_name='MEPC' until time 'sysdate-70';


i still got the same error

Starting restore at 31-JUL-12
using channel ORA_DISK_1

recovery area destination: /mepc_backup/May22fullbkp
database name (or database unique name) used for search: MEPC
channel ORA_DISK_1: no AUTOBACKUPS found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120522
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120521
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120520
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120519
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120518
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120517
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120516
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/31/2012 12:22:53
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece


i also executed the command

RMAN>  restore spfile to '$ORACLE_HOME/dbs/initMEPC.ora' from '/mepc_backup/May22fullbkp//controlfile_bkup_MEPC_c-1469445140-20120522-09' until time 'sysdate-70';


and i still got the same error

Starting restore at 31-JUL-12
using channel ORA_DISK_1

channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/31/2012 14:08:00
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece


Regards,
Harsh
Re: RMAN Backup oracle 10g to be restored on oracle 11g [message #562351 is a reply to message #562303] Tue, 31 July 2012 10:55 Go to previous message
Mahesh Rajendran
Messages: 10628
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As Michel said,
you cannot restore and recover to a higher version using RMAN.

>> As per the document ...

The document talks about compatibility between the RMAN executable and databases for backups.
Assume you did restore those backups in higher version Oracle home.
When you/rman proceed to mount and open the database, the new 11g binaries will not be happy with older 10g datafiles.
RMAN will restore the datafiles it backed up. It will not upgrade it to new version.
Give it a try.

I believe the issues you have now are different. Your post does not provide some info.
Did you use set DBID ? show it.

I would first try something like this

RMAN >  restore spfile from autobackup db_recovery_file_dest='/mepc_backup/May22fullbkp' maxdays 100;
Previous Topic: flashback
Next Topic: SPFILE restore from autobackup no catalog (2 Merged)
Goto Forum:
  


Current Time: Wed Oct 01 11:24:52 CDT 2014

Total time taken to generate the page: 0.09741 seconds