| Restore 10.2.0.4 RAC Backup to 11.2.0.4 dbhome [message #667088] |
Wed, 06 December 2017 19:47  |
 |
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
