Database Administration (MOSC)

MOSC Banner

Wrong connected auxiliary database

edited Dec 21, 2011 12:26AM in Database Administration (MOSC) 2 commentsAnswered
Hi,
I want to cloning prod database (PROD) to uat database (UAT). I have add UAT description in prod tnsnames.ora . Running RMAN from PROD, it is connected to wrong auxiliary database :

rman target / auxiliary sys/sysuat@UAT

Recovery Manager: Release 11.2.0.2.0 - Production on Wed Dec 21 17:00:33 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD (DBID=167798720)
connected to auxiliary database: PROD (not mounted)

RMAN connected to wrong auxiliary database.

Testing tnsping from prod, it is correctly ping to UAT database :

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=oradb.agel.co.id)(PORT=1526)) (CONNECT_DATA= (SERVICE_NAME=UAT) (INSTANCE_NAME=UAT)))

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