Hi ALL,
11gR1
OL6
We have rman backup from our PROD server.
Then I test restore it to our DR server.
Steps done on DR server.
1. restore controlfile from backup
2. restore database
But this step 2 part took so long (3 days now and l no activity showing on the server)
Please help how to check if there is hanging process?
[root@drdb ~]# su - oraprod
[oraprod@drdb ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 20 17:46:07 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 6413680640 bytes
Fixed Size 2265224 bytes
Variable Size 1979715448 bytes
Database Buffers 4412407808 bytes
Redo Buffers 19292160 bytes
Database mounted.
[oraprod@drdb ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Jul 20 17:47:33 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=310452097, not open)
RMAN> restore database;
Starting restore at 20-JUL-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1402 device type=DISK
skipping datafile 37; already restored to file /home/oraprod/PROD/data/a_int03.dbf
skipping datafile 38; already restored to file /home/oraprod/PROD/data/a_txn_ind07.dbf
skipping datafile 40; already restored to file /home/oraprod/PROD/data/a_txn_data05.dbf
skipping datafile 42; already restored to file /home/oraprod/PROD/data/a_txn_data06.dbf
skipping datafile 46; already restored to file /home/oraprod/PROD/data/sysaux04.dbf
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 /home/oraprod/PROD/data/system01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /home/oraprod/PROD/data/system03.dbf
channel ORA_DISK_1: restoring datafile 00005 to /home/oraprod/PROD/data/system05.dbf
channel ORA_DISK_1: restoring datafile 00012 to /home/oraprod/PROD/data/apps_ts_tools01.dbf
channel ORA_DISK_1: restoring datafile 00013 to /home/oraprod/PROD/data/system12.dbf
channel ORA_DISK_1: restoring datafile 00015 to /home/oraprod/PROD/data/a_txn_ind06.dbf
channel ORA_DISK_1: restoring datafile 00016 to /home/oraprod/PROD/data/a_ref03.dbf
channel ORA_DISK_1: restoring datafile 00020 to /home/oraprod/PROD/data/system14.dbf
channel ORA_DISK_1: restoring datafile 00022 to /home/oraprod/PROD/data/system16.dbf
channel ORA_DISK_1: restoring datafile 00024 to /home/oraprod/PROD/data/system18.dbf
channel ORA_DISK_1: restoring datafile 00026 to /home/oraprod/PROD/data/system20.dbf
channel ORA_DISK_1: restoring datafile 00028 to /home/oraprod/PROD/data/system22.dbf
channel ORA_DISK_1: restoring datafile 00030 to /home/oraprod/PROD/data/system24.dbf
channel ORA_DISK_1: restoring datafile 00032 to /home/oraprod/PROD/data/a_ref04.dbf
channel ORA_DISK_1: restoring datafile 00034 to /home/oraprod/PROD/data/a_ref06.dbf
channel ORA_DISK_1: restoring datafile 00036 to /home/oraprod/PROD/data/sysaux03.dbf
channel ORA_DISK_1: restoring datafile 00045 to /home/oraprod/PROD/data/ctxd02.dbf
channel ORA_DISK_1: restoring datafile 00314 to /home/oraprod/PROD/data/portal01.dbf
channel ORA_DISK_1: restoring datafile 00351 to /home/oraprod/PROD/data/system07.dbf
channel ORA_DISK_1: restoring datafile 00379 to /home/oraprod/PROD/data/undo01.dbf
channel ORA_DISK_1: restoring datafile 00394 to /home/oraprod/PROD/data/a_ref01.dbf
channel ORA_DISK_1: restoring datafile 00395 to /home/oraprod/PROD/data/a_int01.dbf
channel ORA_DISK_1: restoring datafile 00398 to /home/oraprod/PROD/data/a_archive01.dbf
channel ORA_DISK_1: restoring datafile 00399 to /home/oraprod/PROD/data/a_queue01.dbf
channel ORA_DISK_1: restoring datafile 00400 to /home/oraprod/PROD/data/a_media01.dbf
channel ORA_DISK_1: restoring datafile 00401 to /home/oraprod/PROD/data/a_txn_data02.dbf
channel ORA_DISK_1: restoring datafile 00405 to /home/oraprod/PROD/data/a_txn_ind04.dbf
channel ORA_DISK_1: restoring datafile 00406 to /home/oraprod/PROD/data/a_txn_ind05.dbf
channel ORA_DISK_1: restoring datafile 00407 to /home/oraprod/PROD/data/a_ref02.dbf
channel ORA_DISK_1: reading from backup piece /home/FRA/PROD/backupset/2017_07_16/o1_mf_nnndf_TAG20170716T001345_dpnhstvv_.bkp
Kind regards,
jc