วันพุธที่ 29 เมษายน พ.ศ. 2558

Drop Database ด้วย RMAN

เราสามารถลบ Database ได้อย่างสมบูรณ์โดยใช้ RMAN ได้และยังสามารถลบ Backup files ที่เกี่ยวข้องได้อีกด้วย
ตัวอย่าง :
1.สั่ง shutdown database ก่อน
[oracle@econdb01 ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Apr 30 12:48:16 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ESPFP1 (DBID=3625069492)

RMAN> shutdown immediate

using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

2.startup mount ขึ้นมา
RMAN> startup mount

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area   41688973312 bytes

Fixed Size                     2262328 bytes
Variable Size               4831840968 bytes
Database Buffers           36775657472 bytes

Redo Buffers                  79212544 bytes

3.ปรับโหมดเป็น Restrict
RMAN> sql 'alter system enable restricted session';


sql statement: alter system enable restricted session

4.ทำการ Drop database และใส่ including backups เป็น optional
RMAN> drop database including backups;

database name is "ESPFP1" and DBID is 3625069492

Do you really want to drop all backups and the database (enter YES or NO)? yes

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2270 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=2522 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=2774 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=2 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=254 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=507 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=760 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=1011 device type=DISK

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
5052    4976    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzp7brs_.bkp
5056    4977    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzr3rsm_.bkp
5066    4978    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzp7dgk_.bkp
5045    4979    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzp7m6s_.bkp
5042    4979    2   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzs3hpp_.bkp
5063    4980    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzp7f6v_.bkp
5058    4980    2   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzsdprs_.bkp
5043    4981    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztgl8g_.bkp
5065    4982    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztgl6y_.bkp
5061    4983    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztgl5d_.bkp
5050    4984    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztgl9v_.bkp
5057    4985    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztqvkk_.bkp
5049    4986    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztszf4_.bkp
5059    4987    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztv2ss_.bkp
5046    4988    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzttksk_.bkp
5051    4989    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzv4owh_.bkp
5062    4990    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzv6qcl_.bkp
5054    4991    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzv6t6j_.bkp
5055    4992    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzv6gj2_.bkp
5053    4993    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzvmj73_.bkp
5044    4994    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzvmkq1_.bkp
5064    4995    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzvkzo5_.bkp
5060    4996    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzvmgo2_.bkp
5047    4997    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_nnsnf_SPFILE_ESPFP1_bmzvw06z_.bkp
5048    4998    1   1   AVAILABLE   DISK        /home/oracle/2015_04_29/o1_mf_ncnnf_CT_ESPFP1_bmzvw2kt_.bkp
5067    4999    1   1   AVAILABLE   DISK        /dbserv/ESPFP01/oracle/FRA/ESPFP1/autobackup/2015_04_29/o1_mf_s_878322466_bn1dk2h7_.bkp
5068    5000    1   1   AVAILABLE   DISK        /dbserv/ESPFP01/oracle/FRA/ESPFP1/autobackup/2015_04_29/o1_mf_s_878323118_bn1f5g67_.bkp
5069    5001    1   1   AVAILABLE   DISK        /dbserv/ESPFP01/oracle/FRA/ESPFP1/autobackup/2015_04_29/o1_mf_s_878323641_bn1fosdj_.bkp
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzp7brs_.bkp RECID=5052 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzr3rsm_.bkp RECID=5056 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzp7dgk_.bkp RECID=5066 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzp7m6s_.bkp RECID=5045 STAMP=878316184
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzs3hpp_.bkp RECID=5042 STAMP=878316184
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzp7f6v_.bkp RECID=5063 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_nnndf_DB_ESPFP1_bmzsdprs_.bkp RECID=5058 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztgl8g_.bkp RECID=5043 STAMP=878316184
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztgl6y_.bkp RECID=5065 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztgl5d_.bkp RECID=5061 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztgl9v_.bkp RECID=5050 STAMP=878316184
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztqvkk_.bkp RECID=5057 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztszf4_.bkp RECID=5049 STAMP=878316184
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmztv2ss_.bkp RECID=5059 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzttksk_.bkp RECID=5046 STAMP=878316184
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzv4owh_.bkp RECID=5051 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzv6qcl_.bkp RECID=5062 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzv6t6j_.bkp RECID=5054 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzv6gj2_.bkp RECID=5055 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzvmj73_.bkp RECID=5053 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzvmkq1_.bkp RECID=5044 STAMP=878316184
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzvkzo5_.bkp RECID=5064 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_annnn_ESPFP1_bmzvmgo2_.bkp RECID=5060 STAMP=878316185
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_nnsnf_SPFILE_ESPFP1_bmzvw06z_.bkp RECID=5047 STAMP=878316184
deleted backup piece
backup piece handle=/home/oracle/2015_04_29/o1_mf_ncnnf_CT_ESPFP1_bmzvw2kt_.bkp RECID=5048 STAMP=878316184
deleted backup piece
backup piece handle=/dbserv/ESPFP01/oracle/FRA/ESPFP1/autobackup/2015_04_29/o1_mf_s_878322466_bn1dk2h7_.bkp RECID=5067 STAMP=878322466
deleted backup piece
backup piece handle=/dbserv/ESPFP01/oracle/FRA/ESPFP1/autobackup/2015_04_29/o1_mf_s_878323118_bn1f5g67_.bkp RECID=5068 STAMP=878323118
deleted backup piece
backup piece handle=/dbserv/ESPFP01/oracle/FRA/ESPFP1/autobackup/2015_04_29/o1_mf_s_878323641_bn1fosdj_.bkp RECID=5069 STAMP=878323641
Deleted 28 objects


released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
released channel: ORA_DISK_5
released channel: ORA_DISK_6
released channel: ORA_DISK_7
released channel: ORA_DISK_8
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2270 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=2522 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=2774 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=2 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=254 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=507 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=760 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=1011 device type=DISK
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
specification does not match any control file copy in the repository
List of Archived Log Copies for database with db_unique_name ESPFP1
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
194310  1    1       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_1_bn1dk8yp_.arc

194311  1    2       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_2_bn1dkkz0_.arc

194312  1    3       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_3_bn1dknbo_.arc

194313  1    4       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_4_bn1dkqj2_.arc

194314  1    5       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_5_bn1dky66_.arc

194315  1    6       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_6_bn1dl40z_.arc

194316  1    7       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_7_bn1dl77t_.arc

194317  1    8       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_8_bn1dlc0o_.arc

194318  1    9       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_9_bn1dlg18_.arc

194319  1    10      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_10_bn1dlk5l_.arc

194320  1    11      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_11_bn1dlnnb_.arc

194321  1    12      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_12_bn1dlqsk_.arc

194322  1    13      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_13_bn1dlv1h_.arc

194323  1    14      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_14_bn1dlycr_.arc

194324  1    15      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_15_bn1dm4b8_.arc

194325  1    16      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_16_bn1dm7qm_.arc

194326  1    17      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_17_bn1dmbwc_.arc

194327  1    18      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_18_bn1dmgfc_.arc

194328  1    19      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_19_bn1dmkv4_.arc

194329  1    20      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_20_bn1dn1pw_.arc

194330  1    21      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_21_bn1dn60c_.arc

194331  1    22      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_22_bn1dn952_.arc

194332  1    23      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_23_bn1dnf6q_.arc

194333  1    24      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_24_bn1dnjt0_.arc

194334  1    25      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_25_bn1dnpp6_.arc

194335  1    26      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_26_bn1dnwsn_.arc

194336  1    27      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_27_bn1do3t8_.arc

194337  1    28      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_28_bn1dob51_.arc

194338  1    29      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_29_bn1dojcr_.arc

194339  1    30      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_30_bn1doprl_.arc

194340  1    31      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_31_bn1dox9f_.arc

194341  1    32      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_32_bn1dp3pg_.arc

194342  1    33      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_33_bn1dp9sm_.arc

194343  1    34      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_34_bn1dpjbf_.arc

194344  1    35      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_35_bn1dppfz_.arc

194345  1    36      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_36_bn1dpwxz_.arc

194346  1    37      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_37_bn1dq327_.arc

194347  1    38      A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_38_bn1f58vv_.arc

194348  1    1       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_1_bn1f9dn1_.arc

194349  1    2       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_2_bn1rzghc_.arc

194350  1    3       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_3_bn1rztgx_.arc

194351  1    4       A 29-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_4_bn28scwv_.arc

194352  1    5       A 30-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_5_bn28yg16_.arc

194353  1    6       A 30-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_6_bn290j2n_.arc

194354  1    7       A 30-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_7_bn296j6d_.arc

194355  1    8       A 30-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_8_bn29hwfy_.arc

194356  1    9       A 30-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_9_bn2dvkgm_.arc

194357  1    10      A 30-APR-15
        Name: /dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_10_bn35kwsw_.arc

deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_1_bn1dk8yp_.arc RECID=194310 STAMP=878322473
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_2_bn1dkkz0_.arc RECID=194311 STAMP=878322482
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_3_bn1dknbo_.arc RECID=194312 STAMP=878322484
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_4_bn1dkqj2_.arc RECID=194313 STAMP=878322487
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_5_bn1dky66_.arc RECID=194314 STAMP=878322494
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_6_bn1dl40z_.arc RECID=194315 STAMP=878322500
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_7_bn1dl77t_.arc RECID=194316 STAMP=878322503
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_8_bn1dlc0o_.arc RECID=194317 STAMP=878322507
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_9_bn1dlg18_.arc RECID=194318 STAMP=878322510
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_10_bn1dlk5l_.arc RECID=194319 STAMP=878322513
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_11_bn1dlnnb_.arc RECID=194320 STAMP=878322516
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_12_bn1dlqsk_.arc RECID=194321 STAMP=878322520
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_13_bn1dlv1h_.arc RECID=194322 STAMP=878322523
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_14_bn1dlycr_.arc RECID=194323 STAMP=878322526
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_15_bn1dm4b8_.arc RECID=194324 STAMP=878322532
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_16_bn1dm7qm_.arc RECID=194325 STAMP=878322535
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_17_bn1dmbwc_.arc RECID=194326 STAMP=878322539
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_18_bn1dmgfc_.arc RECID=194327 STAMP=878322542
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_19_bn1dmkv4_.arc RECID=194328 STAMP=878322546
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_20_bn1dn1pw_.arc RECID=194329 STAMP=878322561
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_21_bn1dn60c_.arc RECID=194330 STAMP=878322566
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_22_bn1dn952_.arc RECID=194331 STAMP=878322569
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_23_bn1dnf6q_.arc RECID=194332 STAMP=878322573
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_24_bn1dnjt0_.arc RECID=194333 STAMP=878322576
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_25_bn1dnpp6_.arc RECID=194334 STAMP=878322582
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_26_bn1dnwsn_.arc RECID=194335 STAMP=878322589
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_27_bn1do3t8_.arc RECID=194336 STAMP=878322596
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_28_bn1dob51_.arc RECID=194337 STAMP=878322602
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_29_bn1dojcr_.arc RECID=194338 STAMP=878322608
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_30_bn1doprl_.arc RECID=194339 STAMP=878322614
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_31_bn1dox9f_.arc RECID=194340 STAMP=878322621
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_32_bn1dp3pg_.arc RECID=194341 STAMP=878322627
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_33_bn1dp9sm_.arc RECID=194342 STAMP=878322634
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_34_bn1dpjbf_.arc RECID=194343 STAMP=878322640
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_35_bn1dppfz_.arc RECID=194344 STAMP=878322646
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_36_bn1dpwxz_.arc RECID=194345 STAMP=878322653
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_37_bn1dq327_.arc RECID=194346 STAMP=878322659
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_38_bn1f58vv_.arc RECID=194347 STAMP=878323113
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_1_bn1f9dn1_.arc RECID=194348 STAMP=878323244
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_2_bn1rzghc_.arc RECID=194349 STAMP=878335214
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_29/o1_mf_1_3_bn1rztgx_.arc RECID=194350 STAMP=878335226
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_4_bn28scwv_.arc RECID=194351 STAMP=878351403
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_5_bn28yg16_.arc RECID=194352 STAMP=878351566
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_6_bn290j2n_.arc RECID=194353 STAMP=878351632
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_7_bn296j6d_.arc RECID=194354 STAMP=878351824
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_8_bn29hwfy_.arc RECID=194355 STAMP=878352124
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_9_bn2dvkgm_.arc RECID=194356 STAMP=878355569
deleted archived log
archived log file name=/dbserv/ESPFP01/oracle/FRA/ESPFP1/archivelog/2015_04_30/o1_mf_1_10_bn35kwsw_.arc RECID=194357 STAMP=878380860
Deleted 48 objects


database name is "ESPFP1" and DBID is 3625069492
database dropped


RMAN>


เสร็จแล้ววว

ไม่มีความคิดเห็น:

แสดงความคิดเห็น