topic Re: Oracle Full Backup ? in Operating System - HP-UX

Oracle Full Backup ?

KY.Chuang — Tue, 12 Aug 2003 04:21:48 GMT

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 ?

Re: Oracle Full Backup ?

malay boy — Tue, 12 Aug 2003 04:42:00 GMT

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

regards
mB

Re: Oracle Full Backup ?

Alexander M. Ermes — Tue, 12 Aug 2003 04:54:07 GMT

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

Re: Oracle Full Backup ?

twang — Tue, 12 Aug 2003 04:56:40 GMT

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.

Re: Oracle Full Backup ?

T G Manikandan — Tue, 12 Aug 2003 06:05:16 GMT

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

Re: Oracle Full Backup ?

Yogeeraj_1 — Tue, 12 Aug 2003 06:19:30 GMT

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

Re: Oracle Full Backup ?

KY.Chuang — Tue, 12 Aug 2003 07:14:34 GMT

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

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

Re: Oracle Full Backup ?

Massimo Bianchi — Tue, 12 Aug 2003 07:22:15 GMT

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

Massimo

Re: Oracle Full Backup ?

twang — Tue, 12 Aug 2003 07:38:44 GMT

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

Re: Oracle Full Backup ?

twang — Tue, 12 Aug 2003 10:05:52 GMT

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

Re: Oracle Full Backup ?

T G Manikandan — Tue, 12 Aug 2003 12:19:47 GMT

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.

Re: Oracle Full Backup ?

KY.Chuang — Wed, 13 Aug 2003 05:29:10 GMT

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?

Re: Oracle Full Backup ?

twang — Wed, 13 Aug 2003 06:03:06 GMT

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

Re: Oracle Full Backup ?

T G Manikandan — Wed, 13 Aug 2003 07:06:03 GMT

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