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