Monday, August 23, 2010

RMAN Restore Point in Time Restore (PITR)


run {
allocate channel t1 type disk ;
allocate channel t2 type disk ;
allocate channel t3 type disk ;
allocate channel t4 type disk ;
set until time "to_date('2010-08-23 08:15:00','YYYY-MM-DD HH24:MI:SS')" ;
restore database ;
recover database ;
sql 'alter database open resetlogs' ;
release channel t1;
release channel t2;
release channel t3;
release channel t4;
}

1 comment:

jamesfo8376 said...

The subsequent time I read a weblog, I hope that it doesnt disappoint me as much as this one. I imply, I do know it was my option to read, however I actually thought youd have something fascinating to say. All I hear is a bunch of whining about one thing that you can fix should you werent too busy on the lookout for attention. casino slots