Re: Duplicate from active database failing with ORA-19625 , ORA-27037 for archivelogs
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 25 Feb 2019 17:30:36 -0600
Message-Id: <DE1B7B04-B1BA-4375-AC3C-3189D4551DF7_at_gmail.com>
>> On Fri, Feb 1, 2019 at 7:56 AM Sandra Becker <sbecker6925_at_gmail.com> wrote:
>> Oracle 11.2 on RHEL
>>
>> I have been trying to duplicate a production database to a new server to do some baseline testing. This is not a situation where I can do a duplicate for standby and the auxiliary database must have a new name. I'm able to get the datafiles restored without a problem. The duplicate is failing to find/copy all the archivelogs it needs. Sometimes it can't find a log with a sequence between two others it did find. For example, it found 730 and 737, but did not find 731 through 736. All logs still exist on the old server.
>>
>> My duplicate script is pretty simple:
>>
>> connect target
>> connect auxiliary
>> run
>> {
>> allocate channel t1 type disk;
>> allocate channel t2 type disk;
>> allocate channel t3 type disk;
>> allocate channel t4 type disk;
>> allocate auxiliary channel a1 type disk;
>> allocate auxiliary channel a2 type disk;
>> allocate auxiliary channel a3 type disk;
>> duplicate target database to baseline from active database nofilenamecheck;
>> release channel t1;
>> .
>> .
>> .
>> release channel a3;
>> }
>> exit
>>
>> Unfortunately, I cannot post the entries from the log due to security policies, but I'll try for a synopsis.
>> After restoring datafiles (or using previous duplicated file), it does an alter system archive log current and then the set new name commands
>> I see "backup as copy reuse" and then a list or archivlogs with the current primary archive log location then the auxiliary format with that location
>> Next catalog clone datafile copy
>> switch clone datafile to datafilecopy
>> executing memory script
>> Starting backup
>> skipping archived log for logs already copied from previous run, then input archived log
>> finished backup
>> catalog archived log
>> instance started
>> alter system to set db_name and reset db_unique_name
>> shutdown
>> release channels
>> Error stack indicating it can't find an archivelog
>>
>> Q1: Why isn't the duplicate copying all the logs if they are on disk?
>> Q2: Can I manually copy the logs before I start the duplicate?
>> Q3: How can I find all the logs that I will need?
>>
>> Frustration level is pretty high since my deadline is Monday and I've been working on this for over a week. Any help/suggestions would be greatly appreciated.
>>
>> Thank you,
>>
>> --
>> Sandy B.
>>
Date: Mon, 25 Feb 2019 17:30:36 -0600
Message-Id: <DE1B7B04-B1BA-4375-AC3C-3189D4551DF7_at_gmail.com>
As i recall the process will error out rather than wait for the archive logs. He can probably do a manual copy and recover but it can be a pain to figure the correct series of commands.
Sent from my iPhone
> On Feb 24, 2019, at 10:25 PM, Jack van Zanen <jack_at_vanzanen.com> wrote: > > Hi > > Am I missing something? > > if the files are restored, simply copy the required archived redo log files create controlfile and recover > > > Jack van Zanen > > > ------------------------- > This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. > Thank you for your cooperation > >
>> On Fri, Feb 1, 2019 at 7:56 AM Sandra Becker <sbecker6925_at_gmail.com> wrote:
>> Oracle 11.2 on RHEL
>>
>> I have been trying to duplicate a production database to a new server to do some baseline testing. This is not a situation where I can do a duplicate for standby and the auxiliary database must have a new name. I'm able to get the datafiles restored without a problem. The duplicate is failing to find/copy all the archivelogs it needs. Sometimes it can't find a log with a sequence between two others it did find. For example, it found 730 and 737, but did not find 731 through 736. All logs still exist on the old server.
>>
>> My duplicate script is pretty simple:
>>
>> connect target
>> connect auxiliary
>> run
>> {
>> allocate channel t1 type disk;
>> allocate channel t2 type disk;
>> allocate channel t3 type disk;
>> allocate channel t4 type disk;
>> allocate auxiliary channel a1 type disk;
>> allocate auxiliary channel a2 type disk;
>> allocate auxiliary channel a3 type disk;
>> duplicate target database to baseline from active database nofilenamecheck;
>> release channel t1;
>> .
>> .
>> .
>> release channel a3;
>> }
>> exit
>>
>> Unfortunately, I cannot post the entries from the log due to security policies, but I'll try for a synopsis.
>> After restoring datafiles (or using previous duplicated file), it does an alter system archive log current and then the set new name commands
>> I see "backup as copy reuse" and then a list or archivlogs with the current primary archive log location then the auxiliary format with that location
>> Next catalog clone datafile copy
>> switch clone datafile to datafilecopy
>> executing memory script
>> Starting backup
>> skipping archived log for logs already copied from previous run, then input archived log
>> finished backup
>> catalog archived log
>> instance started
>> alter system to set db_name and reset db_unique_name
>> shutdown
>> release channels
>> Error stack indicating it can't find an archivelog
>>
>> Q1: Why isn't the duplicate copying all the logs if they are on disk?
>> Q2: Can I manually copy the logs before I start the duplicate?
>> Q3: How can I find all the logs that I will need?
>>
>> Frustration level is pretty high since my deadline is Monday and I've been working on this for over a week. Any help/suggestions would be greatly appreciated.
>>
>> Thank you,
>>
>> --
>> Sandy B.
>>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 26 2019 - 00:30:36 CET