how to take database backup in oracle ?
how to crate a table space in oracle database ?
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 5 Yes | 0 No |
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.
Is This Answer Correct ? | 0 Yes | 0 No |
How to do client copy fast?
How do you do the load balancing?
you have to assign a role to a user.YOu can add the role to user in su01 OR you can add the user to role in pfcg.which method is preferable?why?
What is client administration in sap system? Why do we use multiple clients in sap system?
of the two client copy methods remote and export-import which method lets you copy to different r/3 version? which method requires both systems to be on same support pack level?
Suppose one A User has tcode SU01.When A try to execute tcode su01,not able to execute.but next day User A can able to execute the same tcode SU01. Which not done user comparision next day too but how come User A can able to execute tcode SU01?
How to know the status of saposcol in unix? How to stop and start?
what is logical system ? how to create and why ?
how do you register developers?
a backroungd job is running...it should have finished in 30min but it is runing for long one day...if you check the process in sm50 it is running and if you check the pid in task manager it is running....it is not hanged and job log does not have error...what will you do to troubleshoot it and how will you convince the particular job owner for killing and rescheduling ?
simple transport request is taking so much time to get impoted.what will you do?
Explain the method of making client copy, how can we do it when the SAP user is not there in the system?