环境介绍

11gR2 RAC(原系统)

                       db1        db2
public ip         192.168.1.9      192.168.1.10
vip               192.168.1.11     192.168.1.12
private ip        192.168.1.9      192.168.1.10
scan ip                   192.168.1.13

target (目标系统)

public ip            192.168.1.5

主要步骤(除去post步骤,耗时120~150min,可以多分配几个channel,提高处理速度)

1)rac backup:原系统RMAN备份,耗时 30min

2)copy backup set to target system(耗时30min) or shared by nfs(耗时5min,可提前准备好)

3)rac2single recovery:RAC恢复到单节点数据库(耗时 80min,可以通过多分配通道提速)
                                 
    prepare:--耗时5min
        path:backup,datafile
        env:ORACLE_SID
        pfile: --耗时5min
            SID
            non-rac
            log_file_name_convert
            db_file_name_convert
            service_names
            other:*_dest*
    recovery:--耗时 70min
        set dbid;
        nomount, restore controlfile;
        mount;
        setnew name,restore database,switch datafile all,recover database; --耗时60min ~ 70min
        restore archivelogs; --不需要此步骤
        recreate controlfile; --不需要此步骤
        open database resetlogs; --耗时5min

4)post:监听配置,spfile启动,全备
    listener configuration
    restart target system
    rman full backup targets system

11gR2 RMAN Backup

rman backup

[[email protected] backup]$ rman target/

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Oct 17 10:17:42 2013

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

connected to target database: PROD (DBID=240240185)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data/controlfile/ctl_file_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 10240 M;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u1/app/oracle/product/11.2.0/db1/dbs/snapcf_PROD1.f'; # default

RMAN> run
{
###backup database###
backup  incremental level=0 tag='db_bak_lev0'        
        format='/data/backup/db_bak_lev0_%t_%p_%s'
        database;
###switch out the current logfile###
sql 'alter system archive log thread 1 current';
sql 'alter system archive log thread 2 current';
###backup archived log######
backup archivelog all tag='arc_bak'
       format='/data/backup/archive_log_%t_%p_%s'
       skip inaccessible 
       filesperset 4
       not  backed up 1 times
       delete  input;
###backup current controlfile that contains the records for the backups just made###
backup current controlfile tag='bak_ctlfile' format='/data/backup/ctl_file_%t_%p_%s';
crosscheck backup;
delete force noprompt expired backup;
delete force noprompt obsolete;
}

... ...


RMAN> list backup of controlfile;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
268     Full    18.42M     DISK        00:00:00     17-OCT-13      
        BP Key: 308   Status: AVAILABLE  Compressed: NO  Tag: TAG20131017T104019
        Piece Name: /data/controlfile/ctl_file_c-240240185-20131017-00
  Control File Included: Ckp SCN: 101311620    Ckp time: 17-OCT-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
273     Full    18.39M     DISK        00:00:01     17-OCT-13      
        BP Key: 313   Status: AVAILABLE  Compressed: NO  Tag: BAK_CTLFILE
        Piece Name: /data/backup/ctl_file_829046450_1_273
  Control File Included: Ckp SCN: 101313008    Ckp time: 17-OCT-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
274     Full    18.42M     DISK        00:00:00     17-OCT-13      
        BP Key: 314   Status: AVAILABLE  Compressed: NO  Tag: TAG20131017T104052
        Piece Name: /data/controlfile/ctl_file_c-240240185-20131017-01
  Control File Included: Ckp SCN: 101313063    Ckp time: 17-OCT-13

copy backup set

use scp

copy backup set using scp (estimated time: 0.55h (214GB * 1024MB / 110MB / 3600 ))

file system

[[email protected] ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_erptest1-LV_ROOT
                       50G   16G   31G  35% /
tmpfs                  32G  144K   32G   1% /dev/shm
/dev/mapper/vg_erptest1-LV_APPS
                       99G  188M   94G   1% /apps
/dev/sda2             485M   59M  401M  13% /boot
/dev/sda1             200M  260K  200M   1% /boot/efi
/dev/mapper/vg_erptest1-LV_TMP
                      9.9G  151M  9.2G   2% /tmp
/dev/mapper/vg_erptest1-LV_U1
                      985G  212G  724G  23% /u1

make directory

[[email protected] ~]# mkdir /u1/backup
[[email protected] ~]# ls -l /u1
total 35686692
drwxrwx---. 10 testora dba         4096 Aug 15 14:04 11gR2_BASE
drwxrwx---.  7 testora dba         4096 Jun  1 09:33 11gR2_BASE_11201
drwxr-xr-x.  2 root    root        4096 Oct 15 13:49 backup
drwxr-xr-x.  4 testora dba         4096 Jun 15 14:45 db_expimp
drwx------.  2 root    root       16384 May 28 01:24 lost+found
drwxr-xr-x.  3 testmgr dba         4096 Aug 15 14:01 oracle
drwxr-xr-x. 10 testmgr dba         4096 Sep  5 21:44 patches
-rw-r--r--.  1 root    root 36543116257 Jun 16 02:34 R1213_DB.tar.gz
drwxr-xr-x.  3 root    root        4096 May 29 18:18 redhat

copy parameter file

[[email protected] ~]$ sqlplus  /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 15 14:09:56 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> show parameter spfile

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
spfile				     string	 /u1/app/oracle/product/11.2.0/
                         db1/dbs/spfilePROD1.ora
SQL> create pfile='/home/oracle/initPROD1.ora' from spfile;

File created.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

[[email protected] ~]$ scp initPROD1.ora [email protected]:/u1/backup/
[email protected]'s password: 
initPROD1.ora                                                                                              100% 3121     3.1KB/s   00:00    

copy backup set

[[email protected] ~]# scp /data/backup/* [email protected]:/u1/backup
[email protected]'s password: 
20131016_inc0_7somi1rp_1_1.bkp                                                                      100% 1932KB   1.9MB/s   00:00    
20131016_inc0_7tomi1rt_1_1.bkp                                                                      100%   72GB 110.7MB/s   11:07    
20131016_inc0_7uomi2a5_1_1.bkp                                                                      100%   71GB 110.4MB/s   11:01    
20131016_inc0_7vomi2n6_1_1.bkp                                                                      100%   67GB 109.6MB/s   10:27    
20131016_inc0_80omi33a_1_1.bkp                                                                      100%   16MB  16.2MB/s   00:01    
20131016_inc0_81omi33h_1_1.bkp                                                                      100% 2203KB   2.2MB/s   00:00 

[[email protected] ~]$ ll /u1/backup/
total 220713556
-rwxr-xr-x. 1 root    root     1978368 Oct 16 15:55 20131016_inc0_7somi1rp_1_1.bkp
-rwxr-xr-x. 1 root    root 77434830848 Oct 16 16:06 20131016_inc0_7tomi1rt_1_1.bkp
-rwxr-xr-x. 1 root    root 76532965376 Oct 16 16:18 20131016_inc0_7uomi2a5_1_1.bkp
-rwxr-xr-x. 1 root    root 72021614592 Oct 16 16:28 20131016_inc0_7vomi2n6_1_1.bkp
-rwxr-xr-x. 1 root    root    17006592 Oct 16 16:28 20131016_inc0_80omi33a_1_1.bkp
-rwxr-xr-x. 1 root    root     2255872 Oct 16 16:28 20131016_inc0_81omi33h_1_1.bkp
-rw-r--r--. 1 testora dba         3121 Oct 15 14:11 initPROD1.ora

make soft link

[[email protected] ~]$ ln -s /u1/backup/  /data/backup
[[email protected]rget ~]$ ll /data/backup
lrwxrwxrwx. 1 testora dba 11 Oct 16 16:33 /data/backup -> /u1/backup/
[[email protected] ~]$ ll /data/backup/
total 220713556
-rwxr-xr-x. 1 root    root     1978368 Oct 16 15:55 20131016_inc0_7somi1rp_1_1.bkp
-rwxr-xr-x. 1 root    root 77434830848 Oct 16 16:06 20131016_inc0_7tomi1rt_1_1.bkp
-rwxr-xr-x. 1 root    root 76532965376 Oct 16 16:18 20131016_inc0_7uomi2a5_1_1.bkp
-rwxr-xr-x. 1 root    root 72021614592 Oct 16 16:28 20131016_inc0_7vomi2n6_1_1.bkp
-rwxr-xr-x. 1 root    root    17006592 Oct 16 16:28 20131016_inc0_80omi33a_1_1.bkp
-rwxr-xr-x. 1 root    root     2255872 Oct 16 16:28 20131016_inc0_81omi33h_1_1.bkp
-rw-r--r--. 1 testora dba         3121 Oct 15 14:11 initPROD1.ora

shared with nfs

configure exportfs

[[email protected] ~]# cat /etc/exports 
/patch *(rw,root_squash,no_all_squash,sync)
/data *(rw,no_root_squash,no_all_squash,sync)

restart nfs

[[email protected] ~]# service nfs restart
Shutting down NFS daemon:                                  [  OK  ]
Shutting down NFS mountd:                                  [  OK  ]
Shutting down NFS quotas:                                  [  OK  ]
Shutting down NFS services:                                [  OK  ]
Starting NFS services:                                     [  OK  ]
Starting NFS quotas:                                       [  OK  ]
Starting NFS mountd:                                       [  OK  ]
Stopping RPC idmapd:                                       [  OK  ]
Starting RPC idmapd:                                       [  OK  ]
Starting NFS daemon:                                       [  OK  ]
[[email protected] ~]# exportfs 
/patch        	<world>
/data    	<world>

mount on target system

[[email protected] ~]# showmount -e 192.168.1.9
Export list for 192.168.1.9:
/data/pre1 *
/patch     *
[[email protected] ~]# mount 192.168.1.9:/data/ /data/
[[email protected] ~]# ll /data/backup
total 220713556
-rw-r-----. 1 nobody nobody     1978368 Oct 16 12:32 20131016_inc0_7somi1rp_1_1.bkp
-rw-r-----. 1 nobody nobody 77434830848 Oct 16 12:40 20131016_inc0_7tomi1rt_1_1.bkp
-rw-r-----. 1 nobody nobody 76532965376 Oct 16 12:47 20131016_inc0_7uomi2a5_1_1.bkp
-rw-r-----. 1 nobody nobody 72021614592 Oct 16 12:54 20131016_inc0_7vomi2n6_1_1.bkp
-rw-r-----. 1 nobody nobody    17006592 Oct 16 12:54 20131016_inc0_80omi33a_1_1.bkp
-rw-r-----. 1 nobody nobody     2255872 Oct 16 12:54 20131016_inc0_81omi33h_1_1.bkp

chmod backup directory

[[email protected] ~]# chmod -R 777 /data/backup/
[[email protected] ~]# ll /data/backup/
total 220713556
-rwxrwxrwx. 1 nobody nobody     1978368 Oct 16 12:32 20131016_inc0_7somi1rp_1_1.bkp
-rwxrwxrwx. 1 nobody nobody 77434830848 Oct 16 12:40 20131016_inc0_7tomi1rt_1_1.bkp
-rwxrwxrwx. 1 nobody nobody 76532965376 Oct 16 12:47 20131016_inc0_7uomi2a5_1_1.bkp
-rwxrwxrwx. 1 nobody nobody 72021614592 Oct 16 12:54 20131016_inc0_7vomi2n6_1_1.bkp
-rwxrwxrwx. 1 nobody nobody    17006592 Oct 16 12:54 20131016_inc0_80omi33a_1_1.bkp
-rwxrwxrwx. 1 nobody nobody     2255872 Oct 16 12:54 20131016_inc0_81omi33h_1_1.bkp

recovery on target system

edit parameter file

copy pfile to destination

[[email protected] ~]$ export ORACLE_SID=PROD
[[email protected] ~]$ echo $ORACLE_HOME
/u1/11gR2_BASE/product/11.2.0
[[email protected] ~]$ cp /data/backup/initPROD1.ora /u1/11gR2_BASE/product/11.2.0/dbs/initPROD.ora
[[email protected] ~]$ cd /u1/11gR2_BASE/product/11.2.0/dbs/

before edit

[[email protected] dbs]$ cat initPROD.ora 
PROD1.__db_cache_size=40802189312
PROD1.__java_pool_size=939524096
PROD1.__large_pool_size=134217728
PROD1.__oracle_base='/u1/app/oracle'#ORACLE_BASE set from environment
PROD1.__pga_aggregate_target=1073741824
PROD1.__sga_target=51539607552
PROD1.__shared_io_pool_size=402653184
PROD1.__shared_pool_size=8724152320
PROD1.__streams_pool_size=268435456
*._b_tree_bitmap_plans=FALSE# Required 11i setting
*._disable_fast_validate=TRUE#required by 761570.1
*._fast_full_scan_enabled=FALSE
*._immediate_commit_propagation=TRUE
*._like_with_bind_as_equality=TRUE
*._lm_global_posts=TRUE
*._optimizer_autostats_job=false# Turning off auto statistics 
*._pga_max_size=1048576000#required by 761570.1
*._sort_elimination_cost_ratio=5
*._system_trig_enabled=true
*._trace_files_public=TRUE
*._use_adaptive_log_file_sync='TRUE'# 'FALSE'
*.aq_tm_processes=1
*.audit_file_dest='/u1/app/oracle/admin/prod/adump'
*.AUDIT_SYS_OPERATIONS=FALSE
*.cluster_database=TRUE
*.cluster_database_instances=2
*.compatible='11.2.0'
*.control_files='+DATADG/PROD/CONTROLFILE/control01.ctl','+FRADG/PROD/CONTROLFILE/control02.ctl'
*.cursor_sharing='EXACT'# Required 11i settting
*.db_block_checking='FALSE'
*.db_block_checksum='TRUE'
*.db_block_size=8192
*.db_files=2000# Max. no. of database files
*.db_name='PROD'
*.db_writer_processes=6# improve IO performance
*.diagnostic_dest='/u1/app/oracle/product/11.2.0/db1/admin/PROD1_db1'
*.dml_locks=10000
*.event='44951 trace name context forever, level 1024','31156 trace name context forever, level 0x400'# ref 3-4941349801
*.filesystemio_options='SETALL'
*.instance_name='PROD1'
*.instance_number=1
*.job_queue_processes=64
*.log_archive_dest_1='LOCATION=+FRADG/PROD/archivelog/PROD1'
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=10485760
*.log_checkpoint_interval=100000
*.log_checkpoint_timeout=1200# Checkpoint at least every 20 mins.
*.log_checkpoints_to_alert=TRUE
*.max_dump_file_size='20480'# trace file size 
*.nls_comp='binary'# Required 11i setting 
*.nls_date_format='DD-MON-RR'
*.nls_length_semantics='BYTE'# Required 11i setting  
*.nls_numeric_characters='.,'
*.nls_sort='binary'# Required 11i setting 
*.nls_territory='america'
*.o7_dictionary_accessibility=FALSE#MP
*.olap_page_pool_size=4194304
*.open_cursors=1600# Consumes process memory, unless using MTS. 
*.optimizer_secure_view_merging=false
*.OS_AUTHENT_PREFIX=''
*.parallel_max_servers=64
*.parallel_min_servers=0
*.pga_aggregate_target=1G
*.plsql_code_type='INTERPRETED'# Default 11i setting
*.plsql_optimize_level=2# Required 11i setting
*.processes=5000# Max. no. of users x 2
*.remote_listener='erpdb-cluster-scan:1521'
*.sec_case_sensitive_logon=FALSE
*.service_names='PROD1'
*.session_cached_cursors=500
*.sessions=4400# 2 X processes  
*.sga_target=48G
*.shared_pool_reserved_size=440M
*.shared_pool_size=4400M
*.SQL92_SECURITY=TRUE
*.thread=1
*.timed_statistics=true
*.undo_management='AUTO'# Required 11i setting
*.undo_tablespace='APPS_UNDOTS1'# Required 11i setting
*.utl_file_dir='/usr/tmp','/u1/11gR2_BASE/product/11.2.0/appsutil/outbound/PROD1_db1'
*.workarea_size_policy='AUTO'# Required 11i setting

after edit

[[email protected] dbs]$ cat initPROD.ora 
PROD.__db_cache_size=40802189312
PROD.__java_pool_size=939524096
PROD.__large_pool_size=134217728
PROD.__oracle_base='/u1/11gR2_BASE'#ORACLE_BASE set from environment
PROD.__pga_aggregate_target=1073741824
PROD.__sga_target=51539607552
PROD.__shared_io_pool_size=402653184
PROD.__shared_pool_size=8724152320
PROD.__streams_pool_size=268435456
*._b_tree_bitmap_plans=FALSE# Required 11i setting
*._disable_fast_validate=TRUE#required by 761570.1
*._fast_full_scan_enabled=FALSE
*._immediate_commit_propagation=TRUE
*._like_with_bind_as_equality=TRUE
*._lm_global_posts=TRUE
*._optimizer_autostats_job=false# Turning off auto statistics 
*._pga_max_size=1048576000#required by 761570.1
*._sort_elimination_cost_ratio=5
*._system_trig_enabled=true
*._trace_files_public=TRUE
*._use_adaptive_log_file_sync='TRUE'# 'FALSE'
*.aq_tm_processes=1
*.audit_file_dest='/u1/11gR2_BASE/admin/prod/adump'
*.AUDIT_SYS_OPERATIONS=FALSE
*.compatible='11.2.0'
*.control_files='/u1/TEST/testora/testdata/control01.ctl','/u1/TEST/testora/testdata/control02.ctl'
*.cursor_sharing='EXACT'# Required 11i settting
*.db_block_checking='FALSE'
*.db_block_checksum='TRUE'
*.db_block_size=8192
*.db_files=2000# Max. no. of database files
*.db_name='PROD'
*.db_writer_processes=6# improve IO performance
*.diagnostic_dest='/u1/11gR2_BASE/admin/prod'
*.dml_locks=10000
*.event='44951 trace name context forever, level 1024','31156 trace name context forever, level 0x400'# ref 3-4941349801
*.filesystemio_options='SETALL'
*.instance_name='PROD'
*.job_queue_processes=64
*.log_archive_dest_1='LOCATION=/u1/TEST/testora/archive'
*.log_archive_format='%t_%s_%r.dbf'
*.log_buffer=10485760
*.log_checkpoint_interval=100000
*.log_checkpoint_timeout=1200# Checkpoint at least every 20 mins.
*.log_checkpoints_to_alert=TRUE
*.max_dump_file_size='20480'# trace file size 
*.nls_comp='binary'# Required 11i setting 
*.nls_date_format='DD-MON-RR'
*.nls_length_semantics='BYTE'# Required 11i setting  
*.nls_numeric_characters='.,'
*.nls_sort='binary'# Required 11i setting 
*.nls_territory='america'
*.o7_dictionary_accessibility=FALSE#MP
*.olap_page_pool_size=4194304
*.open_cursors=1600# Consumes process memory, unless using MTS. 
*.optimizer_secure_view_merging=false
*.OS_AUTHENT_PREFIX=''
*.parallel_max_servers=64
*.parallel_min_servers=0
*.pga_aggregate_target=1G
*.plsql_code_type='INTERPRETED'# Default 11i setting
*.plsql_optimize_level=2# Required 11i setting
*.processes=5000# Max. no. of users x 2
*.sec_case_sensitive_logon=FALSE
*.service_names='PROD'
*.session_cached_cursors=500
*.sessions=4400# 2 X processes  
*.sga_target=48G
*.shared_pool_reserved_size=440M
*.shared_pool_size=4400M
*.SQL92_SECURITY=TRUE
*.thread=1
*.timed_statistics=true
*.undo_management='AUTO'# Required 11i setting
*.undo_tablespace='APPS_UNDOTS1'# Required 11i setting
*.utl_file_dir='/usr/tmp','/u1/11gR2_BASE/product/11.2.0/appsutil/PROD'
*.workarea_size_policy='AUTO'# Required 11i setting
*.log_file_name_convert=('+DATADG/prodora/proddata','/u1/TEST/testora/testdata')
*.db_file_name_convert=('+DATADG/prodora/proddata','/u1/TEST/testora/testdata')

copy initPROD.ora to init.ora

[[email protected] dbs]$ cp initPROD.ora init.ora

diff between initPROD1.ora and initPROD.ora

[[email protected] ~]$ diff  /data/backup/initPROD1.ora /u1/11gR2_BASE/product/11.2.0/dbs/initPROD.ora
1,9c1,9
< PROD1.__db_cache_size=40802189312
< PROD1.__java_pool_size=939524096
< PROD1.__large_pool_size=134217728
< PROD1.__oracle_base='/u1/app/oracle'#ORACLE_BASE set from environment
< PROD1.__pga_aggregate_target=1073741824
< PROD1.__sga_target=51539607552
< PROD1.__shared_io_pool_size=402653184
< PROD1.__shared_pool_size=8724152320
< PROD1.__streams_pool_size=268435456
---
> PROD.__db_cache_size=40802189312
> PROD.__java_pool_size=939524096
> PROD.__large_pool_size=134217728
> PROD.__oracle_base='/u1/11gR2_BASE'#ORACLE_BASE set from environment
> PROD.__pga_aggregate_target=1073741824
> PROD.__sga_target=51539607552
> PROD.__shared_io_pool_size=402653184
> PROD.__shared_pool_size=8724152320
> PROD.__streams_pool_size=268435456
23c23
< *.audit_file_dest='/u1/app/oracle/admin/prod/adump'
---
> *.audit_file_dest='/u1/11gR2_BASE/admin/prod/adump'
25,26d24
< *.cluster_database=TRUE
< *.cluster_database_instances=2
28c26
< *.control_files='+DATADG/PROD/CONTROLFILE/control01.ctl','+FRADG/PROD/CONTROLFILE/control02.ctl'
---
> *.control_files='/u1/TEST/testora/testdata/control01.ctl','/u1/TEST/testora/testdata/control02.ctl'
36c34
< *.diagnostic_dest='/u1/app/oracle/product/11.2.0/db1/admin/PROD1_db1'
---
> *.diagnostic_dest='/u1/11gR2_BASE/admin/prod'
40,41c38
< *.instance_name='PROD1'
< *.instance_number=1
---
> *.instance_name='PROD'
43c40
< *.log_archive_dest_1='LOCATION=+FRADG/PROD/archivelog/PROD1'
---
> *.log_archive_dest_1='LOCATION=/u1/TEST/testora/archive'
67d63
< *.remote_listener='erpdb-cluster-scan:1521'
69c67
< *.service_names='PROD1'
---
> *.service_names='PROD'
80c76
< *.utl_file_dir='/usr/tmp','/u1/11gR2_BASE/product/11.2.0/appsutil/outbound/PROD1_db1'
---
> *.utl_file_dir='/usr/tmp','/u1/11gR2_BASE/product/11.2.0/appsutil/PROD'
81a78,79
> *.log_file_name_convert=('+DATADG/prodora/proddata','/u1/TEST/testora/testdata')
> *.db_file_name_convert=('+DATADG/prodora/proddata','/u1/TEST/testora/testdata')

recovery test

[[email protected] ~]$ export ORACLE_SID=PROD
[[email protected] ~]$ rman target/

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Oct 17 10:48:57 2013

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

connected to target database (not started)

RMAN> set dbid=240240185;

executing command: SET DBID

RMAN> startup nomount;

Oracle instance started

Total System Global Area   51309510656 bytes

Fixed Size                     2240344 bytes
Variable Size              10066329768 bytes
Database Buffers           41204842496 bytes
Redo Buffers                  36098048 bytes

RMAN> restore controlfile from '/data/controlfile/ctl_file_c-240240185-20131017-01';

Starting restore at 17-OCT-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u1/TEST/testora/testdata/control01.ctl
output file name=/u1/TEST/testora/testdata/control02.ctl
Finished restore at 17-OCT-13

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> list backup of controlfile;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
262     Incr 0  18.42M     DISK        00:00:01     16-OCT-13      
        BP Key: 282   Status: AVAILABLE  Compressed: NO  Tag: TEST INC0 BACKUP
        Piece Name: /data/backup/20131016_inc0_86omij5d_1_1.bkp
  Control File Included: Ckp SCN: 99193819     Ckp time: 16-OCT-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
264     Full    18.39M     DISK        00:00:01     17-OCT-13      
        BP Key: 284   Status: AVAILABLE  Compressed: NO  Tag: CF1
        Piece Name: /data/backup/ctl_file_20131017_88omkbta
  Control File Included: Ckp SCN: 100644641    Ckp time: 17-OCT-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
268     Full    18.42M     DISK        00:00:00     17-OCT-13      
        BP Key: 308   Status: AVAILABLE  Compressed: NO  Tag: TAG20131017T104019
        Piece Name: /data/controlfile/ctl_file_c-240240185-20131017-00
  Control File Included: Ckp SCN: 101311620    Ckp time: 17-OCT-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
273     Full    18.39M     DISK        00:00:01     17-OCT-13      
        BP Key: 313   Status: AVAILABLE  Compressed: NO  Tag: BAK_CTLFILE
        Piece Name: /data/backup/ctl_file_829046450_1_273
  Control File Included: Ckp SCN: 101313008    Ckp time: 17-OCT-13

RMAN> list backup of spfile;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
262     Incr 0  18.42M     DISK        00:00:01     16-OCT-13      
        BP Key: 282   Status: AVAILABLE  Compressed: NO  Tag: TEST INC0 BACKUP
        Piece Name: /data/backup/20131016_inc0_86omij5d_1_1.bkp
  SPFILE Included: Modification time: 15-OCT-13
  SPFILE db_unique_name: PROD

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
268     Full    18.42M     DISK        00:00:00     17-OCT-13      
        BP Key: 308   Status: AVAILABLE  Compressed: NO  Tag: TAG20131017T104019
        Piece Name: /data/controlfile/ctl_file_c-240240185-20131017-00
  SPFILE Included: Modification time: 15-OCT-13
  SPFILE db_unique_name: PROD

RMAN> run {set newname for datafile 1 to "/u1/TEST/testora/testdata/system01.dbf"; restore datafile 1;recover datafile 1;}

executing command: SET NEWNAME

Starting restore at 17-OCT-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2 device type=DISK

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 00001 to /u1/TEST/testora/testdata/system01.dbf
channel ORA_DISK_1: reading from backup piece /data/backup/db_bak_lev0_829046009_1_267
channel ORA_DISK_1: piece handle=/data/backup/db_bak_lev0_829046009_1_267 tag=DB_BAK_LEV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: reading from backup piece /data/backup/db_bak_lev0_829046009_2_267
channel ORA_DISK_1: piece handle=/data/backup/db_bak_lev0_829046009_2_267 tag=DB_BAK_LEV0
channel ORA_DISK_1: restored backup piece 2
channel ORA_DISK_1: reading from backup piece /data/backup/db_bak_lev0_829046009_3_267
channel ORA_DISK_1: piece handle=/data/backup/db_bak_lev0_829046009_3_267 tag=DB_BAK_LEV0
channel ORA_DISK_1: restored backup piece 3
channel ORA_DISK_1: reading from backup piece /data/backup/db_bak_lev0_829046009_4_267
channel ORA_DISK_1: piece handle=/data/backup/db_bak_lev0_829046009_4_267 tag=DB_BAK_LEV0
channel ORA_DISK_1: restored backup piece 4
channel ORA_DISK_1: reading from backup piece /data/backup/db_bak_lev0_829046009_5_267
channel ORA_DISK_1: piece handle=/data/backup/db_bak_lev0_829046009_5_267 tag=DB_BAK_LEV0
channel ORA_DISK_1: restored backup piece 5
channel ORA_DISK_1: reading from backup piece /data/backup/db_bak_lev0_829046009_6_267
channel ORA_DISK_1: piece handle=/data/backup/db_bak_lev0_829046009_6_267 tag=DB_BAK_LEV0
channel ORA_DISK_1: restored backup piece 6
channel ORA_DISK_1: reading from backup piece /data/backup/db_bak_lev0_829046009_7_267
channel ORA_DISK_1: piece handle=/data/backup/db_bak_lev0_829046009_7_267 tag=DB_BAK_LEV0
channel ORA_DISK_1: restored backup piece 7
channel ORA_DISK_1: restore complete, elapsed time: 00:10:35
Finished restore at 17-OCT-13

Starting recover at 17-OCT-13
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/17/2013 11:01:15
RMAN-06067: RECOVER DATABASE required with a backup or created control file

[[email protected] testdata]# ll -h
total 1.1G
-rw-r-----. 1 testora dba   19M Oct 17 11:01 control01.ctl
-rw-r-----. 1 testora dba   19M Oct 17 11:01 control02.ctl
-rw-r-----. 1 testora dba 1001M Oct 17 11:01 system01.dbf

rman-06067

Error:	RMAN 6067
Text:	RECOVER DATABASE required with a backup or created controlfile 
---------------------------------------------------------------------------
Cause:	The controlfile has been restored from a backup or was created via 
    ALTER DATABASE CREATE CONTROLFILE. 
Action:	Use the RECOVER DATABASE command to perform the recovery.

clean failure instance and datafiles

RMAN> shutdown immediate;

[[email protected] testdata]# rm control01.ctl control02.ctl system01.dbf

recover database

sql script to set newname for datafile

SELECT FILE#,
       NAME,
       '''' ||NEWNAME || ''',' newname,
       'set newname for datafile ' || FILE# || ' to "' || NEWNAME ||
       '";' RECOVERY
  FROM (SELECT FILE#,
               NAME,
               REPLACE(REPLACE(NAME,
                       '+DATADG/prod/datafile/',
                       '/u1/TEST/testora/testdata/'),
                       '+DATADG/prod/undofile/',
                       '/u1/TEST/testora/testdata/'
                       ) NEWNAME
          FROM V$DATAFILE);

sql script output

--new path
'/u1/TEST/testora/testdata/system01.dbf',
'/u1/TEST/testora/testdata/system02.dbf',
'/u1/TEST/testora/testdata/system03.dbf',
'/u1/TEST/testora/testdata/system04.dbf',
'/u1/TEST/testora/testdata/system05.dbf',
'/u1/TEST/testora/testdata/system06.dbf',
'/u1/TEST/testora/testdata/system07.dbf',
'/u1/TEST/testora/testdata/system08.dbf',
'/u1/TEST/testora/testdata/system09.dbf',
'/u1/TEST/testora/testdata/system10.dbf',
'/u1/TEST/testora/testdata/system11.dbf',
'/u1/TEST/testora/testdata/sysaux01.dbf',
'/u1/TEST/testora/testdata/undo01.dbf',
'/u1/TEST/testora/testdata/undo02.dbf',
'/u1/TEST/testora/testdata/undo03.dbf',
'/u1/TEST/testora/testdata/a_archive01.dbf',
'/u1/TEST/testora/testdata/a_archive02.dbf',
'/u1/TEST/testora/testdata/a_archive03.dbf',
'/u1/TEST/testora/testdata/a_archive04.dbf',
'/u1/TEST/testora/testdata/a_archive05.dbf',
'/u1/TEST/testora/testdata/a_int01.dbf',
'/u1/TEST/testora/testdata/a_int02.dbf',
'/u1/TEST/testora/testdata/a_int03.dbf',
'/u1/TEST/testora/testdata/a_int04.dbf',
'/u1/TEST/testora/testdata/a_int05.dbf',
'/u1/TEST/testora/testdata/a_int06.dbf',
'/u1/TEST/testora/testdata/a_int07.dbf',
'/u1/TEST/testora/testdata/a_int08.dbf',
'/u1/TEST/testora/testdata/a_media01.dbf',
'/u1/TEST/testora/testdata/a_media02.dbf',
'/u1/TEST/testora/testdata/a_media03.dbf',
'/u1/TEST/testora/testdata/a_media04.dbf',
'/u1/TEST/testora/testdata/a_media05.dbf',
'/u1/TEST/testora/testdata/a_media06.dbf',
'/u1/TEST/testora/testdata/a_media07.dbf',
'/u1/TEST/testora/testdata/a_media08.dbf',
'/u1/TEST/testora/testdata/a_media09.dbf',
'/u1/TEST/testora/testdata/a_media10.dbf',
'/u1/TEST/testora/testdata/a_nolog01.dbf',
'/u1/TEST/testora/testdata/a_queue01.dbf',
'/u1/TEST/testora/testdata/a_queue02.dbf',
'/u1/TEST/testora/testdata/a_queue03.dbf',
'/u1/TEST/testora/testdata/a_queue04.dbf',
'/u1/TEST/testora/testdata/a_queue05.dbf',
'/u1/TEST/testora/testdata/a_queue06.dbf',
'/u1/TEST/testora/testdata/a_queue07.dbf',
'/u1/TEST/testora/testdata/a_queue08.dbf',
'/u1/TEST/testora/testdata/a_queue09.dbf',
'/u1/TEST/testora/testdata/a_queue10.dbf',
'/u1/TEST/testora/testdata/a_queue11.dbf',
'/u1/TEST/testora/testdata/a_queue12.dbf',
'/u1/TEST/testora/testdata/a_queue13.dbf',
'/u1/TEST/testora/testdata/a_queue14.dbf',
'/u1/TEST/testora/testdata/a_queue15.dbf',
'/u1/TEST/testora/testdata/a_queue16.dbf',
'/u1/TEST/testora/testdata/a_queue17.dbf',
'/u1/TEST/testora/testdata/a_queue18.dbf',
'/u1/TEST/testora/testdata/a_queue19.dbf',
'/u1/TEST/testora/testdata/a_queue20.dbf',
'/u1/TEST/testora/testdata/a_queue21.dbf',
'/u1/TEST/testora/testdata/a_queue22.dbf',
'/u1/TEST/testora/testdata/a_queue23.dbf',
'/u1/TEST/testora/testdata/a_queue24.dbf',
'/u1/TEST/testora/testdata/a_queue25.dbf',
'/u1/TEST/testora/testdata/a_ref01.dbf',
'/u1/TEST/testora/testdata/a_ref02.dbf',
'/u1/TEST/testora/testdata/a_summ01.dbf',
'/u1/TEST/testora/testdata/a_summ02.dbf',
'/u1/TEST/testora/testdata/a_summ03.dbf',
'/u1/TEST/testora/testdata/a_summ04.dbf',
'/u1/TEST/testora/testdata/a_summ05.dbf',
'/u1/TEST/testora/testdata/a_tools01.dbf',
'/u1/TEST/testora/testdata/a_txn_data01.dbf',
'/u1/TEST/testora/testdata/a_txn_data02.dbf',
'/u1/TEST/testora/testdata/a_txn_data03.dbf',
'/u1/TEST/testora/testdata/a_txn_data04.dbf',
'/u1/TEST/testora/testdata/a_txn_data05.dbf',
'/u1/TEST/testora/testdata/a_txn_data06.dbf',
'/u1/TEST/testora/testdata/a_txn_data07.dbf',
'/u1/TEST/testora/testdata/a_txn_data08.dbf',
'/u1/TEST/testora/testdata/a_txn_data09.dbf',
'/u1/TEST/testora/testdata/a_txn_data10.dbf',
'/u1/TEST/testora/testdata/a_txn_data11.dbf',
'/u1/TEST/testora/testdata/a_txn_data12.dbf',
'/u1/TEST/testora/testdata/a_txn_data13.dbf',
'/u1/TEST/testora/testdata/a_txn_data14.dbf',
'/u1/TEST/testora/testdata/a_txn_data15.dbf',
'/u1/TEST/testora/testdata/a_txn_data16.dbf',
'/u1/TEST/testora/testdata/a_txn_data17.dbf',
'/u1/TEST/testora/testdata/a_txn_data18.dbf',
'/u1/TEST/testora/testdata/a_txn_data19.dbf',
'/u1/TEST/testora/testdata/a_txn_data20.dbf',
'/u1/TEST/testora/testdata/a_txn_data21.dbf',
'/u1/TEST/testora/testdata/a_txn_data22.dbf',
'/u1/TEST/testora/testdata/a_txn_data23.dbf',
'/u1/TEST/testora/testdata/a_txn_data24.dbf',
'/u1/TEST/testora/testdata/a_txn_data25.dbf',
'/u1/TEST/testora/testdata/a_txn_data26.dbf',
'/u1/TEST/testora/testdata/a_txn_data28.dbf',
'/u1/TEST/testora/testdata/a_txn_data29.dbf',
'/u1/TEST/testora/testdata/a_txn_data30.dbf',
'/u1/TEST/testora/testdata/a_txn_data31.dbf',
'/u1/TEST/testora/testdata/a_txn_data32.dbf',
'/u1/TEST/testora/testdata/a_txn_data33.dbf',
'/u1/TEST/testora/testdata/a_txn_data34.dbf',
'/u1/TEST/testora/testdata/a_txn_data35.dbf',
'/u1/TEST/testora/testdata/a_txn_data36.dbf',
'/u1/TEST/testora/testdata/a_txn_data37.dbf',
'/u1/TEST/testora/testdata/a_txn_data38.dbf',
'/u1/TEST/testora/testdata/a_txn_data39.dbf',
'/u1/TEST/testora/testdata/a_txn_data40.dbf',
'/u1/TEST/testora/testdata/a_txn_data41.dbf',
'/u1/TEST/testora/testdata/a_txn_data42.dbf',
'/u1/TEST/testora/testdata/a_txn_data43.dbf',
'/u1/TEST/testora/testdata/a_txn_data44.dbf',
'/u1/TEST/testora/testdata/a_txn_data45.dbf',
'/u1/TEST/testora/testdata/a_txn_data46.dbf',
'/u1/TEST/testora/testdata/a_txn_data47.dbf',
'/u1/TEST/testora/testdata/a_txn_data48.dbf',
'/u1/TEST/testora/testdata/a_txn_ind01.dbf',
'/u1/TEST/testora/testdata/a_txn_ind02.dbf',
'/u1/TEST/testora/testdata/a_txn_ind03.dbf',
'/u1/TEST/testora/testdata/a_txn_ind04.dbf',
'/u1/TEST/testora/testdata/a_txn_ind05.dbf',
'/u1/TEST/testora/testdata/a_txn_ind06.dbf',
'/u1/TEST/testora/testdata/a_txn_ind07.dbf',
'/u1/TEST/testora/testdata/a_txn_ind08.dbf',
'/u1/TEST/testora/testdata/a_txn_ind09.dbf',
'/u1/TEST/testora/testdata/a_txn_ind10.dbf',
'/u1/TEST/testora/testdata/a_txn_ind11.dbf',
'/u1/TEST/testora/testdata/a_txn_ind12.dbf',
'/u1/TEST/testora/testdata/a_txn_ind13.dbf',
'/u1/TEST/testora/testdata/a_txn_ind14.dbf',
'/u1/TEST/testora/testdata/a_txn_ind15.dbf',
'/u1/TEST/testora/testdata/a_txn_ind16.dbf',
'/u1/TEST/testora/testdata/a_txn_ind17.dbf',
'/u1/TEST/testora/testdata/a_txn_ind18.dbf',
'/u1/TEST/testora/testdata/a_txn_ind19.dbf',
'/u1/TEST/testora/testdata/a_txn_ind20.dbf',
'/u1/TEST/testora/testdata/a_txn_ind21.dbf',
'/u1/TEST/testora/testdata/a_txn_ind22.dbf',
'/u1/TEST/testora/testdata/a_txn_ind23.dbf',
'/u1/TEST/testora/testdata/a_txn_ind24.dbf',
'/u1/TEST/testora/testdata/a_txn_ind25.dbf',
'/u1/TEST/testora/testdata/a_txn_ind26.dbf',
'/u1/TEST/testora/testdata/a_txn_ind27.dbf',
'/u1/TEST/testora/testdata/a_txn_ind28.dbf',
'/u1/TEST/testora/testdata/a_txn_ind29.dbf',
'/u1/TEST/testora/testdata/a_txn_ind30.dbf',
'/u1/TEST/testora/testdata/a_txn_ind31.dbf',
'/u1/TEST/testora/testdata/a_txn_ind32.dbf',
'/u1/TEST/testora/testdata/a_txn_ind33.dbf',
'/u1/TEST/testora/testdata/a_txn_ind34.dbf',
'/u1/TEST/testora/testdata/a_txn_ind35.dbf',
'/u1/TEST/testora/testdata/a_txn_ind36.dbf',
'/u1/TEST/testora/testdata/a_txn_ind37.dbf',
'/u1/TEST/testora/testdata/a_txn_ind38.dbf',
'/u1/TEST/testora/testdata/a_txn_ind39.dbf',
'/u1/TEST/testora/testdata/a_txn_ind40.dbf',
'/u1/TEST/testora/testdata/a_txn_ind41.dbf',
'/u1/TEST/testora/testdata/a_txn_ind42.dbf',
'/u1/TEST/testora/testdata/a_txn_ind43.dbf',
'/u1/TEST/testora/testdata/a_txn_ind44.dbf',
'/u1/TEST/testora/testdata/a_txn_ind45.dbf',
'/u1/TEST/testora/testdata/a_txn_ind46.dbf',
'/u1/TEST/testora/testdata/a_txn_ind47.dbf',
'/u1/TEST/testora/testdata/a_txn_ind48.dbf',
'/u1/TEST/testora/testdata/a_txn_ind49.dbf',
'/u1/TEST/testora/testdata/a_txn_ind50.dbf',
'/u1/TEST/testora/testdata/a_txn_ind51.dbf',
'/u1/TEST/testora/testdata/a_txn_ind52.dbf',
'/u1/TEST/testora/testdata/a_txn_ind53.dbf',
'/u1/TEST/testora/testdata/a_txn_ind54.dbf',
'/u1/TEST/testora/testdata/a_txn_ind55.dbf',
'/u1/TEST/testora/testdata/ctxd01.dbf',
'/u1/TEST/testora/testdata/odm.dbf',
'/u1/TEST/testora/testdata/olap.dbf',
'/u1/TEST/testora/testdata/owad01.dbf',
'/u1/TEST/testora/testdata/portal01.dbf',
'/u1/TEST/testora/testdata/statspack_01.dbf',
'/u1/TEST/testora/testdata/tplcux_data_01.dbf',
'/u1/TEST/testora/testdata/tplcux_idx_01.dbf',
'/u1/TEST/testora/testdata/interim.dbf',
'/u1/TEST/testora/testdata/system12.dbf',
'/u1/TEST/testora/testdata/a_txn_data49.dbf',
'/u1/TEST/testora/testdata/a_ref03.dbf',
'/u1/TEST/testora/testdata/a_summ06.dbf',
'/u1/TEST/testora/testdata/undo04.dbf',

--set newname;
set newname for datafile 1 to "/u1/TEST/testora/testdata/system01.dbf";
set newname for datafile 2 to "/u1/TEST/testora/testdata/system02.dbf";
set newname for datafile 3 to "/u1/TEST/testora/testdata/system03.dbf";
set newname for datafile 4 to "/u1/TEST/testora/testdata/system04.dbf";
set newname for datafile 5 to "/u1/TEST/testora/testdata/system05.dbf";
set newname for datafile 6 to "/u1/TEST/testora/testdata/system06.dbf";
set newname for datafile 7 to "/u1/TEST/testora/testdata/system07.dbf";
set newname for datafile 8 to "/u1/TEST/testora/testdata/system08.dbf";
set newname for datafile 9 to "/u1/TEST/testora/testdata/system09.dbf";
set newname for datafile 10 to "/u1/TEST/testora/testdata/system10.dbf";
set newname for datafile 11 to "/u1/TEST/testora/testdata/system11.dbf";
set newname for datafile 12 to "/u1/TEST/testora/testdata/sysaux01.dbf";
set newname for datafile 13 to "/u1/TEST/testora/testdata/undo01.dbf";
set newname for datafile 14 to "/u1/TEST/testora/testdata/undo02.dbf";
set newname for datafile 15 to "/u1/TEST/testora/testdata/undo03.dbf";
set newname for datafile 16 to "/u1/TEST/testora/testdata/a_archive01.dbf";
set newname for datafile 17 to "/u1/TEST/testora/testdata/a_archive02.dbf";
set newname for datafile 18 to "/u1/TEST/testora/testdata/a_archive03.dbf";
set newname for datafile 19 to "/u1/TEST/testora/testdata/a_archive04.dbf";
set newname for datafile 20 to "/u1/TEST/testora/testdata/a_archive05.dbf";
set newname for datafile 21 to "/u1/TEST/testora/testdata/a_int01.dbf";
set newname for datafile 22 to "/u1/TEST/testora/testdata/a_int02.dbf";
set newname for datafile 23 to "/u1/TEST/testora/testdata/a_int03.dbf";
set newname for datafile 24 to "/u1/TEST/testora/testdata/a_int04.dbf";
set newname for datafile 25 to "/u1/TEST/testora/testdata/a_int05.dbf";
set newname for datafile 26 to "/u1/TEST/testora/testdata/a_int06.dbf";
set newname for datafile 27 to "/u1/TEST/testora/testdata/a_int07.dbf";
set newname for datafile 28 to "/u1/TEST/testora/testdata/a_int08.dbf";
set newname for datafile 29 to "/u1/TEST/testora/testdata/a_media01.dbf";
set newname for datafile 30 to "/u1/TEST/testora/testdata/a_media02.dbf";
set newname for datafile 31 to "/u1/TEST/testora/testdata/a_media03.dbf";
set newname for datafile 32 to "/u1/TEST/testora/testdata/a_media04.dbf";
set newname for datafile 33 to "/u1/TEST/testora/testdata/a_media05.dbf";
set newname for datafile 34 to "/u1/TEST/testora/testdata/a_media06.dbf";
set newname for datafile 35 to "/u1/TEST/testora/testdata/a_media07.dbf";
set newname for datafile 36 to "/u1/TEST/testora/testdata/a_media08.dbf";
set newname for datafile 37 to "/u1/TEST/testora/testdata/a_media09.dbf";
set newname for datafile 38 to "/u1/TEST/testora/testdata/a_media10.dbf";
set newname for datafile 39 to "/u1/TEST/testora/testdata/a_nolog01.dbf";
set newname for datafile 40 to "/u1/TEST/testora/testdata/a_queue01.dbf";
set newname for datafile 41 to "/u1/TEST/testora/testdata/a_queue02.dbf";
set newname for datafile 42 to "/u1/TEST/testora/testdata/a_queue03.dbf";
set newname for datafile 43 to "/u1/TEST/testora/testdata/a_queue04.dbf";
set newname for datafile 44 to "/u1/TEST/testora/testdata/a_queue05.dbf";
set newname for datafile 45 to "/u1/TEST/testora/testdata/a_queue06.dbf";
set newname for datafile 46 to "/u1/TEST/testora/testdata/a_queue07.dbf";
set newname for datafile 47 to "/u1/TEST/testora/testdata/a_queue08.dbf";
set newname for datafile 48 to "/u1/TEST/testora/testdata/a_queue09.dbf";
set newname for datafile 49 to "/u1/TEST/testora/testdata/a_queue10.dbf";
set newname for datafile 50 to "/u1/TEST/testora/testdata/a_queue11.dbf";
set newname for datafile 51 to "/u1/TEST/testora/testdata/a_queue12.dbf";
set newname for datafile 52 to "/u1/TEST/testora/testdata/a_queue13.dbf";
set newname for datafile 53 to "/u1/TEST/testora/testdata/a_queue14.dbf";
set newname for datafile 54 to "/u1/TEST/testora/testdata/a_queue15.dbf";
set newname for datafile 55 to "/u1/TEST/testora/testdata/a_queue16.dbf";
set newname for datafile 56 to "/u1/TEST/testora/testdata/a_queue17.dbf";
set newname for datafile 57 to "/u1/TEST/testora/testdata/a_queue18.dbf";
set newname for datafile 58 to "/u1/TEST/testora/testdata/a_queue19.dbf";
set newname for datafile 59 to "/u1/TEST/testora/testdata/a_queue20.dbf";
set newname for datafile 60 to "/u1/TEST/testora/testdata/a_queue21.dbf";
set newname for datafile 61 to "/u1/TEST/testora/testdata/a_queue22.dbf";
set newname for datafile 62 to "/u1/TEST/testora/testdata/a_queue23.dbf";
set newname for datafile 63 to "/u1/TEST/testora/testdata/a_queue24.dbf";
set newname for datafile 64 to "/u1/TEST/testora/testdata/a_queue25.dbf";
set newname for datafile 65 to "/u1/TEST/testora/testdata/a_ref01.dbf";
set newname for datafile 66 to "/u1/TEST/testora/testdata/a_ref02.dbf";
set newname for datafile 67 to "/u1/TEST/testora/testdata/a_summ01.dbf";
set newname for datafile 68 to "/u1/TEST/testora/testdata/a_summ02.dbf";
set newname for datafile 69 to "/u1/TEST/testora/testdata/a_summ03.dbf";
set newname for datafile 70 to "/u1/TEST/testora/testdata/a_summ04.dbf";
set newname for datafile 71 to "/u1/TEST/testora/testdata/a_summ05.dbf";
set newname for datafile 72 to "/u1/TEST/testora/testdata/a_tools01.dbf";
set newname for datafile 73 to "/u1/TEST/testora/testdata/a_txn_data01.dbf";
set newname for datafile 74 to "/u1/TEST/testora/testdata/a_txn_data02.dbf";
set newname for datafile 75 to "/u1/TEST/testora/testdata/a_txn_data03.dbf";
set newname for datafile 76 to "/u1/TEST/testora/testdata/a_txn_data04.dbf";
set newname for datafile 77 to "/u1/TEST/testora/testdata/a_txn_data05.dbf";
set newname for datafile 78 to "/u1/TEST/testora/testdata/a_txn_data06.dbf";
set newname for datafile 79 to "/u1/TEST/testora/testdata/a_txn_data07.dbf";
set newname for datafile 80 to "/u1/TEST/testora/testdata/a_txn_data08.dbf";
set newname for datafile 81 to "/u1/TEST/testora/testdata/a_txn_data09.dbf";
set newname for datafile 82 to "/u1/TEST/testora/testdata/a_txn_data10.dbf";
set newname for datafile 83 to "/u1/TEST/testora/testdata/a_txn_data11.dbf";
set newname for datafile 84 to "/u1/TEST/testora/testdata/a_txn_data12.dbf";
set newname for datafile 85 to "/u1/TEST/testora/testdata/a_txn_data13.dbf";
set newname for datafile 86 to "/u1/TEST/testora/testdata/a_txn_data14.dbf";
set newname for datafile 87 to "/u1/TEST/testora/testdata/a_txn_data15.dbf";
set newname for datafile 88 to "/u1/TEST/testora/testdata/a_txn_data16.dbf";
set newname for datafile 89 to "/u1/TEST/testora/testdata/a_txn_data17.dbf";
set newname for datafile 90 to "/u1/TEST/testora/testdata/a_txn_data18.dbf";
set newname for datafile 91 to "/u1/TEST/testora/testdata/a_txn_data19.dbf";
set newname for datafile 92 to "/u1/TEST/testora/testdata/a_txn_data20.dbf";
set newname for datafile 93 to "/u1/TEST/testora/testdata/a_txn_data21.dbf";
set newname for datafile 94 to "/u1/TEST/testora/testdata/a_txn_data22.dbf";
set newname for datafile 95 to "/u1/TEST/testora/testdata/a_txn_data23.dbf";
set newname for datafile 96 to "/u1/TEST/testora/testdata/a_txn_data24.dbf";
set newname for datafile 97 to "/u1/TEST/testora/testdata/a_txn_data25.dbf";
set newname for datafile 98 to "/u1/TEST/testora/testdata/a_txn_data26.dbf";
set newname for datafile 99 to "/u1/TEST/testora/testdata/a_txn_data28.dbf";
set newname for datafile 100 to "/u1/TEST/testora/testdata/a_txn_data29.dbf";
set newname for datafile 101 to "/u1/TEST/testora/testdata/a_txn_data30.dbf";
set newname for datafile 102 to "/u1/TEST/testora/testdata/a_txn_data31.dbf";
set newname for datafile 103 to "/u1/TEST/testora/testdata/a_txn_data32.dbf";
set newname for datafile 104 to "/u1/TEST/testora/testdata/a_txn_data33.dbf";
set newname for datafile 105 to "/u1/TEST/testora/testdata/a_txn_data34.dbf";
set newname for datafile 106 to "/u1/TEST/testora/testdata/a_txn_data35.dbf";
set newname for datafile 107 to "/u1/TEST/testora/testdata/a_txn_data36.dbf";
set newname for datafile 108 to "/u1/TEST/testora/testdata/a_txn_data37.dbf";
set newname for datafile 109 to "/u1/TEST/testora/testdata/a_txn_data38.dbf";
set newname for datafile 110 to "/u1/TEST/testora/testdata/a_txn_data39.dbf";
set newname for datafile 111 to "/u1/TEST/testora/testdata/a_txn_data40.dbf";
set newname for datafile 112 to "/u1/TEST/testora/testdata/a_txn_data41.dbf";
set newname for datafile 113 to "/u1/TEST/testora/testdata/a_txn_data42.dbf";
set newname for datafile 114 to "/u1/TEST/testora/testdata/a_txn_data43.dbf";
set newname for datafile 115 to "/u1/TEST/testora/testdata/a_txn_data44.dbf";
set newname for datafile 116 to "/u1/TEST/testora/testdata/a_txn_data45.dbf";
set newname for datafile 117 to "/u1/TEST/testora/testdata/a_txn_data46.dbf";
set newname for datafile 118 to "/u1/TEST/testora/testdata/a_txn_data47.dbf";
set newname for datafile 119 to "/u1/TEST/testora/testdata/a_txn_data48.dbf";
set newname for datafile 120 to "/u1/TEST/testora/testdata/a_txn_ind01.dbf";
set newname for datafile 121 to "/u1/TEST/testora/testdata/a_txn_ind02.dbf";
set newname for datafile 122 to "/u1/TEST/testora/testdata/a_txn_ind03.dbf";
set newname for datafile 123 to "/u1/TEST/testora/testdata/a_txn_ind04.dbf";
set newname for datafile 124 to "/u1/TEST/testora/testdata/a_txn_ind05.dbf";
set newname for datafile 125 to "/u1/TEST/testora/testdata/a_txn_ind06.dbf";
set newname for datafile 126 to "/u1/TEST/testora/testdata/a_txn_ind07.dbf";
set newname for datafile 127 to "/u1/TEST/testora/testdata/a_txn_ind08.dbf";
set newname for datafile 128 to "/u1/TEST/testora/testdata/a_txn_ind09.dbf";
set newname for datafile 129 to "/u1/TEST/testora/testdata/a_txn_ind10.dbf";
set newname for datafile 130 to "/u1/TEST/testora/testdata/a_txn_ind11.dbf";
set newname for datafile 131 to "/u1/TEST/testora/testdata/a_txn_ind12.dbf";
set newname for datafile 132 to "/u1/TEST/testora/testdata/a_txn_ind13.dbf";
set newname for datafile 133 to "/u1/TEST/testora/testdata/a_txn_ind14.dbf";
set newname for datafile 134 to "/u1/TEST/testora/testdata/a_txn_ind15.dbf";
set newname for datafile 135 to "/u1/TEST/testora/testdata/a_txn_ind16.dbf";
set newname for datafile 136 to "/u1/TEST/testora/testdata/a_txn_ind17.dbf";
set newname for datafile 137 to "/u1/TEST/testora/testdata/a_txn_ind18.dbf";
set newname for datafile 138 to "/u1/TEST/testora/testdata/a_txn_ind19.dbf";
set newname for datafile 139 to "/u1/TEST/testora/testdata/a_txn_ind20.dbf";
set newname for datafile 140 to "/u1/TEST/testora/testdata/a_txn_ind21.dbf";
set newname for datafile 141 to "/u1/TEST/testora/testdata/a_txn_ind22.dbf";
set newname for datafile 142 to "/u1/TEST/testora/testdata/a_txn_ind23.dbf";
set newname for datafile 143 to "/u1/TEST/testora/testdata/a_txn_ind24.dbf";
set newname for datafile 144 to "/u1/TEST/testora/testdata/a_txn_ind25.dbf";
set newname for datafile 145 to "/u1/TEST/testora/testdata/a_txn_ind26.dbf";
set newname for datafile 146 to "/u1/TEST/testora/testdata/a_txn_ind27.dbf";
set newname for datafile 147 to "/u1/TEST/testora/testdata/a_txn_ind28.dbf";
set newname for datafile 148 to "/u1/TEST/testora/testdata/a_txn_ind29.dbf";
set newname for datafile 149 to "/u1/TEST/testora/testdata/a_txn_ind30.dbf";
set newname for datafile 150 to "/u1/TEST/testora/testdata/a_txn_ind31.dbf";
set newname for datafile 151 to "/u1/TEST/testora/testdata/a_txn_ind32.dbf";
set newname for datafile 152 to "/u1/TEST/testora/testdata/a_txn_ind33.dbf";
set newname for datafile 153 to "/u1/TEST/testora/testdata/a_txn_ind34.dbf";
set newname for datafile 154 to "/u1/TEST/testora/testdata/a_txn_ind35.dbf";
set newname for datafile 155 to "/u1/TEST/testora/testdata/a_txn_ind36.dbf";
set newname for datafile 156 to "/u1/TEST/testora/testdata/a_txn_ind37.dbf";
set newname for datafile 157 to "/u1/TEST/testora/testdata/a_txn_ind38.dbf";
set newname for datafile 158 to "/u1/TEST/testora/testdata/a_txn_ind39.dbf";
set newname for datafile 159 to "/u1/TEST/testora/testdata/a_txn_ind40.dbf";
set newname for datafile 160 to "/u1/TEST/testora/testdata/a_txn_ind41.dbf";
set newname for datafile 161 to "/u1/TEST/testora/testdata/a_txn_ind42.dbf";
set newname for datafile 162 to "/u1/TEST/testora/testdata/a_txn_ind43.dbf";
set newname for datafile 163 to "/u1/TEST/testora/testdata/a_txn_ind44.dbf";
set newname for datafile 164 to "/u1/TEST/testora/testdata/a_txn_ind45.dbf";
set newname for datafile 165 to "/u1/TEST/testora/testdata/a_txn_ind46.dbf";
set newname for datafile 166 to "/u1/TEST/testora/testdata/a_txn_ind47.dbf";
set newname for datafile 167 to "/u1/TEST/testora/testdata/a_txn_ind48.dbf";
set newname for datafile 168 to "/u1/TEST/testora/testdata/a_txn_ind49.dbf";
set newname for datafile 169 to "/u1/TEST/testora/testdata/a_txn_ind50.dbf";
set newname for datafile 170 to "/u1/TEST/testora/testdata/a_txn_ind51.dbf";
set newname for datafile 171 to "/u1/TEST/testora/testdata/a_txn_ind52.dbf";
set newname for datafile 172 to "/u1/TEST/testora/testdata/a_txn_ind53.dbf";
set newname for datafile 173 to "/u1/TEST/testora/testdata/a_txn_ind54.dbf";
set newname for datafile 174 to "/u1/TEST/testora/testdata/a_txn_ind55.dbf";
set newname for datafile 175 to "/u1/TEST/testora/testdata/ctxd01.dbf";
set newname for datafile 176 to "/u1/TEST/testora/testdata/odm.dbf";
set newname for datafile 177 to "/u1/TEST/testora/testdata/olap.dbf";
set newname for datafile 178 to "/u1/TEST/testora/testdata/owad01.dbf";
set newname for datafile 179 to "/u1/TEST/testora/testdata/portal01.dbf";
set newname for datafile 180 to "/u1/TEST/testora/testdata/statspack_01.dbf";
set newname for datafile 181 to "/u1/TEST/testora/testdata/tplcux_data_01.dbf";
set newname for datafile 182 to "/u1/TEST/testora/testdata/tplcux_idx_01.dbf";
set newname for datafile 183 to "/u1/TEST/testora/testdata/interim.dbf";
set newname for datafile 184 to "/u1/TEST/testora/testdata/system12.dbf";
set newname for datafile 185 to "/u1/TEST/testora/testdata/a_txn_data49.dbf";
set newname for datafile 186 to "/u1/TEST/testora/testdata/a_ref03.dbf";
set newname for datafile 187 to "/u1/TEST/testora/testdata/a_summ06.dbf";
set newname for datafile 188 to "/u1/TEST/testora/testdata/undo04.dbf";

run recover rman script

RMAN> run {
set newname for datafile 1 to "/u1/TEST/testora/testdata/system01.dbf";
set newname for datafile 2 to "/u1/TEST/testora/testdata/system02.dbf";
set newname for datafile 3 to "/u1/TEST/testora/testdata/system03.dbf";
set newname for datafile 4 to "/u1/TEST/testora/testdata/system04.dbf";
set newname for datafile 5 to "/u1/TEST/testora/testdata/system05.dbf";
set newname for datafile 6 to "/u1/TEST/testora/testdata/system06.dbf";
set newname for datafile 7 to "/u1/TEST/testora/testdata/system07.dbf";
set newname for datafile 8 to "/u1/TEST/testora/testdata/system08.dbf";
set newname for datafile 9 to "/u1/TEST/testora/testdata/system09.dbf";
set newname for datafile 10 to "/u1/TEST/testora/testdata/system10.dbf";
set newname for datafile 11 to "/u1/TEST/testora/testdata/system11.dbf";
set newname for datafile 12 to "/u1/TEST/testora/testdata/sysaux01.dbf";
set newname for datafile 13 to "/u1/TEST/testora/testdata/undo01.dbf";
set newname for datafile 14 to "/u1/TEST/testora/testdata/undo02.dbf";
set newname for datafile 15 to "/u1/TEST/testora/testdata/undo03.dbf";
set newname for datafile 16 to "/u1/TEST/testora/testdata/a_archive01.dbf";
set newname for datafile 17 to "/u1/TEST/testora/testdata/a_archive02.dbf";
set newname for datafile 18 to "/u1/TEST/testora/testdata/a_archive03.dbf";
set newname for datafile 19 to "/u1/TEST/testora/testdata/a_archive04.dbf";
set newname for datafile 20 to "/u1/TEST/testora/testdata/a_archive05.dbf";
set newname for datafile 21 to "/u1/TEST/testora/testdata/a_int01.dbf";
set newname for datafile 22 to "/u1/TEST/testora/testdata/a_int02.dbf";
set newname for datafile 23 to "/u1/TEST/testora/testdata/a_int03.dbf";
set newname for datafile 24 to "/u1/TEST/testora/testdata/a_int04.dbf";
set newname for datafile 25 to "/u1/TEST/testora/testdata/a_int05.dbf";
set newname for datafile 26 to "/u1/TEST/testora/testdata/a_int06.dbf";
set newname for datafile 27 to "/u1/TEST/testora/testdata/a_int07.dbf";
set newname for datafile 28 to "/u1/TEST/testora/testdata/a_int08.dbf";
set newname for datafile 29 to "/u1/TEST/testora/testdata/a_media01.dbf";
set newname for datafile 30 to "/u1/TEST/testora/testdata/a_media02.dbf";
set newname for datafile 31 to "/u1/TEST/testora/testdata/a_media03.dbf";
set newname for datafile 32 to "/u1/TEST/testora/testdata/a_media04.dbf";
set newname for datafile 33 to "/u1/TEST/testora/testdata/a_media05.dbf";
set newname for datafile 34 to "/u1/TEST/testora/testdata/a_media06.dbf";
set newname for datafile 35 to "/u1/TEST/testora/testdata/a_media07.dbf";
set newname for datafile 36 to "/u1/TEST/testora/testdata/a_media08.dbf";
set newname for datafile 37 to "/u1/TEST/testora/testdata/a_media09.dbf";
set newname for datafile 38 to "/u1/TEST/testora/testdata/a_media10.dbf";
set newname for datafile 39 to "/u1/TEST/testora/testdata/a_nolog01.dbf";
set newname for datafile 40 to "/u1/TEST/testora/testdata/a_queue01.dbf";
set newname for datafile 41 to "/u1/TEST/testora/testdata/a_queue02.dbf";
set newname for datafile 42 to "/u1/TEST/testora/testdata/a_queue03.dbf";
set newname for datafile 43 to "/u1/TEST/testora/testdata/a_queue04.dbf";
set newname for datafile 44 to "/u1/TEST/testora/testdata/a_queue05.dbf";
set newname for datafile 45 to "/u1/TEST/testora/testdata/a_queue06.dbf";
set newname for datafile 46 to "/u1/TEST/testora/testdata/a_queue07.dbf";
set newname for datafile 47 to "/u1/TEST/testora/testdata/a_queue08.dbf";
set newname for datafile 48 to "/u1/TEST/testora/testdata/a_queue09.dbf";
set newname for datafile 49 to "/u1/TEST/testora/testdata/a_queue10.dbf";
set newname for datafile 50 to "/u1/TEST/testora/testdata/a_queue11.dbf";
set newname for datafile 51 to "/u1/TEST/testora/testdata/a_queue12.dbf";
set newname for datafile 52 to "/u1/TEST/testora/testdata/a_queue13.dbf";
set newname for datafile 53 to "/u1/TEST/testora/testdata/a_queue14.dbf";
set newname for datafile 54 to "/u1/TEST/testora/testdata/a_queue15.dbf";
set newname for datafile 55 to "/u1/TEST/testora/testdata/a_queue16.dbf";
set newname for datafile 56 to "/u1/TEST/testora/testdata/a_queue17.dbf";
set newname for datafile 57 to "/u1/TEST/testora/testdata/a_queue18.dbf";
set newname for datafile 58 to "/u1/TEST/testora/testdata/a_queue19.dbf";
set newname for datafile 59 to "/u1/TEST/testora/testdata/a_queue20.dbf";
set newname for datafile 60 to "/u1/TEST/testora/testdata/a_queue21.dbf";
set newname for datafile 61 to "/u1/TEST/testora/testdata/a_queue22.dbf";
set newname for datafile 62 to "/u1/TEST/testora/testdata/a_queue23.dbf";
set newname for datafile 63 to "/u1/TEST/testora/testdata/a_queue24.dbf";
set newname for datafile 64 to "/u1/TEST/testora/testdata/a_queue25.dbf";
set newname for datafile 65 to "/u1/TEST/testora/testdata/a_ref01.dbf";
set newname for datafile 66 to "/u1/TEST/testora/testdata/a_ref02.dbf";
set newname for datafile 67 to "/u1/TEST/testora/testdata/a_summ01.dbf";
set newname for datafile 68 to "/u1/TEST/testora/testdata/a_summ02.dbf";
set newname for datafile 69 to "/u1/TEST/testora/testdata/a_summ03.dbf";
set newname for datafile 70 to "/u1/TEST/testora/testdata/a_summ04.dbf";
set newname for datafile 71 to "/u1/TEST/testora/testdata/a_summ05.dbf";
set newname for datafile 72 to "/u1/TEST/testora/testdata/a_tools01.dbf";
set newname for datafile 73 to "/u1/TEST/testora/testdata/a_txn_data01.dbf";
set newname for datafile 74 to "/u1/TEST/testora/testdata/a_txn_data02.dbf";
set newname for datafile 75 to "/u1/TEST/testora/testdata/a_txn_data03.dbf";
set newname for datafile 76 to "/u1/TEST/testora/testdata/a_txn_data04.dbf";
set newname for datafile 77 to "/u1/TEST/testora/testdata/a_txn_data05.dbf";
set newname for datafile 78 to "/u1/TEST/testora/testdata/a_txn_data06.dbf";
set newname for datafile 79 to "/u1/TEST/testora/testdata/a_txn_data07.dbf";
set newname for datafile 80 to "/u1/TEST/testora/testdata/a_txn_data08.dbf";
set newname for datafile 81 to "/u1/TEST/testora/testdata/a_txn_data09.dbf";
set newname for datafile 82 to "/u1/TEST/testora/testdata/a_txn_data10.dbf";
set newname for datafile 83 to "/u1/TEST/testora/testdata/a_txn_data11.dbf";
set newname for datafile 84 to "/u1/TEST/testora/testdata/a_txn_data12.dbf";
set newname for datafile 85 to "/u1/TEST/testora/testdata/a_txn_data13.dbf";
set newname for datafile 86 to "/u1/TEST/testora/testdata/a_txn_data14.dbf";
set newname for datafile 87 to "/u1/TEST/testora/testdata/a_txn_data15.dbf";
set newname for datafile 88 to "/u1/TEST/testora/testdata/a_txn_data16.dbf";
set newname for datafile 89 to "/u1/TEST/testora/testdata/a_txn_data17.dbf";
set newname for datafile 90 to "/u1/TEST/testora/testdata/a_txn_data18.dbf";
set newname for datafile 91 to "/u1/TEST/testora/testdata/a_txn_data19.dbf";
set newname for datafile 92 to "/u1/TEST/testora/testdata/a_txn_data20.dbf";
set newname for datafile 93 to "/u1/TEST/testora/testdata/a_txn_data21.dbf";
set newname for datafile 94 to "/u1/TEST/testora/testdata/a_txn_data22.dbf";
set newname for datafile 95 to "/u1/TEST/testora/testdata/a_txn_data23.dbf";
set newname for datafile 96 to "/u1/TEST/testora/testdata/a_txn_data24.dbf";
set newname for datafile 97 to "/u1/TEST/testora/testdata/a_txn_data25.dbf";
set newname for datafile 98 to "/u1/TEST/testora/testdata/a_txn_data26.dbf";
set newname for datafile 99 to "/u1/TEST/testora/testdata/a_txn_data28.dbf";
set newname for datafile 100 to "/u1/TEST/testora/testdata/a_txn_data29.dbf";
set newname for datafile 101 to "/u1/TEST/testora/testdata/a_txn_data30.dbf";
set newname for datafile 102 to "/u1/TEST/testora/testdata/a_txn_data31.dbf";
set newname for datafile 103 to "/u1/TEST/testora/testdata/a_txn_data32.dbf";
set newname for datafile 104 to "/u1/TEST/testora/testdata/a_txn_data33.dbf";
set newname for datafile 105 to "/u1/TEST/testora/testdata/a_txn_data34.dbf";
set newname for datafile 106 to "/u1/TEST/testora/testdata/a_txn_data35.dbf";
set newname for datafile 107 to "/u1/TEST/testora/testdata/a_txn_data36.dbf";
set newname for datafile 108 to "/u1/TEST/testora/testdata/a_txn_data37.dbf";
set newname for datafile 109 to "/u1/TEST/testora/testdata/a_txn_data38.dbf";
set newname for datafile 110 to "/u1/TEST/testora/testdata/a_txn_data39.dbf";
set newname for datafile 111 to "/u1/TEST/testora/testdata/a_txn_data40.dbf";
set newname for datafile 112 to "/u1/TEST/testora/testdata/a_txn_data41.dbf";
set newname for datafile 113 to "/u1/TEST/testora/testdata/a_txn_data42.dbf";
set newname for datafile 114 to "/u1/TEST/testora/testdata/a_txn_data43.dbf";
set newname for datafile 115 to "/u1/TEST/testora/testdata/a_txn_data44.dbf";
set newname for datafile 116 to "/u1/TEST/testora/testdata/a_txn_data45.dbf";
set newname for datafile 117 to "/u1/TEST/testora/testdata/a_txn_data46.dbf";
set newname for datafile 118 to "/u1/TEST/testora/testdata/a_txn_data47.dbf";
set newname for datafile 119 to "/u1/TEST/testora/testdata/a_txn_data48.dbf";
set newname for datafile 120 to "/u1/TEST/testora/testdata/a_txn_ind01.dbf";
set newname for datafile 121 to "/u1/TEST/testora/testdata/a_txn_ind02.dbf";
set newname for datafile 122 to "/u1/TEST/testora/testdata/a_txn_ind03.dbf";
set newname for datafile 123 to "/u1/TEST/testora/testdata/a_txn_ind04.dbf";
set newname for datafile 124 to "/u1/TEST/testora/testdata/a_txn_ind05.dbf";
set newname for datafile 125 to "/u1/TEST/testora/testdata/a_txn_ind06.dbf";
set newname for datafile 126 to "/u1/TEST/testora/testdata/a_txn_ind07.dbf";
set newname for datafile 127 to "/u1/TEST/testora/testdata/a_txn_ind08.dbf";
set newname for datafile 128 to "/u1/TEST/testora/testdata/a_txn_ind09.dbf";
set newname for datafile 129 to "/u1/TEST/testora/testdata/a_txn_ind10.dbf";
set newname for datafile 130 to "/u1/TEST/testora/testdata/a_txn_ind11.dbf";
set newname for datafile 131 to "/u1/TEST/testora/testdata/a_txn_ind12.dbf";
set newname for datafile 132 to "/u1/TEST/testora/testdata/a_txn_ind13.dbf";
set newname for datafile 133 to "/u1/TEST/testora/testdata/a_txn_ind14.dbf";
set newname for datafile 134 to "/u1/TEST/testora/testdata/a_txn_ind15.dbf";
set newname for datafile 135 to "/u1/TEST/testora/testdata/a_txn_ind16.dbf";
set newname for datafile 136 to "/u1/TEST/testora/testdata/a_txn_ind17.dbf";
set newname for datafile 137 to "/u1/TEST/testora/testdata/a_txn_ind18.dbf";
set newname for datafile 138 to "/u1/TEST/testora/testdata/a_txn_ind19.dbf";
set newname for datafile 139 to "/u1/TEST/testora/testdata/a_txn_ind20.dbf";
set newname for datafile 140 to "/u1/TEST/testora/testdata/a_txn_ind21.dbf";
set newname for datafile 141 to "/u1/TEST/testora/testdata/a_txn_ind22.dbf";
set newname for datafile 142 to "/u1/TEST/testora/testdata/a_txn_ind23.dbf";
set newname for datafile 143 to "/u1/TEST/testora/testdata/a_txn_ind24.dbf";
set newname for datafile 144 to "/u1/TEST/testora/testdata/a_txn_ind25.dbf";
set newname for datafile 145 to "/u1/TEST/testora/testdata/a_txn_ind26.dbf";
set newname for datafile 146 to "/u1/TEST/testora/testdata/a_txn_ind27.dbf";
set newname for datafile 147 to "/u1/TEST/testora/testdata/a_txn_ind28.dbf";
set newname for datafile 148 to "/u1/TEST/testora/testdata/a_txn_ind29.dbf";
set newname for datafile 149 to "/u1/TEST/testora/testdata/a_txn_ind30.dbf";
set newname for datafile 150 to "/u1/TEST/testora/testdata/a_txn_ind31.dbf";
set newname for datafile 151 to "/u1/TEST/testora/testdata/a_txn_ind32.dbf";
set newname for datafile 152 to "/u1/TEST/testora/testdata/a_txn_ind33.dbf";
set newname for datafile 153 to "/u1/TEST/testora/testdata/a_txn_ind34.dbf";
set newname for datafile 154 to "/u1/TEST/testora/testdata/a_txn_ind35.dbf";
set newname for datafile 155 to "/u1/TEST/testora/testdata/a_txn_ind36.dbf";
set newname for datafile 156 to "/u1/TEST/testora/testdata/a_txn_ind37.dbf";
set newname for datafile 157 to "/u1/TEST/testora/testdata/a_txn_ind38.dbf";
set newname for datafile 158 to "/u1/TEST/testora/testdata/a_txn_ind39.dbf";
set newname for datafile 159 to "/u1/TEST/testora/testdata/a_txn_ind40.dbf";
set newname for datafile 160 to "/u1/TEST/testora/testdata/a_txn_ind41.dbf";
set newname for datafile 161 to "/u1/TEST/testora/testdata/a_txn_ind42.dbf";
set newname for datafile 162 to "/u1/TEST/testora/testdata/a_txn_ind43.dbf";
set newname for datafile 163 to "/u1/TEST/testora/testdata/a_txn_ind44.dbf";
set newname for datafile 164 to "/u1/TEST/testora/testdata/a_txn_ind45.dbf";
set newname for datafile 165 to "/u1/TEST/testora/testdata/a_txn_ind46.dbf";
set newname for datafile 166 to "/u1/TEST/testora/testdata/a_txn_ind47.dbf";
set newname for datafile 167 to "/u1/TEST/testora/testdata/a_txn_ind48.dbf";
set newname for datafile 168 to "/u1/TEST/testora/testdata/a_txn_ind49.dbf";
set newname for datafile 169 to "/u1/TEST/testora/testdata/a_txn_ind50.dbf";
set newname for datafile 170 to "/u1/TEST/testora/testdata/a_txn_ind51.dbf";
set newname for datafile 171 to "/u1/TEST/testora/testdata/a_txn_ind52.dbf";
set newname for datafile 172 to "/u1/TEST/testora/testdata/a_txn_ind53.dbf";
set newname for datafile 173 to "/u1/TEST/testora/testdata/a_txn_ind54.dbf";
set newname for datafile 174 to "/u1/TEST/testora/testdata/a_txn_ind55.dbf";
set newname for datafile 175 to "/u1/TEST/testora/testdata/ctxd01.dbf";
set newname for datafile 176 to "/u1/TEST/testora/testdata/odm.dbf";
set newname for datafile 177 to "/u1/TEST/testora/testdata/olap.dbf";
set newname for datafile 178 to "/u1/TEST/testora/testdata/owad01.dbf";
set newname for datafile 179 to "/u1/TEST/testora/testdata/portal01.dbf";
set newname for datafile 180 to "/u1/TEST/testora/testdata/statspack_01.dbf";
set newname for datafile 181 to "/u1/TEST/testora/testdata/tplcux_data_01.dbf";
set newname for datafile 182 to "/u1/TEST/testora/testdata/tplcux_idx_01.dbf";
set newname for datafile 183 to "/u1/TEST/testora/testdata/interim.dbf";
set newname for datafile 184 to "/u1/TEST/testora/testdata/system12.dbf";
set newname for datafile 185 to "/u1/TEST/testora/testdata/a_txn_data49.dbf";
set newname for datafile 186 to "/u1/TEST/testora/testdata/a_ref03.dbf";
set newname for datafile 187 to "/u1/TEST/testora/testdata/a_summ06.dbf";
set newname for datafile 188 to "/u1/TEST/testora/testdata/undo04.dbf";
restore database;
switch datafile all;
recover database;
}

power off failure (中间遇电路检修,短暂停电)

[[email protected] testora]$ du -sh testdata  
205G	testdata

[[email protected] testora]$ ll -rst testdata/  
total 214433112
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 14:54 olap.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 14:54 a_queue25.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 14:54 odm.dbf
 6144012 -rw-r-----. 1 testora dba  6291464192 Oct 17 14:55 undo04.dbf
  204812 -rw-r-----. 1 testora dba   209723392 Oct 17 14:55 interim.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 14:56 a_txn_ind32.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 14:56 a_int07.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 14:56 undo01.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 14:56 a_queue10.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 14:57 a_txn_ind41.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 14:57 a_txn_data41.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 14:57 a_txn_data01.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 14:57 a_queue11.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 14:58 a_txn_ind42.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 14:58 a_txn_data42.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 14:58 a_txn_data02.dbf
   40972 -rw-r-----. 1 testora dba    41951232 Oct 17 14:58 ctxd01.dbf
   10252 -rw-r-----. 1 testora dba    10493952 Oct 17 14:58 owad01.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 14:58 portal01.dbf
23068684 -rw-r-----. 1 testora dba 23622328320 Oct 17 15:01 a_txn_data49.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:01 a_queue12.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:02 a_txn_ind43.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:03 a_txn_data43.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:03 a_txn_data03.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:03 a_queue13.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:03 a_txn_ind44.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:04 a_txn_data44.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:04 a_txn_data04.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:04 a_queue14.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:05 a_txn_ind45.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:05 a_txn_data45.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:05 a_txn_data05.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:05 a_queue15.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:06 a_txn_ind46.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:06 a_txn_data46.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:06 a_txn_data06.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:06 a_queue16.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:07 a_txn_ind47.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:08 a_txn_data47.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:08 a_txn_data07.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:08 a_queue17.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:08 a_txn_ind48.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:09 a_txn_data48.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:09 a_txn_data08.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:09 a_queue18.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:10 a_txn_ind49.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:10 a_txn_ind01.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:10 a_txn_data09.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:10 a_queue19.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:11 a_txn_ind50.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:11 a_txn_ind02.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:11 a_txn_data10.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:11 a_queue20.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:12 a_txn_ind51.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:12 a_txn_ind03.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:12 a_txn_data11.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:12 a_queue21.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:13 a_txn_ind52.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:13 a_txn_ind04.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:13 a_txn_data12.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:13 a_queue22.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:14 a_txn_ind53.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:14 a_txn_ind05.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:14 a_txn_data13.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:14 a_queue23.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:15 a_txn_ind54.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:15 a_txn_ind06.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:15 a_txn_data14.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:15 a_queue09.dbf
  204812 -rw-r-----. 1 testora dba   209723392 Oct 17 15:16 a_media03.dbf
  204812 -rw-r-----. 1 testora dba   209723392 Oct 17 15:16 a_media04.dbf
 5242892 -rw-r-----. 1 testora dba  5368717312 Oct 17 15:16 system12.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:16 a_queue24.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:17 a_txn_ind55.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:17 a_txn_ind07.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:17 a_txn_data15.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:17 a_queue01.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:18 a_txn_ind33.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:18 a_int08.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:18 undo02.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:18 a_queue02.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:18 a_summ01.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:18 a_txn_ind34.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:19 undo03.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:19 a_queue03.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:19 a_txn_ind35.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:20 a_int01.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:20 a_txn_data35.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:20 a_queue04.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:20 a_txn_ind36.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:21 a_int02.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:21 a_txn_data36.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:21 a_queue06.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:21 a_txn_ind38.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:22 a_int04.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:22 a_txn_data38.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:22 a_queue05.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:22 a_txn_ind37.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:23 a_int03.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:23 a_txn_data37.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:23 a_queue07.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:24 a_txn_ind39.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:24 a_int05.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:24 a_txn_data39.dbf
  102412 -rw-r-----. 1 testora dba   104865792 Oct 17 15:24 a_queue08.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:25 a_txn_ind40.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:25 a_int06.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:25 a_txn_data40.dbf
  204812 -rw-r-----. 1 testora dba   209723392 Oct 17 15:25 a_media05.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:26 a_txn_ind26.dbf
 1843212 -rw-r-----. 1 testora dba  1887444992 Oct 17 15:26 a_txn_ind19.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:26 a_txn_data29.dbf
  204812 -rw-r-----. 1 testora dba   209723392 Oct 17 15:26 a_media06.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:27 a_txn_ind27.dbf
 1843212 -rw-r-----. 1 testora dba  1887444992 Oct 17 15:27 a_txn_ind20.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:27 a_txn_data30.dbf
  204812 -rw-r-----. 1 testora dba   209723392 Oct 17 15:27 a_media07.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:28 a_txn_ind28.dbf
 1843212 -rw-r-----. 1 testora dba  1887444992 Oct 17 15:28 a_txn_ind21.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:28 a_txn_data31.dbf
  204812 -rw-r-----. 1 testora dba   209723392 Oct 17 15:28 a_media08.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:29 a_txn_ind29.dbf
 1843212 -rw-r-----. 1 testora dba  1887444992 Oct 17 15:29 a_txn_ind22.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:29 a_txn_data32.dbf
  204812 -rw-r-----. 1 testora dba   209723392 Oct 17 15:29 a_media09.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:30 a_txn_ind30.dbf
 1843212 -rw-r-----. 1 testora dba  1887444992 Oct 17 15:30 a_txn_ind23.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:30 a_txn_data33.dbf
  204812 -rw-r-----. 1 testora dba   209723392 Oct 17 15:30 a_media10.dbf
 1536012 -rw-r-----. 1 testora dba  1572872192 Oct 17 15:31 a_txn_ind31.dbf
 1843212 -rw-r-----. 1 testora dba  1887444992 Oct 17 15:31 a_txn_ind24.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:31 a_txn_data34.dbf
  307212 -rw-r-----. 1 testora dba   314580992 Oct 17 15:32 a_summ02.dbf
 1024012 -rw-r-----. 1 testora dba  1048584192 Oct 17 15:32 system02.dbf
 2048012 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:32 a_txn_ind09.dbf
 2097164 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:32 a_txn_data17.dbf
   18804 -rw-r-----. 1 testora dba    19251200 Oct 17 15:33 control01.ctl
   18804 -rw-r-----. 1 testora dba    19251200 Oct 17 15:33 control02.ctl
  233476 -rw-r-----. 1 testora dba  2097160192 Oct 17 15:33 a_txn_ind08.dbf
  233476 -rw-r-----. 1 testora dba  1048584192 Oct 17 15:33 system01.dbf
  235524 -rw-r-----. 1 testora dba   314580992 Oct 17 15:33 a_archive05.dbf
  234500 -rw-r-----. 1 testora dba  2147491840 Oct 17 15:33 a_txn_data16.dbf

[[email protected] testora]$ sqlplus  /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 17 17:05:35 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 5.1310E+10 bytes
Fixed Size		    2240344 bytes
Variable Size		 1.0066E+10 bytes
Database Buffers	 4.1205E+10 bytes
Redo Buffers		   36098048 bytes
Database mounted.

continue recovering

RMAN> run {
set newname for datafile 1 to "/u1/TEST/testora/testdata/system01.dbf";
set newname for datafile 2 to "/u1/TEST/testora/testdata/system02.dbf";
set newname for datafile 3 to "/u1/TEST/testora/testdata/system03.dbf";
set newname for datafile 4 to "/u1/TEST/testora/testdata/system04.dbf";
set newname for datafile 5 to "/u1/TEST/testora/testdata/system05.dbf";
set newname for datafile 6 to "/u1/TEST/testora/testdata/system06.dbf";
set newname for datafile 7 to "/u1/TEST/testora/testdata/system07.dbf";
set newname for datafile 8 to "/u1/TEST/testora/testdata/system08.dbf";
set newname for datafile 9 to "/u1/TEST/testora/testdata/system09.dbf";
set newname for datafile 10 to "/u1/TEST/testora/testdata/system10.dbf";
set newname for datafile 11 to "/u1/TEST/testora/testdata/system11.dbf";
set newname for datafile 12 to "/u1/TEST/testora/testdata/sysaux01.dbf";
set newname for datafile 13 to "/u1/TEST/testora/testdata/undo01.dbf";
set newname for datafile 14 to "/u1/TEST/testora/testdata/undo02.dbf";
set newname for datafile 15 to "/u1/TEST/testora/testdata/undo03.dbf";
set newname for datafile 16 to "/u1/TEST/testora/testdata/a_archive01.dbf";
set newname for datafile 17 to "/u1/TEST/testora/testdata/a_archive02.dbf";
set newname for datafile 18 to "/u1/TEST/testora/testdata/a_archive03.dbf";
set newname for datafile 19 to "/u1/TEST/testora/testdata/a_archive04.dbf";
set newname for datafile 20 to "/u1/TEST/testora/testdata/a_archive05.dbf";
set newname for datafile 21 to "/u1/TEST/testora/testdata/a_int01.dbf";
set newname for datafile 22 to "/u1/TEST/testora/testdata/a_int02.dbf";
set newname for datafile 23 to "/u1/TEST/testora/testdata/a_int03.dbf";
set newname for datafile 24 to "/u1/TEST/testora/testdata/a_int04.dbf";
set newname for datafile 25 to "/u1/TEST/testora/testdata/a_int05.dbf";
set newname for datafile 26 to "/u1/TEST/testora/testdata/a_int06.dbf";
set newname for datafile 27 to "/u1/TEST/testora/testdata/a_int07.dbf";
set newname for datafile 28 to "/u1/TEST/testora/testdata/a_int08.dbf";
set newname for datafile 29 to "/u1/TEST/testora/testdata/a_media01.dbf";
set newname for datafile 30 to "/u1/TEST/testora/testdata/a_media02.dbf";
set newname for datafile 31 to "/u1/TEST/testora/testdata/a_media03.dbf";
set newname for datafile 32 to "/u1/TEST/testora/testdata/a_media04.dbf";
set newname for datafile 33 to "/u1/TEST/testora/testdata/a_media05.dbf";
set newname for datafile 34 to "/u1/TEST/testora/testdata/a_media06.dbf";
set newname for datafile 35 to "/u1/TEST/testora/testdata/a_media07.dbf";
set newname for datafile 36 to "/u1/TEST/testora/testdata/a_media08.dbf";
set newname for datafile 37 to "/u1/TEST/testora/testdata/a_media09.dbf";
set newname for datafile 38 to "/u1/TEST/testora/testdata/a_media10.dbf";
set newname for datafile 39 to "/u1/TEST/testora/testdata/a_nolog01.dbf";
set newname for datafile 40 to "/u1/TEST/testora/testdata/a_queue01.dbf";
set newname for datafile 41 to "/u1/TEST/testora/testdata/a_queue02.dbf";
set newname for datafile 42 to "/u1/TEST/testora/testdata/a_queue03.dbf";
set newname for datafile 43 to "/u1/TEST/testora/testdata/a_queue04.dbf";
set newname for datafile 44 to "/u1/TEST/testora/testdata/a_queue05.dbf";
set newname for datafile 45 to "/u1/TEST/testora/testdata/a_queue06.dbf";
set newname for datafile 46 to "/u1/TEST/testora/testdata/a_queue07.dbf";
set newname for datafile 47 to "/u1/TEST/testora/testdata/a_queue08.dbf";
set newname for datafile 48 to "/u1/TEST/testora/testdata/a_queue09.dbf";
set newname for datafile 49 to "/u1/TEST/testora/testdata/a_queue10.dbf";
set newname for datafile 50 to "/u1/TEST/testora/testdata/a_queue11.dbf";
set newname for datafile 51 to "/u1/TEST/testora/testdata/a_queue12.dbf";
set newname for datafile 52 to "/u1/TEST/testora/testdata/a_queue13.dbf";
set newname for datafile 53 to "/u1/TEST/testora/testdata/a_queue14.dbf";
set newname for datafile 54 to "/u1/TEST/testora/testdata/a_queue15.dbf";
set newname for datafile 55 to "/u1/TEST/testora/testdata/a_queue16.dbf";
set newname for datafile 56 to "/u1/TEST/testora/testdata/a_queue17.dbf";
set newname for datafile 57 to "/u1/TEST/testora/testdata/a_queue18.dbf";
set newname for datafile 58 to "/u1/TEST/testora/testdata/a_queue19.dbf";
set newname for datafile 59 to "/u1/TEST/testora/testdata/a_queue20.dbf";
set newname for datafile 60 to "/u1/TEST/testora/testdata/a_queue21.dbf";
set newname for datafile 61 to "/u1/TEST/testora/testdata/a_queue22.dbf";
set newname for datafile 62 to "/u1/TEST/testora/testdata/a_queue23.dbf";
set newname for datafile 63 to "/u1/TEST/testora/testdata/a_queue24.dbf";
set newname for datafile 64 to "/u1/TEST/testora/testdata/a_queue25.dbf";
set newname for datafile 65 to "/u1/TEST/testora/testdata/a_ref01.dbf";
set newname for datafile 66 to "/u1/TEST/testora/testdata/a_ref02.dbf";
set newname for datafile 67 to "/u1/TEST/testora/testdata/a_summ01.dbf";
set newname for datafile 68 to "/u1/TEST/testora/testdata/a_summ02.dbf";
set newname for datafile 69 to "/u1/TEST/testora/testdata/a_summ03.dbf";
set newname for datafile 70 to "/u1/TEST/testora/testdata/a_summ04.dbf";
set newname for datafile 71 to "/u1/TEST/testora/testdata/a_summ05.dbf";
set newname for datafile 72 to "/u1/TEST/testora/testdata/a_tools01.dbf";
set newname for datafile 73 to "/u1/TEST/testora/testdata/a_txn_data01.dbf";
set newname for datafile 74 to "/u1/TEST/testora/testdata/a_txn_data02.dbf";
set newname for datafile 75 to "/u1/TEST/testora/testdata/a_txn_data03.dbf";
set newname for datafile 76 to "/u1/TEST/testora/testdata/a_txn_data04.dbf";
set newname for datafile 77 to "/u1/TEST/testora/testdata/a_txn_data05.dbf";
set newname for datafile 78 to "/u1/TEST/testora/testdata/a_txn_data06.dbf";
set newname for datafile 79 to "/u1/TEST/testora/testdata/a_txn_data07.dbf";
set newname for datafile 80 to "/u1/TEST/testora/testdata/a_txn_data08.dbf";
set newname for datafile 81 to "/u1/TEST/testora/testdata/a_txn_data09.dbf";
set newname for datafile 82 to "/u1/TEST/testora/testdata/a_txn_data10.dbf";
set newname for datafile 83 to "/u1/TEST/testora/testdata/a_txn_data11.dbf";
set newname for datafile 84 to "/u1/TEST/testora/testdata/a_txn_data12.dbf";
set newname for datafile 85 to "/u1/TEST/testora/testdata/a_txn_data13.dbf";
set newname for datafile 86 to "/u1/TEST/testora/testdata/a_txn_data14.dbf";
set newname for datafile 87 to "/u1/TEST/testora/testdata/a_txn_data15.dbf";
set newname for datafile 88 to "/u1/TEST/testora/testdata/a_txn_data16.dbf";
set newname for datafile 89 to "/u1/TEST/testora/testdata/a_txn_data17.dbf";
set newname for datafile 90 to "/u1/TEST/testora/testdata/a_txn_data18.dbf";
set newname for datafile 91 to "/u1/TEST/testora/testdata/a_txn_data19.dbf";
set newname for datafile 92 to "/u1/TEST/testora/testdata/a_txn_data20.dbf";
set newname for datafile 93 to "/u1/TEST/testora/testdata/a_txn_data21.dbf";
set newname for datafile 94 to "/u1/TEST/testora/testdata/a_txn_data22.dbf";
set newname for datafile 95 to "/u1/TEST/testora/testdata/a_txn_data23.dbf";
set newname for datafile 96 to "/u1/TEST/testora/testdata/a_txn_data24.dbf";
set newname for datafile 97 to "/u1/TEST/testora/testdata/a_txn_data25.dbf";
set newname for datafile 98 to "/u1/TEST/testora/testdata/a_txn_data26.dbf";
set newname for datafile 99 to "/u1/TEST/testora/testdata/a_txn_data28.dbf";
set newname for datafile 100 to "/u1/TEST/testora/testdata/a_txn_data29.dbf";
set newname for datafile 101 to "/u1/TEST/testora/testdata/a_txn_data30.dbf";
set newname for datafile 102 to "/u1/TEST/testora/testdata/a_txn_data31.dbf";
set newname for datafile 103 to "/u1/TEST/testora/testdata/a_txn_data32.dbf";
set newname for datafile 104 to "/u1/TEST/testora/testdata/a_txn_data33.dbf";
set newname for datafile 105 to "/u1/TEST/testora/testdata/a_txn_data34.dbf";
set newname for datafile 106 to "/u1/TEST/testora/testdata/a_txn_data35.dbf";
set newname for datafile 107 to "/u1/TEST/testora/testdata/a_txn_data36.dbf";
set newname for datafile 108 to "/u1/TEST/testora/testdata/a_txn_data37.dbf";
set newname for datafile 109 to "/u1/TEST/testora/testdata/a_txn_data38.dbf";
set newname for datafile 110 to "/u1/TEST/testora/testdata/a_txn_data39.dbf";
set newname for datafile 111 to "/u1/TEST/testora/testdata/a_txn_data40.dbf";
set newname for datafile 112 to "/u1/TEST/testora/testdata/a_txn_data41.dbf";
set newname for datafile 113 to "/u1/TEST/testora/testdata/a_txn_data42.dbf";
set newname for datafile 114 to "/u1/TEST/testora/testdata/a_txn_data43.dbf";
set newname for datafile 115 to "/u1/TEST/testora/testdata/a_txn_data44.dbf";
set newname for datafile 116 to "/u1/TEST/testora/testdata/a_txn_data45.dbf";
set newname for datafile 117 to "/u1/TEST/testora/testdata/a_txn_data46.dbf";
set newname for datafile 118 to "/u1/TEST/testora/testdata/a_txn_data47.dbf";
set newname for datafile 119 to "/u1/TEST/testora/testdata/a_txn_data48.dbf";
set newname for datafile 120 to "/u1/TEST/testora/testdata/a_txn_ind01.dbf";
set newname for datafile 121 to "/u1/TEST/testora/testdata/a_txn_ind02.dbf";
set newname for datafile 122 to "/u1/TEST/testora/testdata/a_txn_ind03.dbf";
set newname for datafile 123 to "/u1/TEST/testora/testdata/a_txn_ind04.dbf";
set newname for datafile 124 to "/u1/TEST/testora/testdata/a_txn_ind05.dbf";
set newname for datafile 125 to "/u1/TEST/testora/testdata/a_txn_ind06.dbf";
set newname for datafile 126 to "/u1/TEST/testora/testdata/a_txn_ind07.dbf";
set newname for datafile 127 to "/u1/TEST/testora/testdata/a_txn_ind08.dbf";
set newname for datafile 128 to "/u1/TEST/testora/testdata/a_txn_ind09.dbf";
set newname for datafile 129 to "/u1/TEST/testora/testdata/a_txn_ind10.dbf";
set newname for datafile 130 to "/u1/TEST/testora/testdata/a_txn_ind11.dbf";
set newname for datafile 131 to "/u1/TEST/testora/testdata/a_txn_ind12.dbf";
set newname for datafile 132 to "/u1/TEST/testora/testdata/a_txn_ind13.dbf";
set newname for datafile 133 to "/u1/TEST/testora/testdata/a_txn_ind14.dbf";
set newname for datafile 134 to "/u1/TEST/testora/testdata/a_txn_ind15.dbf";
set newname for datafile 135 to "/u1/TEST/testora/testdata/a_txn_ind16.dbf";
set newname for datafile 136 to "/u1/TEST/testora/testdata/a_txn_ind17.dbf";
set newname for datafile 137 to "/u1/TEST/testora/testdata/a_txn_ind18.dbf";
set newname for datafile 138 to "/u1/TEST/testora/testdata/a_txn_ind19.dbf";
set newname for datafile 139 to "/u1/TEST/testora/testdata/a_txn_ind20.dbf";
set newname for datafile 140 to "/u1/TEST/testora/testdata/a_txn_ind21.dbf";
set newname for datafile 141 to "/u1/TEST/testora/testdata/a_txn_ind22.dbf";
set newname for datafile 142 to "/u1/TEST/testora/testdata/a_txn_ind23.dbf";
set newname for datafile 143 to "/u1/TEST/testora/testdata/a_txn_ind24.dbf";
set newname for datafile 144 to "/u1/TEST/testora/testdata/a_txn_ind25.dbf";
set newname for datafile 145 to "/u1/TEST/testora/testdata/a_txn_ind26.dbf";
set newname for datafile 146 to "/u1/TEST/testora/testdata/a_txn_ind27.dbf";
set newname for datafile 147 to "/u1/TEST/testora/testdata/a_txn_ind28.dbf";
set newname for datafile 148 to "/u1/TEST/testora/testdata/a_txn_ind29.dbf";
set newname for datafile 149 to "/u1/TEST/testora/testdata/a_txn_ind30.dbf";
set newname for datafile 150 to "/u1/TEST/testora/testdata/a_txn_ind31.dbf";
set newname for datafile 151 to "/u1/TEST/testora/testdata/a_txn_ind32.dbf";
set newname for datafile 152 to "/u1/TEST/testora/testdata/a_txn_ind33.dbf";
set newname for datafile 153 to "/u1/TEST/testora/testdata/a_txn_ind34.dbf";
set newname for datafile 154 to "/u1/TEST/testora/testdata/a_txn_ind35.dbf";
set newname for datafile 155 to "/u1/TEST/testora/testdata/a_txn_ind36.dbf";
set newname for datafile 156 to "/u1/TEST/testora/testdata/a_txn_ind37.dbf";
set newname for datafile 157 to "/u1/TEST/testora/testdata/a_txn_ind38.dbf";
set newname for datafile 158 to "/u1/TEST/testora/testdata/a_txn_ind39.dbf";
set newname for datafile 159 to "/u1/TEST/testora/testdata/a_txn_ind40.dbf";
set newname for datafile 160 to "/u1/TEST/testora/testdata/a_txn_ind41.dbf";
set newname for datafile 161 to "/u1/TEST/testora/testdata/a_txn_ind42.dbf";
set newname for datafile 162 to "/u1/TEST/testora/testdata/a_txn_ind43.dbf";
set newname for datafile 163 to "/u1/TEST/testora/testdata/a_txn_ind44.dbf";
set newname for datafile 164 to "/u1/TEST/testora/testdata/a_txn_ind45.dbf";
set newname for datafile 165 to "/u1/TEST/testora/testdata/a_txn_ind46.dbf";
set newname for datafile 166 to "/u1/TEST/testora/testdata/a_txn_ind47.dbf";
set newname for datafile 167 to "/u1/TEST/testora/testdata/a_txn_ind48.dbf";
set newname for datafile 168 to "/u1/TEST/testora/testdata/a_txn_ind49.dbf";
set newname for datafile 169 to "/u1/TEST/testora/testdata/a_txn_ind50.dbf";
set newname for datafile 170 to "/u1/TEST/testora/testdata/a_txn_ind51.dbf";
set newname for datafile 171 to "/u1/TEST/testora/testdata/a_txn_ind52.dbf";
set newname for datafile 172 to "/u1/TEST/testora/testdata/a_txn_ind53.dbf";
set newname for datafile 173 to "/u1/TEST/testora/testdata/a_txn_ind54.dbf";
set newname for datafile 174 to "/u1/TEST/testora/testdata/a_txn_ind55.dbf";
set newname for datafile 175 to "/u1/TEST/testora/testdata/ctxd01.dbf";
set newname for datafile 176 to "/u1/TEST/testora/testdata/odm.dbf";
set newname for datafile 177 to "/u1/TEST/testora/testdata/olap.dbf";
set newname for datafile 178 to "/u1/TEST/testora/testdata/owad01.dbf";
set newname for datafile 179 to "/u1/TEST/testora/testdata/portal01.dbf";
set newname for datafile 180 to "/u1/TEST/testora/testdata/statspack_01.dbf";
set newname for datafile 181 to "/u1/TEST/testora/testdata/tplcux_data_01.dbf";
set newname for datafile 182 to "/u1/TEST/testora/testdata/tplcux_idx_01.dbf";
set newname for datafile 183 to "/u1/TEST/testora/testdata/interim.dbf";
set newname for datafile 184 to "/u1/TEST/testora/testdata/system12.dbf";
set newname for datafile 185 to "/u1/TEST/testora/testdata/a_txn_data49.dbf";
set newname for datafile 186 to "/u1/TEST/testora/testdata/a_ref03.dbf";
set newname for datafile 187 to "/u1/TEST/testora/testdata/a_summ06.dbf";
set newname for datafile 188 to "/u1/TEST/testora/testdata/undo04.dbf";
restore database;
switch datafile all;
recover database;
}
Starting restore at 17-OCT-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=629 device type=DISK

datafile 2 is already restored to file /u1/TEST/testora/testdata/system02.dbf
... ...
datafile 188 is already restored to file /u1/TEST/testora/testdata/undo04.dbf
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 00001 to /u1/TEST/testora/testdata/system01.dbf
channel ORA_DISK_1: restoring datafile 00020 to /u1/TEST/testora/testdata/a_archive05.dbf
channel ORA_DISK_1: restoring datafile 00088 to /u1/TEST/testora/testdata/a_txn_data16.dbf
channel ORA_DISK_1: restoring datafile 00127 to /u1/TEST/testora/testdata/a_txn_ind08.dbf
channel ORA_DISK_1: reading from backup piece /data/backup/db_bak_lev0_829058166_1_318
... ...
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 17-OCT-13

datafile 1 switched to datafile copy
input datafile copy RECID=190 STAMP=829070406 file name=/u1/TEST/testora/testdata/system01.dbf
... ...

datafile 188 switched to datafile copy
input datafile copy RECID=377 STAMP=829070448 file name=/u1/TEST/testora/testdata/undo04.dbf

Starting recover at 17-OCT-13
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=88
channel ORA_DISK_1: reading from backup piece /data/backup/archive_log_829058535_1_334
channel ORA_DISK_1: piece handle=/data/backup/archive_log_829058535_1_334 tag=ARC_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=1094
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=1095
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=89
channel ORA_DISK_1: reading from backup piece /data/backup/archive_log_829058537_1_335
channel ORA_DISK_1: piece handle=/data/backup/archive_log_829058537_1_335 tag=ARC_BAK
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u1/TEST/testora/archive/1_1094_828401849.dbf thread=1 sequence=1094
archived log file name=/u1/TEST/testora/archive/2_88_828401849.dbf thread=2 sequence=88
archived log file name=/u1/TEST/testora/archive/1_1095_828401849.dbf thread=1 sequence=1095
archived log file name=/u1/TEST/testora/archive/2_89_828401849.dbf thread=2 sequence=89
unable to find archived log
archived log thread=1 sequence=1096
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/17/2013 17:21:31
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 1096 and starting SCN of 101987199

list backup of archivelog

RMAN> list backup of archivelog all;


List of Backup Sets
===================


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
330     156.45M    DISK        00:00:01     17-OCT-13      
        BP Key: 390   Status: AVAILABLE  Compressed: NO  Tag: ARC_BAK
        Piece Name: /data/backup/archive_log_829058535_1_334

  List of Archived Logs in backup set 330
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1092    101805928  17-OCT-13 101861298  17-OCT-13
  1    1093    101861298  17-OCT-13 101914951  17-OCT-13
  2    87      101311879  17-OCT-13 101861641  17-OCT-13
  2    88      101861641  17-OCT-13 101987191  17-OCT-13

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
331     441.13M    DISK        00:00:02     17-OCT-13      
        BP Key: 391   Status: AVAILABLE  Compressed: NO  Tag: ARC_BAK
        Piece Name: /data/backup/archive_log_829058535_1_333

  List of Archived Logs in backup set 331
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1091    101311755  17-OCT-13 101805928  17-OCT-13

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
332     27.28M     DISK        00:00:00     17-OCT-13      
        BP Key: 392   Status: AVAILABLE  Compressed: NO  Tag: ARC_BAK
        Piece Name: /data/backup/archive_log_829058537_1_335

  List of Archived Logs in backup set 332
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1094    101914951  17-OCT-13 101987096  17-OCT-13
  1    1095    101987096  17-OCT-13 101987199  17-OCT-13
  2    89      101987191  17-OCT-13 101987202  17-OCT-13

datafile size

[[email protected] testora]$ du -sh testdata
271G	testdata

recreate controlfile

[[email protected] ~]$ export ORACLE_SID=PROD
[[email protected] ~]$ sqlplus  /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 17 11:09:21 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> alter database backup controlfile to trace;

Database altered.

SQL> show parameter user_dump

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest			     string	 /u1/11gR2_BASE/admin/prod/diag
                         /rdbms/prod/PROD/trace
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[[email protected] ~]$ ll -rst /u1/11gR2_BASE?admin/prod/diag/rdbms/prod/PROD/trace/ | tail
 3268 -rw-r--r--. 1 testora dba  3346203 Oct 17 10:51 PROD_m000_7617.trc
   12 -rw-r--r--. 1 testora dba     8760 Oct 17 11:01 PROD_dbw0_7573.trm
   72 -rw-r--r--. 1 testora dba    70015 Oct 17 11:01 PROD_dbw0_7573.trc
   84 -rw-r--r--. 1 testora dba    83406 Oct 17 11:01 PROD_ora_7609.trm
  476 -rw-r--r--. 1 testora dba   486962 Oct 17 11:01 PROD_ora_7609.trc
  652 -rw-r--r--. 1 testora dba   663569 Oct 17 11:01 PROD_m000_7779.trm
 4352 -rw-r--r--. 1 testora dba  4454728 Oct 17 11:01 PROD_m000_7779.trc
    4 -rw-r--r--. 1 testora dba      268 Oct 17 11:09 PROD_ora_7826.trm
   28 -rw-r--r--. 1 testora dba    26359 Oct 17 11:09 PROD_ora_7826.trc
  112 -rw-r--r--. 1 testora dba   107376 Oct 17 11:09 alert_PROD.log
  
[[email protected] ~]$ pwd
/home/testora
[[email protected] ~]$ cp /u1/11gR2_BASE/admin/prod/diag/rdbms/prod/PROD/trace/PROD_ora_7826.trc .
[[email protected] ~]$ ls -l
total 11952
drwxr-xr-x. 10 testora dba     4096 Jun 21 17:12 itsection
drwxr-xr-x.  3 testora dba     4096 May 31 00:43 oradiag_testora
-rw-r--r--.  1 testora dba    26359 Oct 17 11:10 PROD_ora_7826.trc
-rw-r--r--.  1 testora dba     1139 Jul 15 16:30 rdccs_m000_15683.out
-rw-r--r--.  1 testora dba 12196573 Jul 15 16:28 rdccs_m000_15683.trc
[[email protected] ~]$ cp PROD_ora_7826.trc controlfile.sql

edit controlfile

[[email protected] ~]$ cat controlfile.sql 
CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXDATAFILES 512
    MAXINSTANCES 63
    MAXLOGHISTORY 2920
LOGFILE
  GROUP 1 (
    '/u1/TEST/testora/testdata/redo1_1.dbf',
    '/u1/TEST/testora/testdata/redo1_2.dbf'
  ) SIZE 500M BLOCKSIZE 512,
  GROUP 2 (
    '/u1/TEST/testora/testdata/redo2_1.dbf',
    '/u1/TEST/testora/testdata/redo2_2.dbf'
  ) SIZE 500M BLOCKSIZE 512,
  GROUP 3 (
    '/u1/TEST/testora/testdata/redo3_1.dbf',
    '/u1/TEST/testora/testdata/redo3_2.dbf'
  ) SIZE 500M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
    '/u1/TEST/testora/testdata/system01.dbf',
    '/u1/TEST/testora/testdata/system02.dbf',
    '/u1/TEST/testora/testdata/system03.dbf',
    '/u1/TEST/testora/testdata/system04.dbf',
    '/u1/TEST/testora/testdata/system05.dbf',
    '/u1/TEST/testora/testdata/system06.dbf',
    '/u1/TEST/testora/testdata/system07.dbf',
    '/u1/TEST/testora/testdata/system08.dbf',
    '/u1/TEST/testora/testdata/system09.dbf',
    '/u1/TEST/testora/testdata/system10.dbf',
    '/u1/TEST/testora/testdata/system11.dbf',
    '/u1/TEST/testora/testdata/sysaux01.dbf',
    '/u1/TEST/testora/testdata/undo01.dbf',
    '/u1/TEST/testora/testdata/undo02.dbf',
    '/u1/TEST/testora/testdata/undo03.dbf',
    '/u1/TEST/testora/testdata/a_archive01.dbf',
    '/u1/TEST/testora/testdata/a_archive02.dbf',
    '/u1/TEST/testora/testdata/a_archive03.dbf',
    '/u1/TEST/testora/testdata/a_archive04.dbf',
    '/u1/TEST/testora/testdata/a_archive05.dbf',
    '/u1/TEST/testora/testdata/a_int01.dbf',
    '/u1/TEST/testora/testdata/a_int02.dbf',
    '/u1/TEST/testora/testdata/a_int03.dbf',
    '/u1/TEST/testora/testdata/a_int04.dbf',
    '/u1/TEST/testora/testdata/a_int05.dbf',
    '/u1/TEST/testora/testdata/a_int06.dbf',
    '/u1/TEST/testora/testdata/a_int07.dbf',
    '/u1/TEST/testora/testdata/a_int08.dbf',
    '/u1/TEST/testora/testdata/a_media01.dbf',
    '/u1/TEST/testora/testdata/a_media02.dbf',
    '/u1/TEST/testora/testdata/a_media03.dbf',
    '/u1/TEST/testora/testdata/a_media04.dbf',
    '/u1/TEST/testora/testdata/a_media05.dbf',
    '/u1/TEST/testora/testdata/a_media06.dbf',
    '/u1/TEST/testora/testdata/a_media07.dbf',
    '/u1/TEST/testora/testdata/a_media08.dbf',
    '/u1/TEST/testora/testdata/a_media09.dbf',
    '/u1/TEST/testora/testdata/a_media10.dbf',
    '/u1/TEST/testora/testdata/a_nolog01.dbf',
    '/u1/TEST/testora/testdata/a_queue01.dbf',
    '/u1/TEST/testora/testdata/a_queue02.dbf',
    '/u1/TEST/testora/testdata/a_queue03.dbf',
    '/u1/TEST/testora/testdata/a_queue04.dbf',
    '/u1/TEST/testora/testdata/a_queue05.dbf',
    '/u1/TEST/testora/testdata/a_queue06.dbf',
    '/u1/TEST/testora/testdata/a_queue07.dbf',
    '/u1/TEST/testora/testdata/a_queue08.dbf',
    '/u1/TEST/testora/testdata/a_queue09.dbf',
    '/u1/TEST/testora/testdata/a_queue10.dbf',
    '/u1/TEST/testora/testdata/a_queue11.dbf',
    '/u1/TEST/testora/testdata/a_queue12.dbf',
    '/u1/TEST/testora/testdata/a_queue13.dbf',
    '/u1/TEST/testora/testdata/a_queue14.dbf',
    '/u1/TEST/testora/testdata/a_queue15.dbf',
    '/u1/TEST/testora/testdata/a_queue16.dbf',
    '/u1/TEST/testora/testdata/a_queue17.dbf',
    '/u1/TEST/testora/testdata/a_queue18.dbf',
    '/u1/TEST/testora/testdata/a_queue19.dbf',
    '/u1/TEST/testora/testdata/a_queue20.dbf',
    '/u1/TEST/testora/testdata/a_queue21.dbf',
    '/u1/TEST/testora/testdata/a_queue22.dbf',
    '/u1/TEST/testora/testdata/a_queue23.dbf',
    '/u1/TEST/testora/testdata/a_queue24.dbf',
    '/u1/TEST/testora/testdata/a_queue25.dbf',
    '/u1/TEST/testora/testdata/a_ref01.dbf',
    '/u1/TEST/testora/testdata/a_ref02.dbf',
    '/u1/TEST/testora/testdata/a_summ01.dbf',
    '/u1/TEST/testora/testdata/a_summ02.dbf',
    '/u1/TEST/testora/testdata/a_summ03.dbf',
    '/u1/TEST/testora/testdata/a_summ04.dbf',
    '/u1/TEST/testora/testdata/a_summ05.dbf',
    '/u1/TEST/testora/testdata/a_tools01.dbf',
    '/u1/TEST/testora/testdata/a_txn_data01.dbf',
    '/u1/TEST/testora/testdata/a_txn_data02.dbf',
    '/u1/TEST/testora/testdata/a_txn_data03.dbf',
    '/u1/TEST/testora/testdata/a_txn_data04.dbf',
    '/u1/TEST/testora/testdata/a_txn_data05.dbf',
    '/u1/TEST/testora/testdata/a_txn_data06.dbf',
    '/u1/TEST/testora/testdata/a_txn_data07.dbf',
    '/u1/TEST/testora/testdata/a_txn_data08.dbf',
    '/u1/TEST/testora/testdata/a_txn_data09.dbf',
    '/u1/TEST/testora/testdata/a_txn_data10.dbf',
    '/u1/TEST/testora/testdata/a_txn_data11.dbf',
    '/u1/TEST/testora/testdata/a_txn_data12.dbf',
    '/u1/TEST/testora/testdata/a_txn_data13.dbf',
    '/u1/TEST/testora/testdata/a_txn_data14.dbf',
    '/u1/TEST/testora/testdata/a_txn_data15.dbf',
    '/u1/TEST/testora/testdata/a_txn_data16.dbf',
    '/u1/TEST/testora/testdata/a_txn_data17.dbf',
    '/u1/TEST/testora/testdata/a_txn_data18.dbf',
    '/u1/TEST/testora/testdata/a_txn_data19.dbf',
    '/u1/TEST/testora/testdata/a_txn_data20.dbf',
    '/u1/TEST/testora/testdata/a_txn_data21.dbf',
    '/u1/TEST/testora/testdata/a_txn_data22.dbf',
    '/u1/TEST/testora/testdata/a_txn_data23.dbf',
    '/u1/TEST/testora/testdata/a_txn_data24.dbf',
    '/u1/TEST/testora/testdata/a_txn_data25.dbf',
    '/u1/TEST/testora/testdata/a_txn_data26.dbf',
    '/u1/TEST/testora/testdata/a_txn_data28.dbf',
    '/u1/TEST/testora/testdata/a_txn_data29.dbf',
    '/u1/TEST/testora/testdata/a_txn_data30.dbf',
    '/u1/TEST/testora/testdata/a_txn_data31.dbf',
    '/u1/TEST/testora/testdata/a_txn_data32.dbf',
    '/u1/TEST/testora/testdata/a_txn_data33.dbf',
    '/u1/TEST/testora/testdata/a_txn_data34.dbf',
    '/u1/TEST/testora/testdata/a_txn_data35.dbf',
    '/u1/TEST/testora/testdata/a_txn_data36.dbf',
    '/u1/TEST/testora/testdata/a_txn_data37.dbf',
    '/u1/TEST/testora/testdata/a_txn_data38.dbf',
    '/u1/TEST/testora/testdata/a_txn_data39.dbf',
    '/u1/TEST/testora/testdata/a_txn_data40.dbf',
    '/u1/TEST/testora/testdata/a_txn_data41.dbf',
    '/u1/TEST/testora/testdata/a_txn_data42.dbf',
    '/u1/TEST/testora/testdata/a_txn_data43.dbf',
    '/u1/TEST/testora/testdata/a_txn_data44.dbf',
    '/u1/TEST/testora/testdata/a_txn_data45.dbf',
    '/u1/TEST/testora/testdata/a_txn_data46.dbf',
    '/u1/TEST/testora/testdata/a_txn_data47.dbf',
    '/u1/TEST/testora/testdata/a_txn_data48.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind01.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind02.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind03.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind04.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind05.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind06.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind07.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind08.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind09.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind10.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind11.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind12.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind13.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind14.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind15.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind16.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind17.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind18.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind19.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind20.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind21.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind22.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind23.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind24.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind25.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind26.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind27.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind28.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind29.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind30.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind31.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind32.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind33.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind34.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind35.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind36.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind37.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind38.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind39.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind40.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind41.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind42.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind43.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind44.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind45.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind46.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind47.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind48.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind49.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind50.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind51.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind52.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind53.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind54.dbf',
    '/u1/TEST/testora/testdata/a_txn_ind55.dbf',
    '/u1/TEST/testora/testdata/ctxd01.dbf',
    '/u1/TEST/testora/testdata/odm.dbf',
    '/u1/TEST/testora/testdata/olap.dbf',
    '/u1/TEST/testora/testdata/owad01.dbf',
    '/u1/TEST/testora/testdata/portal01.dbf',
    '/u1/TEST/testora/testdata/statspack_01.dbf',
    '/u1/TEST/testora/testdata/tplcux_data_01.dbf',
    '/u1/TEST/testora/testdata/tplcux_idx_01.dbf',
    '/u1/TEST/testora/testdata/interim.dbf',
    '/u1/TEST/testora/testdata/system12.dbf',
    '/u1/TEST/testora/testdata/a_txn_data49.dbf',
    '/u1/TEST/testora/testdata/a_ref03.dbf',
    '/u1/TEST/testora/testdata/a_summ06.dbf',
    '/u1/TEST/testora/testdata/undo04.dbf'
CHARACTER SET UTF8
;

create controlfile in SQL*Plus

[[email protected] ~]$ ll
total 11964
-rw-r--r--.  1 testora dba    10773 Oct 17 11:19 controlfile.sql
drwxr-xr-x. 10 testora dba     4096 Jun 21 17:12 itsection
drwxr-xr-x.  3 testora dba     4096 May 31 00:43 oradiag_testora
-rw-r--r--.  1 testora dba    26359 Oct 17 11:10 PROD_ora_7826.trc
-rw-r--r--.  1 testora dba     1139 Jul 15 16:30 rdccs_m000_15683.out
-rw-r--r--.  1 testora dba 12196573 Jul 15 16:28 rdccs_m000_15683.trc

[[email protected] ~]$ sqlplus  /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 17 17:30:33 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
   
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 5.1310E+10 bytes
Fixed Size		    2240344 bytes
Variable Size		 1.0066E+10 bytes
Database Buffers	 4.1205E+10 bytes
Redo Buffers		   36098048 bytes
SQL> @controlfile.sql

Control file created.

open database

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

create logfile group for thread 2 and then disable it

[[email protected] oradata]$ sqlplus  /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 31 16:49:15 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected.

SQL> ALTER DATABASE ADD LOGFILE THREAD 2
  GROUP 4 (
    '/u1/TEST/testora/testdata/redo4_1.dbf',
    '/u1/TEST/testora/testdata/redo4_2.dbf'
  ) SIZE 500M BLOCKSIZE 512,
  GROUP 5 (
    '/u1/TEST/testora/testdata/redo5_1.dbf',
    '/u1/TEST/testora/testdata/redo5_2.dbf'
  ) SIZE 500M BLOCKSIZE 512,
   GROUP 6 (
    '/u1/TEST/testora/testdata/redo6_1.dbf',
    '/u1/TEST/testora/testdata/redo6_2.dbf'
  ) SIZE 500M BLOCKSIZE 512;

Database altered.

open database

SQL> alter database open resetlogs;

Database altered.

SQL> alter database disable thread 2;

Database altered.

SQL> alter database drop logfile group 4, group 5, group 6;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 5.1310E+10 bytes
Fixed Size		    2240344 bytes
Variable Size		 1.0066E+10 bytes
Database Buffers	 4.1205E+10 bytes
Redo Buffers		   36098048 bytes
Database mounted.
Database opened.

alert.log

[[email protected] trace]$ pwd
/u1/11gR2_BASE/admin/prod/diag/rdbms/prod/PROD/trace
[[email protected] trace]$ cat alert_PROD.log
...
WARNING: The following temporary tablespaces contain no files.
         This condition can occur when a backup controlfile has
         been restored.  It may be necessary to add files to these
         tablespaces.  That can be done using the SQL statement:
 
         ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
 
         Alternatively, if these temporary tablespaces are no longer
         needed, then they can be dropped.
           Empty temporary tablespace: TEMP
...

SQL> alter tablespace temp add tempfile '/u1/TEST/testora/testdata/temp01.dbf' size 2000M, '/u1/TEST/testora/testdata/temp02.dbf' size
alter tablespace temp add tempfile '/u1/TEST/testora/testdata/temp01.dbf' size 2000M, '/u1/TEST/testora/testdata/temp02.dbf' size 2000M
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kghstack_free1], [list of datafile
#'s], [], [], [], [], [], [], [], [], [], []

SQL> SELECT TABLESPACE_NAME,FILE_ID,FILE_NAME,BYTES,BLOCKS,STATUS FROM DBA_TEMP_FILES ORDER BY 1, 2;

TABLESPACE_NAME   FILE_ID FILE_NAME						         BYTES	     BLOCKS      STATUS    
----------------- ------- -------------------------------------- ----------- ----------- -------
TEMP				     1 /u1/TEST/testora/testdata/temp01.dbf	  2097152000	  256000 ONLINE    
TEMP				     2 /u1/TEST/testora/testdata/temp02.dbf	  2097152000	  256000 ONLINE    

Post Steps

listener configuration

show service_names

SQL> show parameter name;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert		     string	 +DATADG/prodora/proddata, /u1/
                         TEST/testora/testdata
db_name 			     string	 PROD
db_unique_name			     string	 PROD
global_names			     boolean	 FALSE
instance_name			     string	 PROD
lock_name_space 		     string
log_file_name_convert		     string	 +DATADG/prodora/proddata, /u1/
                         TEST/testora/testdata
processor_group_name		     string
service_names			     string	 PROD

listener configuration

[[email protected] ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 18-OCT-2013 08:41:27

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Starting /u1/11gR2_BASE/product/11.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u1/11gR2_BASE/product/11.2.0/network/admin/ERP_erp/listener.ora
Log messages written to /u1/11gR2_BASE/diag/tnslsnr/target/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=target.egolife.com)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                18-OCT-2013 08:41:27
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u1/11gR2_BASE/product/11.2.0/network/admin/ERP_erp/listener.ora
Listener Log File         /u1/11gR2_BASE/diag/tnslsnr/target/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=target.egolife.com)(PORT=1521)))
The listener supports no services
The command completed successfully

[[email protected] ~]$ env | grep TNS_ADMIN
TNS_ADMIN=/u1/11gR2_BASE/product/11.2.0/network/admin/ERP_erp
[[email protected] ~]$ export TNS_ADMIN=TNS_ADMIN=/u1/11gR2_BASE/product/11.2.0/network/admin
[[email protected] ~]$ echo $TNS_ADMIN
TNS_ADMIN=/u1/11gR2_BASE/product/11.2.0/network/admin
[[email protected] ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 18-OCT-2013 08:46:09

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully

listener.ora and tnsnames.ora

[[email protected] admin]$ pwd
/u1/11gR2_BASE/product/11.2.0/network/admin
[[email protected] admin]$ cat listener.ora 
PROD =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
    )
  )

SID_LIST_ERP =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME= /u1/11gR2_BASE/product/11.2.0)
      (SID_NAME = PROD)
    )
  )

[[email protected] admin]$ cat tnsnames.ora 
PROD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = prod)
    )
  )

start listener

[[email protected] ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 18-OCT-2013 08:46:14

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Starting /u1/11gR2_BASE/product/11.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u1/11gR2_BASE/product/11.2.0/network/admin/listener.ora
Log messages written to /u1/11gR2_BASE/diag/tnslsnr/target/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.5)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                18-OCT-2013 08:46:14
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u1/11gR2_BASE/product/11.2.0/network/admin/listener.ora
Listener Log File         /u1/11gR2_BASE/diag/tnslsnr/target/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.5)(PORT=1521)))
The listener supports no services
The command completed successfully
[[email protected] ~]$ tnsping prod

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 18-OCT-2013 08:46:26

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:
/u1/11gR2_BASE/product/11.2.0/network/admin/ERP_erp/sqlnet_ifile.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = prod)))
OK (10 msec)

client test with PL*SQL Developer …

restart database

SQL> create pfile from spfile;

File created.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup;  
ORACLE instance started.

Total System Global Area 5.1310E+10 bytes
Fixed Size		    2240344 bytes
Variable Size		 1.0066E+10 bytes
Database Buffers	 4.1205E+10 bytes
Redo Buffers		   36098048 bytes
Database mounted.
Database opened.

full backup of database …

Reference

  • Oracle Database Backup and Reference User’s Guide


blog comments powered by Disqus

Published

17 October 2013

Categories

Tags

Github