[askdba] Re: Cloning a oracle 9i database
- From: Nisar Tareen <ntareen@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Wed, 26 Oct 2005 07:20:17 -0700 (PDT)
Dimitre,
Check the clone_db.ora for the reference to old sid in db_name or etc.
Have you done Set oracle_sid=xxxx variable for your environment before
running the script?
Secondly, I will agree please attached your create control file script and
database parameter script for analysis by others.
Nisar Tareen.
"Radoulov, Dimitre" <cichomitiko@xxxxxxxxx> wrote:
Could you please send the create controlfile command? Are you sure you're
using the set command?
create controlfile SET database ...
Regards,
Dimitre Radoulov
----- Original Message -----
From: "drumil narayan"
To:
Sent: Tuesday, October 25, 2005 8:05 PM
Subject: [askdba] Cloning a oracle 9i database
> Dear all,
>
> am preparing a clone for our development db 9i.
> am following following steps..resulting in error
> ora 1500, 1503
>
> 1. alter database backup controlfile to trace
>
> 2. in trace file am changing following such that it
> will point to cloning locations
>
> create controlfile.... database 'clone_sid'
> resetlogs
> ....
> logfiles
> clone locations
> ....
> datafiles
> clone locations
> ....
> character set..
> 3 shutdown old_db
> 4 copy old_db.ora to clone_db.ora
> 5 changing sid, destinations to clone_db sid and
> destinations, not mentioning control file locations
> 6 startup nomount pfile='clone_db.ora'
> database starts....
> ....
> ...
> 7 when am running the control file scripts prepared
> using the old_db, it gives me that the datafiles which
> i have copied from the old locations to clone
> destinatins have the old sid name in their header and
> hence unable to mount and open the new db..
>
> where am going wrong..kindly help..drumil
>
>
>
> __________________________________________________________
> Yahoo! India Matrimony: Find your partner now. Go to
> http://yahoo.shaadi.com
>
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
Other related posts:
