Oracle_Dba

-:Oracle Database into a Quiesced State:- Quiesce restricted lets you safely update code and DDL in the database without shutting down and kicking everyone out. ALTER SYSTEM QUIESCE RESTRICTED; select active_state from v$instance; ACTIVE_ST --------- QUIESCED -:Restoring the System to Normal Operation:- ALTER SYSTEM UNQUIESCE; select active_state from v$instance; ACTIVE_ST --------- NORMAL -:Viewing the Quiesce State of an Instance:- You can query the ACTIVE_STATE column of the V$INSTANCE view to see the current state of an instance. The column values has one of these values: NORMAL: Normal unquiesced state. QUIESCING: Being quiesced, but some non-DBA sessions are still active. QUIESCED: Quiesced; no non-DBA sessions are active or allowed. Source. http://docs.oracle.com/cd/B28359_01/server.111/b28310/start004.htm

Hi All a quick discussion on SMON  Important Oracle Background Process. - SMON stands for system monitor process. -SMON is the heart of oracle architecture.It monitors the activities of all background process. - It is a mandatory background process for running an Oracle instance. - It performs recovery (rollback & rollforward), especially at instance startup. -It checks the space of SYSTEM tablepace and if it is running short of it displays an error message. -It also removes the unwanted data from UNDO after commit after the time interval specified by UNDO_RETENTION parameter. - Also responsible for cleaning up TEMPORARY segments that are no longer in use. - coalesces contiguous areas of free space. - In RAC, the SMON process of one instance can perform instance recovery for a failed CPU or instance as well. - To view its running, grep it on Linux: ps -ef | grep smon Thanks Ghufran

      Flashback New Features and Enhancements in Oracle Database Flashback Query Flashback Version Query Flashback Transaction Query Flashback Table Flashback Drop (Recycle Bin) Flashback Query Flashback Query allows the contents of a table to be queried with reference to a specific point in time, using the AS OF clause. Essentially it is the same as the DBMS_FLASHBACK functionality of Oracle9i, but in a more convenient form. For example: CREATE TABLE flashback_query_test (   id   NUMBER(10) ); SELECT current_scn, TO_CHAR(SYSTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') FROM v$database; CURRENT_SCN TO_CHAR(SYSTIMESTAM ---------------------   ------------------------------------      722452               2004-03-29 13:34:12 INSERT INTO flashback_query_test (id) VALUES (1); COMMIT; SELECT COUNT(*) FROM flashback_query_...

WHAT IS BACKUP AND RECOVERY IN ORACLE ·         Backup Strategy -           Whole DB backup -           Partial DB backup ·         Backup Type -           Full DB backup -           Incremental DB Backup ·         Backup Mode -           Online( Inconsistent ) DB backup -           Offline ( Closed/Consistent ) DB Backup Consistent and Inconsistent Backups A consistent backup is one in which the files being backed up contain all changes up to the same system change number (SCN) . This means that the files in the backup contain all the data taken from a same point in time. Unlike an inconsist...