Symptoms
When creating an RMAN restore using the wizard in NMDA 9.x, restoring back to the original database as the backup source could fail with the following error
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 01/13/2017 19:32:34
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Recovery Manager complete.
Cause
This issue could occur when selecting Yes , during the wizard option Do you want the software to shut down the target database and start the database in mount mode before performing the recovery? . If the users selects yes , and you are using Oracle DB Authentication to connect to the target database, the Oracle listener must have a valid entry for the target database registered.
Resolution
Use Oracle netmgr, or netca tool to add a database listening location for the target database. To ensure this is done correctly, you can verify by connecting to the target database using CLI, while the database is down.
i.e.
PS C:\> rman target user/passwd@SID
Recovery Manager: Release 12.1.0.2.0 - Production on Thu Jan 19 16:01:11 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN>
Alternatively you may use OS authentication to connect to the target database (for UNIX or Linux), or choose not to shutdown the target database during the wizard options.