SQL> ALTER SYSTEM SET log_archive_dest_1='location=+DG1' SCOPE=spfile sid='*'; SQL> ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile sid='*'; srvctl stop database -d ORCL -o immediate srvctl start database -d ORCL -o mount SQL> ALTER DATABASE ARCHIVELOG; srvctl stop database -d ORCL -o immediate srvctl start database -d ORCL
Monthly Archives: November 2016
oracle emcli usage
emcli get_threshold
-target_name="DBNAME.XYZ.COM"
-target_type="rac_database"
-metric="problemTbsp"
emcli modify_threshold
-target_name='DBNAME.XYZ.COM'
-target_type='rac_database'
-metric='problemTbsp'
-column='bytesFree'
-key_columns='USERS;'
-warning_threshold='3000'
-critical_threshold='1500'
-prevent_override='1'
oracle database services configuration
using srvctl command
srvctl add service -db CDB1 -s SALES.XYZ.COM -pdb PDB1 -preferred CDB11,CDB12 srvctl start service -db CDB1 -s SALES.XYZ.COM -instance CDB11 srvctl start service -db CDB1 -s SALES.XYZ.COM -instance CDB12 srvctl config service -db CDB1 srvctl status service -db CDB1 srvctl stop service -db CDB1 -s SALES.XYZ.COM -instance CDB11 srvctl stop service -db CDB1 -s SALES.XYZ.COM -instance CDB12 srvctl remove service -db CDB1 -s SALES.XYZ.COM
using packages
exec DBMS_SERVICE.STOP_SERVICE('SALES.XYZ.COM','CDB11');
exec DBMS_SERVICE.STOP_SERVICE('SALES.XYZ.COM','CDB12');
exec DBMS_SERVICE.DELETE_SERVICE('SALES.XYZ.COM');
exec DBMS_SERVICE.CREATE_SERVICE('SALES.XYZ.COM', 'SALES.XYZ.COM');
exec DBMS_SERVICE.START_SERVICE('SALES.XYZ.COM', 'CDB11');
exec DBMS_SERVICE.START_SERVICE('SALES.XYZ.COM', 'CDB12');
DBMS_SERVICE.STOP_SERVICE(service_name IN VARCHAR2, instance_name IN VARCHAR2);
DBMS_SERVICE.DELETE_SERVICE(service_name IN VARCHAR2);
DBMS_SERVICE.CREATE_SERVICE(service_name IN VARCHAR2, network_name IN VARCHAR2);
DBMS_SERVICE.START_SERVICE(service_name IN VARCHAR2, instance_name IN VARCHAR2);
oracle RMAN script
RMAN configuration
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 4 BACKUP TYPE TO BACKUPSET; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 2; CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 2; CONFIGURE CHANNEL DEVICE TYPE SBT_TAPE TRACE 0 PARMS 'BLKSIZE=, SBT_LIBRARY=,ENV=(STORAGE_UNIT=,BACKUP_HOST=)'; CONFIGURE MAXSETSIZE TO UNLIMITED; CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DISKG1/rman/<>';
RMAN script
run {
set command id to 'COLD_BACKUP';
backup tag 'cold_backup_yymmdd'
filesperset 4
format 'D_%d_%p_%u','tape2.xyz.com/D_%d_%p_%u'
database;
backup current controlfile format 'C_%d_%p_%u','tape2.xyz.com/C_%d_%p_%u';
backup spfile format 'S_%d_%p_%u','tape2.xyz.com/S_%d_%p_%u';
}
oracle datapump parfile
-- exp.par DIRECTORY= SCHEMAS=SCOTT,\"ABC.XYZ\" PARALLEL= EXCLUDE=STATISTICS dumpfile=name_00_%u.dmp FLASHBACK_TIME=systimestamp compression=all -- imp.par DIRECTORY= SCHEMAS=SCOTT,\"ABC.XYZ\" PARALLEL= JOB_NAME= LOGFILE=name_imp.log dumpfile=name_00_%u.dmp -- imp_net.par DIRECTORY= SCHEMAS=SCOTT,\"ABC.XYZ\" PARALLEL= JOB_NAME= LOGFILE=name_imp.log NETWORK_LINK=