How to run SQL scripts at DB level from OS level
$nohup sqlplus '/ as sysdba' @script_name.sql&
bg, fg and jobs Linux Commands
Every command you give is a job that is executed. A job can be suspended, placed in the background, moved back to the foreground or terminated.
While running a job you can Shortcut
--------------------------- ----------
suspend a job ctrl+z
terminate a job ctrl+c
Function Command
-------- ------------
Move a suspended job to the foreground fg
Continue a suspended job in the background bg
List all jobs jobs
Kill a job (%N where N is the job number) kill %N && fg
Start a job directly in the background command &
When you execute a unix shell-script or command that takes a long time, you can run it as a background job.
1. Executing a background job
$ find . -name "*.aud" -mtime +120 -exec rm {} \; &
2. Sending the current foreground job to the background using CTRL+Z and bg command
step 1.Press 'CTRL+Z' which will suspend the current foreground job.
step 2.Execute 'bg to' make that command to execute in background.
Press ‘CTRL+Z’
$ bg
3. View all the background jobs using jobs command.
$jobs
jobs : lists the jobs that you are running in the background and in the foreground
jobs -p : list only the PID of process group leader
jobs -l : list only jobs that have change status since last notified by their status
jobs -r : resrict output to running jobs
jobs – s : restrict output to stopped jobs
4. Taking a job from the background to the foreground using fg command
$ fg
When executed without arguments, it will take the most recent background job to the foreground
SFTP
>sftp <user>@<hostname>
Connecting to <hostname>...
<user>'s Password:
sftp>pwd (remote working directory)
sftp>!pwd (local working directory)
sftp>cd /target/path/ (remote path)
sftp>pwd (remote working directory)
sftp>!ls -l (local working directory)
sftp>put <filename(s)>
Uploading <filename> to /target/path/<filename>
sftp>ls -l (remote location files)
sftp>bye
Linux Commands
Linux Commands
!stty erase ^?
ORACLE_SID=`ps -ef | grep asm_smon | grep -v 'grep' | grep -v 'sed' | awk '{printf $8}' | awk 'BEGIN{FS="_"} {printf $3}'`
date
env
uptime
who -b
last | grep -i boot
ps -ef | grep pmon
ps -ef | grep tns
ps -ef | grep d.bin
df -h or df -g
uname
/etc/oratab or /etc/var/oracle/oratab
df -kh or df -kh . or df -kh /mountpoint/
du -sh * or du -sh .
du -sg *
ls -ltrh <filename> | sort -n
ls -ld
tellme system
lsof /mountpoint/
find /home -name oraInventory -print
find . -name "*.gz" -depth -mtime +60 -exec rm {} \;
nslookup
tnsping
top
bg, fg, jobs
FIND
To find a file/directory
------------------------
find /home -name oraInventory -print
find /home|grep oraInventory
To delete files older than 60 days
----------------------------------
find . -name "*.gz" -depth -mtime +60 -exec rm {} \;
SOURCE : Internet
TAR
tar -cvf newname.tar directory_name (to tar)
tar -xvf filename.tar (to untar)
DELETE COMPRESS FILES OS LEVEL
To list files dated Apr 24
--------------------------
ls -lrt | grep 'Apr 24' | awk -F' ' '{print$9}'
To delete files dated Apr 24
----------------------------
rm -rf `ls -lrt | grep 'Apr 24' | awk -F' ' '{print$9}'`
To list files of Month Apr
--------------------------
ls -lrt | grep 'Apr' | awk -F' ' '{print$9}'
ls -lrt *.trc|grep 'Apr'|xargs rm -rf {}\;
To delete files of Month Apr
----------------------------
rm -rf `ls -lrt | grep 'Apr' | awk -F' ' '{print$9}'`
To list files older than 60 days
--------------------------------
find . -name "*.trc" -depth -mtime +60 -exec ls -l {} \;
find /path/to/files* -mtime +60 -print
To delete files older than 60 days
----------------------------------
find . -name "*.trc" -depth -mtime +60 -exec rm {} \;
find /path/to/files* -mtime +60 -exec rm {} \;
find /path/to/files* -type f -mtime +60 -print0 | xargs -r rm -rf
COMPRESS
--------
nohup compress *.arc &
ls -lrt *.arc|awk '{print "compress "$9}' >ARC_LIST.txt
SOURCE : Internet
DELETE COMPRESS FILES OS LEVEL
To list files dated Apr 24
--------------------------
ls -lrt | grep 'Apr 24' | awk -F' ' '{print$9}'
To delete files dated Apr 24
----------------------------
rm -rf `ls -lrt | grep 'Apr 24' | awk -F' ' '{print$9}'`
To list files of Month Apr
--------------------------
ls -lrt | grep 'Apr' | awk -F' ' '{print$9}'
ls -lrt *.trc|grep 'Apr'|xargs rm -rf {}\;
To delete files of Month Apr
----------------------------
rm -rf `ls -lrt | grep 'Apr' | awk -F' ' '{print$9}'`
To list files older than 60 days
--------------------------------
find . -name "*.trc" -depth -mtime +60 -exec ls -l {} \;
find /path/to/files* -mtime +60 -print
To delete files older than 60 days
----------------------------------
find . -name "*.trc" -depth -mtime +60 -exec rm {} \;
find /path/to/files* -mtime +60 -exec rm {} \;
find /path/to/files* -type f -mtime +60 -print0 | xargs -r rm -rf
COMPRESS
--------
nohup compress *.arc &
ls -lrt *.arc|awk '{print "compress "$9}' >ARC_LIST.txt
SOURCE : Internet
SERVER REBOOT
If its Dataguard setup or normal db, following steps mandatory just take backup of following three steps and store it in separate notepad. once server reboot activity completed cross check once which was taken before server reboot.
####################################################################################################
ps -ef|grep pmon
ps -ef|grep pmon|wc -l
ps -ef|grep inh (OR) ps -ef|grep tns
ps -ef|grep inh|wc -l
ps -ef |grep d.bin
hostname
date
uname -a
cat /etc/oratab / cat /var/opt/oracle/oratab
uptime
who -b
df -h / df -gt
####################################################################################################
server reboot time database side need to check the below commands:
(Before server reboot and after server boot, if its is DG database)
-------------------------------------------------------------------
SQL> select name,db_unique_name,database_role,controlfile_type,CREATED from v$database;
SQL >select sequence#,first_time,next_time,completion_time,applied from v$archived_log where applied <> 'YES' and DEST_ID !=0 and status!='D'and completion_time <(sysdate-1/48) Order By 1;
no rows selected----->in sync
SQL >select process, status ,sequence# from v$managed_standby;
MRP0---->process should reflect
===============================
Data Guard Db Startup Procedure
===============================
Sqlplus “/ as sysdba”
startup nomount;
alter database mount standby database;
recover managed standby database disconnect from session; ----------->To put it in MRM MODE
exit;
=================================
Data Guard Db Shutdown Procedure
=================================
Login as oracle
source the environment
sqlplus “/ as sysdba”
alter database recover managed standby database cancel; ------> to cancel MRM mode
shutdown immediate;
exit
$nohup sqlplus '/ as sysdba' @script_name.sql&
bg, fg and jobs Linux Commands
Every command you give is a job that is executed. A job can be suspended, placed in the background, moved back to the foreground or terminated.
While running a job you can Shortcut
--------------------------- ----------
suspend a job ctrl+z
terminate a job ctrl+c
Function Command
-------- ------------
Move a suspended job to the foreground fg
Continue a suspended job in the background bg
List all jobs jobs
Kill a job (%N where N is the job number) kill %N && fg
Start a job directly in the background command &
When you execute a unix shell-script or command that takes a long time, you can run it as a background job.
1. Executing a background job
$ find . -name "*.aud" -mtime +120 -exec rm {} \; &
2. Sending the current foreground job to the background using CTRL+Z and bg command
step 1.Press 'CTRL+Z' which will suspend the current foreground job.
step 2.Execute 'bg to' make that command to execute in background.
Press ‘CTRL+Z’
$ bg
3. View all the background jobs using jobs command.
$jobs
jobs : lists the jobs that you are running in the background and in the foreground
jobs -p : list only the PID of process group leader
jobs -l : list only jobs that have change status since last notified by their status
jobs -r : resrict output to running jobs
jobs – s : restrict output to stopped jobs
4. Taking a job from the background to the foreground using fg command
$ fg
When executed without arguments, it will take the most recent background job to the foreground
SFTP
>sftp <user>@<hostname>
Connecting to <hostname>...
<user>'s Password:
sftp>pwd (remote working directory)
sftp>!pwd (local working directory)
sftp>cd /target/path/ (remote path)
sftp>pwd (remote working directory)
sftp>!ls -l (local working directory)
sftp>put <filename(s)>
Uploading <filename> to /target/path/<filename>
sftp>ls -l (remote location files)
sftp>bye
Linux Commands
Linux Commands
!stty erase ^?
ORACLE_SID=`ps -ef | grep asm_smon | grep -v 'grep' | grep -v 'sed' | awk '{printf $8}' | awk 'BEGIN{FS="_"} {printf $3}'`
date
env
uptime
who -b
last | grep -i boot
ps -ef | grep pmon
ps -ef | grep tns
ps -ef | grep d.bin
df -h or df -g
uname
/etc/oratab or /etc/var/oracle/oratab
df -kh or df -kh . or df -kh /mountpoint/
du -sh * or du -sh .
du -sg *
ls -ltrh <filename> | sort -n
ls -ld
tellme system
lsof /mountpoint/
find /home -name oraInventory -print
find . -name "*.gz" -depth -mtime +60 -exec rm {} \;
nslookup
tnsping
top
bg, fg, jobs
FIND
To find a file/directory
------------------------
find /home -name oraInventory -print
find /home|grep oraInventory
To delete files older than 60 days
----------------------------------
find . -name "*.gz" -depth -mtime +60 -exec rm {} \;
SOURCE : Internet
TAR
tar -cvf newname.tar directory_name (to tar)
tar -xvf filename.tar (to untar)
DELETE COMPRESS FILES OS LEVEL
To list files dated Apr 24
--------------------------
ls -lrt | grep 'Apr 24' | awk -F' ' '{print$9}'
To delete files dated Apr 24
----------------------------
rm -rf `ls -lrt | grep 'Apr 24' | awk -F' ' '{print$9}'`
To list files of Month Apr
--------------------------
ls -lrt | grep 'Apr' | awk -F' ' '{print$9}'
ls -lrt *.trc|grep 'Apr'|xargs rm -rf {}\;
To delete files of Month Apr
----------------------------
rm -rf `ls -lrt | grep 'Apr' | awk -F' ' '{print$9}'`
To list files older than 60 days
--------------------------------
find . -name "*.trc" -depth -mtime +60 -exec ls -l {} \;
find /path/to/files* -mtime +60 -print
To delete files older than 60 days
----------------------------------
find . -name "*.trc" -depth -mtime +60 -exec rm {} \;
find /path/to/files* -mtime +60 -exec rm {} \;
find /path/to/files* -type f -mtime +60 -print0 | xargs -r rm -rf
COMPRESS
--------
nohup compress *.arc &
ls -lrt *.arc|awk '{print "compress "$9}' >ARC_LIST.txt
SOURCE : Internet
DELETE COMPRESS FILES OS LEVEL
To list files dated Apr 24
--------------------------
ls -lrt | grep 'Apr 24' | awk -F' ' '{print$9}'
To delete files dated Apr 24
----------------------------
rm -rf `ls -lrt | grep 'Apr 24' | awk -F' ' '{print$9}'`
To list files of Month Apr
--------------------------
ls -lrt | grep 'Apr' | awk -F' ' '{print$9}'
ls -lrt *.trc|grep 'Apr'|xargs rm -rf {}\;
To delete files of Month Apr
----------------------------
rm -rf `ls -lrt | grep 'Apr' | awk -F' ' '{print$9}'`
To list files older than 60 days
--------------------------------
find . -name "*.trc" -depth -mtime +60 -exec ls -l {} \;
find /path/to/files* -mtime +60 -print
To delete files older than 60 days
----------------------------------
find . -name "*.trc" -depth -mtime +60 -exec rm {} \;
find /path/to/files* -mtime +60 -exec rm {} \;
find /path/to/files* -type f -mtime +60 -print0 | xargs -r rm -rf
COMPRESS
--------
nohup compress *.arc &
ls -lrt *.arc|awk '{print "compress "$9}' >ARC_LIST.txt
SOURCE : Internet
SERVER REBOOT
If its Dataguard setup or normal db, following steps mandatory just take backup of following three steps and store it in separate notepad. once server reboot activity completed cross check once which was taken before server reboot.
####################################################################################################
ps -ef|grep pmon
ps -ef|grep pmon|wc -l
ps -ef|grep inh (OR) ps -ef|grep tns
ps -ef|grep inh|wc -l
ps -ef |grep d.bin
hostname
date
uname -a
cat /etc/oratab / cat /var/opt/oracle/oratab
uptime
who -b
df -h / df -gt
####################################################################################################
server reboot time database side need to check the below commands:
(Before server reboot and after server boot, if its is DG database)
-------------------------------------------------------------------
SQL> select name,db_unique_name,database_role,controlfile_type,CREATED from v$database;
SQL >select sequence#,first_time,next_time,completion_time,applied from v$archived_log where applied <> 'YES' and DEST_ID !=0 and status!='D'and completion_time <(sysdate-1/48) Order By 1;
no rows selected----->in sync
SQL >select process, status ,sequence# from v$managed_standby;
MRP0---->process should reflect
===============================
Data Guard Db Startup Procedure
===============================
Sqlplus “/ as sysdba”
startup nomount;
alter database mount standby database;
recover managed standby database disconnect from session; ----------->To put it in MRM MODE
exit;
=================================
Data Guard Db Shutdown Procedure
=================================
Login as oracle
source the environment
sqlplus “/ as sysdba”
alter database recover managed standby database cancel; ------> to cancel MRM mode
shutdown immediate;
exit
No comments:
Post a Comment