Find Command usage

Hi

find . -size +100000 -exec ls -ltr {} \; -------------- with date
find . -size +100000 -mtime +60 -exec ls -ltr {} \; --------------- older then 60 days
find ./. -name "core*" -mtime +90 -type f -exec gzip {} \; ---------------- ZIP file older then 90 dayes with name like : core
find / -name aler*.log ------- alertlog file
find / -name creamp_hot_backup.ksh find file name on filesystem
find . -name '*.aud' -exec ls -lrt {} \; -------------- list from / all audit files
find . -name \*.gz -mtime +150 -exec ls -lrt {} \; delete file with aud older then 15 days
find / -name *.sh -------------- to find .sh script
find /orcl/app/oracle/diag/asm/+asm/+ASM1/trace -type f -mtime +3 -exec ls -lrt {} \; ---------> will list file older the 3 days at that mount point.
find . -name \*+ASM1_ora* -mtime +3 -exec rm {} \; --------------------------- > WILL REMOVE FROM THAT DIRECTORY OLDER THEN 3 DAYS WITH NAME +asm
find / -name *GCRPB ----------- To find profie
find / -name *GCRPB_profile --------------- or databasename_profile
find *.sh file
find / -name *.sh 2>/dev/null
w/o permission declined msg...
more /app/clarity/var/tmp/cmdb/data/stdout.kbVVYW|head -10 -------------will show top 10 files
ls -tlr /app/clarity/var/tmp/cmdb/data|grep oracle|wc -l -------------> will give count of files
find /orcl -name emctl -type f 2>/tmp/null ------------------------> find agent and 2>/tmp/null _------> means go to no where
find / -name emctl -type f 2>/tmp/null ------------------> generic from root
nohup find . -name '*.aud' -mtime +3 -exec rm -rf {} \; & ------------> to delete audit files keepign retention of 3 days

Thanks,
sujan

Basic unix commands

Unix/Linux Command Reference
File Commands
1. ls Directory listing
2. ls -al Formatted listing with hidden files
3. ls -lt Sorting the Formatted listing by time modification
4. cd dir Change directory to dir
5. cd Change to home directory
6. pwd Show current working directory
7. mkdir dir Creating a directory dir
8. cat >file Places the standard input into the file
9. more file Output the contents of the file
10. head file Output the first 10 lines of the file
11. tail file Output the last 10 lines of the file
12. tail -f file Output the contents of file as it grows,starting with
the last 10 lines
13. touch file Create or update file
14. rm file Deleting the file
15. rm -r dir Deleting the directory
16. rm -f file Force to remove the file
17. rm -rf dir Force to remove the directory dir
18. cp file1 file2 Copy the contents of file1 to file2
19. cp -r dir1 dir2 Copy dir1 to dir2;create dir2 if not present
20. mv file1 file2 Rename or move file1 to file2,if file2 is an existing
directory
21. ln -s file link Create symbolic link link to file
Process management
1. ps To display the currently working processes
2. top Display all running process
Unix/Linux Command Reference
3. kill pid Kill the process with given pid
4. killall proc Kill all the process named proc
5. pkill pattern Will kill all processes matching the pattern
6. bg List stopped or background jobs,resume a stopped
job in the background
7. fg Brings the most recent job to foreground
8. fg n Brings job n to the foreground
File permission
1. chmod octal file Change the permission of file to octal,which can
be found separately for user,group,world by
adding,
• 4-read(r)
• 2-write(w)
• 1-execute(x)
Searching
1. grep pattern file Search for pattern in file
2. grep -r pattern dir Search recursively for pattern in dir
3. command | grep
pattern
Search pattern in the output of a command
4. locate file Find all instances of file
5. find . -name filename Searches in the current directory (represented by
a period) and below it, for files and directories with
names starting with filename
6. pgrep pattern Searches for all the named processes , that
matches with the pattern and, by default, returns
their ID
System Info
1. date Show the current date and time
2. cal Show this month's calender
3. uptime Show current uptime
4. w Display who is on line
5. whoami Who you are logged in as
Unix/Linux Command Reference
6. finger user Display information about user
7. uname -a Show kernel information
8. cat /proc/cpuinfo Cpu information
9. cat proc/meminfo Memory information
10. man command Show the manual for command
11. df Show the disk usage
12. du Show directory space usage
13. free Show memory and swap usage
14. whereis app Show possible locations of app
15. which app Show which applications will be run by default
Compression
1. tar cf file.tar file Create tar named file.tar containing file
2. tar xf file.tar Extract the files from file.tar
3. tar czf file.tar.gz files Create a tar with Gzip compression
4. tar xzf file.tar.gz Extract a tar using Gzip
5. tar cjf file.tar.bz2 Create tar with Bzip2 compression
6. tar xjf file.tar.bz2 Extract a tar using Bzip2
7. gzip file Compresses file and renames it to file.gz
8. gzip -d file.gz Decompresses file.gz back to file
Network
1. ping host Ping host and output results
2. whois domain Get whois information for domains
3. dig domain Get DNS information for domain
4. dig -x host Reverse lookup host
5. wget file Download file
6. wget -c file Continue a stopped download
Unix/Linux Command Reference
Shortcuts
1. ctrl+c Halts the current command
2. ctrl+z Stops the current command, resume with fg in the
foreground or bg in the background
3. ctrl+d Logout the current session, similar to exit
4. ctrl+w Erases one word in the current line
5. ctrl+u Erases the whole line
6. ctrl+r Type to bring up a recent command
7. !! Repeats the last command
8. exit Logout the current session
Unix/Linux Command Reference

Thanks

Switchover please please follw in order wise

Hi,

I had attached the two doctuments for doing switchover .

first to make

1. switch over to standby
2. then we have to do switchover to primary.

Thanks

1. Switch over to standby:

1. For doing switch over We have to check the primary and standby must be in sync
2. and check we had a propoer backup  for the database so that if anything goes wrong it would be helpful
3. We can make two standby at a time . but we can t make two primaries at a time if that happens maximum times we have to rebuild dr database.
4. Need to check the prarameters to be same on both primary and standby
5. Take a backup of services , stat jobs, partisions jobs , if these kind of jobs are there we have to comment for a while and make sure that we enable after switch over.
6. Basic step first we have to make primary to standby and then standby to primary.
7. On DR side we have to bring the alll instances down except the one mrp is runing on the rac environment.


SQL> select host_name,open_mode,database_role from gv$instance;
SQL> shut immediate [shut down on node2, node3]
SQL> select host_name,open_mode,database_role from gv$instance;
need to check whether FLASH BACK is enabled or not
SQL> sho parameter flash
SQL> create restore point restorepointname guarantee flashback database; [after 11g databases if it is below create restore point restorepointname;]
SQL> select * from v$restore_point;
once the switchover completes successfully we have to make sure the restore point has to be removed.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

SQL> shut immediate [on node1]
and
SQL> startup mount [on threee nodes]

*******************
droping restore point
SQL> drop restore point restorepointname;
if some thing goes wrong and we have to bring
SQL> flashback to restorepointname;



2. Switch over to primary:

1. For doing switch over We have to check the primary and standby must be in sync
2. and check we had a propoer backup  for the database so that if anything goes wrong it would be helpful
3. We can make two standby at a time . but we can t make two primaries at a time if that happens maximum times we have to rebuild dr database.
4. Need to check the prarameters to be same on both primary and standby
5. Take a backup of services , stat jobs, partisions jobs , if these kind of jobs are there we have to comment for a while and make sure that we enable after switch over.
6. Basic step first we have to make primary to standby and then standby to primary.
7. On DR side we have to bring the alll instances down except the one mrp is runing on the rac environment.


SQL> select host_name,open_mode,database_role from gv$instance;
SQL> shut immediate [shut down on node2, node3] except the one mrp is running.
SQL> select host_name,open_mode,database_role from gv$instance;
need to check whether FLASH BACK is enabled or not
SQL> sho parameter flash
SQL> create restore point restorepointname guarantee flashback database; [after 11g databases if it is below create restore point restorepointname;]
SQL> select * from v$restore_point;
once the switchover completes successfully we have to make sure the restore point has to be removed.
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;

once all these completes we have to make sure backups and jobs are started and validate services.
start the MRP on DR side and check the sync with primary.


SQL> alter database open; on all the nodes
*******************
droping restore point
SQL> drop restore point restorepointname;
if some thing goes wrong and we have to bring
SQL> flashback to restorepointname;

Thanks,

Creting DB Manually

Hi

For Creating db manually.we need to know the first the three different modes to bring db up.

NOMOUNT background processes are started based on reading the spfile MOUNT control files are opened and read OPEN data files are opened

NOMOUNT background processes are started based on reading the spfile MOUNT control files are opened and read OPEN data files are opened

NOMOUNT background processes are started based on reading the spfile MOUNT control files are opened and read OPEN data files are opened

NOMOUNT background processes are started based on reading the spfile MOUNT control files are opened and read OPEN data files are opened

NOMOUNT background processes are started based on reading the spfile MOUNT control files are opened and read OPEN data files are opened

Nomount state -- backgroup process wll be started up based on pfile/spfile
Mount state     -- control files are opened and read
open mode      -- datafiles should be open

syntax:
********************
startup nomount
startup mount
startup
********************
alter database mount;
alter database open;
alter database open read only;


Steps to create a database manually:
___________________________

1. Create a pfile initSID.ora and copy to the location $ORACLE_HOME/dbs/initSID.ora
        cp initsid.ora $ORACLE_HOME/dbs/initsid.ora

2. we nned to create a passwd file before starting up the db
$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/pwd<sid>.ora password=oracle entries=

3. sqlplus / as sysdba
        SQL> startup nomount;

4. now we have to issue the create database comand

create database test

logfile group 1 ('/path/to/redo1.log') size 100M,

            group 2 ('/path/to/redo2.log') size 100M,

            group 3 ('/path/to/redo3.log') size 100M

character set WE8ISO8859P1

national character set utf8

datafile '/path/to/system.dbf' size 500M autoextend on next 10M maxsize unlimited extent management local

sysaux datafile '/path/to/sysaux.dbf' size 100M autoextend on next 10M maxsize unlimited

undo tablespace undotbs1 datafile '/path/to/undotbs1.dbf' size 100M

default temporary tablespace temp tempfile '/path/to/temp01.dbf' size 100M;

Note: there's some other things you can do here, like "ARCHIVELOG" "SET TIME_ZONE =" and "USER SYS IDENTIFIED BY password" and "USER SYSTEM IDENTIFIED BY password"

Link:
http://www.dba-oracle.com/oracle_create_database.htm

creating Oracle db using DBCA

Hi

We can create database using the tool DBCA (Database Base management configuration Assistant ) and we can create manually by using linux box.

Creating Oracle Database using DBCA:

The vedio has been provided above we create this database. using this We can create the database easeily

General cause for creating db failure is:
1. Need to check the services of oracle in services.msc
2. DB Name or database files that already has beens
3. OS level permission errors

In Windows :

To launch DBCA:

1. Log on to your computer as a member of the administrative group that is authorized to install Oracle software and create and run the database.
2. To launch DBCA on a Windows operating system, click Start and then select Programs, Oracle - home_name, Configuration and Migration Tools, and then Database Configuration Assistant.

In Unix:

1. To launch the DBCA on UNIX, or as another method on a Windows operating system, enter the following command at a system prompt:

2. dbca
   

Link for further clarification:

http://docs.oracle.com/cd/B16276_01/doc/server.102/b14196/install003.htm