Hi Dears, In this article, we will see Install Ubuntu 20.04.1 LTS On Windows.. Steps to Follow Download and Install Oracle VM VirtualBox Download Ubuntu 20.04.1 LTS Create New Virtual Machine Install Ubuntu 20.04.1 LTS in Virtual Machine Install Guest Additions 1. Download and Install… Read More
Hello Readers, In this article ,we will see how to a container database to the existing RMAN recovery catalog. Please check below article before adding container database to RMAN Catalog. How to Create an RMAN Recovery Catalog Target Database : … Read More
Dear Readers, In this article, we will see the following How to Get Instance Details By Using Boto3. Steps to Follow : Logging to AWS Account Launch Linux Server Connect to Linux EC2 Instance by Using Putty Install Python Package Install Boto3 Package Connect to… Read More
Hello Readers, In this article, we will see Recovery models in SQL Server. 1. Take backup of the primary database
|
1 2 3 4 5 6 7 8 9 10 |
run { allocate channel ch1 device type disk maxpiecesize 2G; allocate channel ch2 device type disk maxpiecesize 2G; backup incremental level 0 cumulative database format ='/rman/dbbackups/DB_BKP/full_%d_%T_df_%f_%s' tag 'INCREMENTAL LEVEL 0'; release channel ch1; release channel ch2; } allocate channel for maintenance type disk; delete noprompt obsolete device type disk; release channel; |
2. Create standby control file from primary database.
|
1 |
RMAN> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/ForStandbyCTRL.bck'; |
3. Transfer backup pieces along with control file from primary server to standby server.… Read More
Hello Readers, In this article, we will see Recovery models in SQL Server. SQL Server backup and restore operations occur within the context of the recovery model of the database. Recovery models are designed to control transaction log maintenance. A recovery model is a database… Read More
Hello Readers, In this article, we will see Creation of RMAN Recovery Catalog. Target Database : Catalog Database: Name : AVPROD … Read More
Dear Readers, In this article, we will see the Oracle : Important Commands for Dataguard (SecureCRT) Menubar Name : Dataguard Tab Name : Instance_info
|
1 2 3 4 5 6 7 |
set linesize 300 col machine for a60 select name||' - '||instance_name||'@'||host_name||' - '||DB_UNIQUE_NAME||' - '||version||' - '||open_mode||' - '||to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') || ' - '|| database_role from v$database, v$instance; NAME||'-'||INSTANCE_NAME||'@'||HOST_NAME||'-'||DB_UNIQUE_NAME||'-'||VERSION||'-'||OPEN_MODE||'-'||TO_CHAR(STARTUP_TIME,'DD-MON-YYYYHH24:MI:SS')||'-'||DATABASE_ROLE ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ORCLTEST - ORCLTEST1@SERVER1234.sephoraus.com - MSTORCLTEST - 12.1.0.2.0 - READ ONLY WITH APPLY - 04-FEB-2021 00:59:59 - PHYSICAL STANDBY |
Tab Name : DG_GAP
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH, (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1; select thread#,applied,max(sequence#) from gv$archived_log where resetlogs_change#=(select resetlogs_change# from v$database) group by thread#,applied order by thread#,applied; Thread Last Sequence Received Last Sequence Applied Difference ---------- ---------------------- --------------------- ---------- 1 44791 44791 0 2 42354 42354 0 3 40223 40223 0 SQL> THREAD# APPLIED MAX(SEQUENCE#) ---------- --------- -------------- 1 IN-MEMORY 44791 1 NO 39800 1 YES 44790 2 NO 38782 2 YES 42354 3 NO 38673 3 YES 40223 |
Tab Name : ERR_DEST
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
set linesize 300 col dest_name for a30 col error for a70 select dest_id,dest_name,status,error from v$archive_dest where dest_id in (1,2,3,4); select inst_id,dest_name,status,error from gv$archive_dest where dest_id in (1,2,3,4) and status='VALID' order by 1; DEST_ID DEST_NAME STATUS ERROR ---------- ------------------------------ --------- -------------- 1 LOG_ARCHIVE_DEST_1 VALID 2 LOG_ARCHIVE_DEST_2 INACTIVE 3 LOG_ARCHIVE_DEST_3 INACTIVE 4 LOG_ARCHIVE_DEST_4 DEFERRED SQL> INST_ID DEST_NAME STATUS ERROR ---------- ------------------------------ --------- -------------- 1 LOG_ARCHIVE_DEST_1 VALID |
Tab Name : Date Format
|
1 |
alter session set nls_date_format='MM/DD/YYYY HH24:MI:SS'; |
Tab Name :… Read More
Dear Readers, In this article, we will see the Autonomous Health Framework. AHF includes number of diagnostic tools in a single bundle and helps us to gather various types og information like upgrading info. , oracheck….. AHF combines Trace file analyzer(TFA), orachk etc.., which oracle… Read More
Dear Readers, In this article, we will see the Oracle : Important Queries for Parallel Feature (SecureCRT). Menubar Name : Parallel Tab Name : Create table show parameter parallel_max_servers
|
1 |
create table owner.tablename_bkp as select /*+ parallel(tablename,64) */ * from owner.tablename ; |
|
1 |
create table vinod.tablename_bkp as select /*+ parallel(EMP,4) */ * from SCOTT.EMP; |
Tab Name : Finding_Parallel_Queries
|
1 2 3 4 5 6 |
set linesize 300 col username for a19 col terminal for a15 col osuser for a15 col program for a45 col time for a25 |
|
1 2 3 4 5 6 7 8 9 |
select inst_id,sid,sql_id,program,username,to_char(LOGON_TIME,'DD-MON-YYYY HH24:MI:SS') time,TERMINAL,OSUSER from gv$session where program like '%P0%' and sql_id is not null; INST_ID SID SQL_ID PROGRAM USERNAME TIME TERMINAL OSUSER ---------- ---------- ------------- --------------------------------------------- ------------------- ------------------------- --------------- --------------- 1 58 29d991q9rq5kn oracle@awsserver003 (P000) SYS 27-FEB-2021 21:08:38 pts/1 oracle 1 59 29d991q9rq5kn oracle@awsserver003 (P001) SYS 27-FEB-2021 21:08:38 pts/1 oracle 2 37 29d991q9rq5kn oracle@awsserver004 (P001) SYS 27-FEB-2021 21:08:38 pts/1 oracle 2 207 29d991q9rq5kn oracle@awsserver004 (P000) SYS 27-FEB-2021 21:08:38 pts/1 oracle |
Tab Name : Select Query with Parallel Option… Read More
Dear Readers, In this article, we will see the Oracle: Important commands for Lock/Unlock Stats and Backup/Restore Old Stats (SecureCRT). MenuBar Name : Lock/Unlock Stats and Backup/Restore Old Stats Tab Name : Check Stats for Table
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
--example : 'DEPT','EMP','SALGRADE' set linesize 300 set pagesize 100 col owner for a15 col LAST_ANALYZED for a30 col table_name for a40 select OWNER,TABLE_NAME , NUM_ROWS , BLOCKS , EMPTY_BLOCKS , CHAIN_CNT, AVG_ROW_LEN CACHE, to_char(LAST_ANALYZED,'DD-MON-YYYY HH24:MI:SS') LAST_ANALYZED from dba_tables where table_name in (&Selected_Tables_Check_Example) and owner='&OWNER'; Enter value for selected_tables_check_example: 'TEST' Enter value for owner: VINOD old 4: from dba_tables where table_name in (&Selected_Tables_Check_Example) and owner='&OWNER' new 4: from dba_tables where table_name in ('TEST') and owner='VINOD' OWNER TABLE_NAME NUM_ROWS BLOCKS EMPTY_BLOCKS CHAIN_CNT CACHE LAST_ANALYZED --------------- ---------------------------------------- ---------- ---------- ------------ ---------- ---------- ------------------------------ VINOD TEST 2 5 0 0 3 18-FEB-2021 22:00:21 |
Tab Name : Backup Existing Stats
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
exec dbms_stats.create_stat_table ( ownname => 'VINOD',stattab => 'TEST_STAT'); exec dbms_stats.export_table_stats ( ownname => 'VINOD',stattab => 'TEST_STAT', tabname => 'TEST',statid => 'stats04252016'); select count(*) from vinod.TEST_STAT; SQL> exec dbms_stats.create_stat_table ( ownname => 'VINOD',stattab => 'TEST_STAT'); PL/SQL procedure successfully completed. SQL> exec dbms_stats.export_table_stats ( ownname => 'VINOD',stattab => 'TEST_STAT', tabname => 'TEST',statid => 'stats04252016'); PL/SQL procedure successfully completed. SQL> select count(*) from vinod.TEST_STAT; COUNT(*) ---------- 2 |
Tab… Read More
