Database Backup and Recovery (MOSC)

MOSC Banner

RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of servic

edited Feb 25, 2019 10:14PM in Database Backup and Recovery (MOSC) 3 commentsAnswered

I was running an RMAN duplicate command for a backup-based duplication to the database PROVSTDB. It had just shutdown the server when the error occurred. Here is the specific command:

DUPLICATE DATABASE TO 'Provstdb'

BACKUP LOCATION '\DB_BACKUP'

NOFILENAMECHECK

SPFILE

PARAMETER_VALUE_CONVERT 'G:\oracle\oradata\provstdb\CONTROL01.CTL', 'E:\Oracle\oradata\ProvSTDB\CONTROL01.CTL'

SET DB_CREATE_FILE_DEST 'E:\Oracle\oradata\ProvSTDB\';

Here also is the tnsnames.ora:

GIHUB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = HSCSPROV2T.hscs.virginia.edu)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ProvSTDB.hscs.virginia.edu)
    )
  )


PROVSTDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = HSCSPROV2T.hscs.virginia.edu)(PORT = 1521))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center