| Export - Import [message #388087] |
Mon, 23 February 2009 02:50  |
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
|
Senior Member |
|
|
I want to do EXPORT-IMPORT of the database
I have some doubts before implement on the production.
I hope i will get all doubts clear 
Steps:
1. Create new database on destinition server through existing template which includes all the parameter setting and tablespace creation.
2. Full Import will import all users, grants, indexes, database objects????
Export Script
sysdate=`date +%Y%m%d_%H%M`
mknod /home/oracle/FULL_EXP_BACKUP/exp_pipe p
gzip -1 < /home/oracle/FULL_EXP_BACKUP/exp_pipe > /home/oracle/FULL_EXP_BACKUP/FullDbexp_$sysdate.dmp.gz &
$ORACLE_HOME/bin/exp parfile=/home/oracle/ExportScript/exp_full_db.par
LOGFILE=/home/oracle/FULL_EXP_BACKUP/FullDbexp_$sysdate.log
exp_full_db.par
userid=system/manager
file=/home/oracle/FULL_EXP_BACKUP/exp_pipe
log=/home/oracle/FULL_EXP_BACKUP/full_exp.log
direct=y
consistent=y
statistics=none
full=y
buffer=200000
Used statistics=none
1.Do we need to export statistics also?
2.Now dump is of 18G if statistics imported how much size will increase?
We can import without unzipping
mknod imp_pipe p
gunzip < /home/oracle/FULL_EXP_BACKUP/FullDbexp_20090220.dmp.gz > imp_pipe &
imp usr1/usr1@testdb1 file=/home/oracle/FULL_EXP_BACKUP/FullDbexp_20090220.dmp.gz log=/home/oracle/FULL_EXP_BACKUP/imp_exp.log full=y buffer=200000
1. With mknod no need to unzip? We can direct import?
2. Archive log off?? Because much archive generates?
3. Create bigger rollback segments or set parameter COMMIT=Y required while importing???
4. Does IGNORE=y required???
5. Statistics parameter not mentioned then will it import statistics????
6. Do we need to consider schema level because some forums say sys, system dictionaries get corrupted????
7. Is import correct or any more parameter to improve speed of import?
Thanks in advance
[Updated on: Mon, 23 February 2009 02:56] Report message to a moderator |
|
|
|
| Re: Export - Import [message #388090 is a reply to message #388087] |
Mon, 23 February 2009 03:17  |
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
|
Senior Member |
 
|
|
>>1. Create new database on destinition server through existing template which includes all the parameter setting and tablespace creation
As per your requirement/standard you can create database.
>>2. Full Import will import all users, grants, indexes, database objects????
Only user objects like (tables,views,synonyms,package,procedure,funcation,triggers,dblink's & grants); You need to create users manually only..
>>.Do we need to export statistics also?
>>Statistics parameter not mentioned then will it import statistics????
Not Require; If you export statistics during import you can avoid this using (STATISTICS=n)
>> Do we need to consider schema level because some forums say sys, system dictionaries get corrupted????
Good question; ASAIK try to import Schema level.
>> Is import correct or any more parameter to improve speed of import?
Try This
Babu
[Updated on: Mon, 23 February 2009 03:18] Report message to a moderator |
|
|
|
| Re: Export - Import [message #388096 is a reply to message #388087] |
Mon, 23 February 2009 03:28 |
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
|
Senior Member |
|
|
| Quote: |
>>2. Full Import will import all users, grants, indexes, database objects????
Only user objects like (tables,views,synonyms,package,procedure,funcation,triggers,dblink's & grants); You need to create users manually only..
|
Are you sure?
Because i find on net that in FULL Import all the users are also imported. No need to create users mannually.
Thanks,
[Updated on: Mon, 23 February 2009 04:15] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
| Re: Export - Import [message #388104 is a reply to message #388087] |
Mon, 23 February 2009 03:57 |
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
|
Senior Member |
|
|
Thanks a lot.
| Quote: | Also; After 300 posting; still your NOT understand posting format.
|
What i missed? So that i remember it in future?
|
|
|
|
|
|
| Re: Export - Import [message #388225 is a reply to message #388087] |
Mon, 23 February 2009 23:01 |
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
|
Senior Member |
|
|
| Quote: | Only user objects like (tables,views,synonyms,package,procedure,funcation,triggers,dblink's & grants);
|
I think indexes,oracle jobs are also imported,
Am i correct?
Thanks,
|
|
|
|
|
|
| Re: Export - Import [message #388361 is a reply to message #388286] |
Tue, 24 February 2009 08:17 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| gentlebabu wrote on Tue, 24 February 2009 03:23 |
But for indexes you need specify INDEXES=Y parameter.
|
That's the default.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
