Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DUPLICATE DATABASE IN ANOTHER HOST WITH THE SAME DATABASE NAME

Wander(Brazil)Jun 13 2008 — edited Jun 14 2008
Hi all.

I want duplicate a database(dbteste1 host:wander) to another host(magda) with the same database name.

My tnsnames in host wander is this:

DBTESTE1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wander)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbteste1)
)
)

DBTEST1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = magda)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbteste1)
)
)

Tnsping is ok !!!

Follow the rman command;

RMAN> run
{
duplicate target database to dbtest1 nofilenamecheck;
}

and i get the following message:

RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE falhou
ORA-01504: o nome 'dbtest1' do banco de dados nÒo corresponde ao parÔmetro db_name 'dbteste1'

If i run this command:

RMAN> run
{
duplicate target database to dbteste1 nofilenamecheck;
}

and i get the following message:

RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: RMAN-20021: database not set
RMAN-06031: could not translate database keyword


I´m using oracle 9.2.0.7 on Windows
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2008
Added on Jun 13 2008
2 comments
1,466 views