Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

URGENT-oracle 9.2 db backup and restore

Akies
Respected Contributor

URGENT-oracle 9.2 db backup and restore

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
3 REPLIES
Patrick Wallek
Honored Contributor

Re: URGENT-oracle 9.2 db backup and restore

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
Honored Contributor

Re: URGENT-oracle 9.2 db backup and restore

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

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Eric Antunes
Honored Contributor

Re: URGENT-oracle 9.2 db backup and restore

Hi Akies,

Check this thread:

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

Best Regards,

Eric Antunes
Each and every day is a good day to learn.