Restore to ASM using an filesystem backup.

rman backup from filesystem and restore to ASM .

[oracle@slcc02db01 R1213XL_11203_Init]$ pwd
dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init
[oracle@slcc02db01 R1213XL_11203_Init]$ ls
01nnh49m_1_1  0nnnh4na_1_1  1dnnh57h_1_1  23nnh5jp_1_1  2pnnh609_1_1
02nnh49m_1_1  0onnh4o4_1_1  1ennh57h_1_1  24nnh5jp_1_1  2qnnh60q_1_1
03nnh49n_1_1  0pnnh4qb_1_1  1fnnh581_1_1  25nnh5k0_1_1  2rnnh61d_1_1
04nnh49n_1_1  0qnnh4qm_1_1  1gnnh582_1_1  26nnh5mc_1_1  2snnh61d_1_1
05nnh49q_1_1  0rnnh4qo_1_1  1hnnh58i_1_1  27nnh5mr_1_1  2tnnh61g_1_1
06nnh4de_1_1  0snnh4r1_1_1  1innh5ak_1_1  28nnh5n2_1_1  2unnh62j_1_1
07nnh4de_1_1  0tnnh4sb_1_1  1jnnh5ak_1_1  29nnh5n2_1_1  2vnnh63n_1_1
08nnh4df_1_1  0unnh4tu_1_1  1knnh5b4_1_1  2annh5nb_1_1  30nnh63n_1_1
09nnh4dg_1_1  0vnnh4tu_1_1  1lnnh5b4_1_1  2bnnh5q0_1_1  31nnh63n_1_1
0annh4dn_1_1  10nnh4tu_1_1  1mnnh5bk_1_1  2cnnh5q3_1_1  32nnh648_1_1
0bnnh4h1_1_1  11nnh4tv_1_1  1nnnh5dv_1_1  2dnnh5qb_1_1  33nnh648_1_1
0cnnh4h2_1_1  12nnh518_1_1  1onnh5dv_1_1  2ennh5qi_1_1  34nnh64o_1_1
0dnnh4hi_1_1  13nnh519_1_1  1pnnh5e6_1_1  2fnnh5qj_1_1  35nnh65k_1_1
0ennh4hi_1_1  14nnh519_1_1  1qnnh5ee_1_1  2gnnh5t8_1_1  36nnh663_1_1
0fnnh4hm_1_1  15nnh51a_1_1  1rnnh5el_1_1  2hnnh5t8_1_1  37nnh663_1_1
0gnnh4k3_1_1  16nnh51a_1_1  1snnh5h0_1_1  2innh5tg_1_1  38nnh66b_1_1
0hnnh4kd_1_1  17nnh558_1_1  1tnnh5h0_1_1  2jnnh5tn_1_1  39nnh66i_1_1
0innh4l6_1_1  18nnh558_1_1  1unnh5h8_1_1  2knnh5tn_1_1  3annh689_1_1
0jnnh4l8_1_1  19nnh558_1_1  1vnnh5hf_1_1  2lnnh5v5_1_1  3bnnh68a_1_1
0knnh4l8_1_1  1annh559_1_1  20nnh5hi_1_1  2mnnh5v5_1_1  3cnnh6a2_1_1
0lnnh4na_1_1  1bnnh55a_1_1  21nnh5j9_1_1  2nnnh608_1_1  3dnnh6a2_1_1
0mnnh4na_1_1  1cnnh571_1_1  22nnh5j9_1_1  2onnh609_1_1  controlfile.dbf

copy old filesystem init.ora file, modify controfile to ASM, change archive log location to ASM

*.control_files='+DATA_SLCC02/VIS/controlfile/current.3265.796769765'
*.log_archive_dest_1='LOCATION=+RECO_SLCC02'

restore controlfile

[oracle@slcc02db01 ~]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Oct 16 06:11:10 2012

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

connected to target database (not started)

RMAN> startup nomount;

Oracle instance started

Total System Global Area   13629980672 bytes

Fixed Size                     2241064 bytes
Variable Size               4898950616 bytes
Database Buffers            8589934592 bytes
Redo Buffers                 138854400 bytes

RMAN> restore controlfile from '/dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_1120
3_Init/controlfile.dbf';

Starting restore at 16-OCT-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1640 instance=VIS1 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=+DATA_SLCC02/vis/controlfile/current.3265.796803159
Finished restore at 16-OCT-12

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> CATALOG START WITH '/dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init';

searching for all files that match the pattern /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/
R1213XL_11203_Init

List of Files Unknown to the Database
=====================================
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/1ennh57h_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/29nnh5n2_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/1pnnh5e6_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/06nnh4de_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/1unnh5h8_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/0jnnh4l8_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/2hnnh5t8_1_1
......
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/2knnh5tn_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/36nnh663_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/34nnh64o_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/0mnnh4na_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/0ennh4hi_1_1

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/1ennh57h_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/29nnh5n2_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/1pnnh5e6_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/06nnh4de_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/1unnh5h8_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/0jnnh4l8_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/2hnnh5t8_1_1
......
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/1onnh5dv_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/1tnnh5h0_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/2knnh5tn_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/36nnh663_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/34nnh64o_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/0mnnh4na_1_1
File Name: /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/0ennh4hi_1_1

RMAN> crosscheck backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1640 instance=VIS1 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1767 instance=VIS1 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1893 instance=VIS1 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=2018 instance=VIS1 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=2144 instance=VIS1 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/05nnh49q_1_1 RECID=118 STAMP=796804226
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/02nnh49m_1_1 RECID=123 STAMP=796804227
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/03nnh49n_1_1 RECID=126 STAMP=796804228
crosschecked backup piece: found to be 'AVAILABLE'
......
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/scratch/oracle/backup/R1213XL_11203_Init/39nnh66i_1_1 RECID=106 STAMP=796432594
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/scratch/oracle/backup/R1213XL_11203_Init/3bnnh68a_1_1 RECID=107 STAMP=796432650
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/scratch/oracle/backup/R1213XL_11203_Init/3annh689_1_1 RECID=108 STAMP=796432649
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/scratch/oracle/backup/R1213XL_11203_Init/3cnnh6a2_1_1 RECID=109 STAMP=796432706
Crosschecked 109 objects

RMAN> 
RMAN> delete expired backup;

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1       1       1   1   EXPIRED     DISK        /scratch/oracle/backup/R1213XL_11203_Init/05nnh49q_1_1
2       2       1   1   EXPIRED     DISK        /scratch/oracle/backup/R1213XL_11203_Init/02nnh49m_1_1
3       3       1   1   EXPIRED     DISK        /scratch/oracle/backup/R1213XL_11203_Init/03nnh49n_1_1
4       4       1   1   EXPIRED     DISK        /scratch/oracle/backup/R1213XL_11203_Init/04nnh49n_1_1
5       5       1   1   EXPIRED     DISK        /scratch/oracle/backup/R1213XL_11203_Init/01nnh49m_1_1
......
106     106     1   1   EXPIRED     DISK        /scratch/oracle/backup/R1213XL_11203_Init/39nnh66i_1_1
107     107     1   1   EXPIRED     DISK        /scratch/oracle/backup/R1213XL_11203_Init/3bnnh68a_1_1
108     108     1   1   EXPIRED     DISK        /scratch/oracle/backup/R1213XL_11203_Init/3annh689_1_1
109     109     1   1   EXPIRED     DISK        /scratch/oracle/backup/R1213XL_11203_Init/3cnnh6a2_1_1

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/scratch/oracle/backup/R1213XL_11203_Init/05nnh49q_1_1 RECID=1 STAMP=796430651
deleted backup piece
backup piece handle=/scratch/oracle/backup/R1213XL_11203_Init/02nnh49m_1_1 RECID=2 STAMP=796430647
deleted backup piece
backup piece handle=/scratch/oracle/backup/R1213XL_11203_Init/03nnh49n_1_1 RECID=3 STAMP=796430647
deleted backup piece
backup piece handle=/scratch/oracle/backup/R1213XL_11203_Init/04nnh49n_1_1 RECID=4 STAMP=796430650
deleted backup piece
backup piece handle=/scratch/oracle/backup/R1213XL_11203_Init/01nnh49m_1_1 RECID=5 STAMP=796430646
......
deleted backup piece
backup piece handle=/scratch/oracle/backup/R1213XL_11203_Init/3annh689_1_1 RECID=108 STAMP=796432649
deleted backup piece
backup piece handle=/scratch/oracle/backup/R1213XL_11203_Init/3cnnh6a2_1_1 RECID=109 STAMP=796432706
Deleted 109 EXPIRED objects

RMAN> run{
  set newname for database to '+DATA_SLCC02';
  restore database;
  switch datafile all;
  alter database open resetlogs;
}2> 3> 4> 5> 6> 

executing command: SET NEWNAME

Starting restore at 16-OCT-12
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00053 to +DATA_SLCC02
channel ORA_DISK_1: restoring datafile 00057 to +DATA_SLCC02
channel ORA_DISK_1: restoring datafile 00088 to +DATA_SLCC02
channel ORA_DISK_1: restoring datafile 00120 to +DATA_SLCC02
channel ORA_DISK_1: restoring datafile 00122 to +DATA_SLCC02
channel ORA_DISK_1: restoring datafile 00123 to +DATA_SLCC02
channel ORA_DISK_1: restoring datafile 00124 to +DATA_SLCC02
channel ORA_DISK_1: restoring datafile 00139 to +DATA_SLCC02
channel ORA_DISK_1: restoring datafile 00281 to +DATA_SLCC02
channel ORA_DISK_1: reading from backup piece /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/05nnh49q_1_1
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00059 to +DATA_SLCC02
channel ORA_DISK_2: restoring datafile 00067 to +DATA_SLCC02
channel ORA_DISK_2: restoring datafile 00133 to +DATA_SLCC02
channel ORA_DISK_2: restoring datafile 00145 to +DATA_SLCC02
channel ORA_DISK_2: restoring datafile 00187 to +DATA_SLCC02
channel ORA_DISK_2: restoring datafile 00211 to +DATA_SLCC02
channel ORA_DISK_2: reading from backup piece /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/02nnh49m_1_1
........
channel ORA_DISK_4: restoring datafile 00101 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00108 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00109 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00149 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00160 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00163 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00164 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00170 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00171 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00175 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00176 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00177 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00192 to +DATA_SLCC02
channel ORA_DISK_4: restoring datafile 00207 to +DATA_SLCC02
channel ORA_DISK_4: reading from backup piece /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/09nnh4dg_1_1
channel ORA_DISK_5: piece handle=/dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/01nnh49m_1_1 tag=R1213_XL_INIT
channel ORA_DISK_5: restored backup piece 1
channel ORA_DISK_5: restore complete, elapsed time: 00:02:01
channel ORA_DISK_5: starting datafile backup set restore
channel ORA_DISK_5: specifying datafile(s) to restore from backup set
channel ORA_DISK_5: restoring datafile 00146 to +DATA_SLCC02
channel ORA_DISK_5: restoring datafile 00147 to +DATA_SLCC02
channel ORA_DISK_5: restoring datafile 00338 to +DATA_SLCC02
channel ORA_DISK_5: reading from backup piece /dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/0annh4dn_1_1
......
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:01:41
channel ORA_DISK_5: piece handle=/dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/3annh689_1_1 tag=R1213_XL_INIT
channel ORA_DISK_5: restored backup piece 1
channel ORA_DISK_5: restore complete, elapsed time: 00:01:40
channel ORA_DISK_2: piece handle=/dbfs_direct/HR3FS3/ebsxl/DB_BACKUP/R1213XL_11203_Init/3cnnh6a2_1_1 tag=R1213_XL_INIT
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:01:15
Finished restore at 16-OCT-12

datafile 1 switched to datafile copy
input datafile copy RECID=343 STAMP=796806734 file name=+DATA_SLCC02/vis/datafile/system.1356.796806407
datafile 2 switched to datafile copy
input datafile copy RECID=344 STAMP=796806734 file name=+DATA_SLCC02/vis/datafile/apps_ts_tx_data.1540.796805137
datafile 3 switched to datafile copy
input datafile copy RECID=345 STAMP=796806734 file name=+DATA_SLCC02/vis/datafile/apps_ts_tx_idx.1274.796806573
datafile 4 switched to datafile copy
input datafile copy RECID=346 STAMP=796806734 file name=+DATA_SLCC02/vis/datafile/apps_undots1.2885.796805021
datafile 5 switched to datafile copy
input datafile copy RECID=347 STAMP=796806735 file name=+DATA_SLCC02/vis/datafile/non_apps_ts_data.1275.796806573
datafile 6 switched to datafile copy
......
input datafile copy RECID=681 STAMP=796806758 file name=+DATA_SLCC02/vis/datafile/sysaux.1538.796805137
datafile 340 switched to datafile copy
input datafile copy RECID=682 STAMP=796806758 file name=+DATA_SLCC02/vis/datafile/sysaux.1115.796805103
datafile 341 switched to datafile copy
input datafile copy RECID=683 STAMP=796806758 file name=+DATA_SLCC02/vis/datafile/sysaux.1544.796805137

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 10/16/2012 07:12:50
ORA-00344: unable to re-create online log '/mnt/oht/log1.dbf'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1

RMAN>
------------------------------------------------------------------------
sqlplus / as sysdba
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/mnt/oht/log3.dbf
/mnt/oht/log2.dbf
/mnt/oht/log1.dbf

alter database rename file '/mnt/oht/log1.dbf' to '+RECO_SLCC02';
alter database rename file '/mnt/oht/log2.dbf' to '+RECO_SLCC02';
alter database rename file '/mnt/oht/log3.dbf' to '+RECO_SLCC02';
------------------------------------------------------------------------
RMAN> alter database open resetlogs;

database opened

RMAN> exit
SQL> select file_name from dba_temp_files;
select file_name from dba_temp_files
                      *
ERROR at line 1:
ORA-01157: cannot identify/lock data file 2001 - see DBWR trace file
ORA-01110: data file 2001: '/mnt/ohu/temp1_01.dbf'

SQL> select name,ts# from v$tempfile;

NAME                                  TS#
------------------------------ ----------
/mnt/ohu/temp1_01.dbf                  75
/mnt/ohu/temp2_01.dbf                  76
/mnt/ohu/temp1_02.dbf                  75
/mnt/ohu/temp2_02.dbf                  76
/mnt/ohu/temp1_03.dbf                  75
/mnt/ohu/temp1_04.dbf                  75
/mnt/ohu/temp1_05.dbf                  75
/mnt/ohu/temp2_03.dbf                  76
/mnt/ohu/temp2_04.dbf                  76
/mnt/ohu/temp2_05.dbf                  76
/mnt/ohu/temp1_06.dbf                  75

NAME                                  TS#
------------------------------ ----------
/mnt/ohu/temp2_06.dbf                  76

SQL> select ts#,name from v$tablespace where ts# in (75,76);

       TS# NAME
---------- ------------------------------
        75 TEMP1
        76 TEMP2

alter database tempfile '/mnt/ohu/temp1_01.dbf' drop;
alter database tempfile '/mnt/ohu/temp2_01.dbf' drop;
alter database tempfile '/mnt/ohu/temp1_02.dbf' drop;
alter database tempfile '/mnt/ohu/temp2_02.dbf' drop;
alter database tempfile '/mnt/ohu/temp1_03.dbf' drop;
alter database tempfile '/mnt/ohu/temp1_04.dbf' drop;
alter database tempfile '/mnt/ohu/temp1_05.dbf' drop;
alter database tempfile '/mnt/ohu/temp2_03.dbf' drop;
alter database tempfile '/mnt/ohu/temp2_04.dbf' drop;
alter database tempfile '/mnt/ohu/temp2_05.dbf' drop;
alter database tempfile '/mnt/ohu/temp1_06.dbf' drop;
alter database tempfile '/mnt/ohu/temp2_06.dbf' drop;

SQL> alter tablespace temp1 add tempfile size 4g,size 4g, size 4g, size 4g, size 4g, size 4g;
alter tablespace temp1 add tempfile size 4g,size 4g, size 4g, size 4g, size 4g, size 4g
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kghstack_free1], [list of datafile
#'s], [], [], [], [], [], [], [], [], [], []

SQL> alter tablespace temp2 add tempfile size 4g,size 4g, size 4g, size 4g, size 4g, size 4g;
alter tablespace temp2 add tempfile size 4g,size 4g, size 4g, size 4g, size 4g, size 4g
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kghstack_free1], [list of datafile
#'s], [], [], [], [], [], [], [], [], [], []

SQL> alter tablespace temp2 add tempfile size 4g;

Tablespace altered.
SQL> alter tablespace temp2 add tempfile size 4g, size 4g, size 4g, size 4g, size 4g;

Tablespace altered.

SQL> 
SQL> alter tablespace temp1 add tempfile size 4g;

Tablespace altered.

SQL> alter tablespace temp1 add tempfile size 4g, size 4g, size 4g, size 4g, size 4g;

Tablespace altered.

SQL> select file_name from dba_temp_files;

FILE_NAME
--------------------------------------------------------------------------------
+DATA_SLCC02/vis/tempfile/temp1.1312.796808065
+DATA_SLCC02/vis/tempfile/temp1.1313.796808065
+DATA_SLCC02/vis/tempfile/temp1.1386.796808065
+DATA_SLCC02/vis/tempfile/temp1.1315.796808065
+DATA_SLCC02/vis/tempfile/temp1.1316.796808067
+DATA_SLCC02/vis/tempfile/temp1.1360.796808067
+DATA_SLCC02/vis/tempfile/temp2.1318.796808099
+DATA_SLCC02/vis/tempfile/temp2.1382.796808099
+DATA_SLCC02/vis/tempfile/temp2.1320.796808099
+DATA_SLCC02/vis/tempfile/temp2.1321.796808099
+DATA_SLCC02/vis/tempfile/temp2.1392.796808099

FILE_NAME
--------------------------------------------------------------------------------
+DATA_SLCC02/vis/tempfile/temp2.1366.796808099
+DATA_SLCC02/vis/tempfile/temp2.1372.796808141
+DATA_SLCC02/vis/tempfile/temp2.1387.796808159
+DATA_SLCC02/vis/tempfile/temp2.1383.796808161
+DATA_SLCC02/vis/tempfile/temp2.1391.796808161
+DATA_SLCC02/vis/tempfile/temp2.1380.796808161
+DATA_SLCC02/vis/tempfile/temp2.1368.796808161
+DATA_SLCC02/vis/tempfile/temp1.1389.796808217
+DATA_SLCC02/vis/tempfile/temp1.1376.796808231
+DATA_SLCC02/vis/tempfile/temp1.1390.796808231
+DATA_SLCC02/vis/tempfile/temp1.1333.796808231

FILE_NAME
--------------------------------------------------------------------------------
+DATA_SLCC02/vis/tempfile/temp1.1393.796808231
+DATA_SLCC02/vis/tempfile/temp1.1373.796808231

24 rows selected.

SQL>

although there is ora-600 error for first alter tablespace sql , the tempfile is already added to temp1 and temp2,  so , I have to drop the additional files;

alter database tempfile '+DATA_SLCC02/vis/tempfile/temp1.1312.796808065' drop including datafiles;
alter database tempfile '+DATA_SLCC02/vis/tempfile/temp1.1313.796808065' drop including datafiles;
alter database tempfile '+DATA_SLCC02/vis/tempfile/temp1.1386.796808065' drop including datafiles;
alter database tempfile '+DATA_SLCC02/vis/tempfile/temp1.1315.796808065' drop including datafiles;
alter database tempfile '+DATA_SLCC02/vis/tempfile/temp1.1316.796808067' drop including datafiles;
alter database tempfile '+DATA_SLCC02/vis/tempfile/temp1.1360.796808067' drop including datafiles;
alter database tempfile '+DATA_SLCC02/vis/tempfile/temp2.1318.796808099' drop including datafiles;
alter database tempfile '+DATA_SLCC02/vis/tempfile/temp2.1382.796808099' drop including datafiles;
alter database tempfile '+DATA_SLCC02/vis/tempfile/temp2.1320.796808099' drop including datafiles;
alter database tempfile '+DATA_SLCC02/vis/tempfile/temp2.1321.796808099' drop including datafiles;
alter database tempfile '+DATA_SLCC02/vis/tempfile/temp2.1392.796808099' drop including datafiles;
alter database tempfile '+DATA_SLCC02/vis/tempfile/temp2.1366.796808099' drop including datafiles;

done, backup new database.

 

 

发表评论

电子邮件地址不会被公开。 必填项已用*标注