Duplicate database filed with ORA-19870 ORA-19504 ORA-27044 Linux-x86_64
Error27 File too large
I was trying with
duplicate database from one of the standby database to UAT environment as a
business requirement. Target server is UAT environment.
Using below command to
duplicate database from target server –
RMAN> run
2> {
3> allocate auxiliary
channel ch1 device TYPE disk;
4> allocate auxiliary
channel ch2 device TYPE disk;
5> allocate auxiliary
channel ch3 device TYPE disk;
6> allocate auxiliary
channel ch4 device TYPE disk;
7> allocate auxiliary
channel ch5 device TYPE disk;
8> allocate auxiliary
channel ch6 device TYPE disk;
9> allocate auxiliary
channel ch7 device TYPE disk;
10> allocate
auxiliary channel ch8 device TYPE disk;
11> allocate auxiliary
channel ch9 device TYPE disk;
12> set newname for
database to '/data/MYUAT/DATAFILE/%b';
13> DUPLICATE
DATABASE TO MYUAT noredo
14>
PFILE='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/initMYUAT.ora'
15> BACKUP LOCATION
'/backupshare/ML_PUNE_DR_Golden_offbkp/'
16> Logfile '/data/MYUAT/LOGFILE/redo1.log'
size 100M,
17> '/data/MYUAT/LOGFILE/redo2.log'
size 100M,
18> '/data/MYUAT/LOGFILE/redo3.log'
size 100M
19> ;
20> }
Duplicate database filed
with below error –
Rman log for duplicate
database -
channel ch4: starting
datafile backup set restore
channel ch4: specifying
datafile(s) to restore from backup set
channel ch4: restoring
datafile 00012 to /data/MYUAT/DATAFILE/ptaudit.3092.947766809
channel ch4: restoring
datafile 00023 to /data/MYUAT/DATAFILE/eocmlrg.3094.947766809
channel ch4: restoring
datafile 00042 to /data/MYUAT/DATAFILE/eotplrg.3093.947766809
channel ch4: restoring
datafile 00051 to /data/MYUAT/DATAFILE/psimage2.2098.947752747
channel ch4: reading
from backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58900_1
channel ch2: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58908_1
tag=TAG20180115T021026
channel ch2: restored
backup piece 1
channel ch2: restore
complete, elapsed time: 00:13:12
channel ch2: starting
datafile backup set restore
channel ch2: specifying
datafile(s) to restore from backup set
channel ch2: restoring
datafile 00013 to /data/MYUAT/DATAFILE/ptcmstar.2090.947766099
channel ch2: restoring
datafile 00040 to /data/MYUAT/DATAFILE/eolarge.2100.947766099
channel ch2: restoring
datafile 00045 to /data/MYUAT/DATAFILE/lmwork.2081.947766099
channel ch2: restoring
datafile 00047 to /data/MYUAT/DATAFILE/psimage.2105.947752747
channel ch2: reading
from backup piece /backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58896_1
channel ch2: ORA-19870:
error while restoring backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58896_1
ORA-19504: failed to
create file "/data/MYUAT/DATAFILE/psimage.2105.947752747"
ORA-27044: unable to write
the header block of file
Linux-x86_64 Error: 27:
File too large
Additional information: 4
channel ch2: starting
datafile backup set restore
channel ch2: specifying
datafile(s) to restore from backup set
channel ch2: restoring
datafile 00025 to /data/MYUAT/DATAFILE/eocuapp.3095.947766809
channel ch2: restoring
datafile 00026 to /data/MYUAT/DATAFILE/eoculrg.3098.947766811
channel ch2: restoring
datafile 00028 to /data/MYUAT/DATAFILE/eodslrg.3099.947766811
channel ch2: restoring
datafile 00044 to /data/MYUAT/DATAFILE/lmlarge.2103.947752747
channel ch2: reading
from backup piece /backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58899_1
channel ch3: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58903_1
tag=TAG20180115T021026
Analysis:
t the initial look
itself I found it OS related error for space issue or the file size is high
which was failed to create file at OS level. So I asked OS team to check from
the OS side.
As usual OS team come
back to saying we are all good at OS side no issue found. 😊
Again I start
investigating –
I checked and found that
the file restoration failed is belongs to bigfile tablespace but there are
other files which got successfully restored are also bigfile tablespace.
Then I checked side of
this file- it’s 3.5 TB. Wow!!!
This file is 3.5 TB and
all database physical size is 5 TB. Then I am sure that issue is with file size
only and there MUST be limitation from OS side or filysystem side.
I started digging on
filesystem – this /data created using ext3 file system. Below are the
limitation for the filesystem level.
Solution –
So in ext3 individual
file can be max 2TB, then OS team remounted the /data mount point with ext4
file system and issue got resolved. As on ext4 file system having individual
file up to 16TB on RHEL6.
ORA-01119
ORA-27044 HPUX-ia64 File Too Large When Creating Tablespace (Doc ID 438853.1)
It's
for different OS but relevant.
Thanks for reading.
Complete error log for
your ref –
Recovery Manager:
Release 11.2.0.4.0 - Production on Wed Jan 17 03:16:21 2018
Copyright (c) 1982,
2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary
database: MYUAT (not mounted)
RMAN> run
2> {
3> allocate auxiliary
channel ch1 device TYPE disk;
4> allocate auxiliary
channel ch2 device TYPE disk;
5> allocate auxiliary
channel ch3 device TYPE disk;
6> allocate auxiliary
channel ch4 device TYPE disk;
7> allocate auxiliary
channel ch5 device TYPE disk;
8> allocate auxiliary
channel ch6 device TYPE disk;
9> allocate auxiliary
channel ch7 device TYPE disk;
10> allocate
auxiliary channel ch8 device TYPE disk;
11> allocate
auxiliary channel ch9 device TYPE disk;
12> set newname for
database to '/data/MYUAT/DATAFILE/%b';
13> DUPLICATE
DATABASE TO MYUAT noredo
14>
PFILE='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/initMYUAT.ora'
15> BACKUP LOCATION
'/backupshare/ML_PUNE_DR_Golden_offbkp/'
16> Logfile '/data/MYUAT/LOGFILE/redo1.log'
size 100M,
17> '/data/MYUAT/LOGFILE/redo2.log'
size 100M,
18> '/data/MYUAT/LOGFILE/redo3.log'
size 100M
19> ;
20> }
21>
allocated channel: ch1
channel ch1: SID=1710
device type=DISK
allocated channel: ch2
channel ch2: SID=5
device type=DISK
allocated channel: ch3
channel ch3: SID=573
device type=DISK
allocated channel: ch4
channel ch4: SID=1142
device type=DISK
allocated channel: ch5
channel ch5: SID=1711
device type=DISK
allocated channel: ch6
channel ch6: SID=6
device type=DISK
allocated channel: ch7
channel ch7: SID=574
device type=DISK
allocated channel: ch8
channel ch8: SID=1143
device type=DISK
allocated channel: ch9
channel ch9: SID=1712
device type=DISK
executing command: SET
NEWNAME
Starting Duplicate Db at
17-JAN-18
contents of Memory
Script:
{
sql clone
"create spfile from memory";
}
executing Memory Script
sql statement: create
spfile from memory
contents of Memory
Script:
{
shutdown
clone immediate;
startup
clone nomount;
}
executing Memory Script
Oracle instance shut
down
connected to auxiliary
database (not started)
Oracle instance started
Total System Global
Area 19241058304 bytes
Fixed
Size
2261368 bytes
Variable Size
9596571272
bytes
Database
Buffers
9596567552 bytes
Redo
Buffers
45658112 bytes
allocated channel: ch1
channel ch1: SID=1705
device type=DISK
allocated channel: ch2
channel ch2: SID=5
device type=DISK
allocated channel: ch3
channel ch3: SID=573
device type=DISK
allocated channel: ch4
channel ch4: SID=1142
device type=DISK
allocated channel: ch5
channel ch5: SID=1710
device type=DISK
allocated channel: ch6
channel ch6: SID=6
device type=DISK
allocated channel: ch7
channel ch7: SID=574
device type=DISK
allocated channel: ch8
channel ch8: SID=1143
device type=DISK
allocated channel: ch9
channel ch9: SID=1711 device
type=DISK
contents of Memory
Script:
{
sql clone
"alter system set db_name =
''MLPRD'' comment=
''Modified by RMAN
duplicate'' scope=spfile";
sql clone
"alter system set db_unique_name =
''MYUAT'' comment=
''Modified by RMAN
duplicate'' scope=spfile";
shutdown
clone immediate;
startup
clone force nomount
restore
clone primary controlfile from
'/backupshare/ML_PUNE_DR_Golden_offbkp/MLprd_golden.ctl';
alter clone
database mount;
}
executing Memory Script
sql statement: alter
system set db_name = ''MLPRD'' comment= ''Modified by RMAN
duplicate'' scope=spfile
sql statement: alter
system set db_unique_name = ''MYUAT'' comment= ''Modified by RMAN
duplicate'' scope=spfile
Oracle instance shut
down
Oracle instance started
Total System Global
Area 19241058304 bytes
Fixed
Size
2261368 bytes
Variable
Size
9596571272 bytes
Database
Buffers
9596567552 bytes
Redo
Buffers
45658112 bytes
allocated channel: ch1
channel ch1: SID=1705
device type=DISK
allocated channel: ch2
channel ch2: SID=5
device type=DISK
allocated channel: ch3
channel ch3: SID=573
device type=DISK
allocated channel: ch4
channel ch4: SID=1142
device type=DISK
allocated channel: ch5
channel ch5: SID=1710
device type=DISK
allocated channel: ch6
channel ch6: SID=6
device type=DISK
allocated channel: ch7
channel ch7: SID=1143
device type=DISK
allocated channel: ch8
channel ch8: SID=574
device type=DISK
allocated channel: ch9
channel ch9: SID=1712
device type=DISK
Starting restore at
17-JAN-18
channel ch2: skipped,
AUTOBACKUP already found
channel ch3: skipped,
AUTOBACKUP already found
channel ch4: skipped,
AUTOBACKUP already found
channel ch5: skipped,
AUTOBACKUP already found
channel ch6: skipped,
AUTOBACKUP already found
channel ch7: skipped,
AUTOBACKUP already found
channel ch8: skipped,
AUTOBACKUP already found
channel ch9: skipped,
AUTOBACKUP already found
channel ch1: restoring
control file
channel ch1: restore
complete, elapsed time: 00:00:22
output file name=/data/MYUAT/CONTROLFILE/current.01
output file name=/data/MYUAT/CONTROLFILE/current.02
Finished restore at
17-JAN-18
database mounted
contents of Memory
Script:
{
set newname
for datafile 1 to
"/data/MYUAT/DATAFILE/system.3097.947766811";
set newname
for datafile 2 to
"/data/MYUAT/DATAFILE/sysaux.2076.947766099";
set newname
for datafile 3 to
"/data/MYUAT/DATAFILE/undotbs1.2095.947765199";
set newname
for datafile 4 to
"/data/MYUAT/DATAFILE/psdefault.2085.947766809";
set newname
for datafile 5 to
"/data/MYUAT/DATAFILE/undotbs2.2102.947752747";
set newname
for datafile 6 to
"/data/MYUAT/DATAFILE/undotbs3.2089.947752747";
set newname
for datafile 7 to
"/data/MYUAT/DATAFILE/undotbs4.2071.947765631";
set newname
for datafile 8 to
"/data/MYUAT/DATAFILE/psimgr.3100.947766811";
set newname
for datafile 9 to
"/data/MYUAT/DATAFILE/ptamsg.3096.947766809";
set newname
for datafile 10 to
"/data/MYUAT/DATAFILE/ptapp.3114.947766845";
set newname
for datafile 11 to
"/data/MYUAT/DATAFILE/ptappe.3105.947766811";
set newname
for datafile 12 to
"/data/MYUAT/DATAFILE/ptaudit.3092.947766809";
set newname
for datafile 13 to
"/data/MYUAT/DATAFILE/ptcmstar.2090.947766099";
set newname
for datafile 14 to
"/data/MYUAT/DATAFILE/ptlock.3091.947766809";
set newname
for datafile 15 to
"/data/MYUAT/DATAFILE/ptprc.2150.947766809";
set newname
for datafile 16 to
"/data/MYUAT/DATAFILE/ptprjwk.3113.947766837";
set newname
for datafile 17 to
"/data/MYUAT/DATAFILE/ptrpts.2151.947766809";
set newname
for datafile 18 to
"/data/MYUAT/DATAFILE/pttbl.2152.947766809";
set newname
for datafile 19 to
"/data/MYUAT/DATAFILE/pttlrg.2072.947766809";
set newname
for datafile 20 to
"/data/MYUAT/DATAFILE/pttree.3111.947766815";
set newname
for datafile 21 to
"/data/MYUAT/DATAFILE/ptwork.3107.947766811";
set newname
for datafile 22 to
"/data/MYUAT/DATAFILE/eocmapp.3104.947766811";
set newname
for datafile 23 to
"/data/MYUAT/DATAFILE/eocmlrg.3094.947766809";
set newname
for datafile 24 to
"/data/MYUAT/DATAFILE/eocmwrk.322.947766809";
set newname
for datafile 25 to
"/data/MYUAT/DATAFILE/eocuapp.3095.947766809";
set newname
for datafile 26 to
"/data/MYUAT/DATAFILE/eoculrg.3098.947766811";
set newname
for datafile 27 to
"/data/MYUAT/DATAFILE/eodsapp.3112.947766815";
set newname
for datafile 28 to
"/data/MYUAT/DATAFILE/eodslrg.3099.947766811";
set newname
for datafile 29 to
"/data/MYUAT/DATAFILE/eoecapp.2074.947766809";
set newname
for datafile 30 to
"/data/MYUAT/DATAFILE/eoeclrg.2069.947766809";
set newname
for datafile 31 to
"/data/MYUAT/DATAFILE/eoecwrk.3103.947766811";
set newname
for datafile 32 to
"/data/MYUAT/DATAFILE/eoeiapp.3106.947766811";
set newname
for datafile 33 to
"/data/MYUAT/DATAFILE/eoeilrg.3108.947766811";
set newname
for datafile 34 to
"/data/MYUAT/DATAFILE/eoewapp.3109.947766813";
set newname
for datafile 35 to
"/data/MYUAT/DATAFILE/eoewlrg.2083.947766099";
set newname
for datafile 36 to
"/data/MYUAT/DATAFILE/eoewwrk.2077.947766099";
set newname
for datafile 37 to
"/data/MYUAT/DATAFILE/eoiuapp.3110.947766815";
set newname
for datafile 38 to
"/data/MYUAT/DATAFILE/eoiulrg.2099.947790101";
set newname
for datafile 39 to
"/data/MYUAT/DATAFILE/eoiuwrk.2113.947766099";
set newname
for datafile 40 to
"/data/MYUAT/DATAFILE/eolarge.2100.947766099";
set newname
for datafile 41 to
"/data/MYUAT/DATAFILE/eotpapp.342.947766809";
set newname
for datafile 42 to
"/data/MYUAT/DATAFILE/eotplrg.3093.947766809";
set newname
for datafile 43 to
"/data/MYUAT/DATAFILE/lmimage.3115.947766855";
set newname
for datafile 44 to
"/data/MYUAT/DATAFILE/lmlarge.2103.947752747";
set newname
for datafile 45 to
"/data/MYUAT/DATAFILE/lmwork.2081.947766099";
set newname
for datafile 46 to
"/data/MYUAT/DATAFILE/pvapp.3116.947766857";
set newname
for datafile 47 to
"/data/MYUAT/DATAFILE/psimage.2105.947752747";
set newname
for datafile 48 to
"/data/MYUAT/DATAFILE/lmapp.2096.947752747";
set newname
for datafile 49 to
"/data/MYUAT/DATAFILE/psindex.2104.947752747";
set newname
for datafile 50 to
"/data/MYUAT/DATAFILE/users.2068.947766809";
set newname
for datafile 51 to
"/data/MYUAT/DATAFILE/psimage2.2098.947752747";
set newname
for datafile 52 to
"/data/MYUAT/DATAFILE/psmatvw.3101.947766811";
set newname
for datafile 53 to
"/data/MYUAT/DATAFILE/psgtt01.3102.947766811";
set newname
for datafile 54 to
"/data/MYUAT/DATAFILE/audit_data.2070.947766809";
set newname
for datafile 55 to
"/data/MYUAT/DATAFILE/undotbs5.2092.947752747";
set newname
for datafile 56 to
"/data/MYUAT/DATAFILE/undotbs6.2080.947765411";
restore
clone
database
;
}
executing Memory Script
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
executing command: SET
NEWNAME
Starting restore at
17-JAN-18
channel ch1: starting
datafile backup set restore
channel ch1: specifying
datafile(s) to restore from backup set
channel ch1: restoring
datafile 00001 to /data/MYUAT/DATAFILE/system.3097.947766811
channel ch1: restoring
datafile 00018 to /data/MYUAT/DATAFILE/pttbl.2152.947766809
channel ch1: restoring
datafile 00019 to /data/MYUAT/DATAFILE/pttlrg.2072.947766809
channel ch1: restoring
datafile 00030 to /data/MYUAT/DATAFILE/eoeclrg.2069.947766809
channel ch1: reading
from backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58907_1
channel ch2: starting
datafile backup set restore
channel ch2: specifying
datafile(s) to restore from backup set
channel ch2: restoring
datafile 00002 to /data/MYUAT/DATAFILE/sysaux.2076.947766099
channel ch2: restoring
datafile 00015 to /data/MYUAT/DATAFILE/ptprc.2150.947766809
channel ch2: restoring
datafile 00029 to /data/MYUAT/DATAFILE/eoecapp.2074.947766809
channel ch2: restoring
datafile 00050 to /data/MYUAT/DATAFILE/users.2068.947766809
channel ch2: reading
from backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58908_1
channel ch3: starting
datafile backup set restore
channel ch3: specifying
datafile(s) to restore from backup set
channel ch3: restoring
datafile 00003 to /data/MYUAT/DATAFILE/undotbs1.2095.947765199
channel ch3: restoring
datafile 00021 to /data/MYUAT/DATAFILE/ptwork.3107.947766811
channel ch3: restoring
datafile 00034 to /data/MYUAT/DATAFILE/eoewapp.3109.947766813
channel ch3: restoring
datafile 00046 to /data/MYUAT/DATAFILE/pvapp.3116.947766857
channel ch3: reading
from backup piece /backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58903_1
channel ch4: starting
datafile backup set restore
channel ch4: specifying
datafile(s) to restore from backup set
channel ch4: restoring
datafile 00004 to /data/MYUAT/DATAFILE/psdefault.2085.947766809
channel ch4: restoring
datafile 00009 to /data/MYUAT/DATAFILE/ptamsg.3096.947766809
channel ch4: restoring
datafile 00017 to /data/MYUAT/DATAFILE/ptrpts.2151.947766809
channel ch4: restoring
datafile 00054 to /data/MYUAT/DATAFILE/audit_data.2070.947766809
channel ch4: reading
from backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58909_1
channel ch5: starting
datafile backup set restore
channel ch5: specifying
datafile(s) to restore from backup set
channel ch5: restoring
datafile 00005 to /data/MYUAT/DATAFILE/undotbs2.2102.947752747
channel ch5: restoring
datafile 00014 to /data/MYUAT/DATAFILE/ptlock.3091.947766809
channel ch5: restoring
datafile 00024 to /data/MYUAT/DATAFILE/eocmwrk.322.947766809
channel ch5: restoring
datafile 00041 to /data/MYUAT/DATAFILE/eotpapp.342.947766809
channel ch5: reading
from backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58901_1
channel ch6: starting
datafile backup set restore
channel ch6: specifying
datafile(s) to restore from backup set
channel ch6: restoring
datafile 00006 to /data/MYUAT/DATAFILE/undotbs3.2089.947752747
channel ch6: restoring
datafile 00020 to /data/MYUAT/DATAFILE/pttree.3111.947766815
channel ch6: restoring
datafile 00027 to /data/MYUAT/DATAFILE/eodsapp.3112.947766815
channel ch6: restoring
datafile 00037 to /data/MYUAT/DATAFILE/eoiuapp.3110.947766815
channel ch6: reading
from backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58902_1
channel ch7: starting
datafile backup set restore
channel ch7: specifying
datafile(s) to restore from backup set
channel ch7: restoring
datafile 00007 to /data/MYUAT/DATAFILE/undotbs4.2071.947765631
channel ch7: restoring
datafile 00010 to /data/MYUAT/DATAFILE/ptapp.3114.947766845
channel ch7: restoring
datafile 00016 to /data/MYUAT/DATAFILE/ptprjwk.3113.947766837
channel ch7: restoring
datafile 00043 to /data/MYUAT/DATAFILE/lmimage.3115.947766855
channel ch7: reading
from backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58906_1
channel ch8: starting
datafile backup set restore
channel ch8: specifying
datafile(s) to restore from backup set
channel ch8: restoring
datafile 00008 to /data/MYUAT/DATAFILE/psimgr.3100.947766811
channel ch8: restoring
datafile 00022 to /data/MYUAT/DATAFILE/eocmapp.3104.947766811
channel ch8: restoring
datafile 00032 to /data/MYUAT/DATAFILE/eoeiapp.3106.947766811
channel ch8: restoring
datafile 00055 to /data/MYUAT/DATAFILE/undotbs5.2092.947752747
channel ch8: reading
from backup piece /backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58905_1
channel ch9: starting
datafile backup set restore
channel ch9: specifying
datafile(s) to restore from backup set
channel ch9: restoring
datafile 00011 to /data/MYUAT/DATAFILE/ptappe.3105.947766811
channel ch9: restoring
datafile 00052 to /data/MYUAT/DATAFILE/psmatvw.3101.947766811
channel ch9: restoring
datafile 00053 to /data/MYUAT/DATAFILE/psgtt01.3102.947766811
channel ch9: restoring
datafile 00056 to /data/MYUAT/DATAFILE/undotbs6.2080.947765411
channel ch9: reading
from backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58904_1
channel ch4: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58909_1
tag=TAG20180115T021026
channel ch4: restored
backup piece 1
channel ch4: restore
complete, elapsed time: 00:12:46
channel ch4: starting
datafile backup set restore
channel ch4: specifying
datafile(s) to restore from backup set
channel ch4: restoring
datafile 00012 to /data/MYUAT/DATAFILE/ptaudit.3092.947766809
channel ch4: restoring
datafile 00023 to /data/MYUAT/DATAFILE/eocmlrg.3094.947766809
channel ch4: restoring
datafile 00042 to /data/MYUAT/DATAFILE/eotplrg.3093.947766809
channel ch4: restoring
datafile 00051 to /data/MYUAT/DATAFILE/psimage2.2098.947752747
channel ch4: reading
from backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58900_1
channel ch2: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58908_1
tag=TAG20180115T021026
channel ch2: restored
backup piece 1
channel ch2: restore
complete, elapsed time: 00:13:12
channel ch2: starting
datafile backup set restore
channel ch2: specifying
datafile(s) to restore from backup set
channel ch2: restoring
datafile 00013 to /data/MYUAT/DATAFILE/ptcmstar.2090.947766099
channel ch2: restoring
datafile 00040 to /data/MYUAT/DATAFILE/eolarge.2100.947766099
channel ch2: restoring
datafile 00045 to /data/MYUAT/DATAFILE/lmwork.2081.947766099
channel ch2: restoring
datafile 00047 to /data/MYUAT/DATAFILE/psimage.2105.947752747
channel ch2: reading from
backup piece /backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58896_1
channel ch2: ORA-19870:
error while restoring backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58896_1
ORA-19504: failed to create
file "/data/MYUAT/DATAFILE/psimage.2105.947752747"
ORA-27044: unable to write
the header block of file
Linux-x86_64 Error: 27:
File too large
Additional information: 4
channel ch2: starting
datafile backup set restore
channel ch2: specifying
datafile(s) to restore from backup set
channel ch2: restoring
datafile 00025 to /data/MYUAT/DATAFILE/eocuapp.3095.947766809
channel ch2: restoring
datafile 00026 to /data/MYUAT/DATAFILE/eoculrg.3098.947766811
channel ch2: restoring
datafile 00028 to /data/MYUAT/DATAFILE/eodslrg.3099.947766811
channel ch2: restoring
datafile 00044 to /data/MYUAT/DATAFILE/lmlarge.2103.947752747
channel ch2: reading
from backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58899_1
channel ch3: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58903_1
tag=TAG20180115T021026
channel ch3: restored
backup piece 1
channel ch3: restore
complete, elapsed time: 00:14:05
channel ch3: starting
datafile backup set restore
channel ch3: specifying
datafile(s) to restore from backup set
channel ch3: restoring
datafile 00031 to /data/MYUAT/DATAFILE/eoecwrk.3103.947766811
channel ch3: restoring
datafile 00033 to /data/MYUAT/DATAFILE/eoeilrg.3108.947766811
channel ch3: restoring
datafile 00035 to /data/MYUAT/DATAFILE/eoewlrg.2083.947766099
channel ch3: restoring
datafile 00048 to /data/MYUAT/DATAFILE/lmapp.2096.947752747
channel ch3: reading
from backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58898_1
channel ch7: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58906_1
tag=TAG20180115T021026
channel ch7: restored
backup piece 1
channel ch7: restore
complete, elapsed time: 00:14:04
channel ch7: starting
datafile backup set restore
channel ch7: specifying
datafile(s) to restore from backup set
channel ch7: restoring
datafile 00036 to /data/MYUAT/DATAFILE/eoewwrk.2077.947766099
channel ch7: restoring
datafile 00038 to /data/MYUAT/DATAFILE/eoiulrg.2099.947790101
channel ch7: restoring
datafile 00039 to /data/MYUAT/DATAFILE/eoiuwrk.2113.947766099
channel ch7: restoring
datafile 00049 to /data/MYUAT/DATAFILE/psindex.2104.947752747
channel ch7: reading
from backup piece
/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58897_1
channel ch8: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58905_1
tag=TAG20180115T021026
channel ch8: restored
backup piece 1
channel ch8: restore
complete, elapsed time: 00:14:04
channel ch9: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58904_1
tag=TAG20180115T021026
channel ch9: restored
backup piece 1
channel ch9: restore
complete, elapsed time: 00:14:04
channel ch1: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58907_1
tag=TAG20180115T021026
channel ch1: restored
backup piece 1
channel ch1: restore
complete, elapsed time: 00:14:05
channel ch6: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58902_1
tag=TAG20180115T021026
channel ch6: restored
backup piece 1
channel ch6: restore
complete, elapsed time: 00:14:40
channel ch5: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58901_1
tag=TAG20180115T021026
channel ch5: restored
backup piece 1
channel ch5: restore
complete, elapsed time: 00:15:00
channel ch4: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58900_1
tag=TAG20180115T021026
channel ch4: restored
backup piece 1
channel ch4: restore
complete, elapsed time: 00:54:35
channel ch2: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58899_1
tag=TAG20180115T021026
channel ch2: restored
backup piece 1
channel ch2: restore
complete, elapsed time: 00:56:33
channel ch3: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58898_1
tag=TAG20180115T021026
channel ch3: restored
backup piece 1
channel ch3: restore
complete, elapsed time: 01:15:48
channel ch7: piece
handle=/backupshare/ML_PUNE_DR_Golden_offbkp/FULL_BACKUP_MLPRD_58897_1
tag=TAG20180115T021026
channel ch7: restored
backup piece 1
channel ch7: restore
complete, elapsed time: 01:29:28
failover to previous
backup
creating datafile file
number=13 name=/data/MYUAT/DATAFILE/ptcmstar.2090.947766099
restarting auxiliary
database without server parameter file
Oracle instance started
Total System Global
Area 19241058304 bytes
Fixed
Size
2261368 bytes
Variable
Size
9529462408 bytes
Database
Buffers
9663676416 bytes
Redo
Buffers
45658112 bytes
RMAN-00571:
===========================================================
RMAN-00569:
=============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571:
===========================================================
RMAN-03002: failure of
Duplicate Db command at 01/17/2018 05:01:02
RMAN-05501: aborting
duplication of target database
RMAN-03015: error
occurred in stored script Memory Script
RMAN-06136: ORACLE error
from auxiliary database: ORA-01119: error in creating database file
'+ndata_my'
ORA-17502: ksfdcre:4
Failed to create file +ndata_ctsp
ORA-15001: diskgroup
"NDATA_MY" does not exist or is not mounted
ORA-15077: could not
locate ASM instance serving a required diskgroup
ORA-29701: unable to
connect to Cluster Synchronization Service
RMAN-06956: create
datafile failed; retry after removing /data/MYUAT/DATAFILE/ptcmstar.2090.947766099
from OS
Recovery Manager
complete.
No comments:
Post a Comment