Tag: Add new tag

What are the different options to shutdown?

shutdown (or shutdown normal) - In this method the database shuts down cleanly and oracle will wait for all users process to terminate before shutting down the database, so if there is user with SQL*Plus session that is idle oracle will not terminate till the user session exits it. If user sessions haven't been terminated … Continue reading What are the different options to shutdown?

How to fix when backup piece is not found when deleting obsolete backup piece?

As part of the RMAN script during backup to disk for example you may have a statement to delete the obsolete backups. And in cases when backup piece is not found the RMAN fails with the error shown below when it can't delete the obsolete backup. Example (portion of the script to delete obsolete backup): … Continue reading How to fix when backup piece is not found when deleting obsolete backup piece?