Tracnac

#!/bin/sh
# Week/Month snapshot

# Variables :
_debug=0
source .bashrc

# Find the last automatic aws snapshot
export date_of_snapshot_to_save=$(date +"%Y-%m-%d")

Aws copy snapshot from rds

Draft...

#!/bin/sh

export date_of_snapshot_to_save=`date +"%Y-%m-%d"`
export snapshot_identifier=`aws rds describe-db-snapshots --query "DBSnapshots[?SnapshotCreateTime&gt;='${date_of_snapshot_to_save}'].[DBSnapshotIdentifier]" --output text`

#SQL #Oracle

Si erreur lors du lancement de l'instance...

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk rac_on
make -f ins_rdbms.mk ioracle

Sous RMAN :

Source :

backup as copy tablespace sysaux format 'datafilecopy-sysaux.rman';

Dest :

#!/bin/bash

normal="\x01"
red="\x05"
yellow="\x06"
green="\x07"
blue="\x0A"

getBattery() {

sqlplus -s / as sysdba << EOF
set verify off
set termout off
set linesize 32767
set colsep "|"
set feedback off
set long 32767
set longchunksize 32767
set numwidth 20

-- User
connect / as sysdba
drop user tst_ctx cascade;
create user tst_ctx identified by <password>;
grant connect, resource to tst_ctx;
grant create any context to tst_ctx;
alter user tst_ctx default role all;
connect tst_ctx/<password>

for x in 0 1 4 5 7 8; do for i in `seq 30 37`; do for a in `seq 40 47`; do echo -ne "\e[$x;$i;$a""m\\\e[$x;$i;$a""m\e[0;37;40m "; done; echo; done; done; echo "";

Grid CleanUP en cas d'échec...

/etc/init.d/ohasd stop
rm -r /ehc/fs1/softs/oracle/grid
rm -r /ehc/fs1/softs/oracle/grid_base
rm -r /ehc/fs1/softs/oracle/oraInventory
rm -r /tmp/.oracle
rm -r /var/tmp/.oracle
rm -r /etc/oracle /etc/oraInst.loc /etc/oratab

	" Reset to default
	set all&
	set nocompatible

	" Plugins
	" https://github.com/junegunn/vim-plug
	"
	if filereadable(expand("~/vimfiles/autoload/plug.vim"))
	runtime! autoload/plug.vim
	call plug#begin()