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 |
What is Unit Testing in SAP?
can anyone tellme java instance startup sequence?
what are SAR & CAR files in sap?
There is a requirement like a user role to be created and he must have rights to view(read rights) the transactions.How it will be created in PFCG
What is the difference between – support package, kernel and sap note?
i m try to disable multi user login with same user and password in same cleint for example client 800. so how can i do it? pls give me in details steps.
hai tell me that which back ground program is run when we using tp param , client copy and back ground jobs schduling, and if any other you know tell me guys?
Explain how client refresh is different than client copy?
how to repair the sap* default password,r3 sys log file accur error..
Can anyone tell me what is Server and Instance in sap,wat is exact meaning of that?
Difference between DB Verify and DB Check?
where i can find the file sapinfo.exe (to check the sap server is running or not through cmd "sapinfo.exe"). i have already check all the SAP GUI installation DVD and sap installation folder, please help, thanks in advance
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)