Primeiro vamos acessar o sqlplus e verificarmos onde esta armazenada a tablespace temporária do oracle.
oracle@meuservidor:~ sqlplus /nolog
sql>conn sys@brancoproducao as sysdba
sql>select name from v$tempfile;
/u01/app/oracle/oradata/temp01.dbf
2)Vamos criar uma tablespace intermediária:
sql>CREATE TEMPORARY TABLESPACE TEMP2
TEMPFILE '/u01/app/oracle/oradata/temp02.dbf' SIZE 5M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
3)Definimos essa tablespace temporária como default:
sql>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;
4)Apagaremos a tablespace TEMP antiga para que possamos recria-la novamente:
sql>DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;
5) Recriamos agora a tablespace TEMP :
sql>CREATE TEMPORARY TABLESPACE TEMP
TEMPFILE '/u01/app/oracle/oradata/temp01.dbf' SIZE 100M REUSE
AUTOEXTEND ON NEXT 25M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
6) Definimos a tablespace temp como padrão novamente:
sql>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP;
7) E finalizando o nosso tutorial apagamos a tablespace temp2 já que ela não terá mais uso:
sql>DROP TABLESPACE TEMP2 INCLUDING CONTENTS AND DATAFILES;
oracle error- ORA-00396: error string required fallback to single-pass recovery
Oracle error
ORA-00396: | error string required fallback to single-pass recovery |
| Cause: | The indicated error caused two-pass instance or crash recovery to fail. Recovery was retried with an alternate (slower) method to avoid the error. |
| Action: | Correct the cause of the indicated error (also recorded) so that future instance or crash recovery can succeed with the two-pass algorithm. This usually requires making more main memory available to the recovery process. |
oracle error- ORA-00395: online logs for the clone database must be renamed
Oracle error
ORA-00395: | online logs for the clone database must be renamed |
| Cause: | A clone database open forces logfile renaming to avoid overwriting the primary logfiles |
| Action: | Rename the logfiles manually or using the log_file_name_convert initialization parameter |
Subscribe to:
Posts (Atom)
