Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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):

Image Added

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;