Oracle RMAN Question:

Download Job Interview Questions and Answers PDF

How to setup the physical stand by database with RMAN?

RMAN Interview Question
RMAN Interview Question

Answer:

$ Export ORACLE_SID=TEST
$ rman target /
RMAN> show all;
Using target database controlfile instead of recovery catalog RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'I:Oracle_Backups%d_%F.rman';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'I:Oracle_Backups%d_%s_%p.rman';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'E:ORACLEORA92DATABASESNCFTEST.ORA';
2. Backup the current production database to create a standby database: RMAN> backup database include current controlfile for standby plus archivelog;


3. Manually copy the backup sets from I:Oracle_Backups on the production server to I:Oracle_Backups on the DR Server (location of backups must match on both production and DR).
4. On the DR Server start up the TEST database in nomount mode:
$ set ORACLE_SID=TEST
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> startup nomount
SQL> exit


5. Create the standby database using RMAN (This assumes the database file structures will be identical on both servers):
$ RMAN target ‘sys/fluffy@STTEST’ auxiliary /
RMAN> duplicate target database for standby nofilenamecheck dorecover;

6. Once the DR database is created; you will need to manually add a tempfile:
SQL> alter database open read only;
SQL> alter tablespace temp add tempfile ‘F:Oracle-DatabasesTESTTEMP01.DBF’ size 500M;

7. Put the DR database into managed standby mode:
SQL> shutdown immediate
SQL> startup nomount
SQL> alter database mount standby database;
SQL> alter database recover managed standby database disconnect;

8. On the production database switch logs to initiate replication:
SQL> alter system switch logfile;
The configuration of Dataguard is now complete.

Download RMAN Interview Questions And Answers PDF

Previous QuestionNext Question
What is auxiliary channel in RMAN? When do you need this?How to enable the encryption for RMAN backups?