Shahid's Oracle DBA Blog
Shahid DBA Blog Spot. Use this blog for the Oracle/SQL/DB2/Postgre Database Storage Management, Database Administrator, Task, RMAN, Dataguard, RAC,...
Read Shahiddba.blogspot.com news digest here: view the latest Shahid DBA Blog Spot articles and content updates right away or get to their most visited pages. Shahiddba.blogspot.com is not yet rated by Alexa and its traffic estimate is unavailable. It seems that Shahid DBA Blog Spot content is notably popular in USA. We haven’t detected security issues or inappropriate content on Shahiddba.blogspot.com and thus you can safely use it. Shahiddba.blogspot.com is hosted with Google LLC (United States) and its basic language is English.
Content verdict: Safe
Website availability: Stale
Language: English
Last check:
-
N/A
Visitors daily -
N/A
Pageviews daily -
N/A
Google PR -
N/A
Alexa rank
Best pages on Shahiddba.blogspot.com
-
Use this blog for the Oracle/SQL/DB2/Postgre Database Storage Management, Database Administrator, Task, RMAN, Dataguard, RAC, Claude, Toad, Oracle D2K
-
Shahid's Oracle DBA Blog: ORA-39070: Unable to open the log file (Datapump Error)
Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under DECLARATION: CAUTION: Own Risk. These scripts May or May not have been Tested.*** Thursd...
-
Shahid's Oracle DBA Blog: Install Oracle Developer Suite 10g on Windows 7 (64bit)
I installed it. It did worked. However after opening several times it would not fully open. Meaning the splash opens. I get to select the type of report. Wizard, build, open exist but after selecting...
Shahiddba.blogspot.com news digest
-
3 years
The following command archives all redo log file groups that are full but have not been archived.
SQL>Alter system archive log all;
In order to manually archive the online redo logs, the following statement must be executed in mount status: -
3 years
Whenever the database is altered, the control file should be backed up.
SQ>Alter database datafile 'DF' end backup
This command can be used to end the begin hot backup -
3 years
Adding NOT NULL column in a table
The following shows how to add in a table a new column that is NOT NULL when a table already has rows without providing a default value.
SQL> connect shahid1/ahmed@orcl3;
Connected. -
3 years
DBA interview Question with Answer Part 04
Why it is not necessary to take UNDO backup
In fact when you do some transaction, redo entries will be generated and accepted just like that whenever some change happen to UNDO tablespace or UNDO segments oracle will generate redo entries.
So even though you does not backup UNDO, you have the redo entries through which you can recover or rollback the transactions....
Domain history
| Web host: | Google LLC |
| Registrar: | MarkMonitor Inc. |
| Registrant: | Google LLC |
| Updated: | June 29, 2023 |
| Expires: | July 31, 2024 |
| Created: | July 31, 2000 |
Whois record
Safety scores
Trustworthiness
N/AChild safety
N/A
