Oracle RMAN Question:
Download Job Interview Questions and Answers PDF
How to setup the physical stand by database with RMAN?
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.
$ 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 Question | Next Question |
What is auxiliary channel in RMAN? When do you need this? | How to enable the encryption for RMAN backups? |