Oracle Full Backup ?

[KY.Chuang]

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 ?

[malay boy]

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

regards
mB

[Alexander M. Ermes]

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

[twang]

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]

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]

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

[KY.Chuang]

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

c:\exp80 system/manager Full=y file=... ???

[Massimo Bianchi]

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

Massimo

[twang]

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

[twang]

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]

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]

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?

[twang]

Remove the datafiles, control files, redolog files. And you may want to make change to the tnsnames.ora, listener.ora ...

[T G Manikandan · Accepted solution]

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