Oracle : Shell script for RMAN backup of Standby Database In this article, we wrote an automation job for Shell script for RMAN backup of Standby Database The below script will be initiating the RMAN backup on the standby database: RMAN Script : [oracle@tewnposqa1 scripts]$… Read More
Dear Readers, Please check the below articles to get good knowledge on RMAN (Recovery Manager). SNO Article Name Article Link 1 How to add Container database to Existing RMAN Recovery catalog https://www.ktexperts.com/how-to-add-container-database-to-existing-rman-recovery-catalog/ 2 How to Create an RMAN Recovery Catalog https://www.ktexperts.com/how-to-create-an-rman-recovery-catalog/ 3 Cloning a Standalone… Read More
Hello Readers, In this article ,we will see how to a container database to the existing RMAN recovery catalog. Please check below article before adding container database to RMAN Catalog. How to Create an RMAN Recovery Catalog Target Database : … Read More
Hello Readers, In this article, we will see Creation of RMAN Recovery Catalog. Target Database : Catalog Database: Name : AVPROD … Read More
Cloning a Standalone database using RMAN Backup pieces I am making this article to create copy of current PROD database in another server using RMAN backup pieces for testing and development purposes. i have used a simple method to perform clone database. Server details :… Read More
In this article you will get to know the step by step installation of Recovery Catalog Database Using RMAN utility. By default, RMAN connects to the target database in NOCATALOG mode, meaning that it uses the control files in the target database as the sole… Read More
PERFORMING RMAN CLONING ON DIFFERENT SERVERS In this article we will implement RMAN Cloning on different servers.
|
1 2 3 4 |
Server 1 : PRIMARY Ip Address : 192.168.0.101 Instance name : Primary Database Name : Primary |
|
1 2 3 4 |
Server 2 : Clone server Ip Address : 192.168.0.102 Instance name : clone_pr Database Name : clone_pr |
Server 1 : Check instance information on server 1
|
1 2 3 4 |
SYS>>select name||' - '||instance_name||'@'||host_name||' - '||DB_UNIQUE_NAME||' - '||version||' - '||open_mode||' - '||to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') || ' - '|| database_role from v$database, v$instance; NAME||'-'||INSTANCE_NAME||'@'||HOST_NAME||'-'||DB_UNIQUE_NAME||'-'||VERSION||'-'||OPEN_MODE||'-'||TO_CHAR(STARTUP_TIME,'DD-MON-YYYYHH24:MI:SS')||'-'||DATABASE_ROLE ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- PRIMARY - PRIMARY@primary.orcl.com - prod_stand - 12.1.0.2.0 - READ WRITE - 25-APR-2019 20:49:24 - PRIMARY |
Check schema report by connecting RMAN
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
[oracle@primary ~]$ rman target / Recovery Manager: Release 12.1.0.2.0 - Production on Mon Apr 29 20:07:30 2019 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: PROD (DBID=1836049007) RMAN> report schema; using target database control file instead of recovery catalog Report of database schema for database with db_unique_name PROD_STAND List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 300 SYSTEM YES /u01/oradata/primary/system.dbf 2 310 SYSAUX NO /u01/oradata/primary/sysaux.dbf 3 100 UNDOTBS1 YES /u01/oradata/primary/undotbs.dbf 4 150 USERDATA NO /u01/oradata/primary/userdata.dbf 5 10 TEST NO /u01/oradata/primary/test.dbf 6 10 DMTS1 NO /u01/oradata/primary/dmts1.dbf 7 10 DMTS2 NO /u01/oradata/primary/dmts2.dbf 8 10 TS_2K NO /u01/oradata/primary/ts_2k.dbf 9 50 TS1 NO /u01/oradata/primary/ts1.dbf List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 100 TEMP1 100 /u01/oradata/primary/temp1.dbf |
Check archive-log
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
[oracle@primary ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 29 20:09:43 2019 Copyrght (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SYS>>archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/oradata/primary/arch Oldest online log sequence 157 Next log sequence to archive 158 Current log sequence 158 |
Shutdown the database and keep database… Read More
Dear Readers, In this article, we will see the following RMAN Commands in Oracle 12c. RECOVERY MANAGER(RMAN) COMMANDS. In this article , we will see all the best practices of RMAN commands. Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup… Read More
Oracle: Scheduling Rman backup jobs through DBMS_SCHEDULER. In this article we will learn how to schedule RMAN backup jobs through DBMS_SCHEDULER. Before reading this article Please check previous article on DBMS_SCHEDULER. Oracle: Scheduler Jobs in Oracle Database Step 1 : Create the Script That Invokes RMAN Create… Read More
Dear Readers, In this article, we will see the following RMAN Enhancements in Oracle 12c. 1.SQL Interface Improvements In Oracle 12c, you can run SQL commands in RMAN without preceding the command with the SQL keyword. You also no longer need to enclose the SQL… Read More
