Тёмный

Interview Question i.e. Why use are using Consistant Logical Backup (EXPDP) with example 

shadatauniversity
Подписаться 8 тыс.
Просмотров 314
50% 1

Interview Question i.e. Why use are using Consistant Logical Backup (EXPDP) with example.
What issues we use to face in case we will take normal backup & role of consistant backup in Real life DBA refresh activity.
.
-------------------------------------------------------------------------
shadataunivers...
“shadatauniversity” (sister concern of SHA Infotech Pvt. Ltd.) is specialized in IT Technologies(Database, Data Science ,Cloud Consultancy/Training,etc).
We are leading Skills and Talent Development Company and building a manpower pool for global industry requirements. The company which was set up years back to help the IT industry overcome its human resource challenges,.
Today one of the leading Data Science, Database and Cloud training owing to its vast, yet comprehensive array of Course Curriculum for future demand in listed below area/domain.
www.linkedin.com/in/upendra-roy-4770018
Website shadataunivers...
/ shadatauniversity
Any Question/Career Guidance:
forms.gle/hrzm...
----------------------
Note: You can connect with a team for guidance if you are really serious about core IT Career. Book a call with IT Consultant or Call @ +91 9073107242
Get into the Masterclass/talk to the consultant by filling up the form:
forms.gle/BJBd...
#shainfotech #carrer #veteran #upendraroy #graduateschool #shadatauniversity #itcareer

Опубликовано:

 

12 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 9   
@balajichandramohan9707
@balajichandramohan9707 5 месяцев назад
Hi sir, how to find the cluster name in RAC.
@balajichandramohan9707
@balajichandramohan9707 5 месяцев назад
Hi sir, is it necessary to add % in the dumpfile name when using parallel option in export.
@shadatauniversity
@shadatauniversity 5 месяцев назад
In Oracle Data Pump Export (expdp), when using the parallel option to perform parallel export operations, it is not necessary to include the '%' symbol in the dump file name. The '%' symbol is typically used as a placeholder for the worker process number when performing parallel operations. However, Oracle Data Pump automatically assigns unique file names to each worker process without the need for explicit specification. When using the parallel option in expdp, Oracle automatically generates unique dump file names based on the specified file name pattern and the worker process number. Each worker process will write its data to a separate dump file with a unique name to avoid conflicts and ensure parallelism. For example, if you specify the following dump file name pattern: Copy code DIRECTORY=export_dir DUMPFILE=expdp_%U.dmp Oracle Data Pump will automatically generate dump file names like "expdp_01.dmp", "expdp_02.dmp", "expdp_03.dmp", etc., for each worker process participating in the parallel export operation. Therefore, it is not necessary to include the '%' symbol explicitly in the dump file name when using the parallel option in expdp. Oracle Data Pump handles the generation of unique dump file names automatically based on the specified file name pattern and the parallelism settings.
@balajichandramohan9707
@balajichandramohan9707 5 месяцев назад
@@shadatauniversity thank you sir. Is it necessary to use % symbol in the dumpfile name to run the export faster when using the parameter parallel.
@shadatauniversity
@shadatauniversity 5 месяцев назад
@@balajichandramohan9707 Nothing to do with faster process with % symbol. Its only for giving naming for the file creation with parallel option..
@balajichandramohan9707
@balajichandramohan9707 5 месяцев назад
@@shadatauniversity thank you sir
@balajichandramohan9707
@balajichandramohan9707 5 месяцев назад
@@shadatauniversity ok. So to run the export faster we just need to add the parameter parallel in the export command. Please confirm.