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
!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
How to compress
Listener log file in Linux
How to compress files
in Linux
How to compress
Listener log file in Linux
Step:-1
-------
cd
/u01/app/oracle/10.2.0/db_1/network/admin --- listener log location
du -sh *|sort -n
du -sh listener.log
Step:-2
-------
vi filecompress.sh
cd
/u01/app/oracle/10.2.0/db_1/network/admin --- listener log location
cp listener.log
listener_currentdate.log
cat /dev/null >
listener.log
-- press esc key
:wq
Run the filecompress.sh
in nohup
---------------------------------
nohup sh -x
filecompress.sh > filecompress.log 2>> filecompress.err &
Step:-3
-------
gzip -9
listener_currentdate.log
du -sh *.gz
--- OR ---
tar -zcvf
listener_currentdate.tar.gz listener_currentdate.log
du -sh *.tar.gz
Note:-
====
Listener will be
available in the above process and no data loss of listener log file.
For Example, 3 GB file
will be compressed to 100M (approx).
vi Editor Commands
vi Editor
Commands
$ vi <filename>
Option ==> Action
vi ==> Starts editing session in memory.
vi ==> Starts session and opens the specified file.
vi * ==> Opens first file that matches the wildcard pattern. Use :n to navigate to the next matched file.
view ==> Opens file in read-only mode.
vi -R ==> Opens file in read-only mode.
vi -r ==> Recovers file and recent edits after abnormal abort from editing session (like a system crash).
vi +n ==> Opens file at specified line number n.
vi + ==> Opens file at the last line.
vi +/ ==> Opens file at first occurrence of specified string pattern.
Common Techniques to Enter vi Insert Mode:
Enter Insert Command ==> Action
i ==> Insert text in front of the cursor.
a ==> Insert text after the cursor.
I ==> Insert text at the beginning of the line.
A ==> Insert text at the end of the line.
o ==> Insert text below the current line.
O ==> Insert text above the current line.
Useful vi Exit Commands
Exit Command ==> Action
:wq ==> Save and exit.
ZZ ==> Save and exit.
:x ==> Save and exit.
:w ==> Save the current edits without exiting.
:w! ==> Override file protections and save.
:q ==> Exit the file.
:q! ==> Exit without saving.
:n ==> Edit next file.
:e! ==> Return to previously saved version.
Common Navigation Commands
Command ==> Action
j (or down arrow) ==> Move down a line.
k (or up arrow) ==> Move up a line.
h (or left arrow) ==> Move one character left.
l (or right arrow) ==> Move one character right.
Ctrl+f (or Page Down) ==> Scroll down one screen.
Ctrl+b (or Page Up) ==> Scroll up one screen.
1G ==> Go to first line in file.
G ==> Go to last line in file.
nG ==> Go to n line number.
H ==> Go to top of screen.
L ==> Go to bottom of screen.
w ==> Move one word forward.
b ==> Move one word backward.
0 ==> Go to start of line.
$ ==> Go to end of line.
Common Options for Copying, Deleting, and Pasting Text
Option ==> Action
yy ==> Yank (copy) the current line.
nyy ==> Yank (copy) n number of lines.
p ==> Put yanked line(s) below the cursor.
P ==> Put yanked line(s) above the cursor.
x ==> Delete the character that the cursor is on.
X ==> Delete the character to the left of the cursor.
dw ==> Delete the word the cursor is currently on.
dd ==> Delete current line of text.
ndd ==> Delete n lines of text
D ==> Delete to the end of the current line.
Common Options for Changing Text
Option ==> Action
r ==> Replace the character that the curser is on with the next character you type.
~ ==> Change the case of a character.
cc ==> Delete the current line and insert text.
C ==> Delete to the end of the line and insert text.
c$ ==> Delete to the end of the line and insert text.
cw ==> Delete to the end of the word and insert text.
R ==> Type over the characters in the current line.
s ==> Delete the current character and insert text.
S ==> Delete the current line and insert text.
Common Options for Text Searching
Option ==> Action
/ ==> Search forward for a string.
? ==> Search backward for a string.
n ==> Repeat the search forward.
N ==> Repeat the search backward.
f ==> Search forward for a character in the current line.
F ==> Search backward for a character in the current line.
:set number ==> Displaying Line Numbers
u ==> Undoing a Command
$ vi <filename>
Option ==> Action
vi ==> Starts editing session in memory.
vi ==> Starts session and opens the specified file.
vi * ==> Opens first file that matches the wildcard pattern. Use :n to navigate to the next matched file.
view ==> Opens file in read-only mode.
vi -R ==> Opens file in read-only mode.
vi -r ==> Recovers file and recent edits after abnormal abort from editing session (like a system crash).
vi +n ==> Opens file at specified line number n.
vi + ==> Opens file at the last line.
vi +/ ==> Opens file at first occurrence of specified string pattern.
Common Techniques to Enter vi Insert Mode:
Enter Insert Command ==> Action
i ==> Insert text in front of the cursor.
a ==> Insert text after the cursor.
I ==> Insert text at the beginning of the line.
A ==> Insert text at the end of the line.
o ==> Insert text below the current line.
O ==> Insert text above the current line.
Useful vi Exit Commands
Exit Command ==> Action
:wq ==> Save and exit.
ZZ ==> Save and exit.
:x ==> Save and exit.
:w ==> Save the current edits without exiting.
:w! ==> Override file protections and save.
:q ==> Exit the file.
:q! ==> Exit without saving.
:n ==> Edit next file.
:e! ==> Return to previously saved version.
Common Navigation Commands
Command ==> Action
j (or down arrow) ==> Move down a line.
k (or up arrow) ==> Move up a line.
h (or left arrow) ==> Move one character left.
l (or right arrow) ==> Move one character right.
Ctrl+f (or Page Down) ==> Scroll down one screen.
Ctrl+b (or Page Up) ==> Scroll up one screen.
1G ==> Go to first line in file.
G ==> Go to last line in file.
nG ==> Go to n line number.
H ==> Go to top of screen.
L ==> Go to bottom of screen.
w ==> Move one word forward.
b ==> Move one word backward.
0 ==> Go to start of line.
$ ==> Go to end of line.
Common Options for Copying, Deleting, and Pasting Text
Option ==> Action
yy ==> Yank (copy) the current line.
nyy ==> Yank (copy) n number of lines.
p ==> Put yanked line(s) below the cursor.
P ==> Put yanked line(s) above the cursor.
x ==> Delete the character that the cursor is on.
X ==> Delete the character to the left of the cursor.
dw ==> Delete the word the cursor is currently on.
dd ==> Delete current line of text.
ndd ==> Delete n lines of text
D ==> Delete to the end of the current line.
Common Options for Changing Text
Option ==> Action
r ==> Replace the character that the curser is on with the next character you type.
~ ==> Change the case of a character.
cc ==> Delete the current line and insert text.
C ==> Delete to the end of the line and insert text.
c$ ==> Delete to the end of the line and insert text.
cw ==> Delete to the end of the word and insert text.
R ==> Type over the characters in the current line.
s ==> Delete the current character and insert text.
S ==> Delete the current line and insert text.
Common Options for Text Searching
Option ==> Action
/ ==> Search forward for a string.
? ==> Search backward for a string.
n ==> Repeat the search forward.
N ==> Repeat the search backward.
f ==> Search forward for a character in the current line.
F ==> Search backward for a character in the current line.
:set number ==> Displaying Line Numbers
u ==> Undoing a Command
Script to Gather
data from the Linux OS
#####################################################################
### Unix script os_stats.sh ###
### Designed to be run periodically to collate information ###
### START OF SCRIPT ###
#####################################################################
#
LOG_FILE="OS_`hostname`_`date '+%m%d%y_%H%M'`.txt"
#
echo "**********************************************" >$LOG_FILE
date >> $LOG_FILE
echo "Running as `id`" >> $LOG_FILE
echo "**********************************************" >>$LOG_FILE
echo "uname -a" >>$LOG_FILE
uname -a >>$LOG_FILE
cat /etc/issue >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "ulimit -a" >>$LOG_FILE
ulimit -a >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "ulimit -Ha" >>$LOG_FILE
ulimit -Ha >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "Netstat -i" >>$LOG_FILE
netstat -i >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "netstat -an">> $LOG_FILE
netstat -an >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "netstat -s">> $LOG_FILE
netstat -s >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "sar -u 5 3">> $LOG_FILE
sar -u 5 3 >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "sar -q 5 3">> $LOG_FILE
sar -q 5 3 >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "ps -e -w -o user,pid,ppid,s,pcpu,pmem,vsz,rss,stime,time,args" >> $LOG_FILE
ps -e -ww -o user,pid,ppid,s,pcpu,pmem,vsz,rss,stime,time,args >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "iostat -t -x" >> $LOG_FILE
iostat -t -x >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "df -h" >> $LOG_FILE
df -h >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "mpstat 5 3" >> $LOG_FILE
/usr/bin/mpstat 5 3 >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "vmstat 5 3" >> $LOG_FILE
vmstat 5 3 >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "free -m -s 5 -c 3" >> $LOG_FILE
free -m -s 5 -c 3 >>$LOG_FILE
grep MemTotal /proc/meminfo >>$LOG_FILE
grep SwapTotal /proc/meminfo >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "IPCS data" >> $LOG_FILE
ipcs -l >> $LOG_FILE
echo " ---------------------------- " >> $LOG_FILE
ipcs -u >> $LOG_FILE
echo " ---------------------------- " >> $LOG_FILE
ipcs >> $LOG_FILE
echo " ---------------------------- " >> $LOG_FILE
ipcs -t >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
#####################################################################
### END OF SCRIPT ###
### Unix script os_stats.sh ###
### Designed to be run periodically to collate information ###
### START OF SCRIPT ###
#####################################################################
#
LOG_FILE="OS_`hostname`_`date '+%m%d%y_%H%M'`.txt"
#
echo "**********************************************" >$LOG_FILE
date >> $LOG_FILE
echo "Running as `id`" >> $LOG_FILE
echo "**********************************************" >>$LOG_FILE
echo "uname -a" >>$LOG_FILE
uname -a >>$LOG_FILE
cat /etc/issue >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "ulimit -a" >>$LOG_FILE
ulimit -a >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "ulimit -Ha" >>$LOG_FILE
ulimit -Ha >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "Netstat -i" >>$LOG_FILE
netstat -i >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "netstat -an">> $LOG_FILE
netstat -an >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "netstat -s">> $LOG_FILE
netstat -s >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "sar -u 5 3">> $LOG_FILE
sar -u 5 3 >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "sar -q 5 3">> $LOG_FILE
sar -q 5 3 >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "ps -e -w -o user,pid,ppid,s,pcpu,pmem,vsz,rss,stime,time,args" >> $LOG_FILE
ps -e -ww -o user,pid,ppid,s,pcpu,pmem,vsz,rss,stime,time,args >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "iostat -t -x" >> $LOG_FILE
iostat -t -x >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "df -h" >> $LOG_FILE
df -h >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "mpstat 5 3" >> $LOG_FILE
/usr/bin/mpstat 5 3 >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "vmstat 5 3" >> $LOG_FILE
vmstat 5 3 >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "free -m -s 5 -c 3" >> $LOG_FILE
free -m -s 5 -c 3 >>$LOG_FILE
grep MemTotal /proc/meminfo >>$LOG_FILE
grep SwapTotal /proc/meminfo >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "IPCS data" >> $LOG_FILE
ipcs -l >> $LOG_FILE
echo " ---------------------------- " >> $LOG_FILE
ipcs -u >> $LOG_FILE
echo " ---------------------------- " >> $LOG_FILE
ipcs >> $LOG_FILE
echo " ---------------------------- " >> $LOG_FILE
ipcs -t >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
#####################################################################
### END OF SCRIPT ###
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
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
!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)
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
--------------------------
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
####################################################################################################
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
How to compress Listener log file in Linux
How to compress files
in Linux
How to compress
Listener log file in Linux
Step:-1
-------
cd
/u01/app/oracle/10.2.0/db_1/network/admin --- listener log location
du -sh *|sort -n
du -sh listener.log
Step:-2
-------
vi filecompress.sh
cd
/u01/app/oracle/10.2.0/db_1/network/admin --- listener log location
cp listener.log
listener_currentdate.log
cat /dev/null >
listener.log
-- press esc key
:wq
Run the filecompress.sh
in nohup
---------------------------------
nohup sh -x
filecompress.sh > filecompress.log 2>> filecompress.err &
Step:-3
-------
gzip -9
listener_currentdate.log
du -sh *.gz
--- OR ---
tar -zcvf
listener_currentdate.tar.gz listener_currentdate.log
du -sh *.tar.gz
Note:-
====
Listener will be
available in the above process and no data loss of listener log file.
For Example, 3 GB file
will be compressed to 100M (approx).
vi Editor Commands
vi Editor
Commands
$ vi <filename>
Option ==> Action
vi ==> Starts editing session in memory.
vi ==> Starts session and opens the specified file.
vi * ==> Opens first file that matches the wildcard pattern. Use :n to navigate to the next matched file.
view ==> Opens file in read-only mode.
vi -R ==> Opens file in read-only mode.
vi -r ==> Recovers file and recent edits after abnormal abort from editing session (like a system crash).
vi +n ==> Opens file at specified line number n.
vi + ==> Opens file at the last line.
vi +/ ==> Opens file at first occurrence of specified string pattern.
Common Techniques to Enter vi Insert Mode:
Enter Insert Command ==> Action
i ==> Insert text in front of the cursor.
a ==> Insert text after the cursor.
I ==> Insert text at the beginning of the line.
A ==> Insert text at the end of the line.
o ==> Insert text below the current line.
O ==> Insert text above the current line.
Useful vi Exit Commands
Exit Command ==> Action
:wq ==> Save and exit.
ZZ ==> Save and exit.
:x ==> Save and exit.
:w ==> Save the current edits without exiting.
:w! ==> Override file protections and save.
:q ==> Exit the file.
:q! ==> Exit without saving.
:n ==> Edit next file.
:e! ==> Return to previously saved version.
Common Navigation Commands
Command ==> Action
j (or down arrow) ==> Move down a line.
k (or up arrow) ==> Move up a line.
h (or left arrow) ==> Move one character left.
l (or right arrow) ==> Move one character right.
Ctrl+f (or Page Down) ==> Scroll down one screen.
Ctrl+b (or Page Up) ==> Scroll up one screen.
1G ==> Go to first line in file.
G ==> Go to last line in file.
nG ==> Go to n line number.
H ==> Go to top of screen.
L ==> Go to bottom of screen.
w ==> Move one word forward.
b ==> Move one word backward.
0 ==> Go to start of line.
$ ==> Go to end of line.
Common Options for Copying, Deleting, and Pasting Text
Option ==> Action
yy ==> Yank (copy) the current line.
nyy ==> Yank (copy) n number of lines.
p ==> Put yanked line(s) below the cursor.
P ==> Put yanked line(s) above the cursor.
x ==> Delete the character that the cursor is on.
X ==> Delete the character to the left of the cursor.
dw ==> Delete the word the cursor is currently on.
dd ==> Delete current line of text.
ndd ==> Delete n lines of text
D ==> Delete to the end of the current line.
Common Options for Changing Text
Option ==> Action
r ==> Replace the character that the curser is on with the next character you type.
~ ==> Change the case of a character.
cc ==> Delete the current line and insert text.
C ==> Delete to the end of the line and insert text.
c$ ==> Delete to the end of the line and insert text.
cw ==> Delete to the end of the word and insert text.
R ==> Type over the characters in the current line.
s ==> Delete the current character and insert text.
S ==> Delete the current line and insert text.
Common Options for Text Searching
Option ==> Action
/ ==> Search forward for a string.
? ==> Search backward for a string.
n ==> Repeat the search forward.
N ==> Repeat the search backward.
f ==> Search forward for a character in the current line.
F ==> Search backward for a character in the current line.
:set number ==> Displaying Line Numbers
u ==> Undoing a Command
$ vi <filename>
Option ==> Action
vi ==> Starts editing session in memory.
vi ==> Starts session and opens the specified file.
vi * ==> Opens first file that matches the wildcard pattern. Use :n to navigate to the next matched file.
view ==> Opens file in read-only mode.
vi -R ==> Opens file in read-only mode.
vi -r ==> Recovers file and recent edits after abnormal abort from editing session (like a system crash).
vi +n ==> Opens file at specified line number n.
vi + ==> Opens file at the last line.
vi +/ ==> Opens file at first occurrence of specified string pattern.
Common Techniques to Enter vi Insert Mode:
Enter Insert Command ==> Action
i ==> Insert text in front of the cursor.
a ==> Insert text after the cursor.
I ==> Insert text at the beginning of the line.
A ==> Insert text at the end of the line.
o ==> Insert text below the current line.
O ==> Insert text above the current line.
Useful vi Exit Commands
Exit Command ==> Action
:wq ==> Save and exit.
ZZ ==> Save and exit.
:x ==> Save and exit.
:w ==> Save the current edits without exiting.
:w! ==> Override file protections and save.
:q ==> Exit the file.
:q! ==> Exit without saving.
:n ==> Edit next file.
:e! ==> Return to previously saved version.
Common Navigation Commands
Command ==> Action
j (or down arrow) ==> Move down a line.
k (or up arrow) ==> Move up a line.
h (or left arrow) ==> Move one character left.
l (or right arrow) ==> Move one character right.
Ctrl+f (or Page Down) ==> Scroll down one screen.
Ctrl+b (or Page Up) ==> Scroll up one screen.
1G ==> Go to first line in file.
G ==> Go to last line in file.
nG ==> Go to n line number.
H ==> Go to top of screen.
L ==> Go to bottom of screen.
w ==> Move one word forward.
b ==> Move one word backward.
0 ==> Go to start of line.
$ ==> Go to end of line.
Common Options for Copying, Deleting, and Pasting Text
Option ==> Action
yy ==> Yank (copy) the current line.
nyy ==> Yank (copy) n number of lines.
p ==> Put yanked line(s) below the cursor.
P ==> Put yanked line(s) above the cursor.
x ==> Delete the character that the cursor is on.
X ==> Delete the character to the left of the cursor.
dw ==> Delete the word the cursor is currently on.
dd ==> Delete current line of text.
ndd ==> Delete n lines of text
D ==> Delete to the end of the current line.
Common Options for Changing Text
Option ==> Action
r ==> Replace the character that the curser is on with the next character you type.
~ ==> Change the case of a character.
cc ==> Delete the current line and insert text.
C ==> Delete to the end of the line and insert text.
c$ ==> Delete to the end of the line and insert text.
cw ==> Delete to the end of the word and insert text.
R ==> Type over the characters in the current line.
s ==> Delete the current character and insert text.
S ==> Delete the current line and insert text.
Common Options for Text Searching
Option ==> Action
/ ==> Search forward for a string.
? ==> Search backward for a string.
n ==> Repeat the search forward.
N ==> Repeat the search backward.
f ==> Search forward for a character in the current line.
F ==> Search backward for a character in the current line.
:set number ==> Displaying Line Numbers
u ==> Undoing a Command
Script to Gather
data from the Linux OS
#####################################################################
### Unix script os_stats.sh ###
### Designed to be run periodically to collate information ###
### START OF SCRIPT ###
#####################################################################
#
LOG_FILE="OS_`hostname`_`date '+%m%d%y_%H%M'`.txt"
#
echo "**********************************************" >$LOG_FILE
date >> $LOG_FILE
echo "Running as `id`" >> $LOG_FILE
echo "**********************************************" >>$LOG_FILE
echo "uname -a" >>$LOG_FILE
uname -a >>$LOG_FILE
cat /etc/issue >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "ulimit -a" >>$LOG_FILE
ulimit -a >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "ulimit -Ha" >>$LOG_FILE
ulimit -Ha >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "Netstat -i" >>$LOG_FILE
netstat -i >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "netstat -an">> $LOG_FILE
netstat -an >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "netstat -s">> $LOG_FILE
netstat -s >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "sar -u 5 3">> $LOG_FILE
sar -u 5 3 >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "sar -q 5 3">> $LOG_FILE
sar -q 5 3 >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "ps -e -w -o user,pid,ppid,s,pcpu,pmem,vsz,rss,stime,time,args" >> $LOG_FILE
ps -e -ww -o user,pid,ppid,s,pcpu,pmem,vsz,rss,stime,time,args >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "iostat -t -x" >> $LOG_FILE
iostat -t -x >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "df -h" >> $LOG_FILE
df -h >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "mpstat 5 3" >> $LOG_FILE
/usr/bin/mpstat 5 3 >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "vmstat 5 3" >> $LOG_FILE
vmstat 5 3 >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "free -m -s 5 -c 3" >> $LOG_FILE
free -m -s 5 -c 3 >>$LOG_FILE
grep MemTotal /proc/meminfo >>$LOG_FILE
grep SwapTotal /proc/meminfo >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "IPCS data" >> $LOG_FILE
ipcs -l >> $LOG_FILE
echo " ---------------------------- " >> $LOG_FILE
ipcs -u >> $LOG_FILE
echo " ---------------------------- " >> $LOG_FILE
ipcs >> $LOG_FILE
echo " ---------------------------- " >> $LOG_FILE
ipcs -t >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
#####################################################################
### END OF SCRIPT ###
### Unix script os_stats.sh ###
### Designed to be run periodically to collate information ###
### START OF SCRIPT ###
#####################################################################
#
LOG_FILE="OS_`hostname`_`date '+%m%d%y_%H%M'`.txt"
#
echo "**********************************************" >$LOG_FILE
date >> $LOG_FILE
echo "Running as `id`" >> $LOG_FILE
echo "**********************************************" >>$LOG_FILE
echo "uname -a" >>$LOG_FILE
uname -a >>$LOG_FILE
cat /etc/issue >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "ulimit -a" >>$LOG_FILE
ulimit -a >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "ulimit -Ha" >>$LOG_FILE
ulimit -Ha >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "Netstat -i" >>$LOG_FILE
netstat -i >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "netstat -an">> $LOG_FILE
netstat -an >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "netstat -s">> $LOG_FILE
netstat -s >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "sar -u 5 3">> $LOG_FILE
sar -u 5 3 >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "sar -q 5 3">> $LOG_FILE
sar -q 5 3 >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "ps -e -w -o user,pid,ppid,s,pcpu,pmem,vsz,rss,stime,time,args" >> $LOG_FILE
ps -e -ww -o user,pid,ppid,s,pcpu,pmem,vsz,rss,stime,time,args >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "iostat -t -x" >> $LOG_FILE
iostat -t -x >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "df -h" >> $LOG_FILE
df -h >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "mpstat 5 3" >> $LOG_FILE
/usr/bin/mpstat 5 3 >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "vmstat 5 3" >> $LOG_FILE
vmstat 5 3 >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "free -m -s 5 -c 3" >> $LOG_FILE
free -m -s 5 -c 3 >>$LOG_FILE
grep MemTotal /proc/meminfo >>$LOG_FILE
grep SwapTotal /proc/meminfo >>$LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
echo "IPCS data" >> $LOG_FILE
ipcs -l >> $LOG_FILE
echo " ---------------------------- " >> $LOG_FILE
ipcs -u >> $LOG_FILE
echo " ---------------------------- " >> $LOG_FILE
ipcs >> $LOG_FILE
echo " ---------------------------- " >> $LOG_FILE
ipcs -t >> $LOG_FILE
echo "++++++++++++++++++++++++++++++++++++++++++++++++" >> $LOG_FILE
#####################################################################
### END OF SCRIPT ###
How to run SQL
scripts at DB level from OS level
$nohup
sqlplus '/ as sysdba' @script_name.sql &
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
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
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 -cvf newname.tar
directory_name (to tar)
tar -xvf filename.tar (to untar)
tar -xvf filename.tar (to untar)
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
--------------------------
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
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
####################################################################################################
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