InterviewQues, faqs, SQL,sql+, PlSql,my sql, Sqlserver, Ms Sql, 7i,8i,9i,10i, SNIpEDstatus, Cloning Database, CPU Resources, Database Crashed, Deadlock, Editing commands, Elapsedtime, Formating Columns, Forms4.5FAQ, Hindi Format, Hit Ratios, Log block size, Multiple fields, Orcl loction on linux, Oracle_SID, Plan TIps,setup for calling, Snapshot too old error,Sols for DBA’s,Sql Via Command Prompt,values back to unix,Schema,Faqs, Interview questions and Real time stuff too,,
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
Posted by Real Time Scenario at 10:20 AM
Labels: Backup n Recovery Tips
1 comments:
Brilliant blog I visit this blog it's incredibly awesome. Curiously, in this blog content formed doubtlessly and sensible. The substance of information is helpful.
Oracle Fusion HCM Online Training
Oracle Fusion Financials Online Training
Post a Comment