How to back Database until a Previous position by RMAN
Database Point-in-time recovery (Time based incomplete recovery)
# This scenario assumes that all initialization files,RMAN backup of database and the current
# controlfile are in place and you want to recover to a point in time '03-07-2010:14:20:00' .
#
RMAN> shutdown immediate
RMAN>STARTUP MOUNT FORCE;
RMAN> RUN
{
SET UNTIL TIME "TO_DATE('03-07-2010:14:20:00','dd-mm-yyyy:hh24:mi:ss')";
RESTORE DATABASE;
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;
}
Everything Changes
2 weeks ago
No comments:
Post a Comment