Home » RDBMS Server » Backup & Recovery » RMAN error ORA-01405 on duplicate database
RMAN error ORA-01405 on duplicate database [message #72356] Tue, 27 May 2003 12:06 Go to next message
Messages: 70
Registered: January 2000

I'm trying to duplicate a database on the same server. When I run this command:

connect rcvcat rman/{pwd here}@ATSREPOSBAK
connect target internal/{pwd here}@ATSIBAK
connect auxiliary internal/{pwd here}@ATSIDEV
run {
allocate auxiliary channel c1 type disk;
duplicate target database to ATSIDEV nofilenamecheck;

I get this error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-06003: ORACLE error from target database: ORA-01405: fetched column value i
RMAN-06097: text of failing SQL statement: select min(maxnc) ,min(maxnc) into :b
1,:b2 from (select max(next_change#) maxnc from v$archived_log group by threa
RMAN-06099: error occurred in source file: krmk.pc, line: 6324

Why is this occurring and how do I get a duplicate effectively?

Re: RMAN error ORA-01405 on duplicate database [message #72434 is a reply to message #72356] Fri, 13 June 2003 17:27 Go to previous message
Raju Angani
Messages: 5
Registered: June 2003
Junior Member
Hi Rob,

Follow these steps. It should work

RMAN – Creating a Duplicate Database.

1) Copy the target “init.ora” file on to duplicate area.

cp initTARGETDB.ora initDUPLICATEDB.ora

2) Edit the initDUPLICATEDB.ora file.
Change the following parameters
remote_login_passwordfile = exclusive

3) Set the Environment variables.
Set ORACLE_HOME=/oracle/product/8.1.7

4) Create a password file for the DUPLICATE database.
Orpwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=palm22

5) Start the DUPLICATE in nomount state.
Sqlplus> connect internal;
Sqlplus> startup nomount;

6) Configure SQl Net8 on the server machine, go to
i) Listener.ora file located at /oracle/product/8.1.7/network/admin

(ORACLE_HOME = /oracle/product/8.1.7)
ii) On the server machine do the netasst to pull tnsnames configuration.
Add the tns entry to tnsnames.ora file.

7) Go to the RMAN Box(Oradump)and configure tnsnames.ora file to connect to the DUPLICATE DB.
Type at d:Rman

RMAN> connect target sys/password@TARGET;
RMAN> connect catalog rman817/rman@CATALOG;
RMAN> connect auxiliary internal/password@DUPLICATE;

RMAN> list database;
RMAN> List backup of archivelog all;
Choose the log sequence number you want to restore from the output.

RMAN> run {
Set until logseq 2780 thread 1;
allocate auxiliary channel d1 type disk;
allocate auxiliary channel d2 type disk;
set newname for datafile 1 TO '/oradisk/oradata01/TEAMDUP/system01.dbf';
set newname for datafile 2 TO '/oradisk/oradata02/TEAMDUP/rbds01.dbf';
set newname for datafile 3 TO '/oradisk/oradata03/TEAMDUP/users01.dbf';
set newname for datafile 4 TO '/oradisk/oradata01/TEAMDUP/temp01.dbf';
set newname for datafile 5 TO '/oradisk/oradata02/TEAMDUP/tools01.dbf';
set newname for datafile 6 TO '/oradisk/oradata02/TEAMDUP/index01.dbf';
set newname for datafile 7 TO '/oradisk/oradata03/TEAMDUP/team01.dbf';
set newname for datafile 8 TO '/oradisk/oradata03/TEAMDUP/indjim01.dbf';
duplicate target database to TEAMDUP
logfile group 1 ('/oradisk/oralog01/TEAMDUP/redo1a.log', ‘/oradisk/oralog01_mirror/TEAMDUP/redo1b.log') size 3000K, group 2 ‘/oradisk/oralog01/TEAMDUP/redo2a.log', '/oradisk/oralog01_mirror/TEAMDUP/redo2b.log') size 3000K, Group 3 ('/oradisk/oralog01/TEAMDUP/redo3a.log', '/oradisk/oralog01_mirror/TEAMDUP/redo3b.log') size 3000K;

8) SQL> select * from V$database;
9) SQL> shutdown immediate;
10) SQL> startup mount;
11) SQL> alter database noarchivelog;
12) SQL> alter database open;
Previous Topic: fail in backup with RMAN.
Next Topic: Rman
Goto Forum:

Current Time: Fri Jun 02 06:59:25 CDT 2023