RMAN Duplicate failure - looking in v$archived_log
- From: "BD" <bobby_dread@xxxxxxxxxxx>
- Date: 29 Sep 2005 09:51:50 -0700
Hey, all...
I'm working through RMAN database duplication (8i, AIX 5.2). Same
server, different filepaths.
I've got the auxiliary (duplicate) instance up, and have the command
string to reassign the paths for the datafiles constructed correctly
(at least it's being parsed).
RMAN runs the command string, but fails on the actual duplicate
command.
Error is:
"RMAN-06003: ORACLE error from target database: ORA-01405: fetched
column value is NULL
RMAN-06097: text of failing SQL statement: select min(maxnc)
,min(maxnc) into :b1,:b2 from (select max(next_change#) maxnc from v$
archived_log group by thread#)"
I've checked the v$archived_log view, and it's empty. I did do a
recovery recently in another recent RMAN exercise, and ran a RESETLOGS
afterwards.
My guess is that it's not finding any archive logs, and so that portion
of the script cannot be validated and fails
Should I be omitting the 'logfile' portion of the duplication if the
database is in this state (no data changes have occurred since I
RESETLOGS)?
Here's my script:
run {
allocate auxiliary channel dupdb1 type disk;
allocate auxiliary channel dupdb2 type disk;
allocate auxiliary channel dupdb3 type disk;
allocate auxiliary channel dupdb4 type disk;
set newname for datafile 1 TO
'/rs01/oradata/CTD2_DUP/system_CTD2_01.dbf';
..
..
..
set newname for datafile 43 TO
'/rs01/oradata/CTD2_DUP/arch_tbl_CTD2_01.dbf';
duplicate target database to CTD2_DUP logfile
group 1 ('/rs02/oradata/CTD2/redo_log_1a.dbf',
'/rs02/oradata/CTD2/redo_log_1b.dbf') size 200K reuse,
group 2 ('/rs02/oradata/CTD2/redo_log_2a.dbf',
'/rs02/oradata/CTD2/redo_log_2b.dbf') size 200K reuse,
group 3 ('/rs02/oradata/CTD2/redo_log_3a.dbf',
'/rs02/oradata/CTD2/redo_log_3b.dbf') size 200K reuse
nofilenamecheck;
}
Thanks for all insights!
BD
.
- Follow-Ups:
- Prev by Date: Re: Scheduling jobs
- Next by Date: Re: RMAN Duplicate failure - looking in v$archived_log
- Previous by thread: Scheduling jobs
- Next by thread: Re: RMAN Duplicate failure - looking in v$archived_log
- Index(es):
Relevant Pages
|
