...
A full restore is something to be done ONLY after all other options has have been exhausted, because there will be loss of data.
...
In the directory backup/logs you can find the log from the last backup:
Find DBID of Database
From that logfile, you can find the start of the last backup, where you can find the DBID of the database.
...
On the line below the file name is the SCN (System Change Number). In this example a bit covered but readable as 10825040684713.
Adviced to use the last sequence number instead of SCN as in the image below (last sequence from the last archive log file):
Restore SPFILE from Backup
...
| Code Block |
|---|
RMAN> alter database open resetlog; |
OBS!!!
For restoring on a different server, we must run the following command 3 times BEFORE the backup starts:
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;