Home » RDBMS Server » Backup & Recovery » Rman Cloning - what am i doing wrong? (Oracle 11g)
Rman Cloning - what am i doing wrong? [message #484551] Wed, 01 December 2010 09:42 Go to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
Hi all,
I'm attempting to teach myself RMAN with the hopes that we can eventually use it to clone our production DB to a production support DB and a QA DB.

We don't use RMAN for our backups, we have our on process for that, so I've attempted to use the 'duplicate ... from active database' command so that the backups aren't needed (if that's a problem, feel free to say so).

So i wrote my cloning script and was able to connect to both the target and the auxiliary db's (i'm running the RMAN session from the auxiliary db).

Here's some info:

10:30:45 >select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Solaris: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

(both target and aux db's are the exact same installation)

rman script:
run
{
set newname for datafile 1 to '/data2/oracle/QAdms/systemQAdms.dbf';
set newname for datafile 2 to '/data3/oracle/QAdms/sysauxQAdms.dbf';
set newname for datafile 3 to '/data3/oracle/QAdms/tsundoQAdms.dbf';
set newname for datafile 4 to '/data1/oracle/QAdms/ts1QAdms.dbf';
set newname for datafile 5 to '/data2/oracle/QAdms/ts2QAdms.dbf';
set newname for datafile 6 to '/data3/oracle/QAdms/ts3QAdms.dbf';
set newname for datafile 7 to '/data3/oracle/QAdms/ts4QAdms.dbf';
set newname for datafile 8 to '/data3/oracle/QAdms/ts5QAdms.dbf';
set newname for datafile 9 to '/data1/oracle/QAdms/tsarchQAdms.dbf';
set newname for datafile 10 to '/data1/oracle/QAdms/tsarchinxQAdms.dbf';
set newname for datafile 11 to '/data2/oracle/QAdms/tsidhQAdms.dbf';
set newname for datafile 12 to '/backup/oracle/QAdms/tsimagesQAdms.dbf';
set newname for tempfile 1 to '/data1/oracle/QAdms/tstempQAdms.dbf';
duplicate target database to QAdms from active database
pfile = /oracle/oracle11g_db/11.2.0/dbs/initQAdms.ora
LOGFILE
        '/oracle/oracle11g_db/11.2.0/dbs/log1QAdms.dbf' size 100M,
        '/oracle/oracle11g_db/11.2.0/dbs/log2QAdms.dbf' size 100M;
}



Auxiliary tnsnames.ora:
QA11.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = qazone.world)
          (PROTOCOL = TCP)
          (Host = qazone)
          (Port = 1521)
        )
    )
    (CONNECT_DATA =
       (SID = QAdms)
       (GLOBAL_NAME = QA11.world)
    )
  )
PRODdb =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = LHTECH11.world)
          (PROTOCOL = TCP)
          (Host = lancelot)
          (Port = 1521)
        )
    )
    (CONNECT_DATA =
       (SID = Lhtech2)
       (GLOBAL_NAME = PRODdb)
    )
  )
qazone_tcp_QAdms=
        (DESCRIPTION=
                (ADDRESS=
                        (PROTOCOL=TCP)
                        (HOST=qazone)
                        (PORT=1521))
                (CONNECT_DATA=(SID=QAdms))



Target tnsnames.ora: (irrelevant entries removed)
QA11.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = qazone.world)
          (PROTOCOL = TCP)
          (Host = qazone)
          (Port = 1521)
        )
    )
    (CONNECT_DATA =
       (SERVICE_NAME = QAdms.lhtech.com)
    )
  )





so i created a password file on the auxiliary db. Started the db in nomount mode.

Then executed my RMAN script. Here is the output.

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Dec 1 10:22:41 2010

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

connected to target database: LHTECH2 (DBID=1305885601)
connected to auxiliary database: QADMS (not mounted)

RMAN> 
RMAN> run
2> {
3> set newname for datafile 1 to '/data2/oracle/QAdms/systemQAdms.dbf';
4> set newname for datafile 2 to '/data3/oracle/QAdms/sysauxQAdms.dbf';
5> set newname for datafile 3 to '/data3/oracle/QAdms/tsundoQAdms.dbf';
6> set newname for datafile 4 to '/data1/oracle/QAdms/ts1QAdms.dbf';
7> set newname for datafile 5 to '/data2/oracle/QAdms/ts2QAdms.dbf';
8> set newname for datafile 6 to '/data3/oracle/QAdms/ts3QAdms.dbf';
9> set newname for datafile 7 to '/data3/oracle/QAdms/ts4QAdms.dbf';
10> set newname for datafile 8 to '/data3/oracle/QAdms/ts5QAdms.dbf';
11> set newname for datafile 9 to '/data1/oracle/QAdms/tsarchQAdms.dbf';
12> set newname for datafile 10 to '/data1/oracle/QAdms/tsarchinxQAdms.dbf';
13> set newname for datafile 11 to '/data2/oracle/QAdms/tsidhQAdms.dbf';
14> set newname for datafile 12 to '/backup/oracle/QAdms/tsimagesQAdms.dbf';
15> set newname for tempfile 1 to '/data1/oracle/QAdms/tstempQAdms.dbf';
16> duplicate target database to QAdms from active database
17> pfile = /oracle/oracle11g_db/11.2.0/dbs/initQAdms.ora
18> LOGFILE
19> 	'/oracle/oracle11g_db/11.2.0/dbs/log1QAdms.dbf' size 100M,
20> 	'/oracle/oracle11g_db/11.2.0/dbs/log2QAdms.dbf' size 100M;
21> }
executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting Duplicate Db at 01-DEC-10
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK

contents of Memory Script:
{
   sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    8554127360 bytes

Fixed Size                     2165208 bytes
Variable Size               4378859048 bytes
Database Buffers            4160749568 bytes
Redo Buffers                  12353536 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''LHTECH2'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name = 
 ''QADMS'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   backup as copy current controlfile auxiliary format  '/oracle/oracle11g_db/11.2.0/dbs/cntrlQAdms.dbf';
   restore clone controlfile to  '/oracle/oracle11g_db/11.2.0/dbs/QAdms/cntrl2QAdms.dbf' from 
 '/oracle/oracle11g_db/11.2.0/dbs/cntrlQAdms.dbf';
   restore clone controlfile to  '/data3/oracle/QAdms/cntrl3QAdms.dbf' from 
 '/oracle/oracle11g_db/11.2.0/dbs/cntrlQAdms.dbf';
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''LHTECH2'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''QADMS'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area    8554127360 bytes

Fixed Size                     2165208 bytes
Variable Size               4378859048 bytes
Database Buffers            4160749568 bytes
Redo Buffers                  12353536 bytes

Starting backup at 01-DEC-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=13 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/01/2010 10:23:29
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/01/2010 10:23:29
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server

RMAN> **end-of-file**

RMAN> 
RMAN> 

Recovery Manager complete.



I can't seem to find anywhere what is causing this error. The passwords used to connect to the target and auxiliary DB's ARE correct. I'm also not sure WHICH database server this is referring to.

Any idea?

Thanks!
Re: Rman Cloning - what am i doing wrong? [message #484553 is a reply to message #484551] Wed, 01 December 2010 09:57 Go to previous messageGo to next message
BlackSwan
Messages: 21949
Registered: January 2009
Senior Member
With V11 by default passwords are NOW case sensitive.
Just asking. Might this be your problem?
Re: Rman Cloning - what am i doing wrong? [message #484555 is a reply to message #484553] Wed, 01 December 2010 10:03 Go to previous messageGo to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
BlackSwan wrote on Wed, 01 December 2010 10:57
With V11 by default passwords are NOW case sensitive.
Just asking. Might this be your problem?


Thanks for the reply. I actually thought about that, so i made sure that the passwords were all lowercase to remove any variables.

So no, i don't think that's it.
Re: Rman Cloning - what am i doing wrong? [message #484561 is a reply to message #484555] Wed, 01 December 2010 10:35 Go to previous messageGo to next message
BlackSwan
Messages: 21949
Registered: January 2009
Senior Member
realize that for remote/SQL*Net access the password that is used resides in external password file & NOT inside the DB.
Re: Rman Cloning - what am i doing wrong? [message #484562 is a reply to message #484561] Wed, 01 December 2010 10:50 Go to previous messageGo to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
hmm..
Well i've created a password file on both servers (one for the target and one for the aux).

I made sure to be consistent with case.

and the "cannot connect to the remote database server" error is still happening.

Any idea which server it's talking about? I would assume that since i'm running RMAN from the aux server, that it's referring to the target server...but i could be wrong i guess.

Thanks

Re: Rman Cloning - what am i doing wrong? [message #484565 is a reply to message #484562] Wed, 01 December 2010 11:00 Go to previous messageGo to next message
BlackSwan
Messages: 21949
Registered: January 2009
Senior Member
the listener log file records every connection request; regardless of success or failure.
You should be able to discern which instance got the connection request.
From the listener's standpoint the connection request was a success & properly handed off to the DB.
On other words the listener log file won't show the ORA-01017 failure; because that was between client & DB only.
Re: Rman Cloning - what am i doing wrong? [message #484569 is a reply to message #484565] Wed, 01 December 2010 11:24 Go to previous messageGo to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
I looked at the listener logs...and wasn't able to see any problems in there (like you said).

I can attach them if seeing them would help. But there was not errors or refused connections or anything.

Re: Rman Cloning - what am i doing wrong? [message #484577 is a reply to message #484569] Wed, 01 December 2010 12:28 Go to previous messageGo to next message
John Watson
Messages: 4086
Registered: January 2010
Location: Global Village
Senior Member
I think you've hit two problems. First you must connect to the target locally, and to the auxilliary through SQL*Net. This is documented,
http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmdupdb.htm#CHDCAIAB
and last time I tested it didn't work the other way round (as you are doing). Secondly, there are known bugs with the 11g password file, you must create it with ignorecase and it is not enough to have the smae password both sides: you must copy and rename it.
Hope this helps.
John.
Re: Rman Cloning - what am i doing wrong? [message #484579 is a reply to message #484577] Wed, 01 December 2010 12:45 Go to previous messageGo to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
John Watson wrote on Wed, 01 December 2010 13:28
I think you've hit two problems. First you must connect to the target locally, and to the auxilliary through SQL*Net. This is documented,
http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmdupdb.htm#CHDCAIAB
and last time I tested it didn't work the other way round (as you are doing). Secondly, there are known bugs with the 11g password file, you must create it with ignorecase and it is not enough to have the smae password both sides: you must copy and rename it.
Hope this helps.
John.


John, i think you got it. For some reason i was under the impression that i had to initiate this from the auxiliary server. I read it somewhere...but that's not an issue i suppose. The processess appears to be moving along now.

EDIT. oh...and thanks a TON!

[Updated on: Wed, 01 December 2010 13:21]

Report message to a moderator

Re: Rman Cloning - what am i doing wrong? [message #499262 is a reply to message #484579] Mon, 14 March 2011 05:38 Go to previous messageGo to next message
venkatgargeyagmailcom
Messages: 20
Registered: October 2010
Location: hyderabad
Junior Member

Hi please help me.i am working on rman cloning

after issuing the fowwing command

duplicate target database to '<db-name>' nofilenamecheck;

After successful restoration and recovery I am getting as below

Contents of memory scripts:
{
Shutdown clone;
Startup clone nomount;
}
Executing memory script

now it is taking too much time

Do u have any idea about it?how much time it will take?

Re: Rman Cloning - what am i doing wrong? [message #499652 is a reply to message #499262] Tue, 15 March 2011 11:40 Go to previous message
gazzag
Messages: 267
Registered: November 2010
Location: Bristol, UK
Senior Member
Quote:
Contents of memory scripts:
{
Shutdown clone;
Startup clone nomount;
}
Executing memory script

now it is taking too much time

Do u have any idea about it?how much time it will take?



Ensure that there are no other sessions logged into the database. "SHUTDOWN CLONE" is the same as a normal "SHUTDOWN" so will wait on any logged in sessions before closing the database.

HTH

-g
Previous Topic: need help with archivelogs
Next Topic: Getting error ORA-19870: error reading backup piece during database cloning
Goto Forum:
  


Current Time: Sun Apr 20 05:20:04 CDT 2014

Total time taken to generate the page: 0.11239 seconds