Restore Incarnation

RMAN> run {
2> set until sequence 13;
3> RESTORE CONTROLFILE;
4> ALTER DATABASE MOUNT;
5> restore database;
6> recover database;
7> alter database open resetlogs;
8> }

executing command: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 07/24/2008 17:31:29
ORA-01507: database not mounted

RMAN> run {
2> set until sequence 13;
3> RESTORE CONTROLFILE;
4> ALTER DATABASE MOUNT;
5> restore database;
6> recover database;
7> alter database open resetlogs;
8> }

executing command: SET until clause
released channel: ORA_DISK_1

Starting restore at 24/07/2008
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/24/2008 17:31:50
RMAN-06496: must use the TO clause when the database is mounted or open

RMAN> run {
2> set until sequence 13;
3> restore database;
4> recover database;
5> alter database open resetlogs;
6> }

executing command: SET until clause

Starting restore at 24/07/2008
using channel ORA_DISK_1

skipping datafile 1; already restored to file D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\SYSTEM01.DBF
skipping datafile 2; already restored to file D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\UNDOTBS01.DBF
skipping datafile 3; already restored to file D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\SYSAUX01.DBF
skipping datafile 4; already restored to file D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\USERS01.DBF
skipping datafile 5; already restored to file D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\EXAMPLE01.DBF
restore not done; all files readonly, offline, or already restored
Finished restore at 24/07/2008

Starting recover at 24/07/2008
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/24/2008 17:32:33
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until cancel
ORA-00283: recovery session canceled due to errors
ORA-38727: FLASHBACK DATABASE requires a current control file.

RMAN> list backup;


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 626.77M DISK 00:10:58 24/07/2008
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20080724T155413
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_NNNDF_TAG20080724T155413_48KV0HJM_.BKP
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 Full 3615824 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\SYSTEM01.DBF
2 Full 3615824 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\UNDOTBS01.DBF
3 Full 3615824 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\SYSAUX01.DBF
4 Full 3615824 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\USERS01.DBF
5 Full 3615824 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\EXAMPLE01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 6.80M DISK 00:00:04 24/07/2008
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20080724T155413
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_NCSNF_TAG20080724T155413_48KVNRTV_.BKP
Control File Included: Ckp SCN: 3616477 Ckp time: 24/07/2008
SPFILE Included: Modification time: 24/07/2008

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3 19.74M DISK 00:00:07 24/07/2008
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20080724T160839
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_ANNNN_TAG20080724T160839_48KVTTJM_.BKP

List of Archived Logs in backup set 3
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ---------- ---------- ---------
1 4 3596066 24/07/2008 3614571 24/07/2008
1 5 3614571 24/07/2008 3617076 24/07/2008

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 627.39M DISK 00:05:53 24/07/2008
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20080724T161713
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_NNNDF_TAG20080724T161713_48KWC3LK_.BKP
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 Full 3617578 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\SYSTEM01.DBF
2 Full 3617578 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\UNDOTBS01.DBF
3 Full 3617578 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\SYSAUX01.DBF
4 Full 3617578 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\USERS01.DBF
5 Full 3617578 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\EXAMPLE01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 6.80M DISK 00:00:03 24/07/2008
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20080724T161713
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_NCSNF_TAG20080724T161713_48KWP4B8_.BKP
Control File Included: Ckp SCN: 3618105 Ckp time: 24/07/2008
SPFILE Included: Modification time: 24/07/2008

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6 20.81M DISK 00:00:04 24/07/2008
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20080724T162416
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_ANNNN_TAG20080724T162416_48KWR44W_.BKP

List of Archived Logs in backup set 6
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ---------- ---------- ---------
1 4 3596066 24/07/2008 3614571 24/07/2008
1 5 3614571 24/07/2008 3617076 24/07/2008
1 6 3617076 24/07/2008 3617287 24/07/2008
1 7 3617287 24/07/2008 3617404 24/07/2008
1 8 3617404 24/07/2008 3617462 24/07/2008
1 9 3617462 24/07/2008 3617519 24/07/2008
1 10 3617519 24/07/2008 3618207 24/07/2008

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 627.49M DISK 00:07:19 24/07/2008
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20080724T162743
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_NNNDF_TAG20080724T162743_48KWYQY8_.BKP
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 Full 3618390 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\SYSTEM01.DBF
2 Full 3618390 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\UNDOTBS01.DBF
3 Full 3618390 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\SYSAUX01.DBF
4 Full 3618390 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\USERS01.DBF
5 Full 3618390 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\EXAMPLE01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 6.80M DISK 00:00:02 24/07/2008
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20080724T162743
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_NCSNF_TAG20080724T162743_48KXDQXS_.BKP
Control File Included: Ckp SCN: 3618757 Ckp time: 24/07/2008
SPFILE Included: Modification time: 24/07/2008

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9 21.50M DISK 00:00:06 24/07/2008
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20080724T163756
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_ANNNN_TAG20080724T163756_48KXKXD6_.BKP

List of Archived Logs in backup set 9
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ---------- ---------- ---------
1 4 3596066 24/07/2008 3614571 24/07/2008
1 5 3614571 24/07/2008 3617076 24/07/2008
1 6 3617076 24/07/2008 3617287 24/07/2008
1 7 3617287 24/07/2008 3617404 24/07/2008
1 8 3617404 24/07/2008 3617462 24/07/2008
1 9 3617462 24/07/2008 3617519 24/07/2008
1 10 3617519 24/07/2008 3618207 24/07/2008
1 11 3618207 24/07/2008 3618290 24/07/2008
1 12 3618290 24/07/2008 3618378 24/07/2008
1 13 3618378 24/07/2008 3618971 24/07/2008

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 627.35M DISK 00:08:47 24/07/2008
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20080724T170051
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_NNNDF_TAG20080724T170051_48KYX1CQ_.BKP
List of Datafiles in backup set 10
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 Full 3618900 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\SYSTEM01.DBF
2 Full 3618900 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\UNDOTBS01.DBF
3 Full 3618900 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\SYSAUX01.DBF
4 Full 3618900 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\USERS01.DBF
5 Full 3618900 24/07/2008 D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\EXAMPLE01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11 Full 6.80M DISK 00:00:15 24/07/2008
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20080724T170051
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_NCSNF_TAG20080724T170051_48KZGD98_.BKP
Control File Included: Ckp SCN: 3619437 Ckp time: 24/07/2008
SPFILE Included: Modification time: 24/07/2008

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
12 21.84M DISK 00:00:07 24/07/2008
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20080724T171116
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_ANNNN_TAG20080724T171116_48KZJ81Y_.BKP

List of Archived Logs in backup set 12
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ---------- ---------- ---------
1 4 3596066 24/07/2008 3614571 24/07/2008
1 5 3614571 24/07/2008 3617076 24/07/2008
1 6 3617076 24/07/2008 3617287 24/07/2008
1 7 3617287 24/07/2008 3617404 24/07/2008
1 8 3617404 24/07/2008 3617462 24/07/2008
1 9 3617462 24/07/2008 3617519 24/07/2008
1 10 3617519 24/07/2008 3618207 24/07/2008
1 11 3618207 24/07/2008 3618290 24/07/2008
1 12 3618290 24/07/2008 3618378 24/07/2008
1 13 3618378 24/07/2008 3618971 24/07/2008
1 14 3618971 24/07/2008 3619228 24/07/2008

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
13 3.03M DISK 00:00:01 24/07/2008
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20080724T171116
Piece Name: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\BACKUPSET\2008_07_24\O1_MF_ANNNN_TAG20080724T171116_48KZJJB8_.BKP

List of Archived Logs in backup set 13
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ---------- ---------- ---------
1 1 3617405 24/07/2008 3618813 24/07/2008
1 2 3618813 24/07/2008 3619524 24/07/2008

RMAN> run {
2> set until sequence 13;
3> restore database;
4> recover database;
5> alter database open resetlogs;
6> }

executing command: SET until clause

Starting restore at 24/07/2008
using channel ORA_DISK_1

skipping datafile 1; already restored to file D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\SYSTEM01.DBF
skipping datafile 2; already restored to file D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\UNDOTBS01.DBF
skipping datafile 3; already restored to file D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\SYSAUX01.DBF
skipping datafile 4; already restored to file D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\USERS01.DBF
skipping datafile 5; already restored to file D:\ORACLE\PRODUCT\10.2.0\ORADATA\POWER\EXAMPLE01.DBF
restore not done; all files readonly, offline, or already restored
Finished restore at 24/07/2008

Starting recover at 24/07/2008
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 10 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\ARCHIVELOG\2008_07_24\O1_MF_1_10_48KWQZ
JM_.ARC
archive log thread 1 sequence 11 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\ARCHIVELOG\2008_07_24\O1_MF_1_11_48KWTD
00_.ARC
archive log thread 1 sequence 12 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\ARCHIVELOG\2008_07_24\O1_MF_1_12_48KWXQ
OZ_.ARC
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\ARCHIVELOG\2008_07_24\O1_MF_1_10_48KWQZJM_.ARC thread=1 sequence=10
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\ARCHIVELOG\2008_07_24\O1_MF_1_11_48KWTD00_.ARC thread=1 sequence=11
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\POWER\ARCHIVELOG\2008_07_24\O1_MF_1_12_48KWXQOZ_.ARC thread=1 sequence=12
media recovery complete, elapsed time: 00:00:07
Finished recover at 24/07/2008

database opened

RMAN> list incarnation;


List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 POWER 1581044439 PARENT 1 30/08/2005
2 2 POWER 1581044439 PARENT 534907 24/07/2008
3 3 POWER 1581044439 ORPHAN 3617405 24/07/2008
4 4 POWER 1581044439 CURRENT 3618379 24/07/2008

RMAN>


COMO LO RE RECUPERE

Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 104859004 bytes
Database Buffers 54525952 bytes
Redo Buffers 7139328 bytes
SQL>
SQL> alter database mount;

Database altered.

NOTA: SE DEBE DESACTIVAR EL MODE FLASHBACK

SQL> alter database flashback off;

Database altered.

SQL>

run {
set until sequence 13;
restore database;
recover database;
alter database open resetlogs;
}


Point-in-Time Recovery to a Previous Incarnation
RMAN can seamlessly restore and recover backups from previous incarnations to the current incarnation. To perform point-in-time recovery to a target time prior to the most recent RESETLOGS, however, you must run the RESET DATABASE command to reset the database to the incarnation current at the desired target time.

Assume the following situation:

You run RMAN with a recovery catalog.
You made a backup of target database trgt on October 2, 2002.
You performed incomplete recovery on this database and opened it with the RESETLOGS option on October 10, 2002. A new database incarnation was created.
On October 25, you discover that you need crucial data that was dropped from the database at 8:00 a.m. on October 8, 2002. You decide to reset trgt to the prior incarnation, restore the October 2 backup, and recover to 7:55 a.m. on October 8.


--------------------------------------------------------------------------------
Note:
It is not possible to restore one datafile of a previous incarnation while the current database is in a different incarnation--you must restore the whole database.

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


To recover the database by means of a backup from the old incarnation:

Obtain the primary key of the prior incarnation with a LIST command:
# obtain primary key of old incarnation
LIST INCARNATION OF DATABASE trgt;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- ------- ------ ------- ---------- ----------
1 2 TRGT 1224038686 PARENT 1 02-OCT-02
1 582 TRGT 1224038686 CURRENT 59727 10-OCT-02


Make sure the database is started but not mounted:
SHUTDOWN FORCE NOMOUNT


Reset the incarnation to the primary key that you just obtained:

# reset database to old incarnation

RESET DATABASE TO INCARNATION 2;


Recover the database, performing the following actions in the RUN command:
Set the end time for recovery to the time just before the loss of the data.
If automatic channels are not configured, then manually allocate one or more channels.
Restore the control file and mount it.
Restore and recover the database.
For example, run the following commands:

RUN
{
# set time to just before data was lost.
SET UNTIL TIME 'Oct 8 2002 07:55:00';
RESTORE CONTROLFILE; # FROM AUTOBACKUP not needed in catalog mode
ALTER DATABASE MOUNT; # mount database after restoring control file
RESTORE DATABASE;
RECOVER DATABASE;
}


If recovery is successful, then reset the online redo logs:
# this command automatically resets the database so that this incarnation is
# the new incarnation
ALTER DATABASE OPEN RESETLOGS;













/////////////////////////////////////////////////////////////////

CONNECT TARGET / NOCATALOG

# step 1: start and mount a control file that knows about the incarnation to which
# you want to return. if the current control file does not know about it, then
# you must restore an older control file
STARTUP NOMOUNT;
RESTORE CONTROLFILE UNTIL TIME 'SYSDATE-250';
ALTER DATABASE MOUNT;

# step 2: obtain the primary key of old incarnation
LIST INCARNATION OF DATABASE trgt;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ------------- ------- ---------- ----------
1 2 TRGT 1334358386 PARENT 154381 OCT 30 2001 16:02:12
1 116 TRGT 1334358386 CURRENT 154877 OCT 30 2001 16:37:39

# step 3: in this example, reset database to incarnation key 2
RESET DATABASE TO INCARNATION 2;

# step 4: restore and recover the database to a point before the RESETLOGS
RESTORE DATABASE UNTIL SCN 154876;
RECOVER DATABASE UNTIL SCN 154876;

# step 5: make this incarnation the current incarnation and then list incarnations:
ALTER DATABASE OPEN RESETLOGS;
LIST INCARNATION OF DATABASE trgt;


List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- ------- ---------- ----------
1 2 TRGT 1334358386 PARENT 154381 OCT 30 2001 16:02:12
1 116 TRGT 1334358386 PARENT 154877 OCT 30 2001 16:37:39
1 311 TRGT 1334358386 CURRENT 154877 AUG 13 2002 17:17:03
Resetting the Database After Incomplete Recovery: Example

This example assumes that an incomplete recovery or recovery with a backup control file was performed in NOCATALOG mode. Later, RMAN is started in CATALOG mode, but the RESYNC command fails because the incarnation has not been reset in the catalog.

% rman target / catalog rman/rman@catdb

Recovery Manager: Release 10.1.0.2.0 - Production

Copyright (c) 1995, 2003, Oracle. All rights reserved.

connected to target database: TRGT (DBID=1334531173)
connected to recovery catalog database

RMAN> RESYNC CATALOG;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 11/01/2001 12:00:43
RMAN-20003: target database incarnation not found in recovery catalog

RMAN> RESET DATABASE;

new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete