Database Administration (MOSC)

MOSC Banner

RMAN-06189: after recovering controlfiles

edited Nov 7, 2017 1:23AM in Database Administration (MOSC) 15 commentsAnswered

Hello.

I have the following scenario:

I have databases A and B.

I want to restore A on B.

When trying to restore controlfile and startup mount I get RMAN-06189. What I'm I doing wrong? I kept the original spfile on B.

RMAN> shutdown immediate;

database dismounted
Oracle instance shut down

RMAN> startup nomount;

connected to target database (not started)
Oracle instance started

Total System Global Area   12884901888 bytes

Fixed Size                     4511656 bytes
Variable Size               2368018520 bytes
Database Buffers           10502537216 bytes
Redo Buffers                   9834496 bytes

RMAN> set dbid 4213739951;

executing command: SET DBID

RMAN> restore controlfile from '/backup1/2017_10_26/o1_mf_ncsnf_TAG20171026T020044_dz27l3w1_.bkp';

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