OraFAQ Forum: Backup & Recovery » rman encrypt on level_0_script

Home » RDBMS Server » Backup & Recovery » rman encrypt on level_0_script_ (11g, 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rman encrypt on level_0_script_ [message #672021]

Fri, 28 September 2018 04:58

MladenP
Messages: 5
Registered: September 2018

Junior Member

Hello, I new one here
I have a question
is it possible to set encrypt backup on level_0 / level_1?
In documentation I found encrypt on tablespace and database.
Thanks

Report message to a moderator

Re: rman encrypt on level_0_script_ [message #672023 is a reply to message #672021]

Fri, 28 September 2018 05:48

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No problem.
You mix up 2 notions:
- DATABASE and TABLESPACE define the objects that are saved: the whole database or some tablespaces ("backupSpec" in the syntax diagram)
- LEVEL indicates how it is saved: whole object(s) (LEVEL 0) or only the differences from the previous backup (LEVEL 1) ("backupOperand" in the syntax diagram).

Report message to a moderator

Re: rman encrypt on level_0_script_ [message #672024 is a reply to message #672023]

Fri, 28 September 2018 05:53

MladenP
Messages: 5
Registered: September 2018

Junior Member

Thank you for fast answer,

My problem is how to setup encrypt on level_0 and level_1, or is it possible?
Thanks

Report message to a moderator

Re: rman encrypt on level_0_script_ [message #672025 is a reply to message #672024]

Fri, 28 September 2018 05:56

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Configuring the RMAN Environment: Advanced Topics.

Report message to a moderator

Re: rman encrypt on level_0_script_ [message #672026 is a reply to message #672024]

Fri, 28 September 2018 06:12

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Sure, but you have to pay for it: Enterprose Edition plus the Advanced Security Option,
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/backing-up-database-advanced.html#GUID-ECBE4965-57F7-49F0-BECD- 734196F417F5

Report message to a moderator

Re: rman encrypt on level_0_script_ [message #672027 is a reply to message #672024]

Fri, 28 September 2018 06:12

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Encryption of Backup Sets

Report message to a moderator

Re: rman encrypt on level_0_script_ [message #672030 is a reply to message #672027]

Fri, 28 September 2018 07:51

MladenP
Messages: 5
Registered: September 2018

Junior Member

Thanks to all
I succeeded, database is encrypted with rman password without setup wallet.

Report message to a moderator

Re: rman encrypt on level_0_script_ [message #672059 is a reply to message #672030]

Sun, 30 September 2018 08:19

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

MladenP wrote on Fri, 28 September 2018 07:51

Thanks to all
I succeeded, database is encrypted with rman password without setup wallet.

Database is encrypted?
Or backup is encrypted?

Rman doesn't encrypt the database.

Report message to a moderator

Re: rman encrypt on level_0_script_ [message #672069 is a reply to message #672059]

Mon, 01 October 2018 06:30

MladenP
Messages: 5
Registered: September 2018

Junior Member

Backup is encrypted,
first You set key
RMAN> SET ENCRYPTION ON IDENTIFIED BY password;

then set
RMAN> CONFIGURE ENCRYPTION FOR database ON;

Now every backup will be encrypted.

Report message to a moderator

Previous Topic:	Missed Proc and Package from Oracle 11G r2 to Oracle 12C r2
Next Topic:	Log file restore

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 06:21:10 CDT 2025