I want to restore database to point in time in the past.
I see in comm console there are available old backups. I am giving the following command and it errors. There is a weekly full backup and daily incremental backups and archivelog backups.
There is full successful backup on 08-23-2025. I am issuing the following command.
run {
allocate channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so,BLKSIZE=262144,ENV=(CvOraSbtParams=/home/oracle/restore.txt)";
SET UNTIL TIME "to_date('2025-08-28:01:00:00','YYYY-MM-DD:hh24:mi:ss')";
restore controlfile from autobackup;
}
arting restore at 18-SEP-25
channel ch1: looking for AUTOBACKUP on day: 20250828
channel ch1: looking for AUTOBACKUP on day: 20250827
channel ch1: looking for AUTOBACKUP on day: 20250826
channel ch1: looking for AUTOBACKUP on day: 20250825
channel ch1: looking for AUTOBACKUP on day: 20250824
channel ch1: looking for AUTOBACKUP on day: 20250823
channel ch1: looking for AUTOBACKUP on day: 20250822
channel ch1: no AUTOBACKUP in 7 days found
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/18/2025 15:34:20
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
