Home » RDBMS Server » Backup & Recovery » backups of read-only tablespaces ?
backups of read-only tablespaces ? [message #401912] Wed, 06 May 2009 23:29 Go to next message
Messages: 142
Registered: March 2006
Senior Member
I read in the doc 'Oracle® Database Backup and Recovery Advanced User's Guide 10g Release 2 (10.2)'
that for a read-only tablespace, we need to only backup this tablespace.

But when I was reading some OUI student guide, I found that all tablespace datafiles, including the read-only ones should be backed up.

So I am confused, which is the correct method for read-only tablespace backups ?

Re: backups of read-only tablespaces ? [message #401918 is a reply to message #401912] Thu, 07 May 2009 00:30 Go to previous messageGo to next message
Michel Cadot
Messages: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When the tablespace is read-only you only need to backup it ONCE because as it is read-only it does not change.

ALWAYS quote (copy and paste) what you read and if it exists post a link to it otherwise give a PRECISE location not just the title of hundreds pages book. Your first quote is wrong.

Re: backups of read-only tablespaces ? [message #401920 is a reply to message #401912] Thu, 07 May 2009 00:33 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
When you are quoting docs,
please post the exact URL or exact content of documentation
instead of explaining the documentation in your words.
Previous Topic: RMAN Channel
Next Topic: Hot backup of control file
Goto Forum:

Current Time: Tue Oct 25 20:15:26 CDT 2016

Total time taken to generate the page: 0.29018 seconds