课程第17/18次（2018-07-22星期日上下午）

botang

set newname for指导restore和 duplicate，set newname之后如果跟着switch，就是为了把restore出来的镜像拷贝变为数据文件，switch实际上就是alter database rename file '' to ''：

1. run{
   
2. set newname for datafile 5 to '/home/oracle/examplettio.dbf';
   
3. restore datafile 5;
   
4. delete datafilecopy '/home/oracle/examplettio.dbf';
   
5. }
   

复制代码

set newname语法可以在克隆时与 set db_file_name_convert/set log_file_name_convert互相替换。

关于克隆的backup location的语法：
1. 在源头数据库上做：

1. --源头把备份优化关掉，或用force语法
   
2. 
   
3. run {
   
4. allocate channel  c1 device type disk format '/home/oracle/backup/%U';
   
5. allocate channel  c2 device type disk format '/home/oracle/backup/%U';
   
6. allocate channel  c3 device type disk format '/home/oracle/backup/%U';
   
7. allocate channel  c4 device type disk format '/home/oracle/backup/%U';
   
8. allocate channel  c5 device type disk format '/home/oracle/backup/%U';
   
9. allocate channel  c6 device type disk format '/home/oracle/backup/%U';
   
10. allocate channel  c7 device type disk format '/home/oracle/backup/%U';
    
11. allocate channel  c8 device type disk format '/home/oracle/backup/%U';
    
12. backup database plus archivelog force;
    
13. backup spfile;
    
14. backup current controlfile;
    
15. }

复制代码

把源头库上的/home/oracle/backup/完整scp -rp 到目的地机器相同的位置：
在目的机器上写一个只有一行或两行的init.ora：db_name=...  db_domain=...
db_name和db_doamin必须在目的地机器上做静态注册。
开启克隆命令：

1. run{
   
2. duplicate target database to mydb
   
3. backup location '/home/oracle/backup'
   
4. nofilenamecheck
   
5. skip tablespace  'TBS1','TBS2'
   
6. spfile
   
7. set
   
8. control_files='/u01/app/oracle/oradata/mydb/control01.ctl','/u01/app/oracle/oradata/mydb/control02.ctl','/u01/app/oracle/oradata/mydb/control03.ctl'
   
9. set
   
10. db_file_name_convert='+DATA/orcl/datafile/example.258.880451611','/u01/app/oracle/oradata/mydb/example01.dbf','+DATA/orcl/datafile/users.259.880451615','/u01/app/oracle/oradata/mydb/users01.dbf','+DATA/orcl/datafile/undotbs1.256.880451607','/u01/app/oracle/oradata/mydb/undotbs01.dbf','+DATA/orcl/datafile/sysaux.257.880451605','/u01/app/oracle/oradata/mydb/sysaux01.dbf','+DATA/orcl/datafile/system.265.880451605','/u01/app/oracle/oradata/mydb/system01.dbf'
    
11. set
    
12. log_file_name_convert='+DATA/orcl/onlinelog/group_1.270.880453135','/u01/app/oracle/oradata/mydb/redo01a.log','+FRA/orcl/onlinelog/group_1.276.880453137','/u01/app/oracle/oradata/mydb/redo01b.log','+DATA/orcl/onlinelog/group_3.272.880453141','/u01/app/oracle/oradata/mydb/redo03a.log','+FRA/orcl/onlinelog/group_3.274.880453141','/u01/app/oracle/oradata/mydb/redo03b.log','+DATA/orcl/onlinelog/group_2.271.880453137','/u01/app/oracle/oradata/mydb/redo02a.log','+FRA/orcl/onlinelog/group_2.275.880453139','/u01/app/oracle/oradata/mydb/redo02b.log'
    
13. set
    
14. audit_file_dest='/u01/app/oracle/admin/mydb/adump'
    
15. set
    
16. db_create_file_dest=''
    
17. set
    
18. db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
    
19. }

复制代码

如果做dataguard的主备库的口令文件一定要写ignorecase=y
主库改了4个对应的参数：

1. SQL> alter system set log_archive_config='dg_config=(PROD1,STDBY)';
   
2. 
   
3. System altered.
   
4. 
   
5. SQL> alter system set log_archive_dest_1='location=use_db_recovery_file_dest';
   
6. 
   
7. System altered.
   
8. 
   
9. 
   
10. SQL> alter system set log_archive_dest_2='service=STDBY  valid_for=(online_logfiles, primary_role) db_unique_name=STDBY';
    
11. 
    
12. System altered.
    
13. 
    
14. SQL> show parameter standby
    
15. 
    
16. NAME                                     TYPE         VALUE
    
17. ------------------------------------ ----------- ------------------------------
    
18. standby_archive_dest                     string         ?/dbs/arch
    
19. standby_file_management              string         MANUAL
    
20. SQL> alter system set standby_file_management=auto;
    
21. 
    
22. System altered.
    

复制代码

1. SQL> conn / as sysdba
   
2. Connected.
   
3. SQL> alter database enable force logging;
   

复制代码

备库的克隆脚本：

1. run{
   
2. duplicate target database
   
3. for standby
   
4. from active database
   
5. nofilenamecheck
   
6. spfile
   
7. set
   
8. control_files='/u01/app/oracle/oradata/STDBY/control01.ctl','/u01/app/oracle/fast_recovery_area/STDBY/control02.ctl'
   
9. set
   
10. db_file_name_convert='/u01/app/oracle/oradata/PROD1','/u01/app/oracle/oradata/STDBY'
    
11. set
    
12. log_file_name_convert='/u01/app/oracle/oradata/PROD1','/u01/app/oracle/oradata/STDBY'
    
13. set
    
14. audit_file_dest='/u01/app/oracle/admin/STDBY/adump'
    
15. set
    
16. log_archive_dest_2='service=PROD1  valid_for=(online_logfiles, primary_role) db_unique_name=PROD1'
    
17. set
    
18. db_unique_name='STDBY';
    
19. }
    

复制代码

备库RMAN命令：

1. rman target sys/oracle_4U@PROD1 auxiliary sys/oracle_4U@STDBY cmdfile=STDBY.rcv

复制代码

在备库上执行以下命令：

1. SQL> alter database  recover managed standby database disconnect from session;

复制代码

关掉日志应用的命令：

1. SQL> alter database  recover managed standby database  cancel ;
   
2. 
   
3. Database altered.
   
4. 
   
5. SQL> !ps aux | grep mrp
   
6. oracle   18755  0.0  0.0   4732   996 pts/2    S+   02:41   0:00 /bin/bash -c ps aux | grep mrp
   
7. oracle   18757  0.0  0.0   4124   628 pts/2    S+   02:41   0:00 grep mrp
   
8. 
   
9. SQL>
   

复制代码

ADG化：

1. SQL> alter database open read only;
   
2. 
   
3. Database altered.
   
4. 
   
5. SQL> alter database  recover managed standby database disconnect from session;
   
6. 
   
7. Database altered.
   
8. 
   
9. SQL>
   

复制代码

Dmon进程两边打开：

1. [oracle@station37 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.3.0 Production on Sun Jul 22 05:58:43 2018
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn / as sysdba
   
8. Connected.
   
9. SQL> show parameter dg
   
10. 
    
11. NAME                                     TYPE         VALUE
    
12. ------------------------------------ ----------- ------------------------------
    
13. dg_broker_config_file1                     string         /u01/app/oracle/product/11.2.0
    
14.                                                  /dbhome_1/dbs/dr1PROD1.dat
    
15. dg_broker_config_file2                     string         /u01/app/oracle/product/11.2.0
    
16.                                                  /dbhome_1/dbs/dr2PROD1.dat
    
17. dg_broker_start                      boolean         FALSE
    
18. SQL> !ps aux | grep dmon
    
19. oracle   27892  0.0  0.0   4732  1000 pts/1    S+   05:59   0:00 /bin/bash -c ps aux | grep dmon
    
20. oracle   27894  0.0  0.0   4124   620 pts/1    S+   05:59   0:00 grep dmon
    
21. 
    
22. SQL> alter system set dg_broker_start=true;
    
23. 
    
24. System altered.
    
25. 
    
26. SQL> !ps aux | grep dmon
    
27. oracle   27897  0.1  0.1 696232 14600 ?        Ss   05:59   0:00 ora_dmon_PROD1
    
28. oracle   27898  0.0  0.0   4732  1000 pts/1    S+   05:59   0:00 /bin/bash -c ps aux | grep dmon
    
29. oracle   27900  0.0  0.0   4124   640 pts/1    S+   05:59   0:00 grep dmon
    
30. 
    

复制代码

1. SQL>  show parameter dg
   
2. 
   
3. NAME                                     TYPE         VALUE
   
4. ------------------------------------ ----------- ------------------------------
   
5. dg_broker_config_file1                     string         /u01/app/oracle/product/11.2.0
   
6.                                                  /dbhome_1/dbs/dr1STDBY.dat
   
7. dg_broker_config_file2                     string         /u01/app/oracle/product/11.2.0
   
8.                                                  /dbhome_1/dbs/dr2STDBY.dat
   
9. dg_broker_start                      boolean         FALSE
   
10. SQL> !ps aux | grep dmon
    
11. oracle   22939  0.0  0.0   4732  1000 pts/2    S+   05:59   0:00 /bin/bash -c ps aux | grep dmon
    
12. oracle   22941  0.0  0.0   4124   632 pts/2    S+   05:59   0:00 grep dmon
    
13. 
    
14. SQL> alter system set dg_broker_start=true;
    
15. 
    
16. System altered.
    
17. 
    
18. SQL> !ps aux | grep dmon
    
19. oracle   22955  0.3  0.1 696232 14512 ?        Ss   05:59   0:00 ora_dmon_STDBY
    
20. oracle   22956  0.0  0.0   4732  1000 pts/2    S+   05:59   0:00 /bin/bash -c ps aux | grep dmon
    
21. oracle   22958  0.0  0.0   4124   636 pts/2    S+   05:59   0:00 grep dmon
    
22. 
    
23. SQL>
    

复制代码

Dataguard构造：

1. [oracle@station37 ~]$ dgmgrl
   
2. DGMGRL for Linux: Version 11.2.0.3.0 - Production
   
3. 
   
4. Copyright (c) 2000, 2009, Oracle. All rights reserved.
   
5. 
   
6. Welcome to DGMGRL, type "help" for information.
   
7. DGMGRL> connect sys/oracle_4U@PROD1
   
8. Connected.
   
9. DGMGRL> help
   
10. 
    
11. The following commands are available:
    
12. 
    
13. add            Adds a standby database to the broker configuration
    
14. connect        Connects to an Oracle database instance
    
15. convert        Converts a database from one type to another
    
16. create         Creates a broker configuration
    
17. disable        Disables a configuration, a database, or fast-start failover
    
18. edit           Edits a configuration, database, or instance
    
19. enable         Enables a configuration, a database, or fast-start failover
    
20. exit           Exits the program
    
21. failover       Changes a standby database to be the primary database
    
22. help           Displays description and syntax for a command
    
23. quit           Exits the program
    
24. reinstate      Changes a database marked for reinstatement into a viable standby
    
25. rem            Comment to be ignored by DGMGRL
    
26. remove         Removes a configuration, database, or instance
    
27. show           Displays information about a configuration, database, or instance
    
28. shutdown       Shuts down a currently running Oracle database instance
    
29. sql            Executes a SQL statement
    
30. start          Starts the fast-start failover observer
    
31. startup        Starts an Oracle database instance
    
32. stop           Stops the fast-start failover observer
    
33. switchover     Switches roles between a primary and standby database
    
34. 
    
35. Use "help <command>" to see syntax for individual commands
    

复制代码

----------------------------------------

1. [oracle@station37 ~]$ dgmgrl
   
2. DGMGRL for Linux: Version 11.2.0.3.0 - Production
   
3. 
   
4. Copyright (c) 2000, 2009, Oracle. All rights reserved.
   
5. 
   
6. Welcome to DGMGRL, type "help" for information.
   
7. DGMGRL> connect sys/oracle_4U@PROD1
   
8. Connected.
   
9. DGMGRL> help create
   
10. 
    
11. Creates a broker configuration
    
12. 
    
13. Syntax:
    
14. 
    
15.   CREATE CONFIGURATION <configuration name> AS
    
16.     PRIMARY DATABASE IS <database name>
    
17.     CONNECT IDENTIFIER IS <connect identifier>;
    
18. 
    
19. DGMGRL> CREATE CONFIGURATION PROD1  as
    
20. >  PRIMARY DATABASE IS  'PROD1'
    
21. > CONNECT IDENTIFIER IS PROD1;
    
22. Configuration "prod1" created with primary database "PROD1"
    
23. DGMGRL> help add
    
24. 
    
25. Adds a standby database to the broker configuration
    
26. 
    
27. Syntax:
    
28. 
    
29.   ADD DATABASE <database name>
    
30.     [AS CONNECT IDENTIFIER IS <connect identifier>]
    
31.     [MAINTAINED AS {PHYSICAL|LOGICAL}];
    
32. 
    
33. DGMGRL>  ADD DATABASE 'STDBY'
    
34. > AS CONNECT IDENTIFIER IS STDBY
    
35. >  MAINTAINED AS  PHYSICAL;
    
36. Database "STDBY" added
    
37. DGMGRL> enable configuration;
    
38. Enabled.
    
39. DGMGRL> show configuration verbose;
    
40. 
    
41. Configuration - prod1
    
42. 
    
43.   Protection Mode: MaxPerformance
    
44.   Databases:
    
45.     PROD1 - Primary database
    
46.     STDBY - Physical standby database
    
47. 
    
48.   Properties:
    
49.     FastStartFailoverThreshold      = '30'
    
50.     OperationTimeout                = '30'
    
51.     FastStartFailoverLagLimit       = '30'
    
52.     CommunicationTimeout            = '180'
    
53.     FastStartFailoverAutoReinstate  = 'TRUE'
    
54.     FastStartFailoverPmyShutdown    = 'TRUE'
    
55.     BystandersFollowRoleChange      = 'ALL'
    
56. 
    
57. Fast-Start Failover: DISABLED
    
58. 
    
59. Configuration Status:
    
60. SUCCESS
    
61. 
    
62. DGMGRL> DGMGRL> [oracle@station37 ~]$
    

复制代码

1. DGMGRL> show database verbose'PROD1';
   
2. 
   
3. Database - PROD1
   
4. 
   
5.   Role:            PRIMARY
   
6.   Intended State:  TRANSPORT-ON
   
7.   Instance(s):
   
8.     PROD1
   
9. 
   
10.   Properties:
    
11.     DGConnectIdentifier             = 'prod1'
    
12.     ObserverConnectIdentifier       = ''
    
13.     LogXptMode                      = 'ASYNC'
    
14.     DelayMins                       = '0'
    
15.     Binding                         = 'optional'
    
16.     MaxFailure                      = '0'
    
17.     MaxConnections                  = '1'
    
18.     ReopenSecs                      = '300'
    
19.     NetTimeout                      = '30'
    
20.     RedoCompression                 = 'DISABLE'
    
21.     LogShipping                     = 'ON'
    
22.     PreferredApplyInstance          = ''
    
23.     ApplyInstanceTimeout            = '0'
    
24.     ApplyParallel                   = 'AUTO'
    
25.     StandbyFileManagement           = 'AUTO'
    
26.     ArchiveLagTarget                = '0'
    
27.     LogArchiveMaxProcesses          = '4'
    
28.     LogArchiveMinSucceedDest        = '1'
    
29.     DbFileNameConvert               = ''
    
30.     LogFileNameConvert              = ''
    
31.     FastStartFailoverTarget         = ''
    
32.     InconsistentProperties          = '(monitor)'
    
33.     InconsistentLogXptProps         = '(monitor)'
    
34.     SendQEntries                    = '(monitor)'
    
35.     LogXptStatus                    = '(monitor)'
    
36.     RecvQEntries                    = '(monitor)'
    
37.     SidName                         = 'PROD1'
    
38.     StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station37.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PROD1_DGMGRL)(INSTANCE_NAME=PROD1)(SERVER=DEDICATED)))'
    
39.     StandbyArchiveLocation          = 'USE_DB_RECOVERY_FILE_DEST'
    
40.     AlternateLocation               = ''
    
41.     LogArchiveTrace                 = '0'
    
42.     LogArchiveFormat                = '%t_%s_%r.dbf'
    
43.     TopWaitEvents                   = '(monitor)'
    
44. 
    
45. Database Status:
    
46. SUCCESS
    
47. 
    
48. DGMGRL> show database verbose 'STDBY';
    
49. 
    
50. Database - STDBY
    
51. 
    
52.   Role:            PHYSICAL STANDBY
    
53.   Intended State:  APPLY-ON
    
54.   Transport Lag:   0 seconds
    
55.   Apply Lag:       0 seconds
    
56.   Real Time Query: ON
    
57.   Instance(s):
    
58.     STDBY
    
59. 
    
60.   Properties:
    
61.     DGConnectIdentifier             = 'stdby'
    
62.     ObserverConnectIdentifier       = ''
    
63.     LogXptMode                      = 'ASYNC'
    
64.     DelayMins                       = '0'
    
65.     Binding                         = 'OPTIONAL'
    
66.     MaxFailure                      = '0'
    
67.     MaxConnections                  = '1'
    
68.     ReopenSecs                      = '300'
    
69.     NetTimeout                      = '30'
    
70.     RedoCompression                 = 'DISABLE'
    
71.     LogShipping                     = 'ON'
    
72.     PreferredApplyInstance          = ''
    
73.     ApplyInstanceTimeout            = '0'
    
74.     ApplyParallel                   = 'AUTO'
    
75.     StandbyFileManagement           = 'AUTO'
    
76.     ArchiveLagTarget                = '0'
    
77.     LogArchiveMaxProcesses          = '4'
    
78.     LogArchiveMinSucceedDest        = '1'
    
79.     DbFileNameConvert               = '/u01/app/oracle/oradata/PROD1, /u01/app/oracle/oradata/STDBY'
    
80.     LogFileNameConvert              = '/u01/app/oracle/oradata/PROD1, /u01/app/oracle/oradata/STDBY'
    
81.     FastStartFailoverTarget         = ''
    
82.     InconsistentProperties          = '(monitor)'
    
83.     InconsistentLogXptProps         = '(monitor)'
    
84.     SendQEntries                    = '(monitor)'
    
85.     LogXptStatus                    = '(monitor)'
    
86.     RecvQEntries                    = '(monitor)'
    
87.     SidName                         = 'STDBY'
    
88.     StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=station38.example.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=STDBY_DGMGRL)(INSTANCE_NAME=STDBY)(SERVER=DEDICATED)))'
    
89.     StandbyArchiveLocation          = 'USE_DB_RECOVERY_FILE_DEST'
    
90.     AlternateLocation               = ''
    
91.     LogArchiveTrace                 = '0'
    
92.     LogArchiveFormat                = '%t_%s_%r.dbf'
    
93.     TopWaitEvents                   = '(monitor)'
    
94. 
    
95. Database Status:
    
96. SUCCESS
    
97. 
    
98. DGMGRL>
    

复制代码

如果改保护模式时，报告：

1. DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability;
   
2. Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode
   
3. 
   
4. Failed.
   
5. DGMGRL>
   

复制代码

说明没有改LOGXPTMODE：
备库的broker属性是主库的参数文件参数；主库的broker属性是备库的参数文件参数：


两头改闪回，并且打开Real Time Apply：

1. SQL> select  flashback_on from v$database;
   
2. 
   
3. FLASHBACK_ON
   
4. ------------------
   
5. NO
   
6. 
   
7. SQL> alter database flashback on ;
   
8. alter database flashback on
   
9. *
   
10. ERROR at line 1:
    
11. ORA-01153: an incompatible media recovery is active
    
12. 
    
13. 
    
14. SQL> alter database recover managed standby database cancel ;
    
15. 
    
16. Database altered.
    
17. 
    
18. SQL> alter database flashback on ;
    
19. 
    
20. Database altered.
    
21. 
    
22. SQL> alter database recover managed standby database using current logfile disconnect;
    
23. 
    
24. Database altered.
    
25. 
    
26. SQL>
    

复制代码

快照物理备库，实际上就是过去1. 手工创建保障闪回还原点；2.激活物理备库。

1. DGMGRL>  CONVERT DATABASE 'STDBY' to SNAPSHOT STANDBY;
   
2. Converting database "STDBY" to a Snapshot Standby database, please wait...
   
3. Database "STDBY" converted successfully
   

复制代码

1. SQL> select  * from v$restore_point;
   
2. 
   
3.        SCN DATABASE_INCARNATION# GUA STORAGE_SIZE TIME                                                                              RESTORE_POINT_TIME                                                          PRE NAME
   
4. ---------- --------------------- --- ------------ --------------------------------------------------------------------------- --------------------------------------------------------------------------- --- --------------------------------------------------------------------------------------------------------------------------------
   
5.    1002609                       2 YES         52428800 22-JUL-15 06.38.53.000000000 AM                                                          YES SNAPSHOT_STANDBY_REQUIRED_07/22/2015 06:38:53
   
6. 
   

复制代码

在物理备库上打开块跟踪：

1. SQL> alter database enable block change tracking using file '/u01/app/oracle/fast_recovery_area/STDBY/ctwr.f';
   
2. 
   
3. Database altered.
   
4. 
   
5. SQL> !ps aux | grep ora_ctwr
   
6. oracle   24736  0.1  0.1 695884 14452 ?        Ss   07:04   0:00 ora_ctwr_STDBY
   
7. oracle   24739  0.0  0.0   4732   996 pts/2    S+   07:05   0:00 /bin/bash -c ps aux | grep ora_ctwr
   
8. oracle   24741  0.0  0.0   4124   632 pts/2    S+   07:05   0:00 grep ora_ctwr
   
9. 
   
10. SQL>
    

复制代码

下面最后一道题：快速启动故障转移。
----------------------------------------------------------------------------
归档性备份:9i的时候是事后做，而11g同时做：
9i：

1. RMAN> change backupset 2 keep until  time 'sysdate+60';
   
2. 
   
3. allocated channel: ORA_DISK_1
   
4. channel ORA_DISK_1: SID=11 device type=DISK
   
5. RMAN-00571: ===========================================================
   
6. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
   
7. RMAN-00571: ===========================================================
   
8. RMAN-03009: failure of KEEP command on ORA_DISK_1 channel at 07/22/2018 17:03:49
   
9. ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
   
10. 
    
11. RMAN> run {
    
12. 2> allocate channel c1 device type disk format '/home/oracle/%U';
    
13. 3> backup backupset 2 force delete input;
    
14. 4> change backupset 2 keep until  time 'sysdate+60';
    
15. 5> }
    
16. 
    
17. released channel: ORA_DISK_1
    
18. allocated channel: c1
    
19. channel c1: SID=11 device type=DISK
    
20. 
    
21. Starting backup at 22-JUL-18
    
22. channel c1: input backup set: count=2, stamp=981994123, piece=1
    
23. channel c1: starting piece 1 at 22-JUL-18
    
24. channel c1: backup piece +FRA/orcl/backupset/2018_07_20/nnndf0_tag20180720t160842_0.262.981994123
    
25. piece handle=/home/oracle/02t8g2kb_1_2 comment=NONE
    
26. channel c1: finished piece 1 at 22-JUL-18
    
27. channel c1: backup piece complete, elapsed time: 00:00:36
    
28. deleted backup piece
    
29. backup piece handle=+FRA/orcl/backupset/2018_07_20/nnndf0_tag20180720t160842_0.262.981994123 RECID=2 STAMP=981994123
    
30. Finished backup at 22-JUL-18
    
31. 
    
32. keep attributes for the backup are changed
    
33. backup will be obsolete on date 20-SEP-18
    
34. backup set key=2 RECID=2 STAMP=981994142
    
35. released channel: c1
    
36. 
    

复制代码

1. RMAN> run {
   
2. 2> allocate channel c1 device type disk format '/home/oracle/example_%U.bkp';
   
3. 3> backup tag 'TAG2'  tablespace example keep until time 'sysdate+600';
   
4. 4> }
   
5. 
   
6. released channel: ORA_DISK_1
   
7. allocated channel: c1
   
8. channel c1: SID=11 device type=DISK
   
9. 
   
10. Starting backup at 22-JUL-18
    
11. current log archived
    
12. 
    
13. backup will be obsolete on date 13-MAR-20
    
14. archived logs required to recover from this backup will be backed up
    
15. channel c1: starting full datafile backup set
    
16. channel c1: specifying datafile(s) in backup set
    
17. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.979605007
    
18. channel c1: starting piece 1 at 22-JUL-18
    
19. channel c1: finished piece 1 at 22-JUL-18
    
20. piece handle=/home/oracle/example_0at8lefa_1_1.bkp tag=TAG2 comment=NONE
    
21. channel c1: backup set complete, elapsed time: 00:00:03
    
22. 
    
23. backup will be obsolete on date 13-MAR-20
    
24. archived logs required to recover from this backup will be backed up
    
25. channel c1: starting full datafile backup set
    
26. channel c1: specifying datafile(s) in backup set
    
27. including current SPFILE in backup set
    
28. channel c1: starting piece 1 at 22-JUL-18
    
29. channel c1: finished piece 1 at 22-JUL-18
    
30. piece handle=/home/oracle/example_0bt8lefd_1_1.bkp tag=TAG2 comment=NONE
    
31. channel c1: backup set complete, elapsed time: 00:00:01
    
32. 
    
33. current log archived
    
34. backup will be obsolete on date 13-MAR-20
    
35. archived logs required to recover from this backup will be backed up
    
36. channel c1: starting archived log backup set
    
37. channel c1: specifying archived log(s) in backup set
    
38. input archived log thread=1 sequence=5 RECID=16 STAMP=982170096
    
39. channel c1: starting piece 1 at 22-JUL-18
    
40. channel c1: finished piece 1 at 22-JUL-18
    
41. piece handle=/home/oracle/example_0ct8lefh_1_1.bkp tag=TAG2 comment=NONE
    
42. channel c1: backup set complete, elapsed time: 00:00:01
    
43. 
    
44. backup will be obsolete on date 13-MAR-20
    
45. archived logs required to recover from this backup will be backed up
    
46. channel c1: starting full datafile backup set
    
47. channel c1: specifying datafile(s) in backup set
    
48. including current control file in backup set
    
49. channel c1: starting piece 1 at 22-JUL-18
    
50. channel c1: finished piece 1 at 22-JUL-18
    
51. piece handle=/home/oracle/example_0dt8lefi_1_1.bkp tag=TAG2 comment=NONE
    
52. channel c1: backup set complete, elapsed time: 00:00:01
    
53. Finished backup at 22-JUL-18
    
54. released channel: c1
    
55. 
    
56. RMAN> list backup of tablespace example;
    
57. 
    
58. 
    
59. List of Backup Sets
    
60. ===================
    
61. 
    
62. 
    
63. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
64. ------- ---- -- ---------- ----------- ------------ ---------------
    
65. 2       Full    1.03G      DISK        00:00:19     20-JUL-18      
    
66.         BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20180720T160842
    
67.         Piece Name: +FRA/orcl/backupset/2018_07_20/nnndf0_tag20180720t160842_0.262.981994123
    
68.   List of Datafiles in backup set 2
    
69.   File LV Type Ckp SCN    Ckp Time  Name
    
70.   ---- -- ---- ---------- --------- ----
    
71.   5       Full 884504     20-JUL-18 +DATA/orcl/datafile/example.265.979605007
    
72. 
    
73. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
74. ------- ---- -- ---------- ----------- ------------ ---------------
    
75. 5       Full    69.57M     DISK        00:00:02     22-JUL-18      
    
76.         BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG2
    
77.         Piece Name: /home/oracle/example_0at8lefa_1_1.bkp
    
78.         Keep: BACKUP_LOGS        Until: 13-MAR-20      
    
79.   List of Datafiles in backup set 5
    
80.   File LV Type Ckp SCN    Ckp Time  Name
    
81.   ---- -- ---- ---------- --------- ----
    
82.   5       Full 956748     22-JUL-18 +DATA/orcl/datafile/example.265.979605007
    
83. 
    
84. RMAN> list backup of archivelog all;
    
85. 
    
86. 
    
87. List of Backup Sets
    
88. ===================
    
89. 
    
90. 
    
91. BS Key  Size       Device Type Elapsed Time Completion Time
    
92. ------- ---------- ----------- ------------ ---------------
    
93. 7       8.00K      DISK        00:00:00     22-JUL-18      
    
94.         BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG2
    
95.         Piece Name: /home/oracle/example_0ct8lefh_1_1.bkp
    
96.         Keep: BACKUP_LOGS        Until: 13-MAR-20      
    
97. 
    
98.   List of Archived Logs in backup set 7
    
99.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
100.   ---- ------- ---------- --------- ---------- ---------
     
101.   1    5       956744     22-JUL-18 956761     22-JUL-18
     

复制代码

1. RMAN> run {                       
   
2. 2> allocate channel c1 device type disk format '/home/oracle/example_%U.bkp';
   
3. 3> backup tag 'TAG3' tablespace example keep  forever;
   
4. 4> }
   
5. 
   
6. allocated channel: c1
   
7. channel c1: SID=11 device type=DISK
   
8. 
   
9. Starting backup at 22-JUL-18
   
10. current log archived
    
11. 
    
12. released channel: c1
    
13. RMAN-00571: ===========================================================
    
14. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
15. RMAN-00571: ===========================================================
    
16. RMAN-03002: failure of backup command at 07/22/2018 17:10:07
    
17. RMAN-06522: KEEP FOREVER option is not supported without the recovery catalog
    
18. 
    

复制代码

1. [oracle@station36 admin]$ rman target /  catalog u36/oracle_4U@rcat
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jul 22 17:14:13 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1507385682)
   
8. connected to recovery catalog database
   
9. 
   
10. RMAN> run {
    
11. 2> allocate channel c1 device type disk format '/home/oracle/example_%U.bkp';
    
12. 3> backup tag 'TAG3' tablespace example keep  forever restore point tag3;
    
13. 4> }
    
14. 
    
15. allocated channel: c1
    
16. channel c1: SID=75 device type=DISK
    
17. 
    
18. Starting backup at 22-JUL-18
    
19. current log archived
    
20. 
    
21. backup will never be obsolete
    
22. archived logs required to recover from this backup will be backed up
    
23. channel c1: starting full datafile backup set
    
24. channel c1: specifying datafile(s) in backup set
    
25. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.979605007
    
26. channel c1: starting piece 1 at 22-JUL-18
    
27. channel c1: finished piece 1 at 22-JUL-18
    
28. piece handle=/home/oracle/example_0et8lf86_1_1.bkp tag=TAG3 comment=NONE
    
29. channel c1: backup set complete, elapsed time: 00:00:01
    
30. 
    
31. backup will never be obsolete
    
32. archived logs required to recover from this backup will be backed up
    
33. channel c1: starting full datafile backup set
    
34. channel c1: specifying datafile(s) in backup set
    
35. including current SPFILE in backup set
    
36. channel c1: starting piece 1 at 22-JUL-18
    
37. channel c1: finished piece 1 at 22-JUL-18
    
38. piece handle=/home/oracle/example_0ft8lf87_1_1.bkp tag=TAG3 comment=NONE
    
39. channel c1: backup set complete, elapsed time: 00:00:01
    
40. 
    
41. 
    
42. current log archived
    
43. backup will never be obsolete
    
44. archived logs required to recover from this backup will be backed up
    
45. channel c1: starting archived log backup set
    
46. channel c1: specifying archived log(s) in backup set
    
47. input archived log thread=1 sequence=8 RECID=19 STAMP=982170890
    
48. channel c1: starting piece 1 at 22-JUL-18
    
49. channel c1: finished piece 1 at 22-JUL-18
    
50. piece handle=/home/oracle/example_0gt8lf8b_1_1.bkp tag=TAG3 comment=NONE
    
51. channel c1: backup set complete, elapsed time: 00:00:01
    
52. 
    
53. backup will never be obsolete
    
54. archived logs required to recover from this backup will be backed up
    
55. channel c1: starting full datafile backup set
    
56. channel c1: specifying datafile(s) in backup set
    
57. including current control file in backup set
    
58. channel c1: starting piece 1 at 22-JUL-18
    
59. channel c1: finished piece 1 at 22-JUL-18
    
60. piece handle=/home/oracle/example_0ht8lf8c_1_1.bkp tag=TAG3 comment=NONE
    
61. channel c1: backup set complete, elapsed time: 00:00:01
    
62. Finished backup at 22-JUL-18
    
63. released channel: c1
    
64. 
    
65. RMAN>
    

复制代码

1. [oracle@station36 admin]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 22 17:15:22 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn / as sysdba
   
8. Connected.
   
9. SQL> set linesize 1000
   
10. SQL> select  * from v$restore_point;
    
11. 
    
12.        SCN DATABASE_INCARNATION# GUA STORAGE_SIZE TIME                                                                              RESTORE_POINT_TIME                                                          PRE NAME
    
13. ---------- --------------------- --- ------------ --------------------------------------------------------------------------- --------------------------------------------------------------------------- --- --------------------------------------------------------------------------------------------------------------------------------
    
14.     958398                       4 NO                0 22-JUL-18 05.14.48.000000000 PM                                                          NO  TAG3
    
15. 
    
16. SQL>
    

复制代码

如果agent死活上传失败，考虑在EMREP上执行：

1. execute mgmt_admin.cleanup_agent('station37.example.com:3872');

复制代码

再装-b -y