RMAN恢复时的时间格式

RMAN> connect target internal/virpure

2> run{

3> allocate channel cc1 type disk;

4> restore database;

sql "alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";-

-------------------注重写法＂＇＇＇＇＂

5> recover database until time '2004-06-25 10:45:00'; #想恢复到这个时间点上。

6> sql 'alter database open resetlogs';

7> release channel cc1;

8> }

9>RMAN> connect target internal/virpure

2> run{

3> allocate channel cc1 type disk;

4> restore database;

sql "alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";-

-------------------注重写法＂＇＇＇＇＂

5> recover database until time '2004-06-25 10:45:00'; #想恢复到这个时间点上。

6> sql 'alter database open resetlogs';

7> release channel cc1;

8> }

9>