Wiki NewForum

Wiki NewForum (https://www.wikinewforum.com//index.php)
-   Oracle Database, SQL, Application, Programming (https://www.wikinewforum.com//forumdisplay.php?f=96)
-   -   Backup and Recovery Tips (https://www.wikinewforum.com//showthread.php?t=7392)

bholus7 05-26-2009 12:44 PM

Backup and Recovery Tips
 
Backup and Recovery Tips

Helpful statement to end the backup for the tablespaces which are in the online backup mode:
1- Create a script through the following commands:
svrmgrl> spool endhotbackup.sql
svrmgrl> select 'ALTER DATABASE DATAFILE '''||name||''' END BACKUP ' FROM V$DATAFILE;
2- Cleanup endhotbackup.sql through vi
3- svrmgrl> @endhotbackup.sql
4- startup the database


All times are GMT. The time now is 12:38 PM.

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2020, vBulletin Solutions, Inc.