Oracle data backup and recovery

Oracle data export: Write the Creation Path file: create_dir.sqlcreateorreplacedirectorydmpdiras

Oracle export data: Write the Creation Path file: create_dir. SQL create or replace directory dmpdir

Homepage → Database Technology

Background:

Read News

Oracle data backup and recovery

[Date:] Source: Linux community Author: Linux [Font:]

Oracle data export:

Create a path file: create_dir. SQL

Create or replace directory dmpdir as 'e: \ app \ tmp ';
Grant read, write on directory dmpdir to test;
Exit

Write and execute export Bat file: export. bat

Sqlplus system/root123 @ MYTEST @ create_dir. SQL
Expdp system/root123 @ MYTEST schemas = test directory = dmpdir dumpfile = MYTEST. DMP

Database to be backed up by MYTEST

Import Data

Create a User File: create_user. SQL

Drop user test2 cascade;
Create user test2 identified by password;
Grant connect, resource to test2;
Create or replace directory dmpdir as 'e: \ app \ tmp ';
Grant read, write on directory dmpdir to test2;
Exit

Write and execute the Bat file: restore. bat

Sqlplus system/root123 @ localhost: 1521/MYTEST @ create_user. SQL
Impdp system/root123 @ localhost: 1521/MYTEST schemas = test directory = dmpdir dumpfile = MYTEST. DMP table_exists_action = replace remap_schema = test: test2

Recommended reading:

RMAN: Configure an archive log deletion policy

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

0

Install MySQL source code

ORA-09925: Unable to create audit trail file

Oracle backup recovery Oracle backup and recovery

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week

Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.


Copyright©2006-2014 Linux community All rights reserved Zhejiang ICP backup No. 06018118