Duplicate DB Issue with Set until time (merged) [message #581712] |
Wed, 10 April 2013 02:01 |
saagar
Messages: 79 Registered: December 2007
|
Member |
|
|
Hi all
i have taken HOT backup of DB on disk
and log says
-rw-r----- 1 oracle oinstall 35127296 Apr 9 19:45 cf_20130409_XXXX_11378_XXXXX_aftback.ctl
this show timestamp that control file has 9th Apr 2013 time 19:45 ...
Now when doing duplication
i set the parameter until_time like this
set until time "to_date('09-Apr-2013 19:42:00','DD-MON-YYYY HH24:MI:SS')";
duplicate target database to XXXX nofilenamecheck;
My Question is ... is this the correct way please let me know
|
|
|
|
Re: Duplicate DB Issue [message #581717 is a reply to message #581715] |
Wed, 10 April 2013 02:27 |
saagar
Messages: 79 Registered: December 2007
|
Member |
|
|
hi michel
control file is taken last when all database and archivelogs are backup
that is why this timestamp i got from log
then please suggest me what time should i put then
Regards
|
|
|
|
Cannot recovery Set until time [message #603615 is a reply to message #581712] |
Wed, 18 December 2013 00:23 |
saagar
Messages: 79 Registered: December 2007
|
Member |
|
|
Hi all
i want to do a set until time recovery while duplication .
last control file was taken backup on 16-dec-2013 at 23:08
duplication is looking for previous backup rather than looking recent ones .
Once i removed set until time command then i was proceed for duplication
Here is the code .
before that on unix command i gave nls format also
export NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'
run {
set until time "to_date('16-Dec-2013 23:08:00','DD-MON-YYYY HH24:MI:SS')";
allocate auxiliary channel ch1 type disk;
allocate auxiliary channel ch2 type disk;
allocate auxiliary channel ch3 type disk;
duplicate target database to XXXX nofilenamecheck;
release channel ch1;
release channel ch2;
release channel ch3;
}
Can any one please guide through this .
Regards
|
|
|
|
|
|
|
|
|
Re: Duplicate DB Issue [message #603628 is a reply to message #581726] |
Wed, 18 December 2013 01:36 |
saagar
Messages: 79 Registered: December 2007
|
Member |
|
|
Hi Micheal
please accept my apologies for the duplication thread i made in forum.
on continuation of topic i am adding further below.
i have used this command and before that i have set nls date format also .
run {
set until time "to_date('16-Dec-2013 23:08:00','DD-MON-YYYY HH24:MI:SS')";
allocate auxiliary channel ch1 type disk;
allocate auxiliary channel ch2 type disk;
allocate auxiliary channel ch3 type disk;
duplicate target database to XXXX nofilenamecheck;
release channel ch1;
release channel ch2;
release channel ch3;
}
Do i need to mention in that run block to restore control file .
restore controlfile from '/nfs/Tp_cntl_20131217_XXXXX_14183_1.ctl';
then set until time for the duplication command ?
Regards
|
|
|
|
|
|
|
|
|
|
|
|
Re: Cannot recovery Set until time [message #603755 is a reply to message #603738] |
Thu, 19 December 2013 02:22 |
saagar
Messages: 79 Registered: December 2007
|
Member |
|
|
Hi Micheal
Sorry cannot provide listing for execution of script bcos the log file got deleted .
I use this script .
run {
set until time "to_date('17-Dec-2013 23:08:00','DD-MON-YYYY HH24:MI:SS')";
allocate auxiliary channel ch1 type disk;
allocate auxiliary channel ch2 type disk;
allocate auxiliary channel ch3 type disk;
duplicate target database to XXXX nofilenamecheck;
release channel ch1;
release channel ch2;
release channel ch3;
}
to refresh my database but after firing this script RMAN is looking out not recent backup instead looking out for older backups.
suggest me or correct me , should i first restore controlfile by restore controlfile from '/nfs/Tp_cntl_20131217_XXXXX_14183_1.ctl';
and in earlier above that run block and go ahead with refresh so that my database is refreshed and is in read,write mode or any other way .
Regards
|
|
|
|
Re: Cannot recovery Set until time [message #603794 is a reply to message #603757] |
Thu, 19 December 2013 08:28 |
saagar
Messages: 79 Registered: December 2007
|
Member |
|
|
Hi Micheal,
Apologies,cannot give KEYS for old backup pieces .
Attached backup list was the recent HOT RMAN Disk backup, while refresh RMAN should be looking for this not for the old backup pieces .
BS KEYS are 12966, 12967,12968,12969,12970,12971,12972,12985,12986,12987,12988,12989,12990,12991,12992,
12993,12994,12995 these are recent HOT RMAN Disk backup.
Does the above script is correct to refresh Database so that auxiliary database is recovered and is in read write mode when refresh is finished.
Regards
|
|
|
|
Re: Cannot recovery Set until time [message #604007 is a reply to message #603804] |
Sun, 22 December 2013 11:49 |
saagar
Messages: 79 Registered: December 2007
|
Member |
|
|
Hi Micheal
Here the HOT BACKUP of my Database .
-rw-r----- 1 oracle oinstall 26112 Dec 21 02:52 s9os1kvk_1_1
-rw-r----- 1 oracle oinstall 852847104 Dec 21 02:56 s4os1kvj_1_1
-rw-r----- 1 oracle oinstall 895366656 Dec 21 02:57 s7os1kvk_1_1
-rw-r----- 1 oracle oinstall 862749696 Dec 21 02:57 s8os1kvk_1_1
-rw-r----- 1 oracle oinstall 786217984 Dec 21 02:57 s6os1kvj_1_1
-rw-r----- 1 oracle oinstall 959141888 Dec 21 02:57 s5os1kvj_1_1
-rw-r----- 1 oracle oinstall 7341113344 Dec 21 04:43 sdos1l8s_1_1
-rw-r----- 1 oracle oinstall 10657964032 Dec 21 04:59 scos1l8s_1_1
-rw-r----- 1 oracle oinstall 7897636864 Dec 21 05:00 sgos1l8t_1_1
-rw-r----- 1 oracle oinstall 7411761152 Dec 21 05:03 saos1l8s_1_1
-rw-r----- 1 oracle oinstall 7261650944 Dec 21 05:05 sbos1l8s_1_1
-rw-r----- 1 oracle oinstall 16164651008 Dec 21 05:19 sfos1l8t_1_1
-rw-r----- 1 oracle oinstall 20935778304 Dec 21 05:30 seos1l8s_1_1
-rw-r----- 1 oracle oinstall 83359744 Dec 21 05:31 shos1u97_1_1
-rw-r----- 1 oracle oinstall 2473984 Dec 21 05:31 Tp_cntl_20131221_XXXX_14226_1.ctl
List of Backup is mentioned below .
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
13022 25.00K DISK 00:00:00 21-DEC-2013 02:52:36
BP Key: 13022 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025235
Piece Name: /nfs/BACKUP/s9os1kvk_1_1
List of Archived Logs in backup set 13022
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 13752 5976867023004 21-DEC-2013 02:52:21 5976867023132 21-DEC-2013 02:52:34
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
13023 813.34M DISK 00:04:18 21-DEC-2013 02:56:53
BP Key: 13023 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025235
Piece Name: /nfs/BACKUP/s4os1kvj_1_1
List of Archived Logs in backup set 13023
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 13737 5976857025235 19-DEC-2013 08:13:32 5976857265613 19-DEC-2013 08:51:41
1 13738 5976857265613 19-DEC-2013 08:51:41 5976857579200 19-DEC-2013 10:14:27
1 13739 5976857579200 19-DEC-2013 10:14:27 5976857859162 19-DEC-2013 11:33:05
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
13024 853.89M DISK 00:04:28 21-DEC-2013 02:57:04
BP Key: 13024 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025235
Piece Name: /nfs/BACKUP/s7os1kvk_1_1
List of Archived Logs in backup set 13024
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 13740 5976857859162 19-DEC-2013 11:33:05 5976858225974 19-DEC-2013 14:28:16
1 13741 5976858225974 19-DEC-2013 14:28:16 5976862174422 19-DEC-2013 19:56:58
1 13742 5976862174422 19-DEC-2013 19:56:58 5976862520059 19-DEC-2013 23:10:35
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
13025 822.78M DISK 00:04:32 21-DEC-2013 02:57:08
BP Key: 13025 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025235
Piece Name: /nfs/BACKUP/s8os1kvk_1_1
List of Archived Logs in backup set 13025
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 13749 5976865001972 20-DEC-2013 10:49:16 5976865247194 20-DEC-2013 12:16:39
1 13750 5976865247194 20-DEC-2013 12:16:39 5976866552507 20-DEC-2013 20:00:42
1 13751 5976866552507 20-DEC-2013 20:00:42 5976867023004 21-DEC-2013 02:52:21
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
13026 749.80M DISK 00:04:42 21-DEC-2013 02:57:17
BP Key: 13026 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025235
Piece Name: /nfs/BACKUP/s6os1kvj_1_1
List of Archived Logs in backup set 13026
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 13746 5976864233994 20-DEC-2013 08:15:45 5976864528239 20-DEC-2013 09:13:52
1 13747 5976864528239 20-DEC-2013 09:13:52 5976864787608 20-DEC-2013 10:41:24
1 13748 5976864787608 20-DEC-2013 10:41:24 5976865001972 20-DEC-2013 10:49:16
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
13027 914.71M DISK 00:04:54 21-DEC-2013 02:57:29
BP Key: 13027 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025235
Piece Name: /nfs/BACKUP/s5os1kvj_1_1
List of Archived Logs in backup set 13027
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 13743 5976862520059 19-DEC-2013 23:10:35 5976862760698 20-DEC-2013 00:36:03
1 13744 5976862760698 20-DEC-2013 00:36:03 5976863241121 20-DEC-2013 03:02:32
1 13745 5976863241121 20-DEC-2013 03:02:32 5976864233994 20-DEC-2013 08:15:45
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
13028 Full 6.84G DISK 01:45:46 21-DEC-2013 04:43:18
BP Key: 13028 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025731
Piece Name: /nfs/BACKUP/sdos1l8s_1_1
List of Datafiles in backup set 13028
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
2 Full 5976867025850 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/system02.dbf
8 Full 5976867025850 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_queue02.dbf
14 Full 5976867025850 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_txn_data04.dbf
16 Full 5976867025850 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_ref03.dbf
18 Full 5976867025850 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/sysaux02.dbf
351 Full 5976867025850 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/system07.dbf
394 Full 5976867025850 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_ref01.dbf
405 Full 5976867025850 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_txn_ind04.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
13029 Full 9.93G DISK 02:01:39 21-DEC-2013 04:59:11
BP Key: 13029 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025731
Piece Name: /nfs/BACKUP/scos1l8s_1_1
List of Datafiles in backup set 13029
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
3 Full 5976867025849 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/system03.dbf
13 Full 5976867025849 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/system12.dbf
15 Full 5976867025849 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_txn_ind06.dbf
22 Full 5976867025849 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_txn_ind07.dbf
23 Full 5976867025849 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/xxjwa01.dbf
353 Full 5976867025849 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/system08.dbf
400 Full 5976867025849 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_media01.dbf
403 Full 5976867025849 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_txn_ind02.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
13030 Full 7.36G DISK 02:03:07 21-DEC-2013 05:00:40
BP Key: 13030 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025731
Piece Name: /nfs/BACKUP/sgos1l8t_1_1
List of Datafiles in backup set 13030
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 Full 5976867025861 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/system01.dbf
4 Full 5976867025861 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/system04.dbf
9 Full 5976867025861 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/odm.dbf
11 Full 5976867025861 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/sysaux01.dbf
20 Full 5976867025861 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/a_txn_data05.dbf
25 Full 5976867025861 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/undo1.dbf
295 Full 5976867025861 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/system06.dbf
404 Full 5976867025861 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/a_txn_ind03.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
13031 Full 6.90G DISK 02:05:59 21-DEC-2013 05:03:31
BP Key: 13031 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025731
Piece Name: /nfs/BACKUP/saos1l8s_1_1
List of Datafiles in backup set 13031
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
12 Full 5976867025838 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/apps_ts_tools01.dbf
17 Full 5976867025838 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_int02.dbf
21 Full 5976867025838 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_txn_data06.dbf
288 Full 5976867025838 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/system10.dbf
314 Full 5976867025838 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/portal01.dbf
402 Full 5976867025838 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_txn_data03.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
13032 Full 6.76G DISK 02:07:50 21-DEC-2013 05:05:22
BP Key: 13032 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025731
Piece Name: /nfs/BACKUP/sbos1l8s_1_1
List of Datafiles in backup set 13032
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
352 Full 5976867025839 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/system09.dbf
392 Full 5976867025839 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_txn_data01.dbf
397 Full 5976867025839 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_nolog01.dbf
401 Full 5976867025839 21-DEC-2013 02:57:32 /u01/app/oracle/db/apps_st/data/a_txn_data02.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
13033 Full 15.05G DISK 02:21:42 21-DEC-2013 05:19:15
BP Key: 13033 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025731
Piece Name: /nfs/BACKUP/sfos1l8t_1_1
List of Datafiles in backup set 13033
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
6 Full 5976867025860 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/ctxd01.dbf
7 Full 5976867025860 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/owad01.dbf
19 Full 5976867025860 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/sysaux03.dbf
24 Full 5976867025860 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/a_media02.dbf
354 Full 5976867025860 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/system11.dbf
395 Full 5976867025860 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/a_int01.dbf
399 Full 5976867025860 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/a_queue01.dbf
406 Full 5976867025860 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/a_txn_ind05.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
13034 Full 19.50G DISK 02:33:27 21-DEC-2013 05:30:59
BP Key: 13034 Status: AVAILABLE Compressed: YES Tag: TAG20131221T025731
Piece Name: /nfs/BACKUP/seos1l8s_1_1
List of Datafiles in backup set 13034
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
5 Full 5976867025853 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/system05.dbf
10 Full 5976867025853 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/olap.dbf
26 Full 5976867025853 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/a_media03.dbf
27 Full 5976867025853 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/a_media04.dbf
393 Full 5976867025853 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/a_txn_ind01.dbf
396 Full 5976867025853 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/a_summ01.dbf
398 Full 5976867025853 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/a_archive01.dbf
407 Full 5976867025853 21-DEC-2013 02:57:33 /u01/app/oracle/db/apps_st/data/a_ref02.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
13035 79.50M DISK 00:00:15 21-DEC-2013 05:31:34
BP Key: 13035 Status: AVAILABLE Compressed: YES Tag: TAG20131221T053119
Piece Name: /nfs/BACKUP/shos1u97_1_1
List of Archived Logs in backup set 13035
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 13753 5976867023132 21-DEC-2013 02:52:34 5976873333914 [b]21-DEC-2013 05:31:07[/b]
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
13036 Full 2.34M DISK 00:00:08 21-DEC-2013 05:31:53
BP Key: 13036 Status: AVAILABLE Compressed: YES Tag: TAG20131221T053144
Piece Name: /nfs/BACKUP/Tp_cntl_20131221_XXXX_14226_1.ctl
Control File Included: Ckp SCN: 5976873337791 Ckp time: 21-DEC-2013 05:31:45
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
13037 Full 33.52M DISK 00:00:03 21-DEC-2013 05:31:58
BP Key: 13037 Status: AVAILABLE Compressed: NO Tag: TAG20131221T053155
Piece Name: /nfs/BACKUP/CF_c-1616662153-20131221-00_PROD.bak
SPFILE Included: Modification time: 21-DEC-2013 05:31:46
SPFILE db_unique_name: XXXXX
Control File Included: Ckp SCN: 5976873337982 Ckp time: 21-DEC-2013 05:31:55
if i want to do duplicate to set until time can i do it for the time 21-DEC-2013 05:31:07
Correct me if i am wrong .
Regards
|
|
|
|
Re: Cannot recovery Set until time [message #605576 is a reply to message #604131] |
Fri, 10 January 2014 15:24 |
|
Littlefoot
Messages: 21811 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I have removed plagiarism-related messages on www.dbametrix.net from this topic and put them into a separate topic which now resides in our Suggestion & Feedback forum. Frank Naude will read it, and take (or not) steps according to your findings. Please, don't continue plagiarism discussion here any more (but feel free to do so in a newly created topic).
[Updated on: Fri, 10 January 2014 15:25] Report message to a moderator
|
|
|
|