Home » RDBMS Server » Backup & Recovery » Duplicate database
Duplicate database [message #270284] Wed, 26 September 2007 06:57 Go to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
i need to create a duplicate database .

i already had two existing database one is DBSIB
and the other is NEWDB

the oracle version which am using is ORACLE 10g
operating system is RHEL 4.0

In my setup DBSIB is the RECOVERY CATALOG and i had registered NEWDB in that.

And i had installed oracle software alone in separate node.

In Oracle backup and recovery advanced user's guide they have given some steps to create duplicate database,
BUT it is more complex. i cant able to follow some of the things in that,i will mention what are the things that i cannot able to follow please help me by providing the solution.
===================================
Basic Steps
Perform these tasks before performing RMAN duplication:

Task 1: setenv ORACLE_SID AUX
Create an Oracle Password File for the Auxiliary Instance

Task 2: Ensure SQL*Net Connectivity to the Auxiliary Instance.
A SQL*Net connection to the Auxilary instance is not required, but recommended. As the setup of the SQL*Net connection is easier done for the auxiliary instance than for the TARGET.RMAN is connecting to the target and auxiliary instance with SYSDBA privileges. A SQL*Net connection using SYSDBA privileges requires a password file.

Task 3: Create an Initialization Parameter File for the Auxiliary Instance
Mandatory initialization parameter settings for the auxiliary database:


db_block_size = <same size as the target>
DB_NAME=AUX
compatible = 9.2.0.0 /* should be the same as the target
CONTROL_FILES=(/dup/oracle/oradata/trgt/control01.ctl,
/dup/oracle/oradata/trgt/control02.ctl)
#DB_FILE_NAME_CONVERT=('/oracle/oradata/trgt/','/dup/oracle/oradata/trgt/')
#LOG_FILE_NAME_CONVERT=('/oracle/oradata/trgt/redo','/dup/oracle/oradata/trgt/redo')


Task 4: Start the Auxiliary Instance NOMOUNT

SQL> CONNECT SYS/oracle@aux AS SYSDBA STARTUP FORCE NOMOUNT

Task 5: Mount or Open the Target Database
Task 6: Make Sure You Have the Necessary Backups and Archived Redo Logs
Task 7: Allocate Auxiliary Channels if Automatic Channels Are Not Configured
==========================================

the above are the steps that was given in that guide.

1)i want to know where i want to create the oracle passwd file in target database ie(newdb) according to my setup where am going to take backup
or
in that new node where i had installed oracle software alone.

2)kindly explain how to check the oracle net connectivity to the auxillary instance.
explain briefly.
Re: Duplicate database [message #270770 is a reply to message #270284] Fri, 28 September 2007 00:08 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

http://babudba.blogspot.com/search/label/Duplicate%20DataBase%20Creation
Re: Duplicate database [message #270813 is a reply to message #270284] Fri, 28 September 2007 01:32 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
i had created pfile from the target database and i copied to the duplicate database and make necessary changes.
when i do that i get the following errors.

[oracle@infra ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 28 14:35:47 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount;
ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925
SQL> exit
Re: Duplicate database [message #270829 is a reply to message #270813] Fri, 28 September 2007 02:04 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


did you created base directory ?? (adump,bdump etc)
Re: Duplicate database [message #270831 is a reply to message #270284] Fri, 28 September 2007 02:16 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
thanks for replying babu.

babu i had installed oracle software alone in the duplicate database.so there was no admin folder.
in admin floder only there will be adump,bdump,cdump .......
should i want to create admin folder itself?

my set is like this

i had one target database,where i had taken full backup, and i had created pfile from target database.

now i had new node where i had installed oracle software alone,not database.i cpoied the pfile manually and make necessary changes and tried to startup with nomount.
while doing that am getting the previous error.

what am doing was correct?
r else u just explain me briefly what i have to do for creating duplicate database.
Re: Duplicate database [message #270850 is a reply to message #270831] Fri, 28 September 2007 03:06 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

See,

In your source database. Take full rman backup. and config. db_file_name_convert and log_file_name_convert parameter (chk my blog)

In your Target database (Duplicate):

1. create pwd file
2. paste here ur pfile database ( from soure)
3. create base directory..
4. configure your tnsname.ora and sqlnet.ora
5. create instance (oradim ..)
6. startup force nomount
7. create spfile from pfile
8. Create auxiliary db using rman

All information i posted in my blog. Already i checked that one it's working well in windows 2000 and 2003.

Babu
Re: Duplicate database [message #270880 is a reply to message #270284] Fri, 28 September 2007 04:28 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
thanks for the reply.

In your blog you are stated that,make changes in the in the init.ora file ie pfile

db_file_name_convert = ('d:\oracle\product\10.1.0\oradata\ORA101','d:\oracle\product\10.1.0\oradata\TESTDB')

log_file_name_convert = ('d:\oracle\product\10.1.0\oradata\ORA101','d:\oracle\product\10.1.0\oradata\TESTDB')

In this the above parameter db_file_name_convert and log_file_name_convert was not the in pfile.
do i want to create this parameter?
Re: Duplicate database [message #270887 is a reply to message #270284] Fri, 28 September 2007 04:49 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
ok babu i understood those two parameters are to be created when am using different directory structures.

butwhen i try to create new instance by using oradim am getting the following error

[oracle@infra ~]$ ORADIM -NEW -SID AUX
-bash: ORADIM: command not found
Re: Duplicate database [message #270888 is a reply to message #270284] Fri, 28 September 2007 04:53 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
am getting the following error also after i create spfile from pfile

[oracle@infra ~]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 28 16:22:41 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL>
SQL> create spfile from pfile='/new/oracle/product/db/database/dbs/initAUX.ora';

File created.

SQL> startup force nomount;
ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925
Re: Duplicate database [message #270890 is a reply to message #270284] Fri, 28 September 2007 04:58 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
In your blog you have given configure your tnsnames.ora and sqlnet.ora in target database(duplicate database)

but in my duplicate database there was no tnsnames.ora and sqlnet.ora since i had installed oracle software alone.
Re: Duplicate database [message #271143 is a reply to message #270890] Sun, 30 September 2007 01:12 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
In LInux system no need to use ORADIM utlity for oracle service creation.
just set ORACLE_SID=sid variable and startup nomount.
you also check pfile for any audit parameter is specify and if yes then check "adump" folder is created.

tnsnames.ora or sqlnet.ora you can created after database created through NETCA tools.

Regards
Mohammed Taj
Re: Duplicate database [message #271226 is a reply to message #270284] Sun, 30 September 2007 23:31 Go to previous message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
thanks so much
Previous Topic: fast copy/duplicate of database (NetApp/time finder-SRDF/BCV)
Next Topic: any one explain rman levels
Goto Forum:
  


Current Time: Mon Dec 05 13:00:57 CST 2016

Total time taken to generate the page: 0.08537 seconds