| Backup Database v Tablespace [message #319299] |
Fri, 09 May 2008 12:23  |
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  |
 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
