- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle export
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
тАО03-27-2003 05:49 AM
тАО03-27-2003 05:49 AM
I've to make a database full export. Before issuing :
exp system/passws file=EXP.DMP full=y buffer=300000
do I have to open the database in restrict mode?
What happens if some users are working on the db while I'm making the export?
Will my export be good?
Thank you.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2003 06:12 AM
тАО03-27-2003 06:12 AM
Re: Oracle export
I would try to have no users active when I export and even limit the access.
see
http://www.orafaq.org/faqiexp.htm
EXPORT:
Set the BUFFER parameter to a high value (eg. 2800000)
Make sure all applications on the site has been closed
Make sure the export file is on a physical drive not used by oracle
DO NOT export to a NFS mounted filesystem. It will take forever.
Steve Steel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2003 06:32 AM
тАО03-27-2003 06:32 AM
SolutionCONSISTENT
Default: N
Specifies whether or not Export uses the SET TRANSACTION READ ONLY statement to ensure that the data seen by Export is consistent to a single point in time and does not change during the execution of the export command. You should specify CONSISTENT=Y when you anticipate that other applications will be updating the target data after an export has started.
If you specify CONSISTENT=N (the default), each table is usually exported in a single transaction. However, if a table contains nested tables, the outer table and each inner table are exported as separate transactions. If a table is partitioned, each partition is exported as a separate transaction.
Therefore, if nested tables and partitioned tables are being updated by other applications, the data that is exported could be inconsistent. To minimize this possibility, export those tables at a time when updates are not being done.
The following chart shows a sequence of events by two users: USER1 exports partitions in a table and USER2 updates data in that table.
Time Sequence USER1 USER2
1
Begins export of TAB:P1
2
Updates TAB:P2
Updates TAB:P1
Commit transaction
3
Ends export of TAB:P1
4
Exports TAB:P2
If the export uses CONSISTENT=Y, none of the updates by USER2 are written to the export file.
If the export uses CONSISTENT=N, the updates to TAB:P1 are not written to the export file. However, the updates to TAB:P2 are written to the export file because the update transaction is committed before the export of TAB:P2 begins. As a result, USER2's transaction is only partially recorded in the export file, making it inconsistent
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2003 06:36 AM
тАО03-27-2003 06:36 AM
Re: Oracle export
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2003 07:33 AM
тАО03-27-2003 07:33 AM
Re: Oracle export
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2003 07:39 AM
тАО03-27-2003 07:39 AM
Re: Oracle export
be careful about Rollback (with database activity)
or you'll get a error
'Snapshot too old'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2003 10:18 AM
тАО03-27-2003 10:18 AM
Re: Oracle export
hope that this export is NOT your way of backing up of the database!
The only real backup you can make is using RMAN.
RMAN is real easy to configure and takes care of any consitency issues as long as you are running in Archive log mode.
if you need any further help, let us know.
Hope this helps!
Best Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2003 12:04 AM
тАО03-28-2003 12:04 AM
Re: Oracle export
There are several other ways, of which RMAN is the best, but not the only. For example, where I currently work, we shutdown the database and do file copy at the O/S level. (Management still believe that this is a supposed 24x7 environment !!)
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2003 06:01 AM
тАО03-28-2003 06:01 AM
Re: Oracle export
it's a program after all, you can have bugs...
Export is useful when you want to restore one table that a user has deleted for example
RMAN is nice because it doesn't backup empty database blocks... and it checks block corruption