URGENT-oracle 9.2 db backup and restore

[Akies]

Hi,

My oracle db 9.2 is installed on HP-UX 11.x. I am using db instance "ovsdnew". This db is used by my service desk server. Now I want to create the same replication on another server.

My RMAN is not working.Can any1 suggest me how can I take the back up of db from one server. and restore it on other "empty" db.

Regards,
Akies

[Patrick Wallek]

A couple of ways:

1) Shut down the DB. Copy from servera to serverb. Adjust the locations of the db files and start on the new server.

2) Export on servera and import on serverb.

[Yogeeraj_1]

hi,

If you manage to fix the RMAN problem you can just duplicate the database.

The easy way to do the replication, is shutdown the database and copy all the database files to the other server and start it there. Of course, depending on the size of the database and possibility of doing a shutdown are the main issues..

You can get all the information on the files being used by the database by generating the the trace file of the control file.

$ sqlplus

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jun 11 08:08:22 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engin
e options

SQL> alter database backup controlfile to trace;

Database altered.

SQL> show parameter dump

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /u01/app/oracle/admin/mydb/bdump
core_dump_dest string /u01/app/oracle/admin/mydb/cdump
max_dump_file_size string UNLIMITED
shadow_core_dump string partial
user_dump_dest string /u01/app/oracle/admin/mydb/udump
SQL>exit

$ cd /u01/app/oracle/admin/mydb/udump
$ ll -rtl|tail -1
-rw-r----- 1 oracle oinstall 12063 Jun 11 08:08 mydb_ora_579.trc
$ more mydb_ora_579.trc
(this should show you all the files being used by the database)


Hope this helps!
kind regards
yogeeraj

[Eric Antunes]

Hi Akies,

Check this thread:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=997677

Best Regards,

Eric Antunes