Recover full db

最新推荐文章于 2025-11-24 20:48:20 发布

转载最新推荐文章于 2025-11-24 20:48:20 发布 · 104 阅读

文章标签：

本文介绍了一个具体的Oracle数据库恢复过程，包括使用RMAN命令进行数据库恢复的脚本示例，以及在恢复过程中出现的问题及解决方法。

ltedb2$[/oracle]nohup ./restore.sh 1>restore.log 2>&1 &
[1] 13172738
ltedb2$[/oracle]
ltedb2$[/oracle]jobs
[1] + Running nohup ./restore.sh 1>restore.log 2>&1 &
ltedb2$[/oracle]
ltedb2$[/oracle]cat restore.sh
#!/bin/sh
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
rman target / nocatalog << EOF
run
{
ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=essdb2,NB_ORA_SERV=sfmbak';
set until time "to_date( '2013-12-06 00:00', 'YYYY-MM-DD HH24:MI' )";
recover DATABASE;
RELEASE CHANNEL CH00;
RELEASE CHANNEL CH01;
}
EOF

[ltedb2:root:/oracle]cat recover.sh

#!/bin/sh
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
rman target / nocatalog << EOF
run
{
ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=essdb2,NB_ORA_SERV=sfmbak';
set until time "to_date( '2013-12-06 00:00', 'YYYY-MM-DD HH24:MI' )";
RECOVER DATABASE;
RELEASE CHANNEL CH00;
RELEASE CHANNEL CH01;
}
EOF

catalog archivelog '/arch/1_14778_813844108.dbf';
catalog archivelog '/arch/1_14779_813844108.dbf';
catalog archivelog '/arch/1_14780_813844108.dbf';
catalog archivelog '/arch/1_14781_813844108.dbf';
catalog archivelog '/arch/1_14782_813844108.dbf';
catalog archivelog '/arch/1_14783_813844108.dbf';
catalog archivelog '/arch/1_14784_813844108.dbf';
catalog archivelog '/arch/1_14785_813844108.dbf';
catalog archivelog '/arch/1_14786_813844108.dbf';
catalog archivelog '/arch/1_14787_813844108.dbf';
catalog archivelog '/arch/1_14788_813844108.dbf';
catalog archivelog '/arch/1_14789_813844108.dbf';

[ltedb2:root:/oracle]cat restore.sh
#!/bin/sh
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
rman target / nocatalog << EOF
run
{
ALLOCATE CHANNEL CH00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE';
SEND 'NB_ORA_CLIENT=essdb2,NB_ORA_SERV=sfmbak';
set until time "to_date( '2013-12-06 00:00', 'YYYY-MM-DD HH24:MI' )";
RESTORE DATABASE;
RELEASE CHANNEL CH00;
RELEASE CHANNEL CH01;
}
EOF

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

SQL> alter database open;

Database altered.

SQL>
SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-1062972/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-1062972/