Go Back   Wiki NewForum > Career Forum > Tech Forum & Tutorial > Oracle Database, SQL, Application, Programming

Reply
Views: 1210  
Thread Tools Rate Thread Display Modes
  #1  
Old 05-26-2009, 12:44 PM
bholus7 bholus7 is offline
Banned
 
Join Date:
Apr 2009
Posts: 1,322
Default 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

Reply With Quote
Reply

New topics in Oracle Database, SQL, Application, Programming

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump


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