I work at Oracle Corporation and my best Oracle version remains Oracle 11.2.0.4. However, like Arun said, best Oracle version is dependent on the application requirement only. We see a lot of performance and data compatibility issues for customers who have upgraded to new version without proper consultation between their application vendor and Oracle development. They end up with a half-baked migration/upgrade that needs to be reverse engineered to work. Thanks for all the informative content Arun, you are truly a gem in our Oracle DBA world!
We could also improve performance by, 1. Using network_link parameter to take expdp remotely on another node 2.exclude statistics if we already have a stats gathered or needs to ne ignored in the new clone setup 3.increase PGA size if required since PGA handles DPR (Direct Path Read) requests to accommodate expdp 4.Increasing UNDO might help exp Pls correct me if I'm wrong :)
Q: by mistake someone removed online redo logs and cleanup job has cleaned archives and we do not have any database backup scheduled at the server. what are ways to recover database again ?
Hi Arun for the question - on recovering the dropped table from recycle bin using flash back option, would like to know what if recycle bin has been flushed off??how can I get back the dropped table??
Hi Arun, Thanks for taking this initiative of dailyDBA show. I have to questions to ask. 1:- Can we directly move from 12c to 19c or we have to firstly move to 18c and then 19c. 2:- Suppose I had performed expdp operation and created log files and dump file at particular location, and because of some mistakes log files or dump files was got deleted then it this case the import operation will be processed or not. Please answer
A1. Search on google "Oracle 12c upgrade matrix" and read it. You will get answer. A2. If log file is deleted, no impact on import if export dump files are delete, off course import will fail.
free extens information stored in data dictionary that is called Dictionary managed TS. free extens inforamation stored in with in the tablespace it is locally managed TS.
In 11g R2 able to export dump using encryption by "ENCRYPTION_PASSWORD=test". exp : expdp dumpfile=emp.dmp logfile=emp.log directory=data_pump_dir tables=EMP ENCRYPTION_PWD_PROMPT=YES if like this it will ask for Password.after enter encryption the password export will start. the same way can I import like "ENCRYPTION_PWD_PROMPT=YES and then it should wait for password prompt. basically I don't want to specify the password in imp command itself.
Hi Arun, one simple question, what if I the archives generated today and before backing it up , I delete them as the space is limited on filesystem? Is there any impact during recovery
![Lil Uzi Vert - Chill Bae [Official Music Video]](http://i.ytimg.com/vi/D7F42F_JM3U/mqdefault.jpg)
I work at Oracle Corporation and my best Oracle version remains Oracle 11.2.0.4. However, like Arun said, best Oracle version is dependent on the application requirement only. We see a lot of performance and data compatibility issues for customers who have upgraded to new version without proper consultation between their application vendor and Oracle development. They end up with a half-baked migration/upgrade that needs to be reverse engineered to work. Thanks for all the informative content Arun, you are truly a gem in our Oracle DBA world!
We could also improve performance by,
1. Using network_link parameter to take expdp remotely on another node
2.exclude statistics if we already have a stats gathered or needs to ne ignored in the new clone setup
3.increase PGA size if required since PGA handles DPR (Direct Path Read) requests to accommodate expdp
4.Increasing UNDO might help exp
Pls correct me if I'm wrong :)
Extremely superb..Much thanks for your time to explain each and every comment to be answered....
Thanks Arun your r doing great job to help dba round globe.
Great explanation of what the disadvantages of oracle.
Q: by mistake someone removed online redo logs and cleanup job has cleaned archives and we do not have any database backup scheduled at the server. what are ways to recover database again ?
The archival backup
And about the flashback logs
Hi Arun, Any other way to make particular schema in single user mode as we do as database..
Hi Arun for the question - on recovering the dropped table from recycle bin using flash back option, would like to know what if recycle bin has been flushed off??how can I get back the dropped table??
Please explain 12c concepts like pdb,cdb .. how to take backup, clone pdb's
Hi Arun,
Thanks for taking this initiative of dailyDBA show.
I have to questions to ask.
1:- Can we directly move from 12c to 19c or we have to firstly move to 18c and then 19c.
2:- Suppose I had performed expdp operation and created log files and dump file at particular location, and because of some mistakes log files or dump files was got deleted then it this case the import operation will be processed or not.
Please answer
how can it possible,unless and until you don't have dump for import...
A1. Search on google "Oracle 12c upgrade matrix" and read it. You will get answer.
A2. If log file is deleted, no impact on import if export dump files are delete, off course import will fail.
Nice explanation ,can you please explain what is the difference between local and dictionary tablespace
free extens information stored in data dictionary that is called Dictionary managed TS.
free extens inforamation stored in with in the tablespace it is locally managed TS.
Can we use direct=y in case of taking export of clob tables.?
Hi Arun
Could you please explain about FRA and the errors we usually see while initiating backup through FRA.
Picked up your question for upcoming episode. Will answer soon!
In 11g R2 able to export dump using encryption by "ENCRYPTION_PASSWORD=test".
exp : expdp dumpfile=emp.dmp
logfile=emp.log directory=data_pump_dir tables=EMP ENCRYPTION_PWD_PROMPT=YES
if like this it will ask for Password.after enter encryption the password export will start.
the same way can I import like "ENCRYPTION_PWD_PROMPT=YES and then it should wait for password prompt.
basically I don't want to specify the password in imp command itself.
Did you check if ENCRYPTION_PWD_PROMPT is also a parameter available for IMPDP?
Hi very very nice thanks a lot
Hi Arun, one simple question, what if I the archives generated today and before backing it up , I delete them as the space is limited on filesystem?
Is there any impact during recovery
Offcourse, archive lost is directly loss of transactions.. no archive means no recovery!
But if this happens in your environment, immediately take a full backup of DB.
DBA Genesis if full back up completed successfully, then all fine
Supperb sir
What is Fal client and Fal server? What's their purpose?
FAl client is your local machine server and FAL server is your remote server
FAL = Fetch Archive Log
Quick googling will get you the answer. Please note FAL_CLIENT is deprecated from 12c onwards.