Re: Create standby for oracle 9i database

I had not checked for read only tablespaces. I will do that today. Thank you.

Sandy

On Tue, Dec 20, 2022 at 4:54 AM Peter Hitchman <pjhoraclel_at_gmail.com> wrote:

> Hi
> Are any of the tablespaces read only? That can cause problems with
> duplication.
>
> Regards
> Pete
>
> On Tue, 20 Dec 2022 at 11:38, Frank Gordon <frankagordon_at_gmail.com> wrote:
>
>> Hello,
>> Are there any additional clues in the alert.log or trace file directories?
>>
>> Besides the "better" hardware on the standby server, how else does the
>> standby server differ from the source database? O/S? Patch level?
>>
>> Regards,
>> Frank
>>
>>
>> On Mon, Dec 19, 2022 at 10:53 PM Sandra Becker <sbecker6925_at_gmail.com>
>> wrote:
>>
>>> OS - Sun Solaris
>>> Oracle: EE 9.2.0.5.0
>>>
>>> We cannot upgrade this database due to the application it supports not
>>> working with higher versions of oracle. (yeah, I know, really stupid)
>>>
>>> We want to create a standby database on a new server with much better
>>> hardware. I'm getting an error on the duplicate that I just haven't been
>>> able to figure out after a couple of days of searching. Everything I've
>>> read points to duplicate filenames, but I have run all the suggested
>>> queries and there are no duplicate filenames. We are using the same
>>> directory structure, so I didn't use db_file_name_convert or
>>> log_file_name_convert. I verified the "standby" can access the backups of
>>> the primary database.
>>>
>>> I did manage to restore the controlfiles manually from the snap_cf file
>>> that I copied from the target server to the auxiliary server to see if that
>>> was where it was failing. Then when I tried to restore the database it
>>> throws the same error as running it from a script. The server is too slow
>>> for me to restore manually, my session would be killed long before it would
>>> finish.
>>>
>>> I would really appreciate any help you can provide or point me to a
>>> useful document/website. Thank you,
>>>
>>> Sandy
>>>
>>> *Duplication Error*
>>> [image: image.png]
>>>
>>>
>>> *Duplicate Script*
>>> sqlplus -S "/ as sysdba" << EOF >> $LOG_FILE
>>> shutdown immediate
>>> startup nomount
>>> EOF
>>>
>>> rman target sys/pwd_at_primary auxiliary sys/pwd_at_stdby_db << EOF >>
>>> $LOG_FILE
>>> run
>>> {
>>> allocate auxiliary channel a1 type disk;
>>> allocate auxiliary channel a2 type disk;
>>> allocate auxiliary channel a3 type disk;
>>> duplicate target database for standby nofilenamecheck dorecover;
>>> release channel a1;
>>> release channel a2;
>>> release channel a3;
>>> }
>>> EOF
>>>
>>> --
>>> Sandy B.
>>>
>>>
>>
>> --
>> +353-86-0695383
>>
>
>
> --
> Regards
>
> Pete
>

-- 
Sandy B.





--
http://www.freelists.org/webpage/oracle-l




image/png attachment: image.png