HI All,
We have created one test database using prod backup to analysis the issue.
After creating database i not able to start that database.
I have seen below errors during the database startup.
Can i know what exactly the issue.
Is our Backup got corrupted ?
How to resolve this errors and start this database.
Please find below for steps we followed
Thu Jul 20 15:27:44 2017
15:27:44 prostrct create session begin for pgresdba on /dev/pts/2. (451)
15:27:45 prostrct create session end. (334)
Thu Jul 20 15:28:23 2017
15:28:23 procopy session begin for pgresdba on /dev/pts/2. (451)
15:28:24 procopy session end. (334)
Thu Jul 20 15:28:24 2017
15:28:24 procopy get default SQL DBA session begin for pgresdba on /dev/pts/2. (451)
15:28:24 procopy get default SQL DBA session end. (334)
Thu Jul 20 15:30:35 2017
15:30:35 prorest session begin for pgresdba on /dev/pts/2. (451)
15:30:41 Full restore started. (1368)
15:57:09 Full restore completed. (1369)
15:57:10 prorest session end. (334)
Thu Jul 20 16:08:18 2017
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.db is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d1 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d2 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d3 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d4 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d5 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d6 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d7 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d8 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d9 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d10 is on a remote device. (9466)
We have created one test database using prod backup to analysis the issue.
After creating database i not able to start that database.
I have seen below errors during the database startup.
Can i know what exactly the issue.
Is our Backup got corrupted ?
How to resolve this errors and start this database.
Please find below for steps we followed
Thu Jul 20 15:27:44 2017
15:27:44 prostrct create session begin for pgresdba on /dev/pts/2. (451)
15:27:45 prostrct create session end. (334)
Thu Jul 20 15:28:23 2017
15:28:23 procopy session begin for pgresdba on /dev/pts/2. (451)
15:28:24 procopy session end. (334)
Thu Jul 20 15:28:24 2017
15:28:24 procopy get default SQL DBA session begin for pgresdba on /dev/pts/2. (451)
15:28:24 procopy get default SQL DBA session end. (334)
Thu Jul 20 15:30:35 2017
15:30:35 prorest session begin for pgresdba on /dev/pts/2. (451)
15:30:41 Full restore started. (1368)
15:57:09 Full restore completed. (1369)
15:57:10 prorest session end. (334)
Thu Jul 20 16:08:18 2017
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.db is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d1 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d2 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d3 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d4 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d5 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d6 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d7 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d8 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d9 is on a remote device. (9466)
16:08:18 BROKER 0: File /progdata/bkup/test/prdcrn_tst.d10 is on a remote device. (9466)