신문지한장

@echo offSET yyyymmdd=%DATE:~0,4%%DATE:~5,2%%DATE:~8,2% SET yyyymmdd=%yyyymmdd: =%ECHO %yyyymmdd%expdp dbsec/dbsec directory=DATAPUMP dumpfile=expdp_full_%yyyymmdd%.dmp logfile=expdp_full_%yyyymmdd%.log exclude=statistics full=ycopy E:\db_backup\expdp\expdp_full_%yyyymmdd%.dmp \\192.168.10.15\db_backup\expdpcopy E:\db_backup\expdp\expdp_full_%yyyymmdd%.log \\192.168.10.15\db_backup\expdpforfile..

$cat check.shexport CDATE=`date +%Y%m%d`export ORACLE_SID=DJPsqlplus "/ as sysdba"

SYS@orcl19>select file_name from dba_data_files where tablespace_name='&1';Enter value for 1: SYSTEM -- SYSTEM 입력-- 출력FILE_NAME-------------------------------------------------------------------------------------/oracle/app/oracle/oradata/ORCL19/system01.dbf

1. _oracle_script 히든 파라미터 조회col name for a40col current_value for a15col default_value for a15col default_t_f for a15selectksppinm "name",ksppstvl "current_value",b.ksppstdfl "default_value",b.ksppstdf "default_t_f"from x$ksppi a, x$ksppsv bwhere 1=1and a.indx=b.indxand a.ksppinm like '_oracle_script';-- default 값까지 확인set lines 200 pages 1000col desc for a70col name for a40col current_value for ..

OS : CentOS 7.9 (64bit)DB : Oracle Database 19c ( Release - 19.3 ) 1. 기존 PDB 확인SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO  2. datafile 확인SQL> select name from v$datafile;NAME-----------------------------------------------------------------------..