Simpler Navigation for Servers and Operating Systems
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.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Full Backup ?

SOLVED
Go to solution
KY.Chuang
Advisor

Oracle Full Backup ?

Dear all,
I tried to do a Oracle Full Backup.
But when I restored the data,
the original data of Chinese was not
correct...
Flowing is my step:
(Os:Windows 2000 Server ; Oracle:8.0.5)
(1) exp80 system/manager Full=y file=...
(2) Delete Database
(original Character Set is AMERICAN_AMERICA.WE8ISO8859P1)
(3) Recreate Database
(Character Set is AMERICAN_AMERICA.WE8ISO8859P1)
(4) imp80 system/manager Full=y file=...

Do I have any incorrect setp ?
Service is King
13 REPLIES
malay boy
Trusted Contributor

Re: Oracle Full Backup ?

Hi,
Don't you need to create the tablespace before importing OR my brain goes "cu-cu" today.

regards
mB

There are three person in my team-Me ,myself and I.
Alexander M. Ermes
Honored Contributor

Re: Oracle Full Backup ?

Hi there.
To clear some things first.
What you have done, is to create a logical backup.
Did you do the export and import with the parameter
NLS_LANG=american_america.we8iso8859p1; export NLS_LANG

?

If not, this might be your problem.
You should do export and import with these NLS_LANG params.
Have you got a full physical backup on tape or a copy of your files on the server to restore the old database ?
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
twang
Honored Contributor

Re: Oracle Full Backup ?

You need to identify the following:
-- What was the database character set specified when issuing the CREATE DATABASE for the source database?
-- What was the client character set when the data was exported?
-- What was the database character set specified when issuing the CREATE DATABASE for the destination database?
-- What was the client character set when the data was imported?

It is important to note Import will do up to 2 character set conversions
depending on:

(a) character set of export file
(b) NLS_LANG of import session
(c) character set of database.
T G Manikandan
Honored Contributor

Re: Oracle Full Backup ?

WHen you do a import you should have got messages like

export done is format
import uses yy character set (possible conversion)


What messages you have ?

Revert
Yogeeraj_1
Honored Contributor

Re: Oracle Full Backup ?

hi,

In general, during import/export the data can and often does go through character set translation.

Unless
a) source database has CHARACTER SET X
b) client running export has their NLS_LANG set to X
c) client running import has their NLS_LANG set to X
d) target database has CHARACTER SET X

hope this helps!
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
KY.Chuang
Advisor

Re: Oracle Full Backup ?

Dear all,
How to set the Character Set Parameter when I export data ???

c:\exp80 system/manager Full=y file=... ???
Service is King
Massimo Bianchi
Honored Contributor

Re: Oracle Full Backup ?

Character set is built in the db.
You change the NLS_LANG environtment variable to the proper value.

Massimo
twang
Honored Contributor

Re: Oracle Full Backup ?

To check and modify them:
Right-click the 'My Computer' icon ->
'Properties'
Select the 'Advanced' Tab ->
Click on 'Environment Variables'
twang
Honored Contributor

Re: Oracle Full Backup ?

A little more add to above reply, you can set the NLS_LANG as an environment variable in a Command prompt too, if such, be aware that it will overrite the current NLS_LANG setting in the Registry and also the System Properties. In an MS-DOS command prompt, use the set command, for example: C:\> set NLS_LANG=american_america.WE8ISO8859P1
T G Manikandan
Honored Contributor

Re: Oracle Full Backup ?

Just query your database for

select * from nls_database_parameters

This should be the value of export from the server.

If you are doing it from a client desktop

registry
HKEY_LOCAL_MACHINE--->software--->Oracle-->oracle0-->NLS_LANG
should be the value.

KY.Chuang
Advisor

Re: Oracle Full Backup ?

Dear all,
Let me conclude this question,
because I did success.
(1)change the Windows' register.
HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ NLS_LANG=traditional chinese_taiwan.ZHT32EUC
HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ HOME0 \ NLS_LANG=traditional chinese_taiwan.ZHT32EUC
(2)exp80 system/manager Full=y file=...
when exporting, screen will display "Export done in ZHT32EUC character set and ZHT32EUC NCHAR character set"...It should be consistent.
(3)Delete Database
(original Character Set is traditional chinese_taiwan.ZHT32EUC)
(4)Recreate Database
(Character Set is traditional chinese_taiwan.ZHT32EUC)
(5)imp80 system/manager Full=y file=...


Thanks all...

Another Question ,
In Unix platform, How to Delete a Database?
Just to kill it's datafiles, is It?



Service is King
twang
Honored Contributor

Re: Oracle Full Backup ?

Remove the datafiles, control files, redolog files. And you may want to make change to the tnsnames.ora, listener.ora ...
T G Manikandan
Honored Contributor
Solution

Re: Oracle Full Backup ?

If you want to delete/drop/remove a database
do the steps below

check your ORACLE_SID and ORACLE_HOME.
Make sure that you are pointing the right ORACLE_SID

01. $svrmgrl
02. startup the database if it's not already started. The database must at least mounted.
svrmgrl>startup mount
03. spool /databasefiles.lst
svrmgrl>spool databasefiles.lst
04. select name from v$datafile; (This will get all the datafiles; alternatively, you can select file_name from dba_data_files)
svrmgrl>select name from v$datafile;
05. select member from v$logfile;
svrmgrl>select * from v$logfile;
06. select name from v$controlfile;
svrmgrl>select * from v$controlfile;
07. archive log list (archive_log_dest is where the archived destination is)
svrmgrl>archive log list;
Go to the destination directory of archive_log_dest parameter and remove all the files.
08. locating ifile by issuing show parameter ifile (alternatively, check the content of init.ora)
09. spool off
svrmgrl>spool off
10. Delete in O/S level the files listed in databasefiles.lst
11. remove all the entries which refer to the deleted database in tnsnames.ora and listener.ora (located in $ORACLE_HOME/network/admin)
12. remove all database links referring to the deleted database.
13. check "/var/opt/oracle/oratab" to make sure there is no entry of the database deleted. If yes, remove it.

Thanks