| Duplicate database [message #270284] |
Wed, 26 September 2007 06:57  |
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 #270813 is a reply to message #270284] |
Fri, 28 September 2007 01:32  |
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 #270831 is a reply to message #270284] |
Fri, 28 September 2007 02:16 |
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 #270880 is a reply to message #270284] |
Fri, 28 September 2007 04:28 |
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 |
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 |
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 |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
