![]() ![]() If you want to use SCN recover table "MYUSER"."MYTABLE" OF PLUGGABLE DATABASE nameofpluggabledbÄ®)finally exit from rman (if no error reported) and import the table impdp full=Y directory=DUMP_DIR dumpfile=saved_copy. ![]() The two notes below outline the steps using the RMAN process. ![]() Until time "to_date(' 16:34:10','dd/mm/yyyy hh24:mi:ss')"Īuxiliary destination '/var/oracle/backup/aux'Äatapump destination '/var/oracle/backup/datapump' This note outlines steps taken in order to copy a datafile from ASM to the file system not using RMAN. ![]() Is essential to have a full backup and recover correctly, in case of multiple backups you must specify TAG when recovery.Ī)we must know the correct date, personally I give the time before delete the table alter session set nls_date_format = 'dd/mm/yyyy hh24:mi:ss' Ä«)on rman the backup was executed with this command BACKUP DATABASE TAG "backup-oracledb" PLUS ARCHIVELOG Ĭ) AFTER the drop table, I execute those commands mkdir /var/oracle/backup/aux'Ä)on rman I recover the lost table in datapump file(of course the datapump dir must exist, configured in ORACLE, etc.) recover table "MYUSER"."MYTABLE" OF PLUGGABLE DATABASE nameofpluggabledb Solution found, this is the correct procedure. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |