How to determine if Oracle instance is a clone or not?

[john2069a]

I'm using SnapManager for Oracle 3.0.3.

What is the best and easiest way to determine if a running Oracle11g instance is a clone or a "real"/non-cloned instance?

thanks

[jakub_wartak]

You could try several things:

1) Easiest would be to verify on your parent DB that has any SMO backups locked by clones (via GUI)

2) If you haven't splitted it, you could try on storage "vol status" (or "snap list") on FlexVols to verify FlexClone status (or "vclone" flags on snapshots)

3) You could verify last Oracle resetlogs time operation , just perform SELECT * FROM v$database_incarnation on the clone. If it is "fresh" then probably it is clone..

4) On your OS you could (e.g. by using "sanlun lun show") verify the storage layout, e.g. if there are FlexVols/LUNs connected with name "SMO" or "SnapManager" then you are using clone.

-Jakub.