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
tridentadm
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: 64152
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.

Regards
Michel
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: Sat Dec 10 20:52:32 CST 2016

Total time taken to generate the page: 0.10531 seconds