- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Creating Database and Importing from 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
тАО06-07-2004 08:42 PM
тАО06-07-2004 08:42 PM
This is what I am planning to do :
1) Install Oracle on new machine
2) Manually create database specifying the new locations of the logfiles and datafiles.
3) Manually create the tablespaces specifying
new locations of datafiles.
4) Import from the daily backup of old server, with ignore=N , so that the database and tablespaces (which already exist) won't be recreated from the details on backup, but will import all other details like tables, indexes etc from backup.
I hope that by doing this all the details from backup(including users, roles etc) will be restored as needed.
Another question is, when I'm finally happy that the database is okay, can I create database , tablespaces manually again and import from latest backup. I hope when I issue the create database, all details of the database (incl users, roles etc) will be dropped and recreated again.
Any replies with any existing notes etc.. would be much appreciated. Many Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-07-2004 08:57 PM
тАО06-07-2004 08:57 PM
Re: Creating Database and Importing from Backup
Your procedure looks to be ok. You can refer to the FAQ for more details:
http://www.orafaq.com/faqiexp.htm
manish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-07-2004 08:59 PM
тАО06-07-2004 08:59 PM
Re: Creating Database and Importing from Backup
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-07-2004 09:02 PM
тАО06-07-2004 09:02 PM
Re: Creating Database and Importing from Backup
Yes you do need to have IGNORE=Y if you have the database else it will crib as objects are already present.
manish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-07-2004 09:05 PM
тАО06-07-2004 09:05 PM
Re: Creating Database and Importing from Backup
If you really want to have a identical image of the source database I would suggest to restore onto new server and clone the database.
As mentioned in one of your previous threads you can change the file locations.
I would not use exp/imp unless I want to restrict the DB refresh to a speific schema and/or specific tables.
If you go the exp/imp route ensure you have the NLS_LANG set correctly on source and target.
Regards,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-07-2004 11:43 PM
тАО06-07-2004 11:43 PM
SolutionThe main steps are:
1. Perform a full export from the source database as a DBA user.
For example:
exp system/manager full=y file=expdat.dmp
2. Move the dump file to the target database server via ftp. (Note: remember to change to BINARY mode to avoid corrupting the file. To configure ftp for binary mode, enter 'binary' at the ftp prompt)
3. Create a database on the target server.
4. Before performing the import, you will need to precreate your tablespaces. This is necessary since the import will want to create the corresponding datafiles in the same file structure as was at the source database. Since your file structure will be different on the target database, precreating the tablespaces will allow you to specify a file structure that will work.
5. Set your environment variable ├в NLS_LANG
e.g.
$ setenv NLS_LANG AMERICAN_AMERICA.US7ASCII
6. Perform a full import with the parameter IGNORE=Y into the target database as a DBA user.
imp system/manager full=y ignore=y file=expdat.dmp
Using IGNORE=Y will tell Oracle to ignore any creation errors during the import, allowing the import to complete.
If you want to test it first then do it again later. it is advisable that you script everything so that you can change them if need be.
hope this help!
regards
Yogeer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-07-2004 11:48 PM
тАО06-07-2004 11:48 PM
Re: Creating Database and Importing from Backup
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-11-2004 01:45 AM
тАО06-11-2004 01:45 AM
Re: Creating Database and Importing from Backup
If you can
1.) Do a cold backup using your favorite UNIX backup utility.
2.) Restore the datafile to their new homes.
3.) Do a startup mount
4.) Issure 'alter datbase rename file 'oldlocation' to 'newlocation';
example: alter database rename file '/u1/orcl/foo.dbf' to '/u6/orcl/foo.dbf';
5.) alter database open;
The rename does not rename the file, but redefines the definitions in the the data dictionary. So, if you have only a few datafiles, you may save some work with the rename. The downside is that your database is unavailable during the cold backup.