SAPTechArena

shutdown databaseSQL> shutdown immediate;startup database in mount modeSQL> startup mount;Change DB log modeSQL> alter database archivelog;Open DB for normal useSQL> alter database open;check archivelog statusSQL> archive log listDefault Archive log destination.1. 10g introduce new feature called FRA (flashback recovery area) so all archivelog files created in FRA.2....

# sqlplus '/as sysdba' SQL> startup nomount SQL> alter database mount standby database; Cheking ps -ef|grep ora       -- that oracle processes has been started On source db run :SQL>alter system switch logfile;      Cheking Alert log file for successfully starting Oeracle.Starting standby database  with...

To add a tempfile into the mounted  opened Oracle db:SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE'/oracle/SID/sapdata1/temp_1/temp.data1' size 32000M reuse; SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE'/oracle/SID/sapdata2/temp_2/temp.data2' size 32000M reuse; SQL> ALTER TABLESPACE PSAPTEMP ADD TEMPFILE'/oracle/SID/sapdata3/temp_3/temp.data3' size 32000M reuse; SQL>...

In Oracle the entity "user" and entity "schema" are same  if  provided user has created at least one object in it. Login in sqlplus as sys To list all schemas: SQL> SELECT username FROM all_users ORDER BY username; SQL> Select username from dba_users; Will give you list of all users but all users may not have created objects in it. So we...

Select  how to check all tables from schema with table sizes. SELECT /*+ PARALLEL(dba_segments,16) */ owner,        segment_name,        segment_type,        tablespace_name,        round(SUM (bytes) / POWER (2, 20), 1) size_gb       ...

procedure for applying redolog files in Oracle db.  sqlplus '/as sysdba'RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;Choose files for applying after last file enter CANCEL ALTER DATABASE OPEN RESETLOGS; Checking that resetlogs were applyed correctlySELECT * FROM "any_small_table"; SHUTDOWN IMMEDIATE; STARTU...

Sometimes it is useful to check report runtime via sqlplus when you have a date timestamp . It can be set by set time on command.thru sqlplus command prompt .SQL> set time on 11:30:01 SQL> 11:33:30 SQL> also, you may omit SQL prompt perfix entry 11:33:30 SQL> set sqlprompt > 11:33:37 > 11:33:38 >...

To delete a job: Go to Transaction SM37. Select a job (or jobs) from the Select Background Jobs screen. In the Job Overview, mark the job or jobs you want to delete by checking the box to the left of the job name. Choose Job --> Delete.Deleting Jobs That Have Dependent Jobs:If you delete a job that must be processed before another job can be started, the dependent job can no longer...