RMAN
Schedule Rman L0 backup
Schedule Rman L1 backup
Schedule Rman L1c backup
Schedule Rman Archive backup.
Work order #
Work order Title
Environment
FR000083 Please do the DR-DRILL
SOURCE : VDSCP -[Link]
TARGET : VDSCP - [Link]
TIME : CHANGE THE DATE AND TIME BASED ON TIME STAMP OF SNAP SHOT CONTROL FILE.
DR-DRILL
Database name: VDSCP
--------
STEP 1: Once login into dr server, change the color and banner.
--------
-------
STEP 2: Create the new directory under /home/oracle
-------
mkdir JANDR2024
mkdir -p /u01/app/oracle/admin/vdscp/adump
mkdir -p /u02/oradata/vdscp/
[root@vdsrm ~]# mkdir -p /u02/FRA/vdscp
[root@vdsrm ~]# chown oracle:oinstall /u02/FRA/vdscp
-----
STEP 3: by using pfile or spfile, we need to startup at nomount state.
Add entries in /etc/oratab
vdscp:/u01/app/oracle/product/[Link]/dbhome_01:N
[oracle@vdsrm ~]$ sqlplus / as sysdba
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1090519040 bytes
Fixed Size 2923440 bytes
Variable Size 822084688 bytes
Database Buffers 251658240 bytes
Redo Buffers 13852672 bytes
SQL>
--------
STEP 4: Find the snap control file using rman SHOW ALL
-------
show all
or
find -name snapcf_vdscp.f -print 2>/dev/null
/u01/app/oracle/product/[Link]/dbhome_01/dbs
oracle@vdscp[/u01/app/oracle/admin]$ ls -ltr
total 69136
-rw-r----- 1 oracle dba 35397632 Sep 26 11:07 snapcf_vdscp.f
-------
STEP 5: Restore control file using snapshot control file.
--------
RMAN TARGET /
run
{
restore controlfile from
'/u01/app/oracle/product/[Link]/dbhome_01/dbs/snapcf_vdscp.f';
alter database mount;
}
---------
STEP 6: Here we are creating two scripts.
-----------
[oracle@vdsrm JANDR2024]$ cat rman_restore_vdscp.sh
export ORACLE_SID=vdscp
export ORACLE_HOME=/u01/app/oracle/product/[Link]/dbhome_01
$ORACLE_HOME/bin/rman cmdfile=/home/oracle/JANDR2024/rman_restore_vdscp.cmd
log=/home/oracle/JANDR2024/rman_restore_vdscp.log
[oracle@vdsrm JANDR2024]$ cat rman_restore_vdscp.cmd
connect target /
run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
set until time "to_date('2024-01-[Link]', 'yyyy-mm-dd:hh24:mi:ss')";
restore database;
recover database;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
-------
STEP 7: Once the above two files are saved, run the below command.
-------
nohup /home/oracle/JANDR2024/rman_restore_vdscp.sh &
--------
STEP 8: Once the restore is completed, open the database with reset logs.
--------
ALTER DATABASE OPEN RESETLOGS;
***********************************************************************************
************
FR000084 Please do the DR-DRILL
SOURCE : VDSCAP -[Link]
TARGET : VDSCAP - [Link]
TIME : CHANGE THE DATE AND TIME BASED ON TIME STAMP OF SNAP SHOT CONTROL FILE.
DR-DRILL
FR000085 Please do the DR-DRILL
SOURCE : DBWORXZ -[Link]
TARGET : DBWORXZ - [Link]
TIME : CHANGE THE DATE AND TIME BASED ON TIME STAMP OF SNAP SHOT CONTROL FILE.
DR-DRILL
***********************************************************************************
***********************
FR000086 ---Please refresh the data from VDSCP database to [Link] server
with latest production backup.
Do not use duplicate command
SOURCE : VDSCP -[Link]
TARGET : VDSCP [Link] Cloning
***********************************************************************************
************************************************
FR000087 Please refresh the data from VDSCU database to [Link] server.
Do not use duplicat command
TIME : SET UNTIL 05-08-2019 [Link]
SOURCE : VDSCU -[Link]
TARGET : VDSCU [Link]. Cloning
FR000088 Please refresh the VDCAP database to [Link] server with latest
production backup. Do not use duplicate command.
SOURCE : VDSCAP -[Link]
TARGET : VDSCAP [Link]. Cloning
FR000089 Please refresh the DBWORXZ database to [Link] server with
duplicate command.
SOURCE : DBWORXZ
TARGET : DBWORXZ [Link] Cloning
FR000090 Please refresh the VDSCAU database to [Link] server with
duplicate command.
SOURCE : VDSCAU -[Link]
TARGET : VDSCAU [Link]. Cloning
FR000091 Please refresh the VDSCP database to VDSCD server with duplicate
command.
SOURCE : VDSCP -[Link]
TARGET : VDSCD [Link] Cloning
FR000092 Please refresh the VDSCAP database to VDSCAD server with duplicate
command.
Cloning
FR000093 Please refresh the DBWORXZ database to VDSRD server with duplicate
command.
Cloning
FR000094 most imp interview q --Some one dropped the table in production
database. How to recover it ?????? DBWORXZ
FR000095 RMAN RECOVER TABLE in Oracle Database 12c. DBWORXZ
FR000096 How To Recover From A Drop/Truncate/Delete Table Done On Primary Using
Flashback On A Standby Database VDSCP
FR000097 How to do database recovery if database is not running archive log mode
or Archvie logs are not available for complete recovery. VDSCD