RMAN> run { allocate channel c1 device type disk; allocate channel c2 device type disk; backup database; backup(archivelog all delete input); }
SQL> create table b(name varchar(100)); Table created.
SQL> insert into b values('INSERT BEFORE BACKUP'); 1 row created.
SQL> select to_char(sysdate,'YYYY-MM-DD hh24:mi:ss') from dual; TO_CHAR(SYSDATE,'YY -------------------------------- 2009-05-24 11:57:43
SQL> drop table b; Table dropped.
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down.
SQL> startup mount; ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1247876 bytes Variable Size 79693180 bytes Database Buffers 79691776 bytes Redo Buffers 7139328 bytes Database mounted.
H:\>set nls_date_format=YYYY-MM-DD hh24:mi:ss H:\>set oracle_sid=dba20 H:\>rman RMAN> connect target sys/sys connected to target database: DBA20 (DBID=847839442, not open)
RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; set until time='2009-05-24 11:57:43'; restore database; recover database; }
SQL> alter database open resetlogs; Database altered.
SQL> select * from b; NAME -------------------------------------------- INSERT BEFORE BACKUP
|