RE: RMAN in RAC

That’s actually not the case.

We have RAC instances where we split RMAN jobs up between the nodes, and after checking a few examples here, I can see that the INST_ID column in GV$RMAN_OUTPUT does reflect where those operations ran.

Not only that, but it’s always been my experience that the INST_ID, INSTANCE_ID, INSTANCE_NUMBER or INSTANCE# column (whichever Oracle decided to use that day) reflects where the operation being recorded occurred, not the node where you are running your query (although there may be exceptions I’m not aware of).

Thanks,
Scott

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Monday, August 22, 2016 12:43 PM
To: oracle-l_at_freelists.org
Subject: Re: RMAN in RAC

Hi Fernando,
I don't think this is correct. INST_ID in any GV$ simply makes note of the instance from which the query was executed, not the instance on which the operation was run. Control file, which contains backups, is shared among instances, which means that there is no way to tell. Also, there is no point in making such distinction, since it is the same database that is being backed up, regardless of the instance on which the backup was run. Regards

On 08/22/2016 08:25 AM, Fernando N. de Souza wrote: You can use INST_ID column from GV$RMAN_OUTPUT

desc GV$RMAN_OUTPUT

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 INST_ID                                            NUMBER
 SID                                                NUMBER
 RECID                                              NUMBER
 STAMP                                              NUMBER
 SESSION_RECID                                      NUMBER
 SESSION_STAMP                                      NUMBER
 OUTPUT                                             VARCHAR2(130)
 RMAN_STATUS_RECID                                  NUMBER
 RMAN_STATUS_STAMP                                  NUMBER
 SESSION_KEY                                        NUMBER

--

Fernando.

To educate a man in mind and not in morals is to educate a menace to society. Theodore Roosevelt

On Mon, Aug 22, 2016 at 2:44 AM, Sumit Kumar T <dba.tyagisumit_at_gmail.com<mailto:dba.tyagisumit_at_gmail.com>> wrote: In N node RAC env How to find out from which node any particular RMAN backup was executed ?

--

--

BR
Sumit Tyagi
+91-7829543355<tel:%2B91-7829543355>

--

Mladen Gogala

Oracle DBA

Tel: (347) 321-1217
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 22 2016 - 18:52:15 CEST