martes, 6 de febrero de 2018

Mover/Realocar Datafiles&Online Redo - Oracle 11g


Archivelog Mode ON:

alter system set log_archive_format = 'archs_%t_%s_%r.arc' scope=spfile;alter system set log_archive_dest_1='LOCATION=O:\Archives' scope=spfile;shutdown immediatestartup mountalter database archivelog;alter database open;

Resultado:



Relocate Datafiles:

Verificar los datafiles por #ID:



Tablespace SYSTEM:









Tablespace SYSAUX:







Tablespace UNDOTBS:








Tablespace USERS:




Tablespace TEMP:




Relocate OnlineRedoLog: