Clone database backups without resetlogs
SnapManager enables you to perform flexible cloning so that you can recover the cloned database manually to a desired point in time without opening the database by using resetlogs. You can also manually configure the cloned database as a Data Guard Standby database.
About this task
When you can select the
-no-resetlogs option while creating the clone, SnapManager performs the following activities to create the cloned database:
Executes the preprocessing task activity, if specified, before starting the clone operation
Creates the cloned database with the user-specified SID
Executes the SQL statements issued against the cloned database.
Only the SQL statements that can be executed in mount state are successfully executed.
Executes the post-processing task activity, if specified.
What tasks you need to do to recover the cloned database manually
Mount the archive log backups and recover the cloned database manually by using the archive log files from the mounted path.
After performing manual recovery, open the recovered cloned database with
Create temporary tablespaces, if required.
Run the DBNEWID utility.
Grant sysdba privilege to the credentials of the cloned database.
While cloning the database backups using the
-no-resetlogs option, SnapManager leaves the cloned database in the mounted state for manual recovery.
The cloned database created with the
If you do not specify the
-no-resetlogs option, SnapManager applies the archive log files, and opens the database with resetlogs.
Enter the following command:
smsap clone create -profile profile_name [-backup-label backup_name | -backup-id backup_id | current] -newsid new_sid -clonespec full_path_to_clonespecfile -no-resetlogs
If you try to specify both
recover-from-locationoptions, SnapManager does not allow you to specify both these options together, and displays the error message:
SMSAP-04084: You must specify either one of the options: -no-resetlogs or -recover-from-location.
smsap clone create -profile product -backup-label full_offline -newsid PROD_CLONE -clonespec prod_clonespec.xml -label prod_clone-reserve -no-reset-logs