Database Administrator's blog: Restore RMAN RAC Backup to Another RAC server

In this article we are showing how to restore RMAN RAC backup to another RAC server:

Step-1: start database in nomount

oracle@drpweb1 [/home/oracle]$rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Nov 2 14:37:46 2016

connected to target database (not started)

RMAN>

RMAN> startup nomount pfile='/u02/app/oracle/product/11.2.0.4.0/dbhome_1/dbs/initdcpdb1.ora';

Oracle instance started

Total System Global Area 5127602176 bytes

Fixed Size 2214432 bytes

Variable Size 2936014304 bytes

Database Buffers 2181038080 bytes

Redo Buffers 8335360 bytes

RMAN>

Step-2: Restore control file from backup.

RMAN> restore controlfile from '/db_rmanbackup/t24_ctl_1_2812_021120160933.bkp';

Starting restore at 02-NOV-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=16 instance=dcpdb1 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:05

output file name=+REDO/dcpdb/controlfile/current.262.926865547

output file name=+CONTROL/dcpdb/controlfile/current.262.926865547

Finished restore at 02-NOV-16

RMAN>

Step-3: Database mount

RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

RMAN>

Step-4: To let RMAN know about the backup in /db_rmanbackup, we use the CATALOG command.

RMAN> catalog start with '/db_rmanbackup';

Starting implicit crosscheck backup at 02-NOV-16

allocated channel: ORA_DISK_1

Crosschecked 822 objects

Finished implicit crosscheck backup at 02-NOV-16

Starting implicit crosscheck copy at 02-NOV-16

using channel ORA_DISK_1

Crosschecked 284 objects

Finished implicit crosscheck copy at 02-NOV-16

searching for all files in the recovery area

cataloging files...

no files cataloged

searching for all files that match the pattern /db_rmanbackup

no files found to be unknown to the database

RMAN>

Step-5: Restore and Recover database

RMAN> run{

2> SET NEWNAME FOR DATAFILE 1 TO '+DATA';

3> SET NEWNAME FOR DATAFILE 2 TO '+DATA';

4> SET NEWNAME FOR DATAFILE 3 TO '+DATA';

5> SET NEWNAME FOR DATAFILE 4 TO '+DATA';

6> SET NEWNAME FOR DATAFILE 5 TO '+DATA';

7> SET NEWNAME FOR DATAFILE 6 TO '+DATA';

8> SET NEWNAME FOR DATAFILE 7 TO '+DATA';

9> SET NEWNAME FOR DATAFILE 8 TO '+DATA';

10> SET NEWNAME FOR DATAFILE 9 TO '+DATA';

11> SET NEWNAME FOR DATAFILE 10 TO '+DATA';

12> SET NEWNAME FOR DATAFILE 11 TO '+DATA';

13> SET NEWNAME FOR DATAFILE 12 TO '+DATA';

14> SET NEWNAME FOR DATAFILE 13 TO '+DATA';

15> SET NEWNAME FOR DATAFILE 14 TO '+DATA';

16> SET NEWNAME FOR DATAFILE 15 TO '+DATA';

17> SET NEWNAME FOR DATAFILE 16 TO '+DATA';

18> SET NEWNAME FOR DATAFILE 17 TO '+DATA';

19> SET NEWNAME FOR DATAFILE 18 TO '+DATA';

20> SET NEWNAME FOR DATAFILE 19 TO '+DATA';

21> SET NEWNAME FOR DATAFILE 20 TO '+DATA';

22> SET NEWNAME FOR DATAFILE 21 TO '+DATA';

23> SET NEWNAME FOR DATAFILE 22 TO '+DATA';

24> SET NEWNAME FOR DATAFILE 23 TO '+DATA';

25> SET NEWNAME FOR DATAFILE 24 TO '+DATA';

26> SET NEWNAME FOR DATAFILE 25 TO '+DATA';

27> SET NEWNAME FOR DATAFILE 26 TO '+DATA';

28> SET NEWNAME FOR DATAFILE 27 TO '+DATA';

29> SET NEWNAME FOR DATAFILE 28 TO '+DATA';

30> restore database;

31> switch datafile all;

recover database;

32> 33> }

executing command: SET NEWNAME

Starting restore at 02-NOV-16

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00005 to +DATA

channel ORA_DISK_1: restoring datafile 00011 to +DATA

channel ORA_DISK_1: restoring datafile 00018 to +DATA

channel ORA_DISK_1: restoring datafile 00025 to +DATA

channel ORA_DISK_1: reading from backup piece /db_rmanbackup/t24_db_1_2807_021120160933.bkp

channel ORA_DISK_1: piece handle=/db_rmanbackup/t24_db_1_2807_021120160933.bkp tag=T24_DB_021120160933

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 01:57:37

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00009 to +DATA

channel ORA_DISK_1: restoring datafile 00016 to +DATA

channel ORA_DISK_1: restoring datafile 00023 to +DATA

channel ORA_DISK_1: restoring datafile 00028 to +DATA

channel ORA_DISK_1: reading from backup piece /db_rmanbackup/t24_db_1_2805_021120160933.bkp

channel ORA_DISK_1: piece handle=/db_rmanbackup/t24_db_1_2805_021120160933.bkp tag=T24_DB_021120160933

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 01:59:02

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to +DATA

channel ORA_DISK_1: restoring datafile 00007 to +DATA

channel ORA_DISK_1: restoring datafile 00014 to +DATA

channel ORA_DISK_1: restoring datafile 00021 to +DATA

channel ORA_DISK_1: reading from backup piece /db_rmanbackup/t24_db_1_2810_021120160933.bkp

channel ORA_DISK_1: piece handle=/db_rmanbackup/t24_db_1_2810_021120160933.bkp tag=T24_DB_021120160933

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 01:56:52

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00003 to +DATA

channel ORA_DISK_1: restoring datafile 00012 to +DATA

channel ORA_DISK_1: restoring datafile 00019 to +DATA

channel ORA_DISK_1: restoring datafile 00026 to +DATA

channel ORA_DISK_1: reading from backup piece /db_rmanbackup/t24_db_1_2808_021120160933.bkp

channel ORA_DISK_1: piece handle=/db_rmanbackup/t24_db_1_2808_021120160933.bkp tag=T24_DB_021120160933

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 01:59:52

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00008 to +DATA

channel ORA_DISK_1: restoring datafile 00015 to +DATA

channel ORA_DISK_1: restoring datafile 00022 to +DATA

channel ORA_DISK_1: restoring datafile 00027 to +DATA

channel ORA_DISK_1: reading from backup piece /db_rmanbackup/t24_db_1_2804_021120160933.bkp

channel ORA_DISK_1: piece handle=/db_rmanbackup/t24_db_1_2804_021120160933.bkp tag=T24_DB_021120160933

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 02:03:33

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00002 to +DATA

channel ORA_DISK_1: restoring datafile 00006 to +DATA

channel ORA_DISK_1: restoring datafile 00013 to +DATA

channel ORA_DISK_1: restoring datafile 00020 to +DATA

channel ORA_DISK_1: reading from backup piece /db_rmanbackup/t24_db_1_2809_021120160933.bkp

channel ORA_DISK_1: piece handle=/db_rmanbackup/t24_db_1_2809_021120160933.bkp tag=T24_DB_021120160933

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 02:22:04

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00004 to +DATA

channel ORA_DISK_1: restoring datafile 00010 to +DATA

channel ORA_DISK_1: restoring datafile 00017 to +DATA

channel ORA_DISK_1: restoring datafile 00024 to +DATA

channel ORA_DISK_1: reading from backup piece /db_rmanbackup/t24_db_1_2806_021120160933.bkp

channel ORA_DISK_1: piece handle=/db_rmanbackup/t24_db_1_2806_021120160933.bkp tag=T24_DB_021120160933

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 02:28:18

Finished restore at 03-NOV-16

datafile 1 switched to datafile copy

input datafile copy RECID=181 STAMP=926918984 file name=+DATA/dcpdb/datafile/system.273.926879947

datafile 2 switched to datafile copy

input datafile copy RECID=182 STAMP=926918985 file name=+DATA/dcpdb/datafile/sysaux.285.926901565

datafile 3 switched to datafile copy

input datafile copy RECID=183 STAMP=926918985 file name=+DATA/dcpdb/datafile/undotbs1.277.926886959

datafile 4 switched to datafile copy

input datafile copy RECID=184 STAMP=926918985 file name=+DATA/dcpdb/datafile/users.289.926910089

datafile 5 switched to datafile copy

input datafile copy RECID=185 STAMP=926918985 file name=+DATA/dcpdb/datafile/undotbs2.265.926865745

datafile 6 switched to datafile copy

input datafile copy RECID=186 STAMP=926918985 file name=+DATA/dcpdb/datafile/nblt24data.282.926901561

datafile 7 switched to datafile copy

input datafile copy RECID=187 STAMP=926918985 file name=+DATA/dcpdb/datafile/nblt24data.270.926879943

datafile 8 switched to datafile copy

input datafile copy RECID=188 STAMP=926918985 file name=+DATA/dcpdb/datafile/nblt24data.278.926894147

datafile 9 switched to datafile copy

input datafile copy RECID=189 STAMP=926918985 file name=+DATA/dcpdb/datafile/nblt24index.266.926872801

datafile 10 switched to datafile copy

input datafile copy RECID=190 STAMP=926918985 file name=+DATA/dcpdb/datafile/nblt24data.286.926910085

datafile 11 switched to datafile copy

input datafile copy RECID=191 STAMP=926918986 file name=+DATA/dcpdb/datafile/nblt24data.262.926865741

datafile 12 switched to datafile copy

input datafile copy RECID=192 STAMP=926918986 file name=+DATA/dcpdb/datafile/nblt24data.274.926886955

datafile 13 switched to datafile copy

input datafile copy RECID=193 STAMP=926918986 file name=+DATA/dcpdb/datafile/nblt24data.283.926901563

datafile 14 switched to datafile copy

input datafile copy RECID=194 STAMP=926918986 file name=+DATA/dcpdb/datafile/nblt24data.271.926879945

datafile 15 switched to datafile copy

input datafile copy RECID=195 STAMP=926918986 file name=+DATA/dcpdb/datafile/nblt24data.279.926894149

datafile 16 switched to datafile copy

input datafile copy RECID=196 STAMP=926918986 file name=+DATA/dcpdb/datafile/nblt24data.267.926872803

datafile 17 switched to datafile copy

input datafile copy RECID=197 STAMP=926918986 file name=+DATA/dcpdb/datafile/nblt24data.287.926910087

datafile 18 switched to datafile copy

input datafile copy RECID=198 STAMP=926918986 file name=+DATA/dcpdb/datafile/nblt24data.263.926865743

datafile 19 switched to datafile copy

input datafile copy RECID=199 STAMP=926918986 file name=+DATA/dcpdb/datafile/nblt24data.275.926886957

datafile 20 switched to datafile copy

input datafile copy RECID=200 STAMP=926918986 file name=+DATA/dcpdb/datafile/nblt24data.284.926901563

datafile 21 switched to datafile copy

input datafile copy RECID=201 STAMP=926918987 file name=+DATA/dcpdb/datafile/nblt24data.272.926879945

datafile 22 switched to datafile copy

input datafile copy RECID=202 STAMP=926918987 file name=+DATA/dcpdb/datafile/nblt24data.280.926894151

datafile 23 switched to datafile copy

input datafile copy RECID=203 STAMP=926918987 file name=+DATA/dcpdb/datafile/nblt24data.268.926872805

datafile 24 switched to datafile copy

input datafile copy RECID=204 STAMP=926918987 file name=+DATA/dcpdb/datafile/nblt24data.288.926910087

datafile 25 switched to datafile copy

input datafile copy RECID=205 STAMP=926918987 file name=+DATA/dcpdb/datafile/nblt24data.264.926865743

datafile 26 switched to datafile copy

input datafile copy RECID=206 STAMP=926918987 file name=+DATA/dcpdb/datafile/nblt24data.276.926886959

datafile 27 switched to datafile copy

input datafile copy RECID=207 STAMP=926918987 file name=+DATA/dcpdb/datafile/nblt24data.281.926894153

datafile 28 switched to datafile copy

input datafile copy RECID=208 STAMP=926918987 file name=+DATA/dcpdb/datafile/nblt24index.269.926872805

Starting recover at 03-NOV-16

using channel ORA_DISK_1

starting media recovery

Oracle Error:

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '+DATA/dcpdb/datafile/system.273.926879947'

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 11/03/2016 05:29:56

RMAN-06053: unable to perform media recovery because of missing log

RMAN-06025: no backup of archived log for thread 2 with sequence 29278 and starting SCN of 19558130718 found to restore

RMAN-06025: no backup of archived log for thread 2 with sequence 29277 and starting SCN of 19556996286 found to restore

RMAN-06025: no backup of archived log for thread 2 with sequence 29276 and starting SCN of 19555585581 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 29533 and starting SCN of 19558528830 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 29532 and starting SCN of 19557621920 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 29531 and starting SCN of 19556730851 found to restore

RMAN-06025: no backup of archived log for thread 1 with sequence 29530 and starting SCN of 19555585633 found to restore

RMAN>

Copy above archivelog (thread 2 with sequence 29278 , thread 2 with sequence 29277, thread 2 with sequence 29276, thread 1 with sequence 29533, thread 1 with sequence 29532, thread 1 with sequence 29531, thread 1 with sequence 29530) to following new RAC server directory +FRA/DCPDB/archivelog/. After copy archivelog RECOVER DATABASE from RMAN. /fra/fast_recovery_area/REMITDB/archivelog/2016_05

Step-6: Copy following archivelog to specified destination

6.1 Copy Archive log from ASM to File System (172.xx.xx.17)

ASMCMD> cp thread_2_seq_29276.2143.926850451 /u01/grid/seq_29276.bak

copying +fra/dcpdb/ARCHIVELOG/2016_11_02/thread_2_seq_29276.2143.926850451 -> /u01/grid/seq_29276.bak

ASMCMD>

ASMCMD> cp thread_2_seq_29277.909.926851881 /u01/grid/seq_29277.bak

copying +fra/dcpdb/ARCHIVELOG/2016_11_02/thread_2_seq_29277.909.926851881 -> /u01/grid/seq_29277.bak

ASMCMD>

ASMCMD> cp thread_2_seq_29278.1497.926853021 /u01/grid/seq_29278.bak

copying +fra/dcpdb/ARCHIVELOG/2016_11_02/thread_2_seq_29278.1497.926853021 -> /u01/grid/seq_29278.bak

ASMCMD>

Copy Archive log from ASM to File System (172.xx.xx.15)

ASMCMD>

ASMCMD> cp thread_1_seq_29530.2118.926850057 /u01/oraclesoft/seq_29530.bak

copying +fra/dcpdb/archivelog/2016_11_02/thread_1_seq_29530.2118.926850057 -> /u01/oraclesoft/seq_29530.bak

ASMCMD>

ASMCMD> cp thread_1_seq_29531.848.926851257 /u01/oraclesoft/seq_29531.bak

copying +fra/dcpdb/archivelog/2016_11_02/thread_1_seq_29531.848.926851257 -> /u01/oraclesoft/seq_29531.bak

ASMCMD>

ASMCMD> cp thread_1_seq_29532.2814.926852359 /u01/oraclesoft/seq_29532.bak

copying +fra/dcpdb/archivelog/2016_11_02/thread_1_seq_29532.2814.926852359 -> /u01/oraclesoft/seq_29532.bak

ASMCMD>

ASMCMD> cp thread_1_seq_29533.2639.926853019 /u01/oraclesoft/seq_29533.bak

copying +fra/dcpdb/archivelog/2016_11_02/thread_1_seq_29533.2639.926853019 -> /u01/oraclesoft/seq_29532.bak

ASMCMD>

6.2 Archivelog transfer to Specified server

grid@dcpdb2 [/u01/grid]$

grid@dcpdb2 [/u01/grid]$ scp seq* grid@172.xx.xxx.26:/u01/grid

The authenticity of host '172.31.200.26 (172.xx.xxx.26)' can't be established.

ECDSA key fingerprint is 09:14:29:aa:83:c6:df:68:28:94:56:e8:0e:b0:db:3d.

Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added '172.xx.xxx.26' (ECDSA) to the list of known hosts.

Password:

seq_29276.bak 100% 582MB 32.3MB/s 34.4MB/s 00:18

seq_29277.bak 100% 582MB 30.6MB/s 34.4MB/s 00:19

seq_29278.bak 100% 561MB 31.1MB/s 35.6MB/s 00:18

grid@dcpdb2 [/u01/grid]$

grid@dcpdb1 [/u01/oraclesoft]$ scp seq* grid@172.xx.xxx.26:/u01/grid

The authenticity of host '172.31.200.26 (172.xx.xxx.26)' can't be established.

ECDSA key fingerprint is 09:14:29:aa:83:c6:df:68:28:94:56:e8:0e:b0:db:3d.

Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added '172.xx.xxx.26' (ECDSA) to the list of known hosts.

Password:

seq_29530.bak 100% 582MB 34.2MB/s 34.0MB/s 00:17

seq_29531.bak 100% 581MB 30.6MB/s 34.9MB/s 00:19

seq_29532.bak 100% 594MB 31.3MB/s 36.1MB/s 00:19

seq_29533.bak 100% 381MB 34.7MB/s 36.1MB/s 00:11

grid@dcpdb1 [/u01/oraclesoft]$

6.3 Copy archivelog to specified destination

ASMCMD>

ASMCMD> cp /u01/grid/seq_29276.bak +fra/dcpdb/ARCHIVELOG/

copying /u01/grid/seq_29276.bak -> +fra/dcpdb/ARCHIVELOG/seq_29276.bak

ASMCMD> cp /u01/grid/seq_29277.bak +fra/dcpdb/ARCHIVELOG/

copying /u01/grid/seq_29277.bak -> +fra/dcpdb/ARCHIVELOG/seq_29277.bak

ASMCMD>

ASMCMD> cp /u01/grid/seq_29278.bak +fra/dcpdb/ARCHIVELOG/

copying /u01/grid/seq_29278.bak -> +fra/dcpdb/ARCHIVELOG/seq_29278.bak

ASMCMD>

ASMCMD> cp /u01/grid/seq_29530.bak +fra/dcpdb/ARCHIVELOG/

copying /u01/grid/seq_29530.bak -> +fra/dcpdb/ARCHIVELOG/seq_29530.bak

ASMCMD>

ASMCMD> cp /u01/grid/seq_29531.bak +fra/dcpdb/ARCHIVELOG/

copying /u01/grid/seq_29531.bak -> +fra/dcpdb/ARCHIVELOG/seq_29531.bak

ASMCMD>

ASMCMD> cp /u01/grid/seq_29532.bak +fra/dcpdb/ARCHIVELOG/

copying /u01/grid/seq_29532.bak -> +fra/dcpdb/ARCHIVELOG/seq_29532.bak

ASMCMD>

ASMCMD> cp /u01/grid/seq_29533.bak +fra/dcpdb/ARCHIVELOG/

copying /u01/grid/seq_29533.bak -> +fra/dcpdb/ARCHIVELOG/seq_29533.bak

ASMCMD>

Step-7: Recover database

oracle@drpweb1 [/db_rmanbackup]$

oracle@drpweb1 [/db_rmanbackup]$rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Nov 3 14:37:55 2016

connected to target database: DCPDB (DBID=400141228, not open)

RMAN> recover database;

Starting recover at 03-NOV-16

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=403 instance=dcpdb1 device type=DISK

starting media recovery

archived log for thread 1 with sequence 29530 is already on disk as file +FRA/dcpdb/archivelog/seq_29530.bak

archived log for thread 1 with sequence 29531 is already on disk as file +FRA/dcpdb/archivelog/seq_29531.bak

archived log for thread 1 with sequence 29532 is already on disk as file +FRA/dcpdb/archivelog/seq_29532.bak

archived log for thread 1 with sequence 29533 is already on disk as file +FRA/dcpdb/archivelog/seq_29533.bak

archived log for thread 2 with sequence 29276 is already on disk as file +FRA/dcpdb/archivelog/seq_29276.bak

archived log for thread 2 with sequence 29277 is already on disk as file +FRA/dcpdb/archivelog/seq_29277.bak

archived log for thread 2 with sequence 29278 is already on disk as file +FRA/dcpdb/archivelog/seq_29278.bak

archived log file name=+FRA/dcpdb/archivelog/seq_29530.bak thread=1 sequence=29530

archived log file name=+FRA/dcpdb/archivelog/seq_29276.bak thread=2 sequence=29276

archived log file name=+FRA/dcpdb/archivelog/seq_29531.bak thread=1 sequence=29531

archived log file name=+FRA/dcpdb/archivelog/seq_29277.bak thread=2 sequence=29277

archived log file name=+FRA/dcpdb/archivelog/seq_29532.bak thread=1 sequence=29532

archived log file name=+FRA/dcpdb/archivelog/seq_29278.bak thread=2 sequence=29278

archived log file name=+FRA/dcpdb/archivelog/seq_29533.bak thread=1 sequence=29533

unable to find archived log

archived log thread=1 sequence=29534

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 11/03/2016 14:43:24

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 29534 and starting SCN of 19559123857

Note: We can ignore that error as RMAN has applied all the available archivelog files and It is now trying to apply a non-existent archive log file.

RMAN>

Step-7: Database open at RESETLOGS

oracle@drpweb1 [/home/oracle]$

oracle@drpweb1 [/home/oracle]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 3 14:48:19 2016

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL>

SQL> alter database open resetlogs;

Database altered.

SQL>

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ WRITE

SQL>

SQL> select inst_name from v$active_instances;

INST_NAME

--------------------------------------------------------------------------------

drpweb1:dcpdb1

SQL>

Database Administrator's blog

Pages

Sunday, November 6, 2016

Restore RMAN RAC Backup to Another RAC server

No comments:

Post a Comment