Home » RDBMS Server » Backup & Recovery » RMAN Duplicate Issue
RMAN Duplicate Issue [message #607380] Wed, 05 February 2014 06:02 Go to next message
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 #607381 is a reply to message #607380] Wed, 05 February 2014 06:11 Go to previous messageGo to next message
Michel Cadot
Messages: 58929
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Do you use FRA (Flash Recovery Area)?
You'd be able to remove the file using asmcmd "rm" command.
What is your OS?

[Updated on: Wed, 05 February 2014 06:12]

Report message to a moderator

Re: RMAN Duplicate Issue [message #607382 is a reply to message #607380] Wed, 05 February 2014 06:25 Go to previous messageGo to next message
John Watson
Messages: 4511
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 #607383 is a reply to message #607381] Wed, 05 February 2014 06:26 Go to previous messageGo to next message
aislanluiz
Messages: 8
Registered: February 2014
Junior Member
I'm using Red hat 2.6.9-55.ELsmp #1 SMP Fri Apr 20 16:36:54 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux

About the FRA, i don't know if I'm using in all old instances/databases/schemmas/services???? I know about some databases I created using dbca where I checked that option.

I tried asmcmd tool but I couldn't put it to work (share realm/oracle home/password issues), I was affraid to use it because the lack of knowing wich file to delete. I stoped to try when some people started to say that asmcmd not work in 10g.

Re: RMAN Duplicate Issue [message #607384 is a reply to message #607382] Wed, 05 February 2014 06:30 Go to previous messageGo to next message
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


[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 #607385 is a reply to message #607384] Wed, 05 February 2014 06:40 Go to previous messageGo to next message
John Watson
Messages: 4511
Registered: January 2010
Location: Global Village
Senior Member
Come on, man! Do you expect me to look through 400 files and try to identify which ones can be deleted? That is your job. Furthermore, you MUST enclose your copy/pastes using [code] tags, or no-one can read them:
please read How to use [code] tags and make your code easier to read
Lastly, you need to learn how to use SQL*Plus commands to format your output. For example,
set linesize 120
set pagesize 1000

Re: RMAN Duplicate Issue [message #607387 is a reply to message #607385] Wed, 05 February 2014 06:50 Go to previous messageGo to next message
aislanluiz
Messages: 8
Registered: February 2014
Junior Member
Sorry about that, after look batter your query, I modify it to not show datafiles. As I teel you, I'm new on it and I don't know with sure what to search (TEMPFILE?) and what to do with it after. I will edit the reply to not flood the topic.


NAME                                             GROUP_NUMBER FILE_NUMBER      BYTES TYPE
------------------------------------------------ ------------ ----------- ---------- ----------------------------------------------------------------
Current.256.669923213                                       1         256   24723456 CONTROLFILE
Current.257.669923213                                       1         257   24723456 CONTROLFILE
control01.ctl                                               3         260   17088512 CONTROLFILE
Current.260.783472037                                       3         260   17088512 CONTROLFILE
group_3.261.739709187                                       1         261  209715712 ONLINELOG
Current.261.783472037                                       3         261   17088512 CONTROLFILE
control02.ctl                                               3         261   17088512 CONTROLFILE
control03.ctl                                               3         262   17088512 CONTROLFILE
Current.262.783472037                                       3         262   17088512 CONTROLFILE
group_1.263.783472061                                       3         263   52429312 ONLINELOG
redo01.log                                                  3         263   52429312 ONLINELOG
group_2.264.783472061                                       3         264   52429312 ONLINELOG
redo02.log                                                  3         264   52429312 ONLINELOG
group_5.265.739707763                                       1         265  209715712 ONLINELOG
TEMP.265.783472067                                          3         265 1.1288E+10 TEMPFILE
temp01.dbf                                                  3         265 1.1288E+10 TEMPFILE
group_3.267.783472281                                       3         267   52429312 ONLINELOG
redo03.log                                                  3         267   52429312 ONLINELOG
group_1.268.834585655                                       1         268   52429312 ONLINELOG
group_4.268.783472281                                       3         268   52429312 ONLINELOG
redo04.log                                                  3         268   52429312 ONLINELOG
spfile.269.783472281                                        3         269       3584 PARAMETERFILE
spfiledbmm.ora                                              3         269       3584 PARAMETERFILE
group_2.270.739709163                                       1         270  209715712 ONLINELOG
group_1.271.739709143                                       1         271  209715712 ONLINELOG
group_4.273.739707865                                       1         273  209715712 ONLINELOG
spfiledbrac.ora                                             1         274       5632 PARAMETERFILE
spfile.274.669978541                                        1         274       5632 PARAMETERFILE
TEMP.280.690052415                                          1         280 5242888192 TEMPFILE
Current.280.832611385                                       5         280   15286272 CONTROLFILE
group_6.281.739707777                                       1         281  209715712 ONLINELOG
Current.281.832611385                                       5         281   15286272 CONTROLFILE
group_7.282.739707795                                       1         282  209715712 ONLINELOG
group_1.282.832611389                                       5         282   52429312 ONLINELOG
group_8.283.739707811                                       1         283  209715712 ONLINELOG
group_1.283.832611389                                       5         283   52429312 ONLINELOG
group_2.284.832611391                                       5         284   52429312 ONLINELOG
group_1.285.834585655                                       1         285   52429312 ONLINELOG
group_2.285.832611391                                       5         285   52429312 ONLINELOG
group_3.286.832611393                                       5         286   52429312 ONLINELOG
group_3.287.832611393                                       5         287   52429312 ONLINELOG
TEMP.288.832611399                                          5         288   20979712 TEMPFILE
group_4.289.834585659                                       1         289   52429312 ONLINELOG
spfile.289.832611425                                        5         289       3584 PARAMETERFILE
spfileproth.ora                                             5         289       3584 PARAMETERFILE
group_4.290.834585659                                       1         290   52429312 ONLINELOG
group_3.291.834585657                                       1         291   52429312 ONLINELOG
group_3.292.834585657                                       1         292   52429312 ONLINELOG
group_2.293.834585657                                       1         293   52429312 ONLINELOG
group_2.294.834585655                                       1         294   52429312 ONLINELOG
Current.294.832613077                                       5         294   15286272 CONTROLFILE
Current.295.832613077                                       5         295   15286272 CONTROLFILE
group_1.296.832613079                                       5         296   52429312 ONLINELOG
group_1.297.832613079                                       5         297   52429312 ONLINELOG
group_2.298.832613081                                       5         298   52429312 ONLINELOG
group_2.299.832613081                                       5         299   52429312 ONLINELOG
group_3.300.832613083                                       5         300   52429312 ONLINELOG
group_3.301.832613083                                       5         301   52429312 ONLINELOG
TEMP.302.832613089                                          5         302   20979712 TEMPFILE
spfile.303.832613117                                        5         303       3584 PARAMETERFILE
spfileprotp.ora                                             5         303       3584 PARAMETERFILE
Current.308.832614037                                       5         308   15286272 CONTROLFILE
Current.309.832614037                                       5         309   15286272 CONTROLFILE
group_1.310.832614039                                       5         310   52429312 ONLINELOG
group_1.311.832614039                                       5         311   52429312 ONLINELOG
group_2.312.832614041                                       5         312   52429312 ONLINELOG
group_2.313.832614041                                       5         313   52429312 ONLINELOG
group_3.314.832614043                                       5         314   52429312 ONLINELOG
group_3.315.832614043                                       5         315   52429312 ONLINELOG
TEMP.316.832614049                                          5         316   20979712 TEMPFILE
spfile.317.832614073                                        5         317       3584 PARAMETERFILE
spfileprott.ora                                             5         317       3584 PARAMETERFILE
Current.322.832614897                                       5         322   15286272 CONTROLFILE
Current.323.832614897                                       5         323   15286272 CONTROLFILE
group_1.324.832614901                                       5         324   52429312 ONLINELOG
group_1.325.832614901                                       5         325   52429312 ONLINELOG
group_2.326.832614901                                       5         326   52429312 ONLINELOG
group_2.327.832614903                                       5         327   52429312 ONLINELOG
group_3.328.832614903                                       5         328   52429312 ONLINELOG
group_3.329.832614903                                       5         329   52429312 ONLINELOG
TEMP.330.832614909                                          5         330   20979712 TEMPFILE
spfile.331.832614933                                        5         331       3584 PARAMETERFILE
spfileprotth.ora                                            5         331       3584 PARAMETERFILE
Current.336.832615603                                       5         336   15286272 CONTROLFILE
Current.337.832615603                                       5         337   15286272 CONTROLFILE
group_1.338.832615605                                       5         338   52429312 ONLINELOG
group_1.339.832615607                                       5         339   52429312 ONLINELOG
group_2.340.832615607                                       5         340   52429312 ONLINELOG
group_2.341.832615607                                       5         341   52429312 ONLINELOG
group_3.342.832615609                                       5         342   52429312 ONLINELOG
group_3.343.832615609                                       5         343   52429312 ONLINELOG
TEMP.344.832615617                                          5         344   20979712 TEMPFILE
spfile.345.832615643                                        5         345       3584 PARAMETERFILE
spfileprottp.ora                                            5         345       3584 PARAMETERFILE
Current.356.833815509                                       5         356   15286272 CONTROLFILE
TEMP.359.834586231                                          5         359   20979712 TEMPFILE
group_3.360.834586223                                       5         360   52429312 ONLINELOG
group_2.361.834586223                                       5         361   52429312 ONLINELOG
Current.362.834585653                                       5         362   15286272 CONTROLFILE
control02.ctl                                               5         362   15286272 CONTROLFILE
group_1.363.834586223                                       5         363   52429312 ONLINELOG
Current.364.834586219                                       5         364   15286272 CONTROLFILE
Current.367.834585653                                       5         367   15286272 CONTROLFILE
control03.ctl                                               5         367   15286272 CONTROLFILE
control01.ctl                                               5         368   15286272 CONTROLFILE
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
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
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
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
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
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
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
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
spfile.392.834586267                                        5         392       3584 PARAMETERFILE
spfileseniorh.ora                                           5         392       3584 PARAMETERFILE

131 rows selected.
Re: RMAN Duplicate Issue [message #607388 is a reply to message #607387] Wed, 05 February 2014 07:01 Go to previous messageGo to next message
John Watson
Messages: 4511
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 #607392 is a reply to message #607388] Wed, 05 February 2014 07:59 Go to previous messageGo to next message
aislanluiz
Messages: 8
Registered: February 2014
Junior Member
Yeah, I'm working on it, I ordered and got the size on GB but in the DATAFILE type I can't identify wich file to delete because the duplicate file, I think, have the same name as the origin... I'm trying to analise and I will continue to verify the forum meanwhile
Re: RMAN Duplicate Issue [message #607433 is a reply to message #607392] Thu, 06 February 2014 07:39 Go to previous message
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.
Previous Topic: Incremental Vs Ar chive log backups
Next Topic: expdp impdp vs RMAN backup restore
Goto Forum:
  


Current Time: Thu Aug 28 10:32:33 CDT 2014

Total time taken to generate the page: 0.10229 seconds