We are aware RMAN plays an important role in backup strategies Today we are going to have a look “RMAN Incremental Backup”. Let’s have look on the steps. Create table for testing purpose SQL> create table sat(id number) tablespace test; Table created. Create a incremental backup with tag option RMAN> run { allocate channel c1 type […]
All posts by Anuradha Mudgal
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
As we are living the world of technology. Each and every second we can find that n number of user name and Password are created by the user. We as best DBA of the Globe. It is our ought too to maintain all credentials in the correct manner. Let’s have look on the steps to […]
RMAN Particular Datafile Backup
Let’s have look on the steps we use for “RMAN Particular Datafile Backup” Check the datafile SQL> select file_id,tablespace_name,file_name from dba_data_files; FILE_ID TABLESPACE_NAME FILE_NAME —————————————————————————————- 4 USERS D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\USERS01.DBF 3 SYSAUX D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\SYSAUX01.DBF 2 UNDOTBS1 D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\UNDOTBS01.DBF 1 SYSTEM D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\SYSTEM01.DBF 6 CHEC D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\CHECK01.DBF 5 TEST D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA01\TEST02.DBF 6 rows selected Create a dummy table and insert some records. SQL> […]
RMAN Recovery From Missing All Control File
Today we are going to have look on the steps are used for “RMAN Recovery From Missing All Control File”. Take a DBID SQL> select dbid from v$database; DBID ———- 847839442 Check the RMAN configuration RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO […]
RMAN Backup With Archivelog
RMAN plays an important role n Oracle RDBMS. Let’s have look on the steps are used by Oracle during the “RMAN Backup With Archivelog” RMAN> run { allocate channel c1 type disk; backup database; backup(archivelog all); } RMAN> backup archivelog all delete input; Note: This will backup all archivelog file and delete those from target location. If […]
ASMCMD-8102: no connection to ASM; command requires ASM to run
Let’s have a look on the steps which we use to resolve the issue “ASMCMD-8102: no connection to ASM; command requires ASM to run”. [grid@oraclehelpdb1 ~]$ asmcmd Connected to an idle instance. ASMCMD> ls ASMCMD-8102: no connection to ASM; command requires ASM to run Solution: [grid@oraclehelpdb1 ~]$ export ORACLE_HOME=/opt/grid/product/11.2.0.3/ [grid@oraclehelpdb1 ~]$ export PATH=/opt/grid/product/11.2.0.3/bin/ [grid@oraclehelpdb1 ~]$ […]
More New Features in Oracle Database 19c
The following are changes in Oracle Installation for Oracle Database release 19c. Root Scripts Automation Support for Oracle Database Installation Rapid Home Provisioning (RHP) Name Change Starting with Oracle Database 19c and Oracle Grid Infrastructure 19c, Rapid Home Provisioning is renamed to Fleet Patching and Provisioning (FPP). The following are changes in Oracle Database Data Warehousing for […]
New Features of Performance Tuning in Oracle Database 19c
The following are changes in Oracle Database Performance Tuning for Oracle Database Release 19c. Memoptimized Rowstore – Fast Ingest Automatic Database Diagnostic Monitor (ADDM) support for pluggable databases (PDBs) The following are changes in Oracle Database In-Memory for Oracle Database release 19. Database In-Memory wait on populate Big Data and performance enhancements for In-Memory external tables Hybrid partitioned […]
New Features of RAC & ASM in Oracle 19c
These are the new features for Oracle Automatic Storage Management 19c. SRVCTL command enhancements Flushing the password file metadata Automatic block corruption recovery with the CONTENT.CHECK disk group attribute New and updated ASMCMD commands The password option with the ASMCMD pwcreate command is now optional. The new ASMCMD setsparseparent command sets the parent for a sparse child file. The new ASMCMD mvfile command moves a […]
New Features of Data Guard in Oracle Database 19c
These are the changes in Oracle Data Guard Concepts and Administration for Oracle Database Release 19c. The process of flashing back a physical standby to a point in time that was captured on the primary is simplified by automatically replicating restore points from primary to the standby. When flashback or point-in-time recovery is performed on the primary […]