Shell scripts are commonly used for automating repetitive tasks, managing system configurations, and executing sequences of commands. learning shell scripts is particularly advantageous in this situation. Here’s a straightforward method I used to monitor multiple databases simultaneously as part of my daily routine before commencing morning work. It involves utilizing shell scripts that I created! […]
To evaluate the space needed for the FRA. The amount of disk space to allocate for FRA depends on the size and activity levels of your database. Ideally, the FRA should be large enough for copies of your data and control files, as well as for flashbacks, online redo and archived logs needed to recover […]
This article shows the Step of Snapshot Standby on Oracle Database 11G. Mention They have downtime on the standby site. snapshot standby opens to read and write but does not apply archive if you want to apply you need to convert to physical standby and apply so when you enable standby to snapshot you can […]
This article shows how to open a database on Physical Standby (Read only with Apply or Active Data Guard) On Physical Standby SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/arch Oldest online log sequence 64 Next log sequence to archive 0 Current log sequence 64 SQL> select DBID,NAME,LOG_MODE,OPEN_MODE,SWITCHOVER#,DATABASE_ROLE,SWITCHOVER_STATUS,DATAGUARD_BROKER,GUARD_STATUS,DB_UNIQUE_NAME […]
This article shows the Step of switchover from Physical standby to primary database on Oracle Database 11G. Mention They have downtime actually do at primary first Step Check the archive and role database on both sites (Primary and Standby) Switchover (start with the primary) Test a little bit of Transaction on the New Primary Switchover […]
Example SQL> select file_name,tablespace_name from dba_temp_files; FILE_NAME TABLESPACE_NAME —————————————- —————— /home/oracle/oradata/DB11G/temp01.dbf TEMP SQL> alter tablespace temp add tempfile ‘/home/oracle/oradata/DB1121G/temp01.dbf’size 200m; Tablespace altered. SQL> select file_name,tablespace_name from dba_temp_files; FILE_NAME TABLESPACE_NAME —————————————- ——————- /home/oracle/oradata/DB1121G/temp01.dbf TEMP /home/oracle/oradata/DB11G/temp01.dbf TEMP SQL> SQL> alter tablespace temp drop tempfile ‘/home/oracle/oradata/DB11G/temp01.dbf’; Tablespace altered. SQL> select file_name,tablespace_name from dba_temp_files; FILE_NAME TABLESPACE_NAME —————————————- ——————– /home/oracle/oradata/DB1121G/temp01.dbf […]
Renaming and Relocating Datafiles You can rename the datafile and change locate but be careful about data will be lost you can see these steps below. ***For undotbs tablespace and system tablespace, if you want to relocate or rename, you’ll have downtime*** Renaming Step ***Only Renaming alter tablaespace xxx offline; mv or cp datafile that […]
steps to rename and relocate, they have a lot of ways to do so this blog gonna show you, How to rename and relocate redo log file without downtime. if you want to rename or add a member to redo log file, I suggest this step because it’s without downtime. Example You can check the […]
You can rename and relocate them, but actually, they have downtime because control_files is an initial parameter. SQL> show parameter control NAME TYPE VALUE ———————————— ———– —————————— control_file_record_keep_time integer 7 control_files string /home/oracle/oradata/DB11G/con trol01.ctl, /home/oracle/flash _recovery_area/DB11G/control02 .ctl control_management_pack_access string DIAGNOSTIC+TUNING SQL> select name from v$controlfile NAME ——————————————————- /home/oracle/oradata/DB11G/control01.ctl /home/oracle/flash_recovery_area/DB11G/control02.ctl SQL> shutdown immediate; Database closed. Database […]
nid is the utility of oracle for changing the DBID and DB name but the datafile name is not changed. These topics and the primary conditions of each topic Changing the DBID and Database Name After finishing this task, You have to change DB_NAME in the initialization parameter and open the database with resetlogs. Changing […]
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| 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 |