RMAN Restore Error

From: Scott Canaan <srcdco_at_rit.edu>
Date: Tue, 24 May 2022 18:34:50 +0000
Message-ID: <MWHPR16MB1550A19F2F39ADA754C893CBC5D79_at_MWHPR16MB1550.namprd16.prod.outlook.com>

I am trying to restore a database back to the last cold backup, 8pm last night. We are on Oracle 19.15. Backups are done via CommVault, using RMAN. I've done this many times before, but this time it keeps telling me that there are no data files to restore, even though I can see them in CommVault.

This is what I see:

RMAN> list incarnation of database 'uc4fstge';

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------
153369665 153369680 UC4FSTGE 2860729756       PARENT  1          09-AUG-21
153369665 153369681 UC4FSTGE 2860729756       PARENT  16548284442260 21-MAR-22
153369665 153369666 UC4FSTGE 2860729756       CURRENT 16548284445098 21-MAR-22
153416349 153416378 UC4FSTGE 2860901304       PARENT  14713191960696 11-JAN-21
153416349 153416350 UC4FSTGE 2860901304       CURRENT 16549066483825 23-MAR-22

RMAN> set dbid 2860901304;
reset database to incarnation 153416350; executing command: SET DBID
database name is "UC4FSTGE" and DBID is 2860901304

RMAN> database reset to incarnation 153416350

RMAN> run {

2>  allocate channel notarget1 device type 'sbt_tape' PARMS
3>  'SBT_LIBRARY=/opt/commvault/Base/libobk.so,BLKSIZE=1048576';
4>  restore controlfile  from  'c-2860901304-20220523-00' ;

alter database mount;
restore database until time = "TO_DATE('05/23/2022 20:29:28','MM/DD/YYYY HH24:MI:SS')" ; 5> 6> 7> release channel notarget1;
recover database noredo ;
alter database open resetlogs;
}8> 9> 10>

allocated channel: notarget1
channel notarget1: SID=142 device type=SBT_TAPE
channel notarget1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)

Starting restore at 24-MAY-22

channel notarget1: restoring control file channel notarget1: restore complete, elapsed time: 00:00:15

output file name=/oracle/data/UC4FSTGE/control01.ctl
output file name=/oracle/data/UC4FSTGE/control02.ctl
output file name=/oracle/data/UC4FSTGE/mirror_files/control03.ctl

Finished restore at 24-MAY-22

Statement processed

Starting restore at 24-MAY-22

released channel: notarget1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/24/2022 14:03:58
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore

RMAN-06023: no backup or copy of datafile 2 found to restore RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN> list backup recoverable;

specification does not match any backup in the repository

RMAN> exit

I'm sure I'm missing something simple, but I just can't see it. I hope someone else can see what's wrong.

Thank you,

Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 24 2022 - 20:34:50 CEST