Home » RDBMS Server » Backup & Recovery » Restoration through full rman backup (11g, 11.2.0.1, window7)
Restoration through full rman backup [message #638898] Thu, 25 June 2015 01:08 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

I took full RMAN backup in which controlfile was autobackup and backup location is mentioned one for all.

While restoring the database, i have kept the folder into one location and from there, tried to restore the database. Restoration of controlfile is done but database dosen't. Please assist me...

Below are the steps -

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------
MHDINTG

SQL> create pfile from spfile;

File created.

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area  914440192 bytes
Fixed Size                  2181104 bytes
Variable Size             247466000 bytes
Database Buffers          658505728 bytes
Redo Buffers                6287360 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\Windows\system32>rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 24 17:46:25 2015

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

connected to target database: MHDINTG (not mounted)

RMAN> restore controlfile from 'E:\dp_dir\dump\CTL_C-3212093803-20150624-00';

Starting restore at 24-JUN-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=D:\11.2.0.1\ORADATA\MHDINTG\CONTROL01.CTL
output file name=D:\11.2.0.1\ORADATA\MHDINTG\CONTROL02.CTL
Finished restore at 24-JUN-15

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> restore database;

Starting restore at 24-JUN-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=191 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=129 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=193 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=6 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to E:\APP\ORACLE\ORADATA\MHDINTG\UNDOTBS01.DBF
channel ORA_DISK_1: restoring datafile 00007 to E:\APP\ORACLE\ORADATA\MHDINTG\CONFTBS01.DBF
channel ORA_DISK_1: restoring datafile 00009 to E:\APP\ORACLE\ORADATA\MHDINTG\ANALYST01.DBF
channel ORA_DISK_1: restoring datafile 00014 to E:\APP\ORACLE\ORADATA\MHDINTG\HLTHCHK01.DBF
channel ORA_DISK_1: reading from backup piece E:\DP_DIR\DUMP\FULL_03QA9UOE_3_1
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00004 to E:\APP\ORACLE\ORADATA\MHDINTG\USERS01.DBF
channel ORA_DISK_2: restoring datafile 00005 to E:\APP\ORACLE\ORADATA\MHDINTG\INS01.DBF
channel ORA_DISK_2: reading from backup piece E:\DP_DIR\DUMP\FULL_02QA9UOD_2_1
channel ORA_DISK_3: starting datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_DISK_3: restoring datafile 00002 to E:\APP\ORACLE\ORADATA\MHDINTG\SYSAUX01.DBF
channel ORA_DISK_3: restoring datafile 00006 to E:\APP\ORACLE\ORADATA\MHDINTG\INDX01.DBF
channel ORA_DISK_3: restoring datafile 00011 to E:\APP\ORACLE\ORADATA\MHDINTG\DW01.DBF
channel ORA_DISK_3: restoring datafile 00013 to E:\APP\ORACLE\ORADATA\MHDINTG\INFS01.DBF
channel ORA_DISK_3: reading from backup piece E:\DP_DIR\DUMP\FULL_04QA9UOS_4_1
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00001 to E:\APP\ORACLE\ORADATA\MHDINTG\SYSTEM01.DBF
channel ORA_DISK_4: restoring datafile 00008 to E:\APP\ORACLE\ORADATA\MHDINTG\REINS01.DBF
channel ORA_DISK_4: restoring datafile 00010 to E:\APP\ORACLE\ORADATA\MHDINTG\BI01.DBF
channel ORA_DISK_4: restoring datafile 00012 to E:\APP\ORACLE\ORADATA\MHDINTG\INSWF01.DBF
channel ORA_DISK_4: reading from backup piece E:\DP_DIR\DUMP\FULL_05QA9URB_5_1
channel ORA_DISK_1: ORA-19870: error while restoring backup piece E:\DP_DIR\DUMP\FULL_03QA9UOE_3_1
ORA-19504: failed to create file "E:\APP\ORACLE\ORADATA\MHDINTG\CONFTBS01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

channel ORA_DISK_2: ORA-19870: error while restoring backup piece E:\DP_DIR\DUMP\FULL_02QA9UOD_2_1
ORA-19504: failed to create file "E:\APP\ORACLE\ORADATA\MHDINTG\INS01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

channel ORA_DISK_3: ORA-19870: error while restoring backup piece E:\DP_DIR\DUMP\FULL_04QA9UOS_4_1
ORA-19504: failed to create file "E:\APP\ORACLE\ORADATA\MHDINTG\DW01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

channel ORA_DISK_4: ORA-19870: error while restoring backup piece E:\DP_DIR\DUMP\FULL_05QA9URB_5_1
ORA-19504: failed to create file "E:\APP\ORACLE\ORADATA\MHDINTG\REINS01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/24/2015 17:49:05
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


Regards
Ashish Kumar Mahanta
Re: Restoration through full rman backup [message #638899 is a reply to message #638898] Thu, 25 June 2015 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
O/S-Error: (OS 3) The system cannot find the path specified.


Check privileges, free space... everything that prevent Oracle from seeing the path or creating a file in it.

Quote:
RMAN-06023: no backup or copy of datafile 4 found to restore


Some backup files are not registered in the control file you restored. Use CATALOG command to manually register them.

Re: Restoration through full rman backup [message #638904 is a reply to message #638899] Thu, 25 June 2015 03:59 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear Michel,

I tried to catalog the backups but it does as below. Please assist, how to restore the database with the valid backups?

RMAN> CATALOG START WITH 'E:\DP_DIR\DUMP\';

searching for all files that match the pattern E:\DP_DIR\DUMP\

List of Files Unknown to the Database
=====================================
File Name: E:\DP_DIR\DUMP\CTL_C-3212093803-20150624-00
File Name: E:\DP_DIR\DUMP\SNAPCF_MED.F

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: E:\DP_DIR\DUMP\CTL_C-3212093803-20150624-00
File Name: E:\DP_DIR\DUMP\SNAPCF_MED.F

RMAN> restore database;

Starting restore at 25-JUN-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to E:\APP\ORACLE\ORADATA\MHDINTG\UNDOTBS01.DBF
channel ORA_DISK_1: restoring datafile 00007 to E:\APP\ORACLE\ORADATA\MHDINTG\CONFTBS01.DBF
channel ORA_DISK_1: restoring datafile 00009 to E:\APP\ORACLE\ORADATA\MHDINTG\ANALYST01.DBF
channel ORA_DISK_1: restoring datafile 00014 to E:\APP\ORACLE\ORADATA\MHDINTG\HLTHCHK01.DBF
channel ORA_DISK_1: reading from backup piece E:\DP_DIR\DUMP\FULL_03QA9UOE_3_1
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00004 to E:\APP\ORACLE\ORADATA\MHDINTG\USERS01.DBF
channel ORA_DISK_2: restoring datafile 00005 to E:\APP\ORACLE\ORADATA\MHDINTG\INS01.DBF
channel ORA_DISK_2: reading from backup piece E:\DP_DIR\DUMP\FULL_02QA9UOD_2_1
channel ORA_DISK_3: starting datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_DISK_3: restoring datafile 00002 to E:\APP\ORACLE\ORADATA\MHDINTG\SYSAUX01.DBF
channel ORA_DISK_3: restoring datafile 00006 to E:\APP\ORACLE\ORADATA\MHDINTG\INDX01.DBF
channel ORA_DISK_3: restoring datafile 00011 to E:\APP\ORACLE\ORADATA\MHDINTG\DW01.DBF
channel ORA_DISK_3: restoring datafile 00013 to E:\APP\ORACLE\ORADATA\MHDINTG\INFS01.DBF
channel ORA_DISK_3: reading from backup piece E:\DP_DIR\DUMP\FULL_04QA9UOS_4_1
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00001 to E:\APP\ORACLE\ORADATA\MHDINTG\SYSTEM01.DBF
channel ORA_DISK_4: restoring datafile 00008 to E:\APP\ORACLE\ORADATA\MHDINTG\REINS01.DBF
channel ORA_DISK_4: restoring datafile 00010 to E:\APP\ORACLE\ORADATA\MHDINTG\BI01.DBF
channel ORA_DISK_4: restoring datafile 00012 to E:\APP\ORACLE\ORADATA\MHDINTG\INSWF01.DBF
channel ORA_DISK_4: reading from backup piece E:\DP_DIR\DUMP\FULL_05QA9URB_5_1
channel ORA_DISK_1: ORA-19870: error while restoring backup piece E:\DP_DIR\DUMP\FULL_03QA9UOE_3_1
ORA-19504: failed to create file "E:\APP\ORACLE\ORADATA\MHDINTG\CONFTBS01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

channel ORA_DISK_2: ORA-19870: error while restoring backup piece E:\DP_DIR\DUMP\FULL_02QA9UOD_2_1
ORA-19504: failed to create file "E:\APP\ORACLE\ORADATA\MHDINTG\INS01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

channel ORA_DISK_3: ORA-19870: error while restoring backup piece E:\DP_DIR\DUMP\FULL_04QA9UOS_4_1
ORA-19504: failed to create file "E:\APP\ORACLE\ORADATA\MHDINTG\DW01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

channel ORA_DISK_4: ORA-19870: error while restoring backup piece E:\DP_DIR\DUMP\FULL_05QA9URB_5_1
ORA-19504: failed to create file "E:\APP\ORACLE\ORADATA\MHDINTG\REINS01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/25/2015 14:15:35
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

RMAN> CATALOG START WITH 'E:\DP_DIR\DUMP\FULL_02QA9UOD_2_1';

searching for all files that match the pattern E:\DP_DIR\DUMP\FULL_02QA9UOD_2_1
no files found to be unknown to the database

RMAN> CATALOG START WITH 'E:\DP_DIR\DUMP\FULL_03QA9UOE_3_1';

searching for all files that match the pattern E:\DP_DIR\DUMP\FULL_03QA9UOE_3_1
no files found to be unknown to the database

RMAN> CATALOG START WITH 'E:\DP_DIR\DUMP\FULL_04QA9UOS_4_1';

searching for all files that match the pattern E:\DP_DIR\DUMP\FULL_04QA9UOS_4_1
no files found to be unknown to the database

RMAN> CATALOG START WITH 'E:\DP_DIR\DUMP\FULL_05QA9URB_5_1';

searching for all files that match the pattern E:\DP_DIR\DUMP\FULL_05QA9URB_5_1
no files found to be unknown to the database

RMAN> restore database;

Starting restore at 25-JUN-15
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to E:\APP\ORACLE\ORADATA\MHDINTG\UNDOTBS01.DBF
channel ORA_DISK_1: restoring datafile 00007 to E:\APP\ORACLE\ORADATA\MHDINTG\CONFTBS01.DBF
channel ORA_DISK_1: restoring datafile 00009 to E:\APP\ORACLE\ORADATA\MHDINTG\ANALYST01.DBF
channel ORA_DISK_1: restoring datafile 00014 to E:\APP\ORACLE\ORADATA\MHDINTG\HLTHCHK01.DBF
channel ORA_DISK_1: reading from backup piece E:\DP_DIR\DUMP\FULL_03QA9UOE_3_1
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00004 to E:\APP\ORACLE\ORADATA\MHDINTG\USERS01.DBF
channel ORA_DISK_2: restoring datafile 00005 to E:\APP\ORACLE\ORADATA\MHDINTG\INS01.DBF
channel ORA_DISK_2: reading from backup piece E:\DP_DIR\DUMP\FULL_02QA9UOD_2_1
channel ORA_DISK_3: starting datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_DISK_3: restoring datafile 00002 to E:\APP\ORACLE\ORADATA\MHDINTG\SYSAUX01.DBF
channel ORA_DISK_3: restoring datafile 00006 to E:\APP\ORACLE\ORADATA\MHDINTG\INDX01.DBF
channel ORA_DISK_3: restoring datafile 00011 to E:\APP\ORACLE\ORADATA\MHDINTG\DW01.DBF
channel ORA_DISK_3: restoring datafile 00013 to E:\APP\ORACLE\ORADATA\MHDINTG\INFS01.DBF
channel ORA_DISK_3: reading from backup piece E:\DP_DIR\DUMP\FULL_04QA9UOS_4_1
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00001 to E:\APP\ORACLE\ORADATA\MHDINTG\SYSTEM01.DBF
channel ORA_DISK_4: restoring datafile 00008 to E:\APP\ORACLE\ORADATA\MHDINTG\REINS01.DBF
channel ORA_DISK_4: restoring datafile 00010 to E:\APP\ORACLE\ORADATA\MHDINTG\BI01.DBF
channel ORA_DISK_4: restoring datafile 00012 to E:\APP\ORACLE\ORADATA\MHDINTG\INSWF01.DBF
channel ORA_DISK_4: reading from backup piece E:\DP_DIR\DUMP\FULL_05QA9URB_5_1
channel ORA_DISK_1: ORA-19870: error while restoring backup piece E:\DP_DIR\DUMP\FULL_03QA9UOE_3_1
ORA-19504: failed to create file "E:\APP\ORACLE\ORADATA\MHDINTG\CONFTBS01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

channel ORA_DISK_2: ORA-19870: error while restoring backup piece E:\DP_DIR\DUMP\FULL_02QA9UOD_2_1
ORA-19504: failed to create file "E:\APP\ORACLE\ORADATA\MHDINTG\INS01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

channel ORA_DISK_3: ORA-19870: error while restoring backup piece E:\DP_DIR\DUMP\FULL_04QA9UOS_4_1
ORA-19504: failed to create file "E:\APP\ORACLE\ORADATA\MHDINTG\DW01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

channel ORA_DISK_4: ORA-19870: error while restoring backup piece E:\DP_DIR\DUMP\FULL_05QA9URB_5_1
ORA-19504: failed to create file "E:\APP\ORACLE\ORADATA\MHDINTG\REINS01.DBF"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/25/2015 14:19:08
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

Re: Restoration through full rman backup [message #638908 is a reply to message #638904] Thu, 25 June 2015 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You have fixed one the problems.
You also have to fix the first one and I can't help you as I have no access to your system to know what it is. So first search for what I mentioned then come back the result.

Re: Restoration through full rman backup [message #638915 is a reply to message #638898] Thu, 25 June 2015 06:21 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
What files exist in the e:\dp_dir\dump directory?
Re: Restoration through full rman backup [message #638919 is a reply to message #638915] Thu, 25 June 2015 07:22 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear John,

It has control-file, snapshot & full database backup files.

E:\dp_dir\dump>dir
 Volume in drive E is New Volume
 Volume Serial Number is 4883-D01A

 Directory of E:\dp_dir\dump

24/06/2015  03:45 PM    <DIR>          .
24/06/2015  03:45 PM    <DIR>          ..
24/06/2015  01:09 PM         9,863,168 CTL_C-3212093803-20150624-00
24/06/2015  01:05 PM       404,955,136 FULL_02QA9UOD_2_1
24/06/2015  01:03 PM       133,128,192 FULL_03QA9UOE_3_1
24/06/2015  01:09 PM       448,798,720 FULL_04QA9UOS_4_1
24/06/2015  01:09 PM       287,236,096 FULL_05QA9URB_5_1
24/06/2015  01:09 PM         9,781,248 SNAPCF_MED.F
               6 File(s)  1,293,762,560 bytes
               2 Dir(s)  124,972,072,960 bytes free


RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1       B  F  A DISK        24-JUN-15       1       1       YES        TAG20150624T125644
2       B  F  A DISK        24-JUN-15       1       1       YES        TAG20150624T125644
3       B  F  A DISK        24-JUN-15       1       1       YES        TAG20150624T125644
4       B  F  A DISK        24-JUN-15       1       1       YES        TAG20150624T125644

RMAN> list backup tag='TAG20150624T125644';


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    126.95M    DISK        00:07:11     24-JUN-15
        BP Key: 1   Status: AVAILABLE  Compressed: YES  Tag: TAG20150624T125644
        Piece Name: E:\DP_DIR\DUMP\FULL_03QA9UOE_3_1
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\UNDOTBS01.DBF
  7       Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\CONFTBS01.DBF
  9       Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\ANALYST01.DBF
  14      Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\HLTHCHK01.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    386.19M    DISK        00:09:23     24-JUN-15
        BP Key: 2   Status: AVAILABLE  Compressed: YES  Tag: TAG20150624T125644
        Piece Name: E:\DP_DIR\DUMP\FULL_02QA9UOD_2_1
  List of Datafiles in backup set 2
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\USERS01.DBF
  5       Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\INS01.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    428.00M    DISK        00:12:16     24-JUN-15
        BP Key: 3   Status: AVAILABLE  Compressed: YES  Tag: TAG20150624T125644
        Piece Name: E:\DP_DIR\DUMP\FULL_04QA9UOS_4_1
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\SYSAUX01.DBF
  6       Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\INDX01.DBF
  11      Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\DW01.DBF
  13      Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\INFS01.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    273.92M    DISK        00:11:01     24-JUN-15
        BP Key: 4   Status: AVAILABLE  Compressed: YES  Tag: TAG20150624T125644
        Piece Name: E:\DP_DIR\DUMP\FULL_05QA9URB_5_1
  List of Datafiles in backup set 4
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\SYSTEM01.DBF
  8       Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\REINS01.DBF
  10      Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\BI01.DBF
  12      Full 81051662112 24-JUN-15 E:\APP\ORACLE\ORADATA\MHDINTG\INSWF01.DBF

RMAN>

[Updated on: Thu, 25 June 2015 07:30]

Report message to a moderator

Re: Restoration through full rman backup [message #638920 is a reply to message #638919] Thu, 25 June 2015 07:32 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Do, path of oracle_home of target database and source should be same?

Here, oracle_home paths are different.
Re: Restoration through full rman backup [message #638951 is a reply to message #638920] Fri, 26 June 2015 08:12 Go to previous message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Please assist me on the same...
Previous Topic: Missing control file backup
Next Topic: restore win oracle 10.2 cold backup to different drive
Goto Forum:
  


Current Time: Thu Mar 28 10:10:48 CDT 2024