Which of the spfile and controlfile to use for restore?
I have run the following script
run {
backup database archivelog all;
backup spfile current controlfile;
}
This produces 5 files:
1 Archivelog backup
2 Full backup included controlfile and spfile
3 Archivelog backup
4 Controlfile backup
5 spfile backup.
Which of the spfile- and controlfile backup should I use for restore?
Restoring to another host.