Answer / sudhan

USING BRTOOLS WE CAN TAKE THE BACKUP IN ORACLE,IN BRTOOLS
FOURTH OPTION DATABASE BACKUP & COPY OPTION IS THERE USING
THAT OPTION WE CAN TAKE THE BACKUP,IN THAT WE WILL GIVE THE
BACKUP MODE , TYPE , DEVICE TYPE ,COMPRESSION MODE

Answer / john

dbForge Studio for Oracle provides database backup option:
1. Start Page -> Data Pump -> click Schema Export -> Schema Export Wizard
2. In the Connection list select a connection / click <Manage...> -> New (create a new connection).
3. Select a database you want to backup in the Schema list, once the connection is established.
4. Specify a folder path to store backups in the Path text box.
5. Specify an output file name in the Output file name text box.
6. (Optional) You can setup some optional settings such as: Append timestamp to the file name, Auto delete old files, Use compression (ZIP), etc.
7. Click Next.
8. Select database objects to export -> Next.
9. Specify detailed options on how schema export should be performed -> Next.
10. Select the Write a report to a log file check box to save the backup process information to a log file. Enter the path where to store the file, for instance: C:UsersDocumentsExportSchemaExport.log
11. Click Export.
12. As soon as the export process is finished -> Next -> Save Project.

Backup can be run also from the Command Line. Scheduling is included.

When your database size is large, how you can perform client copy in sap landscape?

1 Answers  

---

what are the previleages before applying support packages.

3 Answers   Patni,

---

where do you see the transport logs?

6 Answers   TCS,

---

Hi , Today , while refering about SAPDBA , i came know about , when we are facing performance issue, we need to increase Table space and need to add data files to table space . but i dint understand about data files and wht it contains ... What is data files in Table spaces , what it contains actually ?

1 Answers  

---

Can you import a transport request using STMS_QUEUES and STMS_IMPORT?

3 Answers  

---

All the background jobs are in released state and there is a delay time and the background work processes are in wait status. What could be the reason why the jobs are not in ready or active state and the solution?

10 Answers  

---

wat description should be given in creating a role....in description area wat should be given ??

1 Answers   IBM,

---

a transport request is imported, it should have finished in 30 min but it is running for one day(it is running in quality system and it has the transport directory local)you see the slog and all logs are showing that import is processing....and it does not show any error...how will you troubleshoot it?

2 Answers   HCL,

---

How do you generate (recover) old system logs in a newly created SLOG00?

0 Answers   IBC,

---

Can SNOTE be deimplemented?

2 Answers  

---

1.AFTER KERNEL UPGRADE IGS IS NOT WORKING WHAT SHOULD U DO ? 2.WHAT IS THE DIFFERENCE B/W USERTRACE AND BACKGROUND TRACE IN DATABASE? 3JSPM IS NOT WORKING WHILE APPLYING PATCHS WHAT COULD BE THE RESONS?

2 Answers   Bosch,

---

what are client settings?

1 Answers   GBT,

---