To find if database or any tablespace is in backup mode, the status in V$BACKUP is ACTIVE
SQL) select * from v$backup;
If the backup is stuck and you need to end that back up, give the below sql command :
SQL) ALTER DATABASE END BACKUP;
Database altered.
If one tries to perform shutdown of database when database is in BACKUP mode, you will receive the following error “ORA-01149″
SQL) shutdown immediate;
ORA-01149: cannot shutdown – file 1 has online backup set
ORA-01110: data file 1: ‘/oracle/SRS/sapdata1/sys_01.dbf’
If one tries to set the database that is already in backup mode, one will receive the following error “ORA-01146″
SQL) alter database begin backup;
alter database begin backup
*
ERROR at line 1:
ORA-01146: cannot start online backup – file 1 is already in backup
ORA-01110: data file 1: ‘/oracle/SRS/sapdata1/sys_01.dbf’
Subscribe to:
Post Comments (Atom)
4 comments:
Thanks for sharing great information in your blog. Got to learn new things from your Blog . It was very nice blog to learn about Selenium.
selenium Training in Chennai
Hii , if you are looking best SAP consulting company then denpro technologies is most https://www.denprotech.com/
Unlock seamless connectivity and optimize business processes with our best-in-class SAP integration services, ensuring efficient data synchronization and real-time insights for enhanced operational excellence.
for more info- https://www.denprotech.com/SAP-3rd-party-integration
What as up, I read your blogs like every week. Your writing style is awesome, keep up the good work!
Business Analysis Training
<a href="https://viswaonlinetrainings.com/courses/ibm-infosphere-datastage-training/>Datastage Training</a>
Post a Comment