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@xxxxxxxxx <mailto:dba.tyagisumit@xxxxxxxxx>> 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>/