| RMAN error ORA-01405 on duplicate database [message #72356] |
Tue, 27 May 2003 12:06  |
Rob
Messages: 70
Registered: January 2000
|
Member |
|
|
Hi,
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
s NULL
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
d#)
RMAN-06099: error occurred in source file: krmk.pc, line: 6324
Why is this occurring and how do I get a duplicate effectively?
Thanks,
Rob
|
|
|
|
| Re: RMAN error ORA-01405 on duplicate database [message #72434 is a reply to message #72356] |
Fri, 13 June 2003 17:27  |
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
Db_name
Instance_name
Control_files
Background_dump_dest
Core_dump_dest
User_dump_dest
Log_archive_dest_1
Db_file_name_convert
Log_file_name_convert
remote_login_passwordfile = exclusive
3) Set the Environment variables.
Set ORACLE_HOME=/oracle/product/8.1.7
Set ORACLE_SID=DUPLICATEDB.
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
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = TEAMDUP)
(ORACLE_HOME = /oracle/product/8.1.7)
(SID_NAME = TEAMDUP)
)
)
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
