ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.

 

Ejecutar con RMAN:

> rman target/

> list archivelog all;

> delete archivelog all;

Ejecutar con ORACLE:

> sqlplus / as sysdba

> select name ,total_mb, free_mb ,round(free_mb*100/total_mb) free_pct, used_mb,round(used_mb*100/total_mb) used_pct from (select NAME,round((total_mb-required_mirror_free_mb)/(decode(type,'HIGH',3,'NORMAL',2,1))) total_mb,(usable_file_mb) free_mb,round(((total_mb-required_mirror_free_mb)/(decode(type,'HIGH',3,'NORMAL',2,1)))-usable_file_mb) used_mb from v$asm_diskgroup);

*** El disco de FRA O RECO debería tener espacio.

PowerShell: Reducir tamaño de archivos

Posicionarse en la ruta donde se encuentren los archivos que queremos reducir de tamaño:

Get-Childitem -Path . -File -Recurse -ErrorAction SilentlyContinue | Where-Object {$_.Length -gt 100MB} | clear-content

VALIDAR/CREAR LOGIN Y USUARIO CON MISMO SID EN SQL SERVER

Consultar el SID  de un usuario ya creado

USE [prhcwmsprd]

GO 

SELECT name, sid FROM sys.sysusers WHERE name = 'prhcwmsprd' 

GO 

USE MASTER 

GO 

SELECT name, sid FROM sys.sql_logins WHERE name = 'prhcwmsprd' 

GO

Crear un login y usuario con el mismo SID

CREATE Login prhcwmsprdrestore WITH password = 'prhcwmsprdrestore', CHECK_POLICY = OFF, SID = 0x734712F5096E2A4CB174E264EC4AC776;

CREATE Login prhcwebprdrestore WITH password = 'prhcwebprdrestore', CHECK_POLICY = OFF, SID = 0x9383DE08533C9543B42D4E606EA540EE;

*** Pasos utilizados en una configuración de Always On en SQL

https://blog.sqlauthority.com/2015/04/18/sql-server-create-login-with-sid-way-to-synchronize-logins-on-secondary-server/

START/SHUTDOWN base de datos Oracle + Listener

 -- VALIDAR BASES DE DATOS

ps -fea | grep pmon

-- VALIDAR LISTENERS

ps -fea | grep tns

-- SERVICIO DE BD AL QUE ESTAMOS APUNTANDO

sudo su - oracle

echo $ORACLE_SID

-- CAMBIAR SERVICIO DE BD AL QUE ESTAMOS APUNTANDO

export ORACLE_SID=sigmatmd

sqlplus / as sysdba;

--BAJAR BASE DE DATOS

shutdown;

shutdown immediate;

shutdown abort;

-- INICIAR BASE DE DATOS

startup;

-- VALIDAR STATUS DE LA BASE DE DATOS

SELECT INSTANCE_NAME, STATUS, DATABASE_STATUS FROM V$INSTANCE;

la base de datos debe estar en status OPEN;

-- En caso de iniciar la base de datos con:

startup mount;

alter database open;

-- DETENER / INICIAR UN LISTENER

lsnrctl stop LISTENER_ADMON

lsnrctl start LISTENER_ADMON

Consultar y cambiar los valores SGA y Cursores

show parameter sga;

show parameter session_cached_cursors;

Eliminar archives logs por fecha - Oracle

 delete archivelog until time 'sysdate -15';

Eliminar respaldos RMAN - Oracle

----Iniciar sesión con el usuario Oracle

su - oracle

----Correr las variables de ambiente Oracle 

---- Conectarse por RMAN

rman target /

---- Listar los respaldos en RMAN

list backup summary;

---- Eliminar los baclups según el ID

delete backupset 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 966, 969, 970, 971, 972, 973, 974, 975, 976, 977, 979, 980, 981, 982, 983, 984, 985, 986, 987, 989, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011;

Listar las bases de datos, sus archivos de ubicación y tamaño

select d.database_id,d.name, a.name as filename,a.physical_name as ubication,

 a.type_desc,(a.size/128)as sizeMB, recovery_model_desc,d.state_desc,compatibility_level

from sys.master_files a inner join sys.databases d on (a.database_id = d.database_id)

order by a.type,a.size

Mover tempdb a otra ruta / unidad de disco

 USE MASTER;  

GO

ALTER DATABASE tempdb   

MODIFY FILE (NAME = tempdev, FILENAME = 'E:\SQLDATA\tempdb.mdf');  

GO  

ALTER DATABASE tempdb  

MODIFY FILE (NAME = templog, FILENAME = 'F:\SQLLOG\templog.ldf');  

GO  

Reducir espacio en tempdb.mdf

 -- write everything from your buffers to the disc!

CHECKPOINT; 

GO

-- Clean all buffers and caches

DBCC DROPCLEANBUFFERS; 

DBCC FREEPROCCACHE;

DBCC FREESYSTEMCACHE('ALL');

DBCC FREESESSIONCACHE;

GO

-- Now shrink the file to your desired size

DBCC SHRINKFILE (TEMPDEV, 4060);

-- Make sure that there is no running transaction which uses the tempdb while shrinking!

-- This is most trickiest part of it all.

GO

Listar todos los índices en Azure SQL Database

select i.[name] as index_name, substring(column_names, 1, len(column_names)-1) as [columns], case when i.[type] = 1 then 'Clustered index' when i.[type] = 2 then 'Nonclustered unique index' when i.[type] = 3 then 'XML index' when i.[type] = 4 then 'Spatial index' when i.[type] = 5 then 'Clustered columnstore index' when i.[type] = 6 then 'Nonclustered columnstore index' when i.[type] = 7 then 'Nonclustered hash index' end as index_type, case when i.is_unique = 1 then 'Unique' else 'Not unique' end as [unique], schema_name(t.schema_id) + '.' + t.[name] as table_view, case when t.[type] = 'U' then 'Table' when t.[type] = 'V' then 'View' end as [object_type] from sys.objects as t inner join sys.indexes as i on t.object_id = i.object_id cross apply (select col.[name] + ', ' from sys.index_columns as ic inner join sys.columns as col on ic.object_id = col.object_id and ic.column_id = col.column_id where ic.object_id = t.object_id and ic.index_id = i.index_id order by col.column_id for xml path ('') ) as D (column_names) where t.is_ms_shipped <> 1 and index_id > 0 order by i.[name]

Instalar MongoDB en Windows

Descargar e instalar:

https://www.mongodb.com/download-center/community

Una vez que se termina de instalar, agregar mongo a las variables de ambientes:






Ejecutar desde CMD>  mongod

-- Para iniciar el servidor de base de datos

Ejecutar desde CMD> mongo

-- Para empezar a consultar / crear bases de datos y consultas.