Let’s have look on the steps used for Cold Backup and Recovery From Archivelog. Check the archive log status SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 6 Current log sequence 8 Enable the archive logs SQL> shutdown immediate; Database closed. Database dismounted. […]
All posts by Anuradha Mudgal
Anuradha Mudgal
Cold Backup with Rman in Oracle
Today we are going to have look on Cold Backup. Being DBA we are aware of the importance of Backup in Oracle. Different kind of backup has a different kind of uses. Let’s have look on Cold Backup. Steps for Cold Backup SQL> create table cold_back(name varchar(100)); Table created. SQL> insert into cold_back values(‘********* DATA INSERTED […]
RMAN Recovery From Missing All Control File
Today we are going to have look on the steps which are used by “DBA” for RMAN Recovery From Missing All Control File. SQL> select dbid from v$database; DBID ———- 847839442 RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default […]
RMAN Backup With Archivelog
This post is about how to take 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 a target location. If we physically delete some archivelog file before backup then we have […]
Delete applied archivelog script
We need to delete archivelogs which are applied on standby servers. Following script will do the job for you. vi /home/oracle/crons/remove_applied_archivelog.sh #!/bin/ksh # # # Remove applied archivelog all; # # ORACLE_SID=ORCL; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1; export ORACLE_HOME tmpfile=/tmp/arch_id.tmp $ORACLE_HOME/bin/sqlplus -S /nolog <<EOF > $tmpfile connect / as sysdba set head off set […]
Catalog Database in RMAN
Purpose of Catalog Database A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. A virtual private catalog is a set of synonyms and views that enable user access to a subset of a base recovery catalog. Catalog Database can be two types Base recovery catalog Virtual […]
Basic of RMAN Backup and Recovery Scenario
Backup and recovery is a common task in DBA’s Daily Routine. Let’s have looked over the process to take backup of Oracle database and know about the process to recover the database. Check the archive log status SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log […]
RMAN Time Based Recovery
RMAN is the most useful tool for Oracle in DBA’s life. Today’s post is about “RMAN Time Based Recovery”. Let’s have look on the steps. First, take the full backup. RMAN> run { allocate channel c1 device type disk; allocate channel c2 device type disk; backup database and archivelog all delete input; } Create a […]
Advantage Of RMAN in Oracle
This post is for those who are new in “Oracle RDBMS”, Being a part of Oracle technology in Database. “RMAN” plays an important part in “Backup&Recovery”. “RMAN” has its own benefits. Let’s have looked over the “RMAN” benefits. RMAN helps to DBA have incremental where only modified data blocks will be copied It integrity checks for the […]
TNS-12547: TNS:lost contact
Being DBA we all are aware that we must have knowledge of OS level too because Database not just runs over the only one OS. In a different organization, we have a different OS. Being a part if IT we understand that different OS environment has a different parameter. We have to set them. Today […]