Oracle Database RAC2Single Recovery
环境介绍
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] ~]$ 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;
[roo[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