Home » RDBMS Server » Backup & Recovery » Backup Database v Tablespace (8i,9i,10g)
Backup Database v Tablespace [message #319299] Fri, 09 May 2008 12:23 Go to next message
dariakon
Messages: 6
Registered: March 2008
Junior Member
On RMAN, I did ONLY tablespace backups as follows :


rman> backup tablespace system,sysaux,users,.........


Would I be able to do, later on :


rman> restore database ??


How about disaster recovery situation, will the tablespace backups alone suffice for recontructing the entire database on a new system ?

-----------------------------

LIke wise if I ONLY did :

rman> backup database

would I be able to do

rman> restore tablespace users ?



Thank you for the response.

Re: Backup Database v Tablespace [message #319301 is a reply to message #319299] Fri, 09 May 2008 12:48 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
dariakon wrote on Fri, 09 May 2008 13:23
On RMAN, I did ONLY tablespace backups as follows :


rman> backup tablespace system,sysaux,users,.........


Would I be able to do, later on :


rman> restore database ??

How about disaster recovery situation, will the tablespace backups alone suffice for recontructing the entire database on a new system ?

Sure, but why make it harder on yourself. If you add another tablespace and don't update your script, then you'll miss out on that tablespace.

dariakon wrote on Fri, 09 May 2008 13:23


LIke wise if I ONLY did :

rman> backup database

would I be able to do

rman> restore tablespace users ?

Yes.
Previous Topic: Backup of Tablespaces
Next Topic: Backup and Recovery without using Archivelog ON
Goto Forum:
  


Current Time: Sat Dec 10 18:50:54 CST 2016

Total time taken to generate the page: 0.09381 seconds