Trying to do a DR test . Restoring our production database to a new host. The windows 2012 hosts are set up identically. same OS. same directory structure etc.
I haven't done a restore on another server using rman. We are not using a catalog.
I did the prelim, started no mount with a near empty pfile, restored the control file and spfile from the rman backup.
I copied the files from the network drive to a local drive c:\backup
I want to do a point in time recovery
I perform the following and the result. Anything obvious I am doing wrong?
RMAN> run
2> {
3> allocate channel dev1 device type disk format 'c:\backup\%U';
4> set until time "to_date('2024-11-18:00:00:00', 'YYYY-MM-DD:HH24:MI:SS')";
5> restore database;
6> }
allocated channel: dev1
channel dev1: SID=471 device type=DISK
executing command: SET until clause
Starting restore at 26-NOV-24
released channel: dev1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/26/2024 11:25:32
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 12
RMAN-06100: no channel to restore a backup or copy of datafile 11
RMAN-06100: no channel to restore a backup or copy of datafile 10
RMAN-06100: no channel to restore a backup or copy of datafile 9
RMAN-06100: no channel to restore a backup or copy of datafile 8
RMAN-06100: no channel to restore a backup or copy of datafile 7
RMAN-06100: no channel to restore a backup or copy of datafile 6
RMAN-06100: no channel to restore a backup or copy of datafile 5
RMAN-06100: no channel to restore a backup or copy of datafile 4
RMAN-06100: no channel to restore a backup or copy of datafile 3
RMAN-06100: no channel to restore a backup or copy of datafile 2
RMAN-06100: no channel to restore a backup or copy of datafile 1