After the storage administrator provides you with the disk for the database and presents the disk to the server, you want to stamp the disks as ASMLIB disks using the oracleasm command. All options to the oracleasm script that are not read-only actions require root privileges to execute. Such options include commands to configure, create, […]
oracle
How to add or drop redo log groups in Oracle RAC
redo in RAC environment In RAC, each instance has a redo thread; when you start the instance, it mounts one and only one thread. Therefore if you want to add logs or increase the size, you must do it for each thread. The goal is normally to have the same number and size of logs […]
How to Clear a Redo Log file in Oracle Database
What is the Redo Log? Redo Logs consist of two or more pre-allocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has associated online redo logs to protect the database in case of an instance failure. Redo log files are filled with redo records. A […]
How to find daily and hourly archive log generation in Oracle Database
Redo Logs consist of two or more pre-allocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has associated online redo logs to protect the database in case of an instance failure. Redo log files are filled with redo records. A redo record also called a […]
How to Perform Manual Archiving in Oracle Database
You can configure your database for manual archiving only. To operate your database in manual archiving mode, follow the procedure below: 1. Shut down the database instance. SQL> SHUTDOWN An open database must first be closed and any associated instances shut down before you can switch the database archiving mode. You cannot change the mode […]
How to find redo log members/redo log file size/redo log status
Redo Logs consist of two or more pre-allocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has associated online redo logs to protect the database in case of an instance failure. Redo log files are filled with redo records. A redo record also called a […]
How to Move tables and indexes to a different tablespace
Today, I got a request from the application team to separate tables & indexes on tablespace level. We can move the indexes & tables to separate tablespaces using the below query. ALTER TABLE [TABLE_NAME] MOVE TABLESPACE TEST_TBL; ALTER INDEX [INDEX_NAME] REBUILD TABLESPACE TEST_TBL; Above queries are possible to move 1 to 2 indexes & tables, […]
How to find the Character set of Oracle Database
What is a database character set? The NLS_CHARACTERSET of an Oracle database defines what characters can be stored in the database using the CHAR, VARCHAR2, LONG and CLOB datatypes. A Character set does not define languages, it defines a certain range of characters. Any language that uses the characters known by that characterset can then […]
What are the .lok files used in WebLogic
Question: There are several files with a .lok extension in the WebLogic Server (WLS) domain directory. What are these files used for? There are config.lok, EmbeddedLDAP.lok and XXXserver.lok files which are used by the admin server and managed server. Another lock file named edit.lok is used for the admin server only. Why are .lok files […]
How to Restore and Recover files over network in Oracle 12c
Steps to Restoring and Recovering Files Over the Network: Primary DB = chicago, its net service name is chicago Standby DB = boston, its net service name is boston You want to restore lost data files, control files, or tablespaces on a primary database using the corresponding files on the physical standby database. You can […]