Home » RDBMS Server » Backup & Recovery » Restore 10.2.0.4 RAC Backup to 11.2.0.4 dbhome (11.2.0.4 Redhat 7.3,)
Restore 10.2.0.4 RAC Backup to 11.2.0.4 dbhome [message #667088] Wed, 06 December 2017 19:47 Go to previous message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear all,

I was attempting to restore 10.2.0.4 RAC Backup to 11.2.0.4 single instance dbhome, but rman complains no backup of datafile available.

RMAN> SET ECHO ON
4> 
5> run {
6> ALLOCATE CHANNEL C1 DEVICE TYPE disk;
7> SET UNTIL SCN 27943506119;
8> SET NEWNAME FOR DATAFILE '+DATAFILES/dwhdb/datafile/system.268.733459341' TO '/u02/app/oracle/oradata/dwhdb/system01.dbf';
9> SET NEWNAME FOR DATAFILE '+DATAFILES/dwhdb/datafile/undotbs1.270.733459341' TO '/u02/app/oracle/oradata/dwhdb/undotbs01.dbf';
10> SET NEWNAME FOR DATAFILE '+DATAFILES/dwhdb/datafile/sysaux.269.733459341' TO '/u02/app/oracle/oradata/dwhdb/sysaux01.dbf';
11> SET NEWNAME FOR DATAFILE '+DATAFILES/dwhdb/datafile/users.271.733459341' TO '/u02/app/oracle/oradata/dwhdb/users01.dbf';
12> SET NEWNAME FOR DATAFILE '+DATAFILES/dwhdb/datafile/undotbs2.276.733459401' TO '/u02/app/oracle/oradata/dwhdb/undotbs02.dbf';
.......
Starting restore at 2017-12-07 09:02:26

released channel: C1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/07/2017 09:02:26
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore


have check https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=418622567307092&id=965122.1&_adf.ctrl-state=kic0xko94_77

RMAN RESTORE FAILS WITH RMAN-06023 ALTHOUGH BACKUPS ARE AVAILABLE (Doc ID 965122.1)

SYS@11gr2 dwhdb>SELECT name, value, display_value, isspecified FROM v$spparameter WHERE name LIKE 'db_recovery_file_dest%' ORDER BY name;

NAME                           VALUE
------------------------------ --------------------
DISPLAY_VALUE                            ISSPE
---------------------------------------- -----
db_recovery_file_dest
                                         FALSE

db_recovery_file_dest_size
                                         FALSE

db_recovery_File_dest has all along been not specified in the created spfile.

rman backup is available


list backup recoverable;

 List of Archived Logs in backup set 18647
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    108099  27965668110 2017-12-04 12:00:56 27965816794 2017-12-04 12:23:38
  1    108100  27965816794 2017-12-04 12:23:38 27965950325 2017-12-04 12:45:51
  1    108101  27965950325 2017-12-04 12:45:51 27966135030 2017-12-04 13:05:21
  1    108102  27966135030 2017-12-04 13:05:21 27966366169 2017-12-04 13:44:40
  1    108103  27966366169 2017-12-04 13:44:40 27966555294 2017-12-04 14:00:35
  1    108104  27966555294 2017-12-04 14:00:35 27966828287 2017-12-04 14:28:07
  1    108105  27966828287 2017-12-04 14:28:07 27967034257 2017-12-04 14:51:29
  1    108106  27967034257 2017-12-04 14:51:29 27967242020 2017-12-04 15:16:41
  1    108107  27967242020 2017-12-04 15:16:41 27967454302 2017-12-04 15:42:59


and there is datafile 1 backup


RMAN> list backup of datafile 1;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
18636   Full    291.41G    DISK        23:17:12     2017-12-03 19:17:35
        BP Key: 18648   Status: AVAILABLE  Compressed: NO  Tag: TAG20171202T200022
        Piece Name: /u03/app/oracle/formatted_backup/dwhbackup/full_bisl4s2n_1_1

		List of Datafiles in backup set 18636
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 27943506119 2017-12-02 20:00:23 +DATAFILES/dwhdb/datafile/system.268.733459341

How do I restore the database?

many thanks in advance!

[Updated on: Wed, 06 December 2017 19:48]

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: RMAN Backups are not deleting
Next Topic: IMPDP data from a source table into a destination table with more columns?
Goto Forum:
  


Current Time: Thu Mar 28 11:03:15 CDT 2024