Home » RDBMS Server » Backup & Recovery » Toggle Read-Only Schema (Oracle 10g (10.2.0.4))
Toggle Read-Only Schema [message #402304] Fri, 08 May 2009 11:28 Go to next message
gespi
Messages: 2
Registered: May 2009
Location: MILWAUKEE, WI
Junior Member
I am aware of hot backups with RMAN but is there a way to toggle a specific SCHEMA to Read-Only to effectively "lock" the schema during cold backups (Oracle dumps)?

While we have RMAN for hot backups for our daily backup operations, we would like to retain cold backups for weekly, monthly, and yearly backups without necessarily having to take the system down.

Thanks in advance!
Re: Toggle Read-Only Schema [message #402308 is a reply to message #402304] Fri, 08 May 2009 11:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: Toggle Read-Only Schema [message #402309 is a reply to message #402308] Fri, 08 May 2009 11:43 Go to previous message
gespi
Messages: 2
Registered: May 2009
Location: MILWAUKEE, WI
Junior Member
Thanks Michel!

Quick and to the point...
Previous Topic: obtaining last SCN generated for crashed database ?
Next Topic: RMAN errors: RMAN-06207 and RMAN-06214
Goto Forum:
  


Current Time: Thu Mar 28 16:10:43 CDT 2024