Steps if you need to restore all datafiles in a tablespace is corrupted so you would need to restore the table space. The following example shows the steps -- Shows cannot restore the tablespace yet till the tablespace is online RMAN> run { 2> restore tablespace ts_something; 3> } Starting restore at 27-NOV-10 using channel … Continue reading How to restore and recover tablespace?
Tag: immediate
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?
alexlima.com 