Pages

▼
Showing posts with label Database backup/restore. Show all posts
Showing posts with label Database backup/restore. Show all posts
Monday, 13 November 2017

Step by Step to Restore RMAN Incremental Backup in Oracle 11g Database

›
In this scenario we will restore incremental backup when all data files, control files including redo logs are lost Step 1: take full RMA...
Thursday, 16 March 2017

Export/Import in Datapump using query parameter

›
Purpose Enables  you to filter the data that is exported by specifying a clause for a SELECT  statement, which is applied to all/multip...
1 comment:
Thursday, 12 May 2016

Export Backup exclude table in Data Pump Error: ORA-39071

›
Error : ORA-39001: invalid argument value ORA-39071: Value for EXCLUDE is badly formed. ORA-00911: invalid character Solution: [ora...
1 comment:
Tuesday, 25 August 2015

EXPDP in Oracle 12c (ORA-39002 ORA-39070 ORA-39087)

›
DROP DIRECTORY DUMP_DATA; CREATE OR REPLACE DIRECTORY DUMP_DATA AS 'G:\InHouse_DB_Backup'; GRANT EXECUTE, READ, WRITE ...
Sunday, 17 May 2015

ORA-31693 ORA-02354 ORA-01555: snapshot too old: rollback segment number 12 with name "_SYSSMU12_933907484$" too small in expdp

›
Problem: Processing object type DATABASE_EXPORT/AUDIT ORA-31693: Table data object "MICR"."OUTWDCLR" failed to load/u...
Saturday, 15 November 2014

Import (IMPDP) Oracle Database backup from network location

›
Scenario : Suppose we want to restore backup into destination database server (192.168.10.6) and backup resides in  source database serv...
Tuesday, 10 June 2014

Export/Import Specific Table in Oracle

›
Export/Import Specific Table in Oracle  Step1: Export specific table/tables backup using following command exp /password@db_name table...