This content has been marked as final. Show 2 replies
You can find some of those information in the name of the files. Most of the time, there is the SID of the database, or the timestamp of the backup. If you have the autobackup of the controlfile, you will have the DBID which will be useful to restore.
You can also try the CATALOG command in RMAN (10g and above) to find the DBID and SID of the database that created the file. The CATALOG command itself will fail if you are not connected to the database that created the backup, but it will return you those information.
Regarding the version, it is hard to tell.
If you have an autobackup of the controlfile (filename begins with CF), then it is 9i or above.
If you have OMF files (Oracle Managed Files) , then it is 10g or above.
Hope this will help.
If its in a catalog you can use the view RC_BACKUP_PIECE_DETAILS and the HANDLE column to tie it back to a DB_ID.
If it's not in a catalog you can use the view V$BACKUP_PIECE_DETAILS database by database to do the same thing.