For the messy, spring transaction extension mechanism, A thorough understanding of how to choose abstract classes or interfaces, baidu Java post must ask interview questions for four consecutive years, A pair of slippers triggered the murder, crazy God said java series notes, Monologue of a programmer: despite my ups and downs in my life, Java framework is the foundation of interview, Java283pdf, Three Oracle RMAN backup encryption strategies (Part 2).
RMAN - Recovery Senario ORA-26040: Data block was RMAN - Restore spfile from memory on RAC 12.1.0.2.0.
Relocate Rac service to preferred instance.
[[emailprotected] ~]$ cd $ORACLE_HOME/network/admin, drwxrwxr-x 2 oracle oinstall 4096 May 5 10:03 samples, -rwxrwxr-x 1 oracle oinstall 381 Dec 17 2012 shrept.lst, -rwxrwxr-x 1 oracle oinstall 327 Jun 8 15:32 sqlnet1506083PM3230.bak, -rwxrwxr-x 1 oracle oinstall 327 Jun 8 14:29 sqlnet.ora, -rwxrwxr-x 1 oracle oinstall 340 Jun 8 15:32 tnsnames1506083PM3230.bak, -rwxrwxr-x 1 oracle oinstall 340 Jun 8 16:19 tnsnames.ora, [[emailprotected] admin]$ cat sqlnet.ora. Creating a persistent File System on an OEL 6.7 Vi AWS - Create RDS Oracle database instance. RUN RMAN>Shutdown;RMAN>startupmount; RMAN>RUN{> allocatechanneln1d 1<=m*n<2000020000*20000a[i]+a[i-2],a[i-1] lk(x)(k=0,1,,n) N2KOKC5ND9L09/11/30http://pro.taobao.com/yuanye/yuanye_index.htm 2021-2022 All rights reserved by CodeAntenna.com. [oracle@hdp orcl]$ pwd SQL> alter system set encryption wallet open identified by "test"; channel ORA_DISK_1: starting datafile backup set restore, channel ORA_DISK_1: restored backup piece 1, channel ORA_DISK_1: restore complete, elapsed time: 00:00:35, media recovery complete, elapsed time: 00:00:01. Be careful Although the listener is pointing to Grid Directory location . Starting Control File and SPFILE Autobackup at 08-JUN-15, piece handle=+RECO/sicsstb/autobackup/2015_06_08/s_881858264.262.881858265 comment=NONE, Finished Control File and SPFILE Autobackup at 08-JUN-15, The backup operation was successful , But if we close the purse , How about the backup operation , channel ORA_DISK_1: starting full datafile backup set, RMAN-00571: ===========================================================, RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============, RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/08/2015 16:39:38, connected to target database (not started), Total System Global Area 1603411968 bytes, Fixed Size 2253664 bytes, Variable Size 1006636192 bytes, Database Buffers 587202560 bytes, Redo Buffers 7319552 bytes, channel ORA_DISK_1: SID=131 device type=DISK, RMAN-03002: failure of restore command at 06/08/2015 16:41:19, ORA-19870: error while restoring backup piece +RECO/sicsstb/backupset/2015_06_08/nnndf0_tag20150608t163709_0.261.881858229.
RMAN> backup database;Starting backup at 30-OCT-08allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=1620 devtype=DISKfile 4 is excluded from whole database backupchannel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00008 name=/opt/oracle/oradata/STAPLES/datafiledaimin01.dbfinput datafile fno=00001 name=/opt/oracle/oradata/STAPLES/datafile/o1_mf_system_40n25j1h_.dbfinput datafile fno=00003 name=/opt/oracle/oradata/STAPLES/datafile/o1_mf_sysaux_40n25j2m_.dbfinput datafile fno=00002 name=/opt/oracle/oradata/STAPLES/datafile/o1_mf_undotbs1_40n25j77_.dbfinput datafile fno=00007 name=/opt/oracle/oradata/STAPLES/datafile/perfstat.dbfinput datafile fno=00005 name=/opt/oracle/oradata/STAPLES/datafile/MYDBinput datafile fno=00006 name=/opt/oracle/oradata/STAPLES/datafile/test02.dbfchannel ORA_DISK_1: starting piece 1 at 30-OCT-08RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/30/2008 15:28:48ORA-19914: unable to encrypt backupORA-28365: wallet is not open. Oracle Wallet It's an encryption security policy , We used to be TDEOracle Transparent encryption I've looked at this component in part .
explain This article references eygle The teacher's work Oracle DBA Notes 4 Data security alert , Thank you very much . This method is more suitable for local data recovery , If the combination of local and remote recovery , A third hybrid strategy is recommended .
[oracle@hdp orcl]$ ls RMAN>Shutdown;RMAN>startupmount;RMAN>backupdatabase;RMAN>alterdatabaseopen|startup;2.
Found Error : TNS-12560: TNS:protocol adapter erro Rman Catalog script for Tablespace backup.
AWS - Install oracle software and database on EC2 RMAN - Recovering Tables using RMAN RECOVER Comman RMAN - Performing Tablespace Point-in-Time Recover RMAN - Performing database point-in-time recovery RMAN - Recovery of datafiles using Image copy meth AWS - Changing host name on EC2 machine OEL 7.6, Rman complete Recovery of datafile 12.1.0.2.0, DB ID Check Using RMAN database open 12.1.0.2.0.
Copyright (c) 1991, 2013, Oracle. SQL*Plus: Release 12.1.0.2.0 Production on Thu Aug 1 16:28:15 2019.
[oracle@hdp orcl]$ sqlplus/, ------------ --------------- --------------- --------- ---------. RMAN>backupdatabaseplusarchivelogdeleteinput;Startingbackupat09-MAR-12currentlogarchivedusingchannelORA_DISK_1RMAN-00571:===========================================================RMAN-00569:======== #include
Instance "sicsstb", status READY, has 1 handler(s) for this service Set up wallet Directory location , Need modification sqlnet.ora file , Add specific parameter path information . When I went to the backup again, I found that the backup was normal.
The following article is mainly to do a simple demonstration of rman encryption, View the default encryption algorithm of the database.
SQL> alter system set encryption key authenticated by "test"; /u02/app/oracle/product/11.2.0/dbhome_1/network/admin, [[emailprotected] admin]$ cd /u02/app/oracle/admin/sicsstb/WALLET, -rw-r--r-- 1 oracle asmadmin 2845 Jun 8 14:29 ewallet.p12. Multithreading is a must for Java Concurrent Programming. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)), Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production, Start Date 25-MAY-2015 17:39:56, Uptime 13 days 20 hr. RMAN> sql 'ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY oracle'; sql statement: ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY oracle, channel ORA_DISK_1: finished piece 1 at 01-AUG-19, piece handle=/u01/app/oracle/fast_recovery_area/SMR1/backupset/2019_08_01/o1_mf_nnndf_ENCRYPTED_USERS_gn5kxhcv_.bkp tag=ENCRYPTED_USERS comment=NONE, channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01, Oracle Database Commands and Practical Examples. Copyright (c) 1982, 2014, Oracle. , https://javamana.com/2021/04/20210416223018103r.html, [computer network 12 (1), Shang Xuetang Ma soldier java video tutorial, The most complete collection of Java interview questions in history is here, [process of program ape (1), JavaWeb video tutorial, baidu cloud, Spring Boot 03Spring Boot , Refined spring boot 03: spring boot configuration files and configuration management, and reading configuration files in three ways, [recursion, Java intelligence podcast notes, [adhere to painting for 386 days] the beginning of spring of 24 solar terms, K8SServiceEndPointskubeadm, K8s Series Part 8 (service, endpoints and high availability kubeadm deployment), [re recognize HTML (3) and share 350 real Java interview questions, [re recognize HTML (2). All rights reserved.
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Aug 11 12:36: channel ORA_DISK_3: restore complete, elapsed time: 00:00: media recovery complete, elapsed time: 00:00.
Copyright (c) 1982, 2014, Oracle and/or its affiliates. Security is a big topic of information technology today , From technology management The system and personnel should be allocated at various levels , Set up standard process specifications . To put it simply ,Oracle Wallet It is to configure an encrypted configuration file on the local computer , adopt SQL Command control Oracle Wallet It's on and off , If Wallet Closed or nonexistent , So some encrypted information Include TDE and RMAN Backup set The data can't be opened normally . All rights reserved. Use Oracle Wallet Apply to RMAN Backup in progress , A similar transparency strategy can be implemented .
All rights reserved. Go to the corresponding directory and create a wallet folder. # Generated by Oracle configuration tools.
51 sec, Security ON: Local OS Authentication, Listener Parameter File /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora, Listener Log File /u01/app/grid/diag/tnslsnr/NCR-Standby-Asm/listener/alert/log.xml, (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))), (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))).
RMAN> set encryption on identified by "test"; -- Be careful There is no only . The hybrid encryption strategy is actually a combination of the previous two strategies .
If it's off-site recovery , You can use password policies .
But modified sqlnet.ora file , It must be Oracle Instance In the catalog sqlnet.ora file . connected to target database: SMR1 (DBID=3409868754), using target database control file instead of recovery catalog. Using RMAN Transparent-mode Encrypted Backups -Manual, RMAN - Configuring setup Transparent Data Encryption.
How dare you not, [re recognize HTML (1), two Java rookies' 4-sided bytes beat and become slag in seconds, RPC 1: how to develop RPC framework from scratch, Clear it all at once.
:1walletSQL> alter system set encryption key authenticated by "111111";2open wallet --walletwalletSQL> alter system set wallet open identified by "111111"; alter system set wallet open identified by "111111"; SQL> connect / as sysdbaConnected.SQL> alter system set encryption key authenticated by "111111";alter system set encryption key authenticated by "111111"*ERROR at line 1:ORA-28368: cannot auto-create wallet, /opt/oracle/admin/STAPLESwallet, CSDNdaimin1983CC 4.0 BY-SA.
adump dpdump pfile wallet Backup database , Note that this time wallet Turn on .
RAC : Node connectivity check failed (PRVG-11138, PT - Displaying Execution Plan using dbms_xplan.di PT - Execution Plan using EXPLAIN PLAN FOR Command, PT- Enable plustrace for Autotrace schema. 9 min. https://blog.csdn.net/daimin1983/article/details/3185600.
RMAN> BACKUP TABLESPACE users TAG 'ENCRYPTED_USERS'; channel ORA_DISK_1: SID=63 device type=DISK, channel ORA_DISK_1: starting full datafile backup set, channel ORA_DISK_1: specifying datafile(s) in backup set, input datafile file number=00006 name=/u01/app/oracle/oradata/smr1/users01.dbf, channel ORA_DISK_1: starting piece 1 at 01-AUG-19, RMAN-00571: ===========================================================, RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============, RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/01/2019 16:30:58. PT - Displaying Execution Plan using SQL Developer. LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-JUN-2015 13:49:47. SQL> alter system set encryption wallet close identified by "test"; SQL> alter system set encryption wallet open identified by "test"; -- hold wallet Open the. channel ORA_DISK_1: specifying datafile(s) to restore from backup set, channel ORA_DISK_1: restoring datafile 00001 to +DATA/sicsstb/datafile/system.267.881856977, channel ORA_DISK_1: restoring datafile 00002 to +DATA/sicsstb/datafile/sysaux.268.881856977, channel ORA_DISK_1: restoring datafile 00003 to +DATA/sicsstb/datafile/undotbs1.269.881856977, channel ORA_DISK_1: restoring datafile 00004 to +DATA/sicsstb/datafile/users.270.881856977, channel ORA_DISK_1: reading from backup piece +RECO/sicsstb/backupset/2015_06_08/nnndf0_tag20150608t163709_0.261.881858229, RMAN-03002: failure of restore command at 06/08/2015 16:47:42. RMAN> configure encryption for database on; new RMAN configuration parameters are successfully stored.
After opening the wallet, we can continue our operation, Reference : https://blog.csdn.net/stephen11111/article/details/77769577, [oracle@hdp orcl]$ mkdir wallet Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production, With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options, Total System Global Area 1795162112 bytes, Fixed Size 2925456 bytes, Variable Size 553651312 bytes, Database Buffers 1224736768 bytes, Redo Buffers 13848576 bytes.
Copyright (c) 1982, 2013, Oracle.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT), ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/u02/app/oracle/admin/sicsstb/WALLET))), [[emailprotected] admin]$ sqlplus /nolog, SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 8 14:29:28 2015. Be careful The author's GI Single instance ASM Strategy , The monitor is from Grid What's going on inside .
Otherwise, the process of automatically creating the secret key file will fail . PT - Usage: SET AUTOT[RACE] {OFF | ON | TRACE[ONLY RMAN - Restore the SPFILE from AUTOBACKUP on RAC 2 Error : ORA-01919: role 'PLUSTRACE' does not exist. and , Backup sets can only be on the same server With the help of Wallet file To open it correctly . SQL> SELECT KEY_ID FROM V$ENCRYPTION_KEYS; Recovery Manager: Release 12.1.0.2.0 - Production on Thu Aug 1 16:30:41 2019. If local backup recovery , You can use wallet Transparent operation .