dotmaik1

--The following script can be used to see open DB link sessions (on both databases).
-- who is querying via dblink?
-- Courtesy of Tom Kyte, via Mark Bobak
-- this script can be used at both ends of the database link
-- to match up which session on the remote database started
-- the local transaction
-- the GTXID will match for those sessions
-- just run the script on both databases

dotmaik1

1.-TOMAMOS UN BACKUP 
nohup expdp USERID=\'/ as sysdba\' schemas=AMOSUSER_MIGRATION5, AMOSSERVER_MIGRATION5 directory=DATA_PUMP_DIR dumpfile=BACKUP_TRAINING5_20072016.dmp logfile=BACKUP_TRAINING5_20072016.log EXCLUDE=statistics  &


export_MIGRATION5_18072016.dmp

2.-DROPEAMOS LOS USUARIOS:

dotmaik1

nohup impdp USERID=\'/ as sysdba\' TABLES = AMOSSERVER_TRAINING2.MENU_USER, AMOSSERVER_TRAINING2.NG_USER_ACCESS, AMOSSERVER_TRAINING2.SIGN, AMOSSERVER_TRAINING2.STAFF_ACCESS_RIGHT, AMOSSERVER_TRAINING2.USER_ACCESS, AMOSSERVER_TRAINING2.USER_GROUP remap_schema=AMOSSERVER_TRAINING2:AMOSSERVER_TRAINING6, AMOSUSER_TRAINING2:AMOSUSER_TRAINING6 REMAP_TABLESPACE=TRAINING2:TRAINING6 DIRECTORY=BACKUP dumpfile=export_TRAINING2_18072016.dmp LOGFILE=import_only_tables_TRAINING2_18072016.log CONTENT=DATA_ONLY &

dotmaik1

#********************************************************************************
#                            DATA PUMP EXPORTS
#********************************************************************************
#********************************************************************************
#  DAILY BACKUP
#********************************************************************************
00 21 * * 1-6 /usr/bin/ksh /oracle/u06/exports/MRORM1/scripts/backup_daily_full.ksh MRORM1
#********************************************************************************
#  DELETE BACKUP
#********************************************************************************

dotmaik1

SET LINESIZE 200
SET PAGES 500
COLUMN file_name FORMAT A70

SELECT file_id,
       file_name,
       ROUND(bytes/1024/1024) AS size_mb,
       ROUND(maxbytes/1024/1024) AS max_size_mb,
       autoextensible,
       increment_by,

dotmaik1

select sum(BYTES)/1024/1024/1204 GB 
from DBA_EXTENTS;


select sum(BYTES)/1024/1024 MB 
from DBA_EXTENTS;

dotmaik1

--Para obtener una lista con los objetos bloqueados ejecucutados:
set lines 200
select substr(a.os_user_name,1,8) "OS User"
, substr(b.object_name,1,30) "Object Name"
, substr(b.object_type,1,8) "Type"
, e.process "PROCESS"
, e.sid
, e.serial#
, e.username
, e.osuser

dotmaik1

SET linesize 160 pagesize 200
col RECORD_ID FOR 9999999 head ID
col ORIGINATING_TIMESTAMP FOR a20 head DATE
col MESSAGE_TEXT FOR a120 head Message

SELECT
    record_id,
    to_char(originating_timestamp,'DD.MM.YYYY HH24:MI:SS'),
    message_text
FROM

dotmaik1

-- -----------------------------------------------------------------------------------
-- File Name    : https://oracle-base.com/dba/10g/segment_advisor.sql
-- Author       : Tim Hall
-- Description  : Displays segment advice for the specified segment.
-- Requirements : Access to the DBMS_ADVISOR package.
-- Call Syntax  : Object-type = "tablespace":
--                  @segment_advisor.sql tablespace (tablespace-name) null
--                Object-type = "table" or "index":
--                  @segment_advisor.sql (object-type) (object-owner) (object-name)
-- Last Modified: 08-APR-2005

dotmaik1

DECLARE
  l_object_id  NUMBER;
BEGIN
 -- Create a segment advisor task for the PAPERLESS tablespace.
DBMS_ADVISOR.create_task (
advisor_name      => 'Segment Advisor',
task_name         => 'PAPERLESS_SEGMENT_ADVISOR',
task_desc         => 'Segment Advisor For PAPERLESS');

DBMS_ADVISOR.create_object (