- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Full Backup ?
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-11-2003 09:21 PM
тАО08-11-2003 09:21 PM
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 ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-11-2003 09:42 PM
тАО08-11-2003 09:42 PM
Re: Oracle Full Backup ?
Don't you need to create the tablespace before importing OR my brain goes "cu-cu" today.
regards
mB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-11-2003 09:54 PM
тАО08-11-2003 09:54 PM
Re: Oracle Full Backup ?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-11-2003 09:56 PM
тАО08-11-2003 09:56 PM
Re: Oracle Full Backup ?
-- 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-11-2003 11:05 PM
тАО08-11-2003 11:05 PM
Re: Oracle Full Backup ?
export done is
import uses yy character set (possible conversion)
What messages you have ?
Revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-11-2003 11:19 PM
тАО08-11-2003 11:19 PM
Re: Oracle Full Backup ?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-12-2003 12:14 AM
тАО08-12-2003 12:14 AM
Re: Oracle Full Backup ?
How to set the Character Set Parameter when I export data ???
c:\exp80 system/manager Full=y file=... ???
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-12-2003 12:22 AM
тАО08-12-2003 12:22 AM
Re: Oracle Full Backup ?
You change the NLS_LANG environtment variable to the proper value.
Massimo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-12-2003 12:38 AM
тАО08-12-2003 12:38 AM
Re: Oracle Full Backup ?
Right-click the 'My Computer' icon ->
'Properties'
Select the 'Advanced' Tab ->
Click on 'Environment Variables'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-12-2003 03:05 AM
тАО08-12-2003 03:05 AM