- root@hu ~]# su - oracle
- [oracle@hu ~]$ sqlplus / as sysdba
-
- SQL*Plus: Release 11.2.0.4.0 Production on Sun May 7 10:08:36 2017
-
- Copyright (c) 1982, 2013, Oracle. All rights reserved.
-
-
- Connected to:
- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
-
- SQL>
- SQL> alter database backup controlfile to trace;
-
- Database altered.
-
- SQL>
- SQL> show parameter user_dump
-
- NAME TYPE VALUE
- ------------------------------------ ----------- ------------------------------
- user_dump_dest string /u01/app/oracle/diag/rdbms/hu/
- HU/trace
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- [oracle@hu ~]$ cd /u01/app/oracle/diag/rdbms/hu/HU/trace/
- [oracle@hu trace]$ ls -lrt
- total 832
- -rw-r----- 1 oracle oinstall 78 Apr 22 18:13 HU_ora_9399.trm
- -rw-r----- 1 oracle oinstall 827 Apr 22 18:13 HU_ora_9399.trc
- -rw-r----- 1 oracle oinstall 67 Apr 22 18:13 HU_ora_9474.trm
- -rw-r----- 1 oracle oinstall 1729 Apr 22 18:13 HU_ora_9474.trc
- -rw-r----- 1 oracle oinstall 65 Apr 22 18:13 HU_mman_9435.trm
- -rw-r----- 1 oracle oinstall 843 Apr 22 18:13 HU_mman_9435.trc
- -rw-r----- 1 oracle oinstall 86 Apr 22 18:16 HU_vktm_9413.trm
- -rw-r----- 1 oracle oinstall 1184 Apr 22 18:16 HU_vktm_9413.trc
- -rw-r----- 1 oracle oinstall 105 Apr 22 18:16 HU_ora_9492.trm
- -rw-r----- 1 oracle oinstall 1339 Apr 22 18:16 HU_ora_9492.trc
- -rw-r----- 1 oracle oinstall 78 Apr 22 18:16 HU_ora_9496.trm
- -rw-r----- 1 oracle oinstall 828 Apr 22 18:16 HU_ora_9496.trc
- -rw-r----- 1 oracle oinstall 57 Apr 22 18:16 HU_mman_9532.trm
- -rw-r----- 1 oracle oinstall 843 Apr 22 18:16 HU_mman_9532.trc
- -rw-r----- 1 oracle oinstall 178 Apr 22 18:16 HU_m000_9583.trm
- -rw-r----- 1 oracle oinstall 1068 Apr 22 18:16 HU_m000_9583.trc
- -rw-r----- 1 oracle oinstall 58 Apr 22 18:16 HU_mmon_9575.trm
- -rw-r----- 1 oracle oinstall 909 Apr 22 18:16 HU_mmon_9575.trc
- -rw-r----- 1 oracle oinstall 764 Apr 22 18:16 HU_ora_9571.trm
- -rw-r----- 1 oracle oinstall 8984 Apr 22 18:16 HU_ora_9571.trc
- -rw-r----- 1 oracle oinstall 119 Apr 22 18:16 HU_cjq0_9599.trm
- -rw-r----- 1 oracle oinstall 1249 Apr 22 18:16 HU_cjq0_9599.trc
- -rw-r----- 1 oracle oinstall 82 Apr 22 18:16 HU_j005_9630.trm
- -rw-r----- 1 oracle oinstall 959 Apr 22 18:16 HU_j005_9630.trc
- -rw-r----- 1 oracle oinstall 58 Apr 22 18:16 HU_ora_9606.trm
- -rw-r----- 1 oracle oinstall 997 Apr 22 18:16 HU_ora_9606.trc
- -rw-r----- 1 oracle oinstall 65 Apr 22 18:17 HU_ora_9676.trm
- -rw-r----- 1 oracle oinstall 892 Apr 22 18:17 HU_ora_9676.trc
- -rw-r----- 1 oracle oinstall 66 Apr 22 18:17 HU_dm00_9684.trm
- -rw-r----- 1 oracle oinstall 966 Apr 22 18:17 HU_dm00_9684.trc
- -rw-r----- 1 oracle oinstall 86 Apr 22 18:17 HU_dbrm_9524.trm
- -rw-r----- 1 oracle oinstall 1260 Apr 22 18:17 HU_dbrm_9524.trc
- -rw-r----- 1 oracle oinstall 180 Apr 22 18:18 HU_dw00_9688.trm
- -rw-r----- 1 oracle oinstall 1646 Apr 22 18:18 HU_dw00_9688.trc
- -rw-r----- 1 oracle oinstall 57 Apr 22 18:19 HU_ora_9728.trm
- -rw-r----- 1 oracle oinstall 942 Apr 22 18:19 HU_ora_9728.trc
- -rw-r----- 1 oracle oinstall 109 Apr 22 18:20 HU_ora_9755.trm
- -rw-r----- 1 oracle oinstall 1058 Apr 22 18:20 HU_ora_9755.trc
- -rw-r----- 1 oracle oinstall 85 Apr 22 18:20 HU_vktm_9510.trm
- -rw-r----- 1 oracle oinstall 1184 Apr 22 18:20 HU_vktm_9510.trc
- -rw-r----- 1 oracle oinstall 117 Apr 22 18:20 HU_ora_9758.trm
- -rw-r----- 1 oracle oinstall 1361 Apr 22 18:20 HU_ora_9758.trc
- -rw-r----- 1 oracle oinstall 65 Apr 22 18:20 HU_ckpt_9544.trm
- -rw-r----- 1 oracle oinstall 946 Apr 22 18:20 HU_ckpt_9544.trc
- -rw-r----- 1 oracle oinstall 77 Apr 22 18:20 HU_ora_9762.trm
- -rw-r----- 1 oracle oinstall 827 Apr 22 18:20 HU_ora_9762.trc
- -rw-r----- 1 oracle oinstall 57 Apr 22 18:20 HU_mman_9798.trm
- -rw-r----- 1 oracle oinstall 843 Apr 22 18:20 HU_mman_9798.trc
- -rw-r----- 1 oracle oinstall 57 Apr 22 18:20 HU_ora_9837.trm
- -rw-r----- 1 oracle oinstall 868 Apr 22 18:20 HU_ora_9837.trc
- -rw-r----- 1 oracle oinstall 74 Apr 22 18:20 HU_ora_9848.trm
- -rw-r----- 1 oracle oinstall 967 Apr 22 18:20 HU_ora_9848.trc
- -rw-r----- 1 oracle oinstall 78 Apr 22 18:21 HU_dbrm_9790.trm
- -rw-r----- 1 oracle oinstall 1260 Apr 22 18:21 HU_dbrm_9790.trc
- -rw-r----- 1 oracle oinstall 70 Apr 22 18:25 HU_mmon_9822.trm
- -rw-r----- 1 oracle oinstall 1040 Apr 22 18:25 HU_mmon_9822.trc
- -rw-r----- 1 oracle oinstall 172 Apr 22 18:26 HU_m000_9931.trm
- -rw-r----- 1 oracle oinstall 2982 Apr 22 18:26 HU_m000_9931.trc
- -rw-r----- 1 oracle oinstall 85 Apr 22 18:26 HU_vktm_9776.trm
- -rw-r----- 1 oracle oinstall 1184 Apr 22 18:26 HU_vktm_9776.trc
- -rw-r----- 1 oracle oinstall 135 Apr 22 18:26 HU_ora_9945.trm
- -rw-r----- 1 oracle oinstall 1361 Apr 22 18:26 HU_ora_9945.trc
- -rw-r----- 1 oracle oinstall 78 Apr 22 18:26 HU_ora_9949.trm
- -rw-r----- 1 oracle oinstall 856 Apr 22 18:26 HU_ora_9949.trc
- -rw-r----- 1 oracle oinstall 66 Apr 22 18:26 HU_mman_9985.trm
- -rw-r----- 1 oracle oinstall 843 Apr 22 18:26 HU_mman_9985.trc
- -rw-r----- 1 oracle oinstall 67 Apr 22 18:26 HU_ora_10035.trm
- -rw-r----- 1 oracle oinstall 969 Apr 22 18:26 HU_ora_10035.trc
- -rw-r----- 1 oracle oinstall 87 Apr 22 18:27 HU_dbrm_9977.trm
- -rw-r----- 1 oracle oinstall 1260 Apr 22 18:27 HU_dbrm_9977.trc
- -rw-r----- 1 oracle oinstall 118 Apr 22 20:05 HU_lgwr_9993.trm
- -rw-r----- 1 oracle oinstall 2011 Apr 22 20:05 HU_lgwr_9993.trc
- -rw-r----- 1 oracle oinstall 76 Apr 22 22:35 HU_cjq0_10071.trm
- -rw-r----- 1 oracle oinstall 978 Apr 22 22:35 HU_cjq0_10071.trc
- -rw-r----- 1 oracle oinstall 112 Apr 22 22:37 HU_vktm_9963.trm
- -rw-r----- 1 oracle oinstall 1507 Apr 22 22:37 HU_vktm_9963.trc
- -rw-r----- 1 oracle oinstall 436 Apr 22 23:16 HU_mmon_10009.trm
- -rw-r----- 1 oracle oinstall 4318 Apr 22 23:16 HU_mmon_10009.trc
- -rw-r----- 1 oracle oinstall 79 Apr 22 23:45 HU_ora_4679.trm
- -rw-r----- 1 oracle oinstall 856 Apr 22 23:45 HU_ora_4679.trc
- -rw-r----- 1 oracle oinstall 57 Apr 22 23:45 HU_mman_4716.trm
- -rw-r----- 1 oracle oinstall 843 Apr 22 23:45 HU_mman_4716.trc
- -rw-r----- 1 oracle oinstall 209 Apr 22 23:45 HU_ora_4767.trm
- -rw-r----- 1 oracle oinstall 2678 Apr 22 23:45 HU_ora_4767.trc
- -rw-r----- 1 oracle oinstall 57 Apr 27 16:23 HU_lgwr_4724.trm
- -rw-r----- 1 oracle oinstall 875 Apr 27 16:23 HU_lgwr_4724.trc
- -rw-r----- 1 oracle oinstall 65 Apr 27 16:24 HU_w000_5970.trm
- -rw-r----- 1 oracle oinstall 997 Apr 27 16:24 HU_w000_5970.trc
- -rw-r----- 1 oracle oinstall 67 Apr 27 16:24 HU_j000_6136.trm
- -rw-r----- 1 oracle oinstall 960 Apr 27 16:24 HU_j000_6136.trc
- -rw-r----- 1 oracle oinstall 129 Apr 29 00:50 HU_vktm_4693.trm
- -rw-r----- 1 oracle oinstall 1653 Apr 29 00:50 HU_vktm_4693.trc
- -rw-r----- 1 oracle oinstall 57 Apr 29 00:50 HU_smon_4732.trm
- -rw-r----- 1 oracle oinstall 929 Apr 29 00:50 HU_smon_4732.trc
- -rw-r----- 1 oracle oinstall 57 Apr 29 00:50 HU_vkrm_6178.trm
- -rw-r----- 1 oracle oinstall 966 Apr 29 00:50 HU_vkrm_6178.trc
- -rw-r----- 1 oracle oinstall 298 Apr 29 00:50 HU_mmon_4740.trm
- -rw-r----- 1 oracle oinstall 3195 Apr 29 00:50 HU_mmon_4740.trc
- -rw-r----- 1 oracle oinstall 67 Apr 29 00:50 HU_cjq0_4795.trm
- -rw-r----- 1 oracle oinstall 984 Apr 29 00:50 HU_cjq0_4795.trc
- -rw-r----- 1 oracle oinstall 67 Apr 29 00:50 HU_j003_6154.trm
- -rw-r----- 1 oracle oinstall 931 Apr 29 00:50 HU_j003_6154.trc
- -rw-r----- 1 oracle oinstall 257 Apr 29 00:51 HU_j005_6162.trm
- -rw-r----- 1 oracle oinstall 2990 Apr 29 00:51 HU_j005_6162.trc
- -rw-r----- 1 oracle oinstall 163 Apr 29 00:52 HU_dbrm_4708.trm
- -rw-r----- 1 oracle oinstall 12322 Apr 29 00:52 HU_dbrm_4708.trc
- -rw-r----- 1 oracle oinstall 79 May 5 16:00 HU_ora_4810.trm
- -rw-r----- 1 oracle oinstall 856 May 5 16:00 HU_ora_4810.trc
- -rw-r----- 1 oracle oinstall 65 May 5 16:01 HU_mman_4852.trm
- -rw-r----- 1 oracle oinstall 843 May 5 16:01 HU_mman_4852.trc
- -rw-r----- 1 oracle oinstall 58 May 5 16:01 HU_mmon_4876.trm
- -rw-r----- 1 oracle oinstall 909 May 5 16:01 HU_mmon_4876.trc
- -rw-r----- 1 oracle oinstall 76 May 5 16:01 HU_j004_4981.trm
- -rw-r----- 1 oracle oinstall 959 May 5 16:01 HU_j004_4981.trc
- -rw-r----- 1 oracle oinstall 86 May 5 16:02 HU_dbrm_4844.trm
- -rw-r----- 1 oracle oinstall 1260 May 5 16:02 HU_dbrm_4844.trc
- -rw-r----- 1 oracle oinstall 86 May 5 16:02 HU_vktm_4830.trm
- -rw-r----- 1 oracle oinstall 1184 May 5 16:02 HU_vktm_4830.trc
- -rw-r----- 1 oracle oinstall 278 May 5 16:02 HU_ora_4914.trm
- -rw-r----- 1 oracle oinstall 3289 May 5 16:02 HU_ora_4914.trc
- -rw-r----- 1 oracle oinstall 76 May 5 16:02 HU_ora_4994.trm
- -rw-r----- 1 oracle oinstall 827 May 5 16:02 HU_ora_4994.trc
- -rw-r----- 1 oracle oinstall 65 May 5 16:03 HU_mman_5030.trm
- -rw-r----- 1 oracle oinstall 843 May 5 16:03 HU_mman_5030.trc
- -rw-r----- 1 oracle oinstall 66 May 5 16:04 HU_ora_5081.trm
- -rw-r----- 1 oracle oinstall 967 May 5 16:04 HU_ora_5081.trc
- -rw-r----- 1 oracle oinstall 85 May 5 16:23 HU_ora_5596.trm
- -rw-r----- 1 oracle oinstall 1128 May 5 16:23 HU_ora_5596.trc
- -rw-r----- 1 oracle oinstall 75 May 5 18:00 HU_j000_6721.trm
- -rw-r----- 1 oracle oinstall 961 May 5 18:00 HU_j000_6721.trc
- -rw-r----- 1 oracle oinstall 66 May 5 21:55 HU_w000_7215.trm
- -rw-r----- 1 oracle oinstall 994 May 5 21:55 HU_w000_7215.trc
- -rw-r----- 1 oracle oinstall 77 May 5 22:00 HU_lgwr_5038.trm
- -rw-r----- 1 oracle oinstall 946 May 5 22:00 HU_lgwr_5038.trc
- -rw-r----- 1 oracle oinstall 70 May 6 08:53 HU_vkrm_7267.trm
- -rw-r----- 1 oracle oinstall 1028 May 6 08:53 HU_vkrm_7267.trc
- -rw-r----- 1 oracle oinstall 78 May 6 09:15 HU_ckpt_5042.trm
- -rw-r----- 1 oracle oinstall 1267 May 6 09:15 HU_ckpt_5042.trc
- -rw-r----- 1 oracle oinstall 65 May 6 11:00 HU_arc0_5087.trm
- -rw-r----- 1 oracle oinstall 940 May 6 11:00 HU_arc0_5087.trc
- -rw-r----- 1 oracle oinstall 67 May 6 23:32 HU_j001_9083.trm
- -rw-r----- 1 oracle oinstall 960 May 6 23:32 HU_j001_9083.trc
- -rw-r----- 1 oracle oinstall 70 May 7 02:00 HU_vkrm_7354.trm
- -rw-r----- 1 oracle oinstall 1042 May 7 02:00 HU_vkrm_7354.trc
- -rw-r----- 1 oracle oinstall 278 May 7 09:55 HU_vktm_5008.trm
- -rw-r----- 1 oracle oinstall 3877 May 7 09:55 HU_vktm_5008.trc
- -rw-r----- 1 oracle oinstall 58 May 7 09:55 HU_vkrm_11025.trm
- -rw-r----- 1 oracle oinstall 984 May 7 09:55 HU_vkrm_11025.trc
- -rw-r----- 1 oracle oinstall 192 May 7 09:55 HU_cjq0_5132.trm
- -rw-r----- 1 oracle oinstall 1907 May 7 09:55 HU_cjq0_5132.trc
- -rw-r----- 1 oracle oinstall 184 May 7 09:56 HU_j001_11015.trm
- -rw-r----- 1 oracle oinstall 1137 May 7 09:56 HU_j001_11015.trc
- -rw-r----- 1 oracle oinstall 159 May 7 10:10 HU_ora_11275.trm
- -rw-r----- 1 oracle oinstall 7074 May 7 10:10 HU_ora_11275.trc
- -rw-r----- 1 oracle oinstall 57221 May 7 10:10 alert_HU.log
- -rw-r----- 1 oracle oinstall 1421 May 7 10:10 HU_mmon_5054.trm
- -rw-r----- 1 oracle oinstall 13447 May 7 10:10 HU_mmon_5054.trc
- -rw-r----- 1 oracle oinstall 4485 May 7 10:13 HU_dbrm_5022.trm
- -rw-r----- 1 oracle oinstall 94435 May 7 10:13 HU_dbrm_5022.trc
- [oracle@hu trace]$
- [oracle@hu trace]$ more HU_ora_11275.trc
- ----
- STARTUP NOMOUNT
- CREATE CONTROLFILE REUSE DATABASE "HU" NORESETLOGS ARCHIVELOG
- MAXLOGFILES 16
- MAXLOGMEMBERS 3
- MAXDATAFILES 100
- MAXINSTANCES 8
- MAXLOGHISTORY 292
- LOGFILE
- GROUP 1 '/u01/app/oracle/oradata/HU/redo01.log' SIZE 50M BLOCKSIZE 512,
- GROUP 2 '/u01/app/oracle/oradata/HU/redo02.log' SIZE 50M BLOCKSIZE 512,
- GROUP 3 '/u01/app/oracle/oradata/HU/redo03.log' SIZE 50M BLOCKSIZE 512
- -- STANDBY LOGFILE
- DATAFILE
- '/u01/app/oracle/oradata/HU/system01.dbf',
- '/u01/app/oracle/oradata/HU/sysaux01.dbf',
- '/u01/app/oracle/oradata/HU/undotbs01.dbf',
- '/u01/app/oracle/oradata/HU/users01.dbf',
- '/u01/app/oracle/oradata/HU/example01.dbf'
- CHARACTER SET AL32UTF8
- ;
- -- Configure RMAN configuration record 1
- VARIABLE RECNO NUMBER;
- EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CHANNEL','DEVICE TYPE DISK
- FORMAT ''/u01/app/backup/db_%U.rum''');
- -- Commands to re-create incarnation table
- -- Below log names MUST be changed to existing filenames on
- -- disk. Any one log file from each branch can be used to
- -- re-create incarnation records.
- -- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/
- arch1_1_824297850.dbf';
- -- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/
- arch1_1_941998577.dbf';
- -- Recovery is required if any of the datafiles are restored backups,
- -- or if the last shutdown was not normal or immediate.
- RECOVER DATABASE
- -- All logs need archiving and a log switch is needed.
- ALTER SYSTEM ARCHIVE LOG ALL;
- -- Database can now be opened normally.
- ALTER DATABASE OPEN;
- -- Commands to add tempfiles to temporary tablespaces.
- -- Online tempfiles have complete space information.
- -- Other tempfiles may require adjustment.
- ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/HU/temp01.dbf'
- SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
- -- End of tempfile additions.
- --
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31399171/viewspace-2138611/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31399171/viewspace-2138611/