Home Database Mysql Tutorial Shell脚本备份恢复Oracle数据库简单示例

Shell脚本备份恢复Oracle数据库简单示例

Jun 07, 2016 pm 05:07 PM
oracle database

exp_p.sh #!/bin/sh #$1生成dmp文件保存路径 if [ -d $1 ]; then echo $1 exist #用户名/密码 生成文件名称根据当天

exp_p.sh

#!/bin/sh

#$1生成dmp文件保存路径

if [ -d "$1" ]; then

   echo ""$1" exist "

   #用户名/密码 生成文件名称根据当天日期自动生成,,例如20111128.dmp

   exp test/test file="$1/`date + %Y%m%d`.dmp"

else

#如果制定的文件保存路径不存在则创建文件夹后在导出数据

  mkdir -p "$1"

  exp test/test file="$1/`date + %Y%m%d`.dmp"

fi

chmod +x exp_p.sh

./exp_p.sh /home/Oracle/bak

 

imp_p.sh

#!/bin/sh

#$1导入的dmp文件,例如/home/oracle/bak/20111128.dmp

if [ -f "$1" ]; then

   echo ""$1" exist"

   #导入目标数据库的用户名/密码, fromuser源数据库用户

   imp test/test file="$1" fromuser=test1

else

   echo "ERROR:"$1" does not exist"

fi

linux

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to check which table space a table belongs to in Oracle How to check which table space a table belongs to in Oracle Jul 06, 2023 pm 01:31 PM

How to check which table space a table belongs to in Oracle

How to connect to Oracle database using PDO How to connect to Oracle database using PDO Jul 28, 2023 pm 12:48 PM

How to connect to Oracle database using PDO

How to retrieve only one piece of duplicate data in oracle How to retrieve only one piece of duplicate data in oracle Jul 06, 2023 am 11:45 AM

How to retrieve only one piece of duplicate data in oracle

Implement data import into PHP and Oracle databases Implement data import into PHP and Oracle databases Jul 12, 2023 pm 06:46 PM

Implement data import into PHP and Oracle databases

How oracle determines whether a table exists in a stored procedure How oracle determines whether a table exists in a stored procedure Jul 06, 2023 pm 01:20 PM

How oracle determines whether a table exists in a stored procedure

Does oracle database require jdk? Does oracle database require jdk? Jun 05, 2023 pm 05:06 PM

Does oracle database require jdk?

How to use PHP and Oracle database connection pools efficiently How to use PHP and Oracle database connection pools efficiently Jul 12, 2023 am 10:07 AM

How to use PHP and Oracle database connection pools efficiently

How to use php to extend PDO to connect to Oracle database How to use php to extend PDO to connect to Oracle database Jul 29, 2023 pm 07:21 PM

How to use php to extend PDO to connect to Oracle database

See all articles