Oracle RMAN
Jump to navigation
Jump to search
Duplicate Database
Restore Point in time
Restore point in time utilizando il catalogo, spfile presente, valorizzato db_create_file_dest diverso dal database sorgente:
startup nomount force; run { set dbid 9564328665; allocate channel c1 type disk; set until time "to_date('2021-06-15:01:00:00','YYYY-MM-DD:hh24:mi:ss')"; restore controlfile from autobackup; sql 'alter database mount'; sql 'alter database disable block change tracking'; set newname for database to new; restore database; switch datafile all; recover database; }
Recupero schema da backup
Istanza avviata con init o spfile:
processes=200 sga_target=10G pga_aggregate_target=2G db_block_size=8192 compatible="12.2.0" log_archive_dest_1="location=+DG_ARCH" db_files=1000 db_create_file_dest="+DG_DATA" _system_trig_enabled=false db_name="DBORA01" db_unique_name="RECO01" diagnostic_dest="/u01/app/oracle" control_files="+DG_DATA/RECO01/controlfile/current.786.1075850995"
Da rman:
sql 'alter database mount clone database'; run { set until time "to_date('2021-06-20:03:20:00','YYYY-MM-DD:HH24:MI:SS')"; set newname for database to new; restore database skip forever tablespace USERS,TBS01,TBS02 ; switch datafile all; recover database skip forever tablespace USERS,TBS01,TBS02 ; }