Examples of backup, restore, and recover operations
You can find information about some of the backup, restore, and recover scenarios that you can use to accomplish your data protection goals.
The following illustration shows the contents of the tablespace:
In the illustration, Tablespace1 has one table and two database files associated with it. Tablespace2 has two tables and one database file associated with it.
The following tables describe some full and partial backup, restore, and recover scenarios:
Examples of full backup, restore, and recover operations
Full backup | Restore | Recover |
---|---|---|
SnapManager makes a backup of everything in database DB1, including the data files, archive logs, and control files. |
Complete restore with control files SnapManager restores all data files, tablespaces, and control files in the backup. |
You can specify one of the following:
|
Complete restore without control files SnapManager restores all tablespaces and data files, without the control files. |
||
Restore either data files or tablespaces with control files Specify one of the following:
|
SnapManager recovers the data to the last transaction made to the database. |
|
Restore either data files or tablespaces without control filesSnapManager restores one of the following:
|
||
Restore control files only |
Examples of partial backup, restore, and recover operations
Partial backup | Restore | Recover |
---|---|---|
You can choose one of the following options:
Regardless of which option you select, the backup includes all the control files. Archive log files are included in the partial backup if the profile is not enabled to create the archive log backups separately. |
Complete restore SnapManager restores all data files, tablespaces, and control files specified in the partial backup. |
SnapManager recovers the data to the last transaction made to the database instance. |
Restore either data files or tablespaces with control files SnapManager restores one of the following:
|
||
Restore either data files or tablespaces without control files SnapManager restores one of the following:
|
||
Restore control files only |