RMAN Duplicate Issue [message #607380] |
Wed, 05 February 2014 06:02 |
|
aislanluiz
Messages: 8 Registered: February 2014
|
Junior Member |
|
|
Hi,
I encountered an issue that I can't find a solution. I searched it in many ways, documentation, foruns, blogs and so on...
I am a fresh "DBA" pulled from the PHP development area here where I work and I don't have too much experience on Oracle, so I will explain the way I think can be understandable. (By the way, sorry about my english...)
I have in hands an Oracle 10g with RAC and ASM. In my inexperience, I thought the RMAN duplicate could duplicate schemas (I made a mistake in some concepts like database, instance and schema as my main experience was with postgresql). I followed a tutorial, did the connect target auxiliary commands using the schemas names and no error were appointed, but the process couldn't complete because of lack of space left on the diskgroups.
They wanted so much that clone that I forgot for a moment the error and after more search, I learned how to clone it using export. I did the job and now my problem is that my largest diskgroup is full and all tablespace files attached to that DG will not expand (i think).
In my search, everyone says that I can add more space and the rman will continue the process where it stoped, but i don't want to continue, I just want to delete the temporary files that are waiting rman to continue.
I tried asmcmd but in some posts I read that in 10g it didnt work. I tried to use RMAN delete, but only delete some files with backup relations and in the normal file system, the diskgroups didn't change they available space, so I think it's not the way too.
I don't have any more space to add on that storage to finish the process and delete the duplicated database(?) after...
|
|
|
|
Re: RMAN Duplicate Issue [message #607382 is a reply to message #607380] |
Wed, 05 February 2014 06:25 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I would begin by determining what is on your disc groups. Connect to an ASM instance, and run queries such as select name, GROUP_NUMBER, FILE_NUMBER,BYTES, TYPE from v$asm_file join v$asm_alias using(GROUP_NUMBER, FILE_NUMBER);
|
|
|
|
Re: RMAN Duplicate Issue [message #607384 is a reply to message #607382] |
Wed, 05 February 2014 06:30 |
|
aislanluiz
Messages: 8 Registered: February 2014
|
Junior Member |
|
|
export ORACLE_SID=+ASM1
sqlplus / as sysdba
select name, GROUP_NUMBER, FILE_NUMBER,BYTES, TYPE from v$asm_file join v$asm_alias using(GROUP_NUMBER, FILE_NUMBER);
SELECT's result is here
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.256.669923213 1 256
24723456 CONTROLFILE
PDV_DADOS.256.708868003 2 256
6291464192 DATAFILE
system01.dbf 3 256
2380275712 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSTEM.256.783472009 3 256
2380275712 DATAFILE
PDV_INDICES.256.783517705 4 256
1.0737E+10 DATAFILE
WIS_DADOS.256.783511175 5 256
5242888192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.257.669923213 1 257
24723456 CONTROLFILE
PDV_DADOS.257.708868079 2 257
6291464192 DATAFILE
SYSAUX.257.783472009 3 257
1017126912 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
sysaux01.dbf 3 257
1017126912 DATAFILE
PDV_INDICES.257.783517909 4 257
1.0737E+10 DATAFILE
WIS_DADOS.257.783511149 5 257
5242888192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSTEM5 1 258
1073750016 DATAFILE
SYSTEM.258.836995069 1 258
1073750016 DATAFILE
PDV_INDICES.258.708868121 2 258
8396800 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
UNDOTBS1.258.783472009 3 258
26222592 DATAFILE
undotbs01.dbf 3 258
26222592 DATAFILE
PDV_INDICES.258.783518137 4 258
1.0737E+10 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS_DADOS.258.783511127 5 258
5242888192 DATAFILE
SYSTEM6 1 259
5368717312 DATAFILE
SYSTEM.259.837339899 1 259
5368717312 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_DADOS.259.708868191 2 259
6289367040 DATAFILE
users01.dbf 3 259
5262548992 DATAFILE
USERS.259.783472009 3 259
5262548992 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_INDICES.259.783518371 4 259
1.0737E+10 DATAFILE
WIS_DADOS.259.783511101 5 259
5242888192 DATAFILE
SYSTEM2 1 260
1073750016 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSTEM.260.829503231 1 260
1073750016 DATAFILE
PDV_INDICES.260.708868287 2 260
10493952 DATAFILE
control01.ctl 3 260
17088512 CONTROLFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.260.783472037 3 260
17088512 CONTROLFILE
PDV_INDICES.260.783518619 4 260
1.0737E+10 DATAFILE
VETORH_DATA.260.783513391 5 260
5242888192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_3.261.739709187 1 261
209715712 ONLINELOG
PDV_DADOS.261.708868345 2 261
6291464192 DATAFILE
Current.261.783472037 3 261
17088512 CONTROLFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
control02.ctl 3 261
17088512 CONTROLFILE
PDV_INDICES.261.783518821 4 261
1.0737E+10 DATAFILE
PDV_DADOS.261.783513821 5 261
1.0737E+10 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSTEM.262.669923217 1 262
4194312192 DATAFILE
PDV_INDICES.262.708868431 2 262
10493952 DATAFILE
control03.ctl 3 262
17088512 CONTROLFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.262.783472037 3 262
17088512 CONTROLFILE
PDV_INDICES.262.783519035 4 262
1.0737E+10 DATAFILE
PDV_DADOS.262.783513909 5 262
1.0737E+10 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_DATA.263.788783027 1 263
4194312192 DATAFILE
PDV_INDICES.263.708868539 2 263
15736832 DATAFILE
group_1.263.783472061 3 263
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
redo01.log 3 263
52429312 ONLINELOG
PDV_INDICES.263.783519241 4 263
1.0737E+10 DATAFILE
PDV_DADOS.263.783514005 5 263
1.0737E+10 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSAUX.264.669923227 1 264
2221940736 DATAFILE
PDV_DADOS.264.712575697 2 264
6291464192 DATAFILE
group_2.264.783472061 3 264
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
redo02.log 3 264
52429312 ONLINELOG
PDV_INDICES.264.783519457 4 264
1.0737E+10 DATAFILE
PDV_DADOS.264.783514095 5 264
1.0737E+10 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_5.265.739707763 1 265
209715712 ONLINELOG
PDV_INDICES.265.713376017 2 265
5251072 DATAFILE
TEMP.265.783472067 3 265
1.1288E+10 TEMPFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
temp01.dbf 3 265
1.1288E+10 TEMPFILE
PDV_INDICES.265.783519675 4 265
1.0737E+10 DATAFILE
PDV_DADOS.265.783514185 5 265
1.0737E+10 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VRHINDEX.13062013 1 266
7340040192 DATAFILE
VETORH_INDEX.266.818010477 1 266
7340040192 DATAFILE
PDV_DADOS.266.734091063 2 266
3145736192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
UNDOTBS2.266.783472083 3 266
204480512 DATAFILE
undotbs02.dbf 3 266
204480512 DATAFILE
PROTP 4 266
1073750016 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PROTP_D.266.838660259 4 266
1073750016 DATAFILE
PDV_DADOS.266.783514281 5 266
1.0737E+10 DATAFILE
USERS.267.669923231 1 267
760225792 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_3.267.783472281 3 267
52429312 ONLINELOG
redo03.log 3 267
52429312 ONLINELOG
PROTP_I.267.838660365 4 267
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PROTPI 4 267
524296192 DATAFILE
PDV_DADOS.267.783514385 5 267
1.0737E+10 DATAFILE
group_1.268.834585655 1 268
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_4.268.783472281 3 268
52429312 ONLINELOG
redo04.log 3 268
52429312 ONLINELOG
SYSTEM.268.838660503 4 268
262152192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSTEM1 4 268
262152192 DATAFILE
PDV_DADOS.268.783514485 5 268
1.0737E+10 DATAFILE
WIS_INDEXES.269.669923361 1 269
32514048 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
CONCARCRED.269.782924261 2 269
763371520 DATAFILE
spfile.269.783472281 3 269
3584 PARAMETERFILE
spfiledbmm.ora 3 269
3584 PARAMETERFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSAUX.269.838660577 4 269
262152192 DATAFILE
SYSAUX 4 269
262152192 DATAFILE
PDV_DADOS.269.783514573 5 269
1.0737E+10 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_2.270.739709163 1 270
209715712 ONLINELOG
CONCARCRED.270.782924309 2 270
704913408 DATAFILE
WIS_INDEXES.270.783513301 3 270
5242888192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
UNDOTBS1.270.838660691 4 270
104865792 DATAFILE
UNDOTBS2 4 270
104865792 DATAFILE
PDV_DADOS.270.783514667 5 270
1.0737E+10 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_1.271.739709143 1 271
209715712 ONLINELOG
WIS_INDEXES.271.796992563 2 271
19931136 DATAFILE
VETORH_INDEX.271.783513669 3 271
5242888192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_DADOS.271.783514755 5 271
1.0737E+10 DATAFILE
WIS_INDEXES.272.825070577 1 272
104865792 DATAFILE
WIS_INDEXES.02092013 1 272
104865792 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
CONCARCRED 2 272
524296192 DATAFILE
CONCARCRED.272.823533025 2 272
524296192 DATAFILE
UNDOTBS1.272.783940265 3 272
1.0737E+10 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_DADOS.272.783514857 5 272
1.0737E+10 DATAFILE
group_4.273.739707865 1 273
209715712 ONLINELOG
CONCARCRED.273.825418391 2 273
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
CONCARCRED2 2 273
524296192 DATAFILE
UNDOTBS1.273.783941665 3 273
1.0737E+10 DATAFILE
PDV_DADOS.273.783514955 5 273
1.0737E+10 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
spfiledbrac.ora 1 274
5632 PARAMETERFILE
spfile.274.669978541 1 274
5632 PARAMETERFILE
CONCARCRED.274.829474141 2 274
2147491840 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
CONCARCRED3 2 274
2147491840 DATAFILE
UNDOTBS2.274.783941857 3 274
1.0737E+10 DATAFILE
PDV_DADOS.274.783515045 5 274
1.0737E+10 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_DATA.275.671293117 1 275
8387829760 DATAFILE
UNDOTBS2.275.783942145 3 275
1.0737E+10 DATAFILE
PDV_DADOS.275.783515141 5 275
1.0737E+10 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_INDEX.276.671293157 1 276
7340040192 DATAFILE
UNDOTBS02.276.786359647 3 276
1185947648 DATAFILE
SYSTEM.276.832611333 5 276
534781952 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SENIORH.277.833886949 1 277
104865792 DATAFILE
UNDOTBS01.277.786360185 3 277
6291464192 DATAFILE
SYSAUX.277.832611335 5 277
368050176 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_DADOS.278.687953479 1 278
6291464192 DATAFILE
WIS47_DADOS.278.790603279 3 278
7712219136 DATAFILE
UNDOTBS1.278.832611335 5 278
62922752 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_INDICES.279.687953561 1 279
9445376 DATAFILE
WIS47_DADOS.279.790619673 3 279
8589942784 DATAFILE
USERS.279.832611335 5 279
5251072 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
TEMP.280.690052415 1 280
5242888192 TEMPFILE
VETORH_DATA.280.836297319 3 280
1073750016 DATAFILE
VTHD.08012014 3 280
1073750016 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.280.832611385 5 280
15286272 CONTROLFILE
group_6.281.739707777 1 281
209715712 ONLINELOG
WIS47_DADOS.281.793182623 3 281
4504690688 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.281.832611385 5 281
15286272 CONTROLFILE
group_7.282.739707795 1 282
209715712 ONLINELOG
VETORH_INDEX.282.800461301 3 282
911220736 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_1.282.832611389 5 282
52429312 ONLINELOG
group_8.283.739707811 1 283
209715712 ONLINELOG
VETORH_DATA.283.807815869 3 283
6500130816 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_1.283.832611389 5 283
52429312 ONLINELOG
VETORH_INDEX.284.765123899 1 284
4294975488 DATAFILE
VETORH_DATA.284.807816027 3 284
4534050816 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_2.284.832611391 5 284
52429312 ONLINELOG
group_1.285.834585655 1 285
52429312 ONLINELOG
VETORH_INDEX.285.807816051 3 285
838868992 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_2.285.832611391 5 285
52429312 ONLINELOG
SYSTEM1 1 286
524296192 DATAFILE
SYSTEM.286.825420391 1 286
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS47_DADOS.286.836297465 3 286
1073750016 DATAFILE
WIS47D.08012014 3 286
1073750016 DATAFILE
group_3.286.832611393 5 286
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSTEM4 1 287
524296192 DATAFILE
SYSTEM.287.836491709 1 287
524296192 DATAFILE
datafilewis47.13062013 3 287
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS47_DADOS.287.817957493 3 287
524296192 DATAFILE
group_3.287.832611393 5 287
52429312 ONLINELOG
SYSTEM3 1 288
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSTEM.288.836299301 1 288
524296192 DATAFILE
VETORH_DATA.288.817957641 3 288
524296192 DATAFILE
VTRH.13062013 3 288
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
TEMP.288.832611399 5 288
20979712 TEMPFILE
group_4.289.834585659 1 289
52429312 ONLINELOG
WIS47_DADOS.289.818010765 3 289
1048584192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS47.13062013 3 289
1048584192 DATAFILE
spfile.289.832611425 5 289
3584 PARAMETERFILE
spfileproth.ora 5 289
3584 PARAMETERFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_4.290.834585659 1 290
52429312 ONLINELOG
VETORH_DATA.290.819816849 3 290
524296192 DATAFILE
vtrh.03072013 3 290
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSTEM.290.832613025 5 290
535822336 DATAFILE
group_3.291.834585657 1 291
52429312 ONLINELOG
WIS47.06082013 3 291
1048584192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS47_DADOS.291.822765107 3 291
1048584192 DATAFILE
SYSAUX.291.832613025 5 291
378535936 DATAFILE
group_3.292.834585657 1 292
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS.14102013 3 292
2147491840 DATAFILE
WIS47_DADOS.292.828829759 3 292
2147491840 DATAFILE
UNDOTBS1.292.832613027 5 292
37748736 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_2.293.834585657 1 293
52429312 ONLINELOG
VETORH_DATA.293.828984131 3 293
2147491840 DATAFILE
VTRH.16102013 3 293
2147491840 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
USERS.293.832613027 5 293
5251072 DATAFILE
group_2.294.834585655 1 294
52429312 ONLINELOG
VETORH_INDEX.294.836297383 3 294
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VTHI.08012014 3 294
524296192 DATAFILE
Current.294.832613077 5 294
15286272 CONTROLFILE
UNDOTBS01.295.836297725 3 295
104865792 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
UNDOT.08012014 3 295
104865792 DATAFILE
Current.295.832613077 5 295
15286272 CONTROLFILE
VETORH_INDEX.296.836491783 3 296
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VTHI.10012014 3 296
524296192 DATAFILE
group_1.296.832613079 5 296
52429312 ONLINELOG
VETORH_DATA.297.836491939 3 297
2147491840 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VTHD.10012014 3 297
2147491840 DATAFILE
group_1.297.832613079 5 297
52429312 ONLINELOG
WIS47_DADOS.298.836492021 3 298
5368717312 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS47.10012014 3 298
5368717312 DATAFILE
group_2.298.832613081 5 298
52429312 ONLINELOG
UNDOTBS01.299.836774729 3 299
6291464192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
UNDOT.13022014 3 299
6291464192 DATAFILE
group_2.299.832613081 5 299
52429312 ONLINELOG
SYSTEM.300.836774935 3 300
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSTEM2 3 300
524296192 DATAFILE
group_3.300.832613083 5 300
52429312 ONLINELOG
UNDOTBS01.301.836776207 3 301
1073750016 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
UNDOTBS01 3 301
1073750016 DATAFILE
group_3.301.832613083 5 301
52429312 ONLINELOG
TEMP.302.832613089 5 302
20979712 TEMPFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
spfile.303.832613117 5 303
3584 PARAMETERFILE
spfileprotp.ora 5 303
3584 PARAMETERFILE
SYSTEM.304.832613987 5 304
546308096 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSAUX.305.832613987 5 305
389021696 DATAFILE
UNDOTBS1.306.832613987 5 306
210763776 DATAFILE
USERS.307.832613987 5 307
5251072 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.308.832614037 5 308
15286272 CONTROLFILE
Current.309.832614037 5 309
15286272 CONTROLFILE
group_1.310.832614039 5 310
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_1.311.832614039 5 311
52429312 ONLINELOG
group_2.312.832614041 5 312
52429312 ONLINELOG
group_2.313.832614041 5 313
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_3.314.832614043 5 314
52429312 ONLINELOG
group_3.315.832614043 5 315
52429312 ONLINELOG
TEMP.316.832614049 5 316
20979712 TEMPFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
spfile.317.832614073 5 317
3584 PARAMETERFILE
spfileprott.ora 5 317
3584 PARAMETERFILE
SYSTEM.318.832614847 5 318
513810432 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSAUX.319.832614847 5 319
368050176 DATAFILE
UNDOTBS1.320.832614847 5 320
27262976 DATAFILE
USERS.321.832614847 5 321
5251072 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.322.832614897 5 322
15286272 CONTROLFILE
Current.323.832614897 5 323
15286272 CONTROLFILE
group_1.324.832614901 5 324
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_1.325.832614901 5 325
52429312 ONLINELOG
group_2.326.832614901 5 326
52429312 ONLINELOG
group_2.327.832614903 5 327
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_3.328.832614903 5 328
52429312 ONLINELOG
group_3.329.832614903 5 329
52429312 ONLINELOG
TEMP.330.832614909 5 330
20979712 TEMPFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
spfile.331.832614933 5 331
3584 PARAMETERFILE
spfileprotth.ora 5 331
3584 PARAMETERFILE
SYSTEM.332.832615553 5 332
513810432 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSAUX.333.832615553 5 333
368050176 DATAFILE
UNDOTBS1.334.832615553 5 334
27262976 DATAFILE
USERS.335.832615553 5 335
5251072 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.336.832615603 5 336
15286272 CONTROLFILE
Current.337.832615603 5 337
15286272 CONTROLFILE
group_1.338.832615605 5 338
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_1.339.832615607 5 339
52429312 ONLINELOG
group_2.340.832615607 5 340
52429312 ONLINELOG
group_2.341.832615607 5 341
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
group_3.342.832615609 5 342
52429312 ONLINELOG
group_3.343.832615609 5 343
52429312 ONLINELOG
TEMP.344.832615617 5 344
20979712 TEMPFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
spfile.345.832615643 5 345
3584 PARAMETERFILE
spfileprottp.ora 5 345
3584 PARAMETERFILE
PROTH_D.346.832771953 5 346
104865792 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PROTH_I.347.832771975 5 347
209723392 DATAFILE
PROTP_D.348.832772257 5 348
105906176 DATAFILE
PROTP_I.349.832772271 5 349
315621376 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PROTT_D.350.832772351 5 350
209723392 DATAFILE
PROTT_I.351.832772365 5 351
314580992 DATAFILE
PROTTH_D.352.832772433 5 352
104865792 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PROTTH_I.353.832772471 5 353
104865792 DATAFILE
PROTTP_D.354.832772539 5 354
104865792 DATAFILE
PROTTP_I.355.832772587 5 355
104865792 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.356.833815509 5 356
15286272 CONTROLFILE
UNDOTBS1.357.834586167 5 357
26222592 DATAFILE
SYSAUX.358.834586167 5 358
273678336 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
TEMP.359.834586231 5 359
20979712 TEMPFILE
group_3.360.834586223 5 360
52429312 ONLINELOG
group_2.361.834586223 5 361
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.362.834585653 5 362
15286272 CONTROLFILE
control02.ctl 5 362
15286272 CONTROLFILE
group_1.363.834586223 5 363
52429312 ONLINELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.364.834586219 5 364
15286272 CONTROLFILE
USERS.365.834586167 5 365
5251072 DATAFILE
SYSTEM.366.834586167 5 366
513810432 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.367.834585653 5 367
15286272 CONTROLFILE
control03.ctl 5 367
15286272 CONTROLFILE
control01.ctl 5 368
15286272 CONTROLFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
Current.368.834585653 5 368
15286272 CONTROLFILE
thread_2_seq_1.369.833824087 5 369
2381824 ARCHIVELOG
thread_1_seq_24.370.833820811 5 370
46779392 ARCHIVELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
thread_2_seq_2.371.833904011 5 371
52425216 ARCHIVELOG
thread_1_seq_25.372.833901375 5 372
52427264 ARCHIVELOG
thread_1_seq_26.373.833903955 5 373
52427264 ARCHIVELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
thread_1_seq_27.374.833904067 5 374
52427264 ARCHIVELOG
thread_2_seq_3.375.833907779 5 375
1927680 ARCHIVELOG
thread_1_seq_28.376.833904151 5 376
52427264 ARCHIVELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
thread_1_seq_29.377.833904293 5 377
52427264 ARCHIVELOG
thread_2_seq_4.378.833925633 5 378
52427264 ARCHIVELOG
thread_2_seq_5.379.833925693 5 379
52427264 ARCHIVELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
thread_1_seq_30.380.833923837 5 380
28169216 ARCHIVELOG
thread_2_seq_6.381.833927785 5 381
8955904 ARCHIVELOG
thread_1_seq_31.382.834002717 5 382
19022848 ARCHIVELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
thread_2_seq_7.383.834026487 5 383
52427264 ARCHIVELOG
thread_2_seq_8.384.834114649 5 384
52427264 ARCHIVELOG
thread_2_seq_9.385.834199203 5 385
52427264 ARCHIVELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
thread_1_seq_32.386.834195503 5 386
43593728 ARCHIVELOG
thread_2_seq_10.387.834318039 5 387
52426752 ARCHIVELOG
thread_2_seq_11.388.834382817 5 388
52427264 ARCHIVELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
thread_1_seq_33.389.834411537 5 389
52426240 ARCHIVELOG
thread_2_seq_12.390.834444533 5 390
52427264 ARCHIVELOG
thread_2_seq_13.391.834530411 5 391
52426240 ARCHIVELOG
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
spfile.392.834586267 5 392
3584 PARAMETERFILE
spfileseniorh.ora 5 392
3584 PARAMETERFILE
WIS47_DADOS.393.834748511 5 393
8589942784 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_INDICES.394.834748513 5 394
5251072 DATAFILE
WIS47_DADOS.395.834750005 5 395
8589942784 DATAFILE
PDV_INDICES.396.834750007 5 396
5251072 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_DATA.397.834750327 5 397
8387829760 DATAFILE
PDV_INDICES.398.834750329 5 398
8396800 DATAFILE
WIS47_DADOS.399.834750723 5 399
7712219136 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_INDICES.400.834750725 5 400
9445376 DATAFILE
VETORH_INDEX.401.834751017 5 401
7340040192 DATAFILE
PDV_INDICES.402.834751019 5 402
10493952 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_INDEX.403.834751313 5 403
7340040192 DATAFILE
PDV_INDICES.404.834751315 5 404
10493952 DATAFILE
PDV_DADOS.405.834751479 5 405
6291464192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSTEM.406.834751479 5 406
524296192 DATAFILE
PDV_DADOS.407.834751843 5 407
6289367040 DATAFILE
CONCARCRED.408.834751845 5 408
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_DADOS.409.834752189 5 409
6291464192 DATAFILE
SENIORH.410.834752189 5 410
104865792 DATAFILE
PDV_DADOS.411.834752523 5 411
6291464192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS_INDEXES.412.834752525 5 412
104865792 DATAFILE
PDV_DADOS.413.834752859 5 413
6291464192 DATAFILE
WIS_INDEXES.414.834752859 5 414
32514048 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_DADOS.415.834753203 5 415
6291464192 DATAFILE
WIS_INDEXES.416.834753205 5 416
19931136 DATAFILE
UNDOTBS01.417.834753469 5 417
6291464192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_INDICES.418.834753471 5 418
15736832 DATAFILE
WIS47_DADOS.419.834753855 5 419
4504690688 DATAFILE
CONCARCRED.420.834753855 5 420
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_INDEX.421.834754099 5 421
4294975488 DATAFILE
VETORH_DATA.422.834754099 5 422
524296192 DATAFILE
SYSTEM.423.834754305 5 423
4194312192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS47_DADOS.424.834754305 5 424
524296192 DATAFILE
VETORH_DATA.425.834754501 5 425
4194312192 DATAFILE
VETORH_DATA.426.834754503 5 426
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_DADOS.427.834754717 5 427
3145736192 DATAFILE
CONCARCRED.428.834754719 5 428
704913408 DATAFILE
VETORH_DATA.429.834754883 5 429
2515542016 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_DATA.430.834754885 5 430
706748416 DATAFILE
SYSAUX.431.834755029 5 431
2221940736 DATAFILE
USERS.432.834755031 5 432
760225792 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS47_DADOS.433.834755145 5 433
2147491840 DATAFILE
VETORH_INDEX.434.834755145 5 434
806363136 DATAFILE
VETORH_DATA.435.834755231 5 435
2147491840 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_INDEX.436.834755231 5 436
786440192 DATAFILE
CONCARCRED.437.834755305 5 437
2147491840 DATAFILE
CONCARCRED.438.834755307 5 438
763371520 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
UNDOTBS02.439.834755381 5 439
1185947648 DATAFILE
WIS47_DADOS.440.834755381 5 440
1048584192 DATAFILE
SYSTEM.441.834755487 5 441
1073750016 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS47_DADOS.442.834755487 5 442
1048584192 DATAFILE
WIS47_DADOS.443.834913463 5 443
8589942784 DATAFILE
PDV_INDICES.444.834913465 5 444
5251072 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_DATA.445.834913797 5 445
8387829760 DATAFILE
PDV_INDICES.446.834913799 5 446
8396800 DATAFILE
WIS47_DADOS.447.834914191 5 447
7712219136 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_INDICES.448.834914193 5 448
9445376 DATAFILE
VETORH_INDEX.449.834914487 5 449
7340040192 DATAFILE
PDV_INDICES.450.834914489 5 450
10493952 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_INDEX.451.834914791 5 451
7340040192 DATAFILE
PDV_INDICES.452.834914793 5 452
10493952 DATAFILE
UNDOTBS02.453.834915001 5 453
1185947648 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS47_DADOS.454.834914993 5 454
1048584192 DATAFILE
WIS47_DADOS.455.835873813 5 455
8589942784 DATAFILE
PDV_INDICES.456.835873813 5 456
5251072 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_DATA.457.835874133 5 457
8387829760 DATAFILE
PDV_INDICES.458.835874135 5 458
8396800 DATAFILE
WIS47_DADOS.459.835874529 5 459
7712219136 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_INDICES.460.835874531 5 460
9445376 DATAFILE
VETORH_INDEX.461.835874805 5 461
7340040192 DATAFILE
PDV_INDICES.462.835874807 5 462
10493952 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_INDEX.463.835875101 5 463
7340040192 DATAFILE
PDV_INDICES.464.835875101 5 464
10493952 DATAFILE
PDV_DADOS.465.835875235 5 465
6291464192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
SYSTEM.466.835875237 5 466
524296192 DATAFILE
PDV_DADOS.467.835875601 5 467
6289367040 DATAFILE
CONCARCRED.468.835875603 5 468
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_DADOS.469.835875937 5 469
6291464192 DATAFILE
SENIORH.470.835875937 5 470
104865792 DATAFILE
PDV_DADOS.471.835876263 5 471
6291464192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS_INDEXES.472.835876263 5 472
104865792 DATAFILE
PDV_DADOS.473.835876587 5 473
6291464192 DATAFILE
WIS_INDEXES.474.835876589 5 474
32514048 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_DADOS.475.835876921 5 475
6291464192 DATAFILE
WIS_INDEXES.476.835876923 5 476
19931136 DATAFILE
UNDOTBS01.477.835877147 5 477
6291464192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
PDV_INDICES.478.835877149 5 478
15736832 DATAFILE
WIS47_DADOS.479.835877493 5 479
4504690688 DATAFILE
CONCARCRED.480.835877495 5 480
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_INDEX.481.835877709 5 481
4294975488 DATAFILE
VETORH_DATA.482.835877709 5 482
524296192 DATAFILE
SYSTEM.483.835877903 5 483
4194312192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
WIS47_DADOS.484.835877905 5 484
524296192 DATAFILE
VETORH_DATA.485.835878089 5 485
4194312192 DATAFILE
VETORH_DATA.486.835878089 5 486
524296192 DATAFILE
NAME GROUP_NUMBER FILE_NUMBER
------------------------------------------------ ------------ -----------
BYTES TYPE
---------- ----------------------------------------------------------------
VETORH_DATA.487.835878295 5 487
2515542016 DATAFILE
VETORH_DATA.488.835878297 5 488
706748416 DATAFILE
407 rows selected.
[EDITED by LF: applied [spoiler] tags]
[Updated on: Fri, 07 February 2014 00:17] by Moderator Report message to a moderator
|
|
|
|
|
Re: RMAN Duplicate Issue [message #607388 is a reply to message #607387] |
Wed, 05 February 2014 07:01 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
If you interrupted a DUPLICATE, you will probably have datafiles that you can remove.
You have some archive logfiles that you can backup and delete.
You have several multi-gigabyte tempfiles that you may be able replace with much smaller ones.
That is about it for releasing space, as far as I can see.
And a couple of other hints: you could make this a lot more readable if you converted bytes to gigabtyes; use ORDER BY; perhaps one or queries with GROUP BY; add a join to v$asm_diskgroup; query vasm_diskgroup to show space used, free, required mirror free, and the redundancy type. Generally, get the environment documented.
|
|
|
|
Re: RMAN Duplicate Issue [message #607433 is a reply to message #607392] |
Thu, 06 February 2014 07:39 |
|
aislanluiz
Messages: 8 Registered: February 2014
|
Junior Member |
|
|
Thanks for all replies, I could detect a directory with the entire database inside on the diskgroup full, so I tried to drop using alter diskgroup but it didn't work, so i used the asmcmd tool and it worked.
|
|
|