Home » RDBMS Server » Backup & Recovery » Duplicate DB Issue with Set until time (merged) (oracle 11G, linux 5)
Duplicate DB Issue with Set until time (merged) [message #581712] Wed, 10 April 2013 02:01 Go to next message
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 #581715 is a reply to message #581712] Wed, 10 April 2013 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you set a time before the backup then RMAN will not take this backup.

Regards
Michel
Re: Duplicate DB Issue [message #581717 is a reply to message #581715] Wed, 10 April 2013 02:27 Go to previous messageGo to next message
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
Re: Duplicate DB Issue [message #581726 is a reply to message #581717] Wed, 10 April 2013 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Restore the control file first then set UNTIL TIME.

Regards
Michel
Cannot recovery Set until time [message #603615 is a reply to message #581712] Wed, 18 December 2013 00:23 Go to previous messageGo to next message
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: Cannot recovery Set until time [message #603618 is a reply to message #603615] Wed, 18 December 2013 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If you start a backup at 23:08 then it is not completed at this time and so it is logical RMAN searches for the previous one.

Re: Cannot recovery Set until time [message #603620 is a reply to message #603618] Wed, 18 December 2013 00:59 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
Hi Micheal

hot backup finished at 23:08 and that was last control file taken while hot backup.
earlier was database and archivelogs .

Regards
Re: Cannot recovery Set until time [message #603621 is a reply to message #603620] Wed, 18 December 2013 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You did not feedback in your previous topic about the same question, please do it.
Now copy and paste all what you did and got including the list of backups and the execution of the current script.

Re: Cannot recovery Set until time [message #603622 is a reply to message #603621] Wed, 18 December 2013 01:15 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
Sorry micheal

do i need to close this topic and continue the earlier one ?
let me know
Re: Cannot recovery Set until time [message #603624 is a reply to message #603622] Wed, 18 December 2013 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You need to feedback: tell us what you did and if it solves your issue or if there is something pending and all things you think that can be useful for people that will see your topic.

Re: Cannot recovery Set until time [message #603626 is a reply to message #603624] Wed, 18 December 2013 01:28 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
Ok micheal

please close this topic i will continue the earlier one .

Regards
Re: Duplicate DB Issue [message #603628 is a reply to message #581726] Wed, 18 December 2013 01:36 Go to previous messageGo to next message
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: Duplicate DB Issue [message #603629 is a reply to message #603628] Wed, 18 December 2013 01:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Set NLS_DATE_FORMAT environment variable to DD-MON-YYYY HH24:MI:SS, enter RMAN and repost your backup list with time part.


Re: Cannot recovery Set until time [message #603630 is a reply to message #603628] Wed, 18 December 2013 01:51 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
Hi Micheal

thanks for merging my topics ..
can you please suggest ...

Regards
Re: Cannot recovery Set until time [message #603632 is a reply to message #603630] Wed, 18 December 2013 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Michel Cadot wrote on Wed, 18 December 2013 08:51

Set NLS_DATE_FORMAT environment variable to DD-MON-YYYY HH24:MI:SS, enter RMAN and repost your backup list with time part.

Re: Cannot recovery Set until time [message #603637 is a reply to message #603632] Wed, 18 December 2013 02:29 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
Micheal its attached in post
can you please check once again

List backup.txt
Re: Cannot recovery Set until time [message #603660 is a reply to message #603637] Wed, 18 December 2013 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Nothing is attached to your post.

Re: Cannot recovery Set until time [message #603666 is a reply to message #603660] Wed, 18 December 2013 05:09 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
Hi Micheal

Attached is the List backup text file ..

Regards
Re: Cannot recovery Set until time [message #603691 is a reply to message #603666] Wed, 18 December 2013 08:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't what I asked.

export NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'
rman target /
list backup ...


And I also asked a copy and paste of the session that shows your issue including the script you execute?
Re: Cannot recovery Set until time [message #603721 is a reply to message #603691] Wed, 18 December 2013 19:58 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
Hi Micheal

Attached is the output for list backup as per you requested.
Session log got deleted .
i used the same run block only date was 17-Dec-2013.

Regards



[Updated on: Wed, 18 December 2013 20:14]

Report message to a moderator

Re: Cannot recovery Set until time [message #603738 is a reply to message #603721] Thu, 19 December 2013 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK, now the listing of the execution of your script showing your issue (you have to explain).

Re: Cannot recovery Set until time [message #603755 is a reply to message #603738] Thu, 19 December 2013 02:22 Go to previous messageGo to next message
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 #603757 is a reply to message #603755] Thu, 19 December 2013 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Which backup is it looking for?
Which one it is not looking for?
Give the keys from your listing.

Re: Cannot recovery Set until time [message #603794 is a reply to message #603757] Thu, 19 December 2013 08:28 Go to previous messageGo to next message
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 #603804 is a reply to message #603794] Thu, 19 December 2013 08:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
BS KEYS are


Is this the list it uses or the list you think it should use?
Remember we know NOTHING about your actual execution as you didn't post it.
I advise to execute it again and post the COMPLETE things I asked.
Till now you are just wasting my and your time.

Re: Cannot recovery Set until time [message #604007 is a reply to message #603804] Sun, 22 December 2013 11:49 Go to previous messageGo to next message
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 #604131 is a reply to message #604007] Tue, 24 December 2013 07:02 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
Hi Micheal

Can you let me know if this is correct approach .

Regards
Re: Cannot recovery Set until time [message #605576 is a reply to message #604131] Fri, 10 January 2014 15:24 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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

Re: Cannot recovery Set until time [message #609691 is a reply to message #605576] Tue, 11 March 2014 05:31 Go to previous message
saagar
Messages: 79
Registered: December 2007
Member
please close this thread . got the answer as we can get Completion Time to set until time .

Regards
Previous Topic: problem in TSPITR
Next Topic: RMAN Restore Scenario
Goto Forum:
  


Current Time: Thu Mar 28 07:58:51 CDT 2024