数据库做完全恢复198

 

1.数据库处于mount状态

SQL>start mount

 

2.做完全恢复

#!/bin/bash
. /etc/profile
. ~/.bash_profile

export ORACLE_SID=epidb
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1
rman target / log=/home/oracle/my_scripts/restore_database.log<<EOF
run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
allocate channel ch5 device type disk;
restore database;
recover database;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
release channel ch5;
}
EOF

 

3.打开数据库

alter database open；