To recover from a dropped
or truncated table, a dummy database (copy of primary) will be restored and
recovered to point in time so the table can be exported. Once the table
export is complete, the table can be imported into the primary database.
This dummy database can be a subset of the primary database. However, the
'dummy' database must include the SYSTEM, UNDO (or ROLLBACK), and the
tablespace(s) where the dropped/truncated table resid...
Showing posts with label Backup/Restore. Show all posts
Showing posts with label Backup/Restore. Show all posts
Monday, 15 September 2014
Saturday, 22 February 2014
Impdp does not created user/schema
Until now my understanding for EXPDP/IMPDP was that
if the user performing import has 'IMPORT FULL DATABASE' privilege, it'll
create the users/schemas in the target database. I needed to export (expdp)
schema from one machine and import (impdp) it to another machine. I just wanted impdp to create schema on target database.
While doing import i
encountered error
$ impdp system/oracle123
directory=TEST_DIR dumpfile=test.dmp logfile=impdptest.log
.......
Starting
"SYSTEM"."SYS_IMPORT_FULL_01": system/********...
Identify the Tablespace names from EXPDP dump file
I got request from development team to
import some old data in UAT region.The expdp dump file received from backup team was without log file and i have no access to the export file's source DB. I wanted to import that
dumpfile into UAT DB and i do not know the tablespace names required to do
so.
Solution:
Use the sqlfile option present in impdp utility. This
option will write all the SQL DDL to a specified file instead of executing
them.
$ impdp scott/tiger directory=exp_dir
dumpfile=scott.dmp sqlfile=script.sql
Import:...
Monday, 23 December 2013
Restoring an RMAN Backup to Another Node /Clone Database
In certain circumstances, it may be desirable to restore a
database from an RMAN backup onto a machine other than the original
host.
For example,Restore and recover data at a given point in time for UAT/Testing, or to
duplicate a production instance.
The example assumes:
the target database is on host A
the database is to be restored onto host B
the directory structure of host B is different to host A
the ORACLE_SID will not change for the restored database
a recovery catalog is being used
the backups were carried out to disk (for...