treekvm.blogg.se - Oracle restore controlfile to new location

Until time "to_date(' 10:20:49','yyyy-mm-dd hh24:mi:ss')"Īuxiliary destination '/tmp/oracle/recover'ĭatapump destination '/tmp/recover/dumpfiles'

RMAN> recover table lotus.cndba of pluggable database dave SQL> conn create table cndba as select * from dba_objects SQL> grant resource,connect,dba to lotus SQL> create user lotus identified by lotus default tablespace lotus SQL> create tablespace lotus datafile '/dave/app/oracle/oradata/cndba/dave/lotus01.dbf' size 20m Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production RAC: Frequently Asked Questions (RAC FAQ) (Doc ID 220970.1).