Home » RDBMS Server » Backup & Recovery » Where does actual database lies? & How to migrate it?
Where does actual database lies? & How to migrate it? [message #120874] Tue, 24 May 2005 07:40 Go to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member
I am a beginner in Oracle.

I have develop and small stock and inventory system in Oracle8i.

It is working well but I always wonder that I have no idea of Backup & Recovery and wonder that if some day my client calls me and say that !“I want to reinstall windows so please backup database” then what will I do.
I don’t even know where the actual database lies. How to copy or migrate it.

So can some one help me in this regard?



2ndly is it possible in copy a part of database date wise?
I have created a column of “entry_date” with every table of database which store the date with every new record.
Is it possible that if a company has same table structure at two places one person enters all data and then make a database backup file of “one day work only” and send this file to other person “by email of CD” the other person run that file and update his database.

Any Possibility?
Or some one can even refer me some documentation to achieve that functionality?

Wishes
Jawad

Report message to a moderator

Re: Where does actual database lies? & How to migrate it? [message #120880 is a reply to message #120874] Tue, 24 May 2005 08:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Backup & Recovery and wonder that if some day my client calls me and say that !“I want to reinstall windows so please backup database” then what will I do.
I don’t even know where the actual database lies. How to copy or migrate it.


READ documentation.

You can export or do hotbackup with RMAN or just alter database begin backup.
But anyof the above makes sense only if you understand what happens in the background.

as there is a specific time_stamp available in form of “entry_date”
the table data can be selectively exported with a where clause and imported into another table.

Report message to a moderator

Re: Where does actual database lies? & How to migrate it? [message #120965 is a reply to message #120874] Wed, 25 May 2005 03:57 Go to previous messageGo to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member
Dear Mahesh Rajendran

thanks for help.
Please refer me some documentation, examples & notes to master these things.

+ What is RMAN and where to get it?

Wishes
Jawad

[Updated on: Wed, 25 May 2005 05:09]

Report message to a moderator

Re: Where does actual database lies? & How to migrate it? [message #120988 is a reply to message #120965] Wed, 25 May 2005 05:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
documentation is available at
http://www.oracle.com/pls/db92/db92.docindex?remark=homepage

You need a free registration.

Look into server concepts manual, administrators manual, backup/recovery.
RMAN is recovery manager, oracle's tool for backup/recovery.

Report message to a moderator

Re: Where does actual database lies? & How to migrate it? [message #120996 is a reply to message #120874] Wed, 25 May 2005 06:19 Go to previous message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member
Dear Mahesh Rajendran

Thanks for your repeating support.
I am looking into it.

Wishes
Jawad

Report message to a moderator

Previous Topic: archive log file size
Next Topic: Database Cloning
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 17:40:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.