ORACLE DATABASE: RECUPERACION BASE DE DATOS ORACLE (notas

ora105@qaora1 [/oracle105/rman/restore] $cd database
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $ls
core database_cfgser_sept03_1310.log database.cfgser16Jun14_junio18.log nohup.out
database_cfgser_feb202014_2.log database_cfgser_sept03.sh database.cfgser17Sep13 prueba.log
database_cfgser_feb202014_3.log database.cfgipqa database.cfgser17Sep13.log report.log
database_cfgser_feb202014.log database.cfgipqa.log database.cfgser31Oct.log rest_cfgser_291112_0853.log
database_cfgser_feb202014.sh database.cfgqa15Mar2013 database.cfgser31Oct13 rest_dat_cfgser_nov26
database_cfgser_feb24.log database.cfgqa15Mar2013.log database.cfgser31Oct13.log rest_dat_cfgser_nov26.log
database_cfgser_feb24022014.log database.cfgser database.cfgsom restore_cfgser.log
database_cfgser_may07.log database.cfgser_octu database.cfgsom.falta restore_cfgser.oct.log
database_cfgser_may07.sh database.cfgser06May2013 database.cvrqa16Mar2013 restore_cfgsom.log
database_cfgser_may07.sh_2.log database.cfgser06May2013.log database.telivr16Mar2013 restore_cfgsom2.log
database_cfgser_may07.sh2 database.cfgser15Mar2013 database.telivr16Mar2013.log restore_prueba.log
database_cfgser_may08.log database.cfgser15Mar2013.log falta.log
database_cfgser_may08.sh database.cfgser16Jun14 falta2.log
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $ls -lart
total 159274
-rw-r--r-- 1 ora105 oinstall 9457 Oct 2 2011 database.cfgser
-rw-r--r-- 1 ora105 oinstall 58810 Oct 3 2011 restore_cfgser.log
drwxr-xr-x 5 ora105 oinstall 512 Oct 3 2011 ..
-rw-r--r-- 1 ora105 oinstall 8726 Nov 7 2011 database.cfgser_octu
-rw-r--r-- 1 ora105 oinstall 58136 Nov 7 2011 restore_cfgser.oct.log
-rw-r--r-- 1 ora105 oinstall 61876 Feb 3 2012 restore_cfgsom.log
-rw-r--r-- 1 ora105 oinstall 58609 Feb 5 2012 restore_cfgsom2.log
-rw-r--r-- 1 ora105 oinstall 4434 Feb 5 2012 falta.log
-rw-r--r-- 1 ora105 oinstall 6659 Feb 5 2012 falta2.log
-rw-r--r-- 1 ora105 oinstall 427 Feb 6 2012 database.cfgsom.falta
-rw-r--r-- 1 ora105 oinstall 1504 Feb 6 2012 prueba.log
-rw-r--r-- 1 ora105 oinstall 9531 Feb 6 2012 database.cfgsom
-rw-r--r-- 1 ora105 oinstall 24632 Feb 6 2012 restore_prueba.log
-rw-r--r-- 1 ora105 oinstall 9746 Nov 28 2012 rest_dat_cfgser_nov26
-rw-r--r-- 1 ora105 oinstall 29594 Nov 29 2012 rest_dat_cfgser_nov26.log
-rw-r--r-- 1 ora105 oinstall 50344 Nov 29 2012 rest_cfgser_291112_0853.log
-rw-r--r-- 1 ora105 oinstall 8985 Mar 16 2013 database.cfgser15Mar2013
-rw-r--r-- 1 ora105 oinstall 38297 Mar 16 2013 database.cfgser15Mar2013.log
-rw-r--r-- 1 ora105 oinstall 8667 Mar 16 2013 database.cfgqa15Mar2013
-rw-r--r-- 1 ora105 oinstall 37343 Mar 16 2013 database.cfgqa15Mar2013.log
-rw-r--r-- 1 ora105 oinstall 4974 Mar 16 2013 database.telivr16Mar2013
-rw-r--r-- 1 ora105 oinstall 1905 Mar 16 2013 database.cvrqa16Mar2013
-rw-r--r-- 1 ora105 oinstall 36353 Mar 17 2013 database.telivr16Mar2013.log
-rw-r--r-- 1 ora105 oinstall 9810 May 6 2013 database.cfgser06May2013
-rw-r--r-- 1 ora105 oinstall 40714 May 6 2013 database.cfgser06May2013.log
-rw-r--r-- 1 ora105 oinstall 9793 Jun 20 2013 database.cfgipqa
-rw-r--r-- 1 ora105 oinstall 26371 Jun 20 2013 database.cfgipqa.log
-rw-r--r-- 1 ora105 oinstall 9912 Sep 3 2013 database_cfgser_sept03.sh
-rw-r--r-- 1 ora105 oinstall 26930 Sep 3 2013 database_cfgser_sept03_1310.log
-rw-r--r-- 1 ora105 oinstall 9900 Sep 17 2013 database.cfgser17Sep13
-rw-r--r-- 1 ora105 oinstall 26589 Sep 17 2013 database.cfgser17Sep13.log
-rw-r--r-- 1 ora105 oinstall 849 Nov 1 2013 report.log
-rw-r--r-- 1 ora105 oinstall 15354 Nov 1 2013 database.cfgser31Oct13.log
-rw------- 1 ora105 oinstall 80419019 Nov 1 2013 core
-rw------- 1 ora105 oinstall 135 Nov 1 2013 nohup.out
-rw-r--r-- 1 ora105 oinstall 9788 Nov 1 2013 database.cfgser31Oct13
-rw-r--r-- 1 ora105 oinstall 64984 Nov 2 2013 database.cfgser31Oct.log
-rw-r--r-- 1 ora105 oinstall 21935 Feb 20 22:46 database_cfgser_feb202014.log
-rw-r--r-- 1 ora105 oinstall 32762 Feb 24 08:41 database_cfgser_feb24022014.log
-rw-r--r-- 1 ora105 oinstall 19588 Feb 24 11:24 database_cfgser_feb24.log
-rw-r--r-- 1 ora105 oinstall 38175 Feb 25 03:53 database_cfgser_feb202014_2.log
-rw-r--r-- 1 ora105 oinstall 9650 Feb 25 08:58 database_cfgser_feb202014.sh
-rw-r--r-- 1 ora105 oinstall 25101 Feb 25 09:57 database_cfgser_feb202014_3.log
-rw-r--r-- 1 ora105 oinstall 34434 May 8 06:51 database_cfgser_may07.log
-rw-r--r-- 1 ora105 oinstall 460 May 8 08:57 database_cfgser_may08.sh
-rw-r--r-- 1 ora105 oinstall 12014 May 8 09:22 database_cfgser_may08.log
-rw-r--r-- 1 ora105 oinstall 9724 May 8 09:27 database_cfgser_may07.sh
-rw-r--r-- 1 ora105 oinstall 29344 May 8 11:24 database_cfgser_may07.sh_2.log
-rw-r--r-- 1 ora105 oinstall 1610 May 8 15:48 database_cfgser_may07.sh2
-rw-r--r-- 1 ora105 oinstall 10117 Jun 17 18:40 database.cfgser16Jun14
drwxr-xr-x 2 ora105 oinstall 2048 Jun 18 09:41 .
-rw-r--r-- 1 ora105 oinstall 27394 Jun 18 17:40 database.cfgser16Jun14_junio18.log
ora105@qaora1 [/oracle105/rman/restore/database] $cp database.cfgser16Jun14 database.cfgser16Jun14copia
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $vi database.cfgser16Jun14copia
"database.cfgser16Jun14copia" 147 lines, 10117 characters
connect catalog rman_restore/prueba2012@catrman;
connect target;
run
{
set until time "to_date('16-06-2014 23:42','dd-mm-yyyy hh24:mi')";

allocate channel t1_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t2_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t3_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t4_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t5_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t6_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t7_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t8_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';

recover database;

release channel t1_cfgser;
release channel t2_cfgser;
release channel t3_cfgser;
release channel t4_cfgser;
release channel t5_cfgser;
release channel t6_cfgser;
release channel t7_cfgser;
release channel t8_cfgser;

}
~
~
~
~
~
~
~
~
~
~
"database.cfgser16Jun14copia" 35 lines, 1610 characters
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $echo $ORACLE_SID
cfgsomqa
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $rman @database.cfgser16Jun14copia

Recovery Manager: Release 10.2.0.5.0 - Production on Fri Jun 20 09:28:53 2014

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

RMAN> connect catalog *
2> connect target;
3> run
4> {
5> set until time "to_date('16-06-2014 23:42','dd-mm-yyyy hh24:mi')";
6>
7> allocate channel t1_cfgser type 'SBT_TAPE'
8> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
9> allocate channel t2_cfgser type 'SBT_TAPE'
10> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
11> allocate channel t3_cfgser type 'SBT_TAPE'
12> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
13> allocate channel t4_cfgser type 'SBT_TAPE'
14> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
15> allocate channel t5_cfgser type 'SBT_TAPE'
16> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
17> allocate channel t6_cfgser type 'SBT_TAPE'
18> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
19> allocate channel t7_cfgser type 'SBT_TAPE'
20> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
21> allocate channel t8_cfgser type 'SBT_TAPE'
22> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
23>
24> recover database;
25>
26> release channel t1_cfgser;
27> release channel t2_cfgser;
28> release channel t3_cfgser;
29> release channel t4_cfgser;
30> release channel t5_cfgser;
31> release channel t6_cfgser;
32> release channel t7_cfgser;
33> release channel t8_cfgser;
34>
35> }
36>
connected to recovery catalog database

connected to target database: CFGSER (DBID=3640123222, not open)

executing command: SET until clause

allocated channel: t1_cfgser
channel t1_cfgser: sid=541 devtype=SBT_TAPE
channel t1_cfgser: NMDA Oracle v1.2.0

allocated channel: t2_cfgser
channel t2_cfgser: sid=537 devtype=SBT_TAPE
channel t2_cfgser: NMDA Oracle v1.2.0

allocated channel: t3_cfgser
channel t3_cfgser: sid=536 devtype=SBT_TAPE
channel t3_cfgser: NMDA Oracle v1.2.0

allocated channel: t4_cfgser
channel t4_cfgser: sid=535 devtype=SBT_TAPE
channel t4_cfgser: NMDA Oracle v1.2.0

allocated channel: t5_cfgser
channel t5_cfgser: sid=534 devtype=SBT_TAPE
channel t5_cfgser: NMDA Oracle v1.2.0

allocated channel: t6_cfgser
channel t6_cfgser: sid=533 devtype=SBT_TAPE
channel t6_cfgser: NMDA Oracle v1.2.0

allocated channel: t7_cfgser
channel t7_cfgser: sid=532 devtype=SBT_TAPE
channel t7_cfgser: NMDA Oracle v1.2.0

allocated channel: t8_cfgser
channel t8_cfgser: sid=531 devtype=SBT_TAPE
channel t8_cfgser: NMDA Oracle v1.2.0

Starting recover at 20-JUN-14

List of remote backup files
============================
Handle: FULL_INC_DIA_CFGSER_850415277_7mpb0jld_1_1 Media: A01768
Handle: FULL_INC_DIA_CFGSER_850415277_7jpb0jld_1_1 Media: A01768
Handle: FULL_INC_DIA_CFGSER_850415277_7ipb0jld_1_1 Media: A01768
Handle: FULL_INC_DIA_CFGSER_850415277_7lpb0jld_1_1 Media: A01768
Handle: FULL_INC_DIA_CFGSER_850415277_7gpb0jld_1_1 Media: A01768
Handle: FULL_INC_DIA_CFGSER_850415277_7hpb0jld_1_1 Media: A01768
Handle: FULL_INC_DIA_CFGSER_850415633_7npb0k0h_1_1 Media: A01768
Handle: FULL_INC_DIA_CFGSER_850415277_7kpb0jld_1_1 Media: A01768
Handle: FULL_INC_DIA_CFGSER_850415277_7fpb0jld_1_1 Media: A01768
released channel: t1_cfgser
released channel: t2_cfgser
released channel: t3_cfgser
released channel: t4_cfgser
released channel: t5_cfgser
released channel: t6_cfgser
released channel: t7_cfgser
released channel: t8_cfgser
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/20/2014 09:31:44
RMAN-20507: some targets are remote - aborting restore

Recovery Manager complete.
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 20 09:32:43 2014

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL>
SQL>
SQL> alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss';
select name, checkpoint_time from v$datafile_header order by 2;
Session altered.

SQL>

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/42_ele_red_dat_sm_01.dbf
14-06-2014 19:04:29

/CFGSOMQA/datafile/110_cfgser_dat_sm_09.dbf
14-06-2014 19:04:29

/CFGSOMQA/datafile/3_ele_red_dat_sm_04.dbf
14-06-2014 19:04:29

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/102_cfgser_dat_big_16.dbf
14-06-2014 19:04:29

/CFGSOMQA/datafile/34_cfgser_dat_med1_01.dbf
14-06-2014 19:04:29

/CFGSOMQA/datafile/84_frtmovil_dat_peq_01.dbf
14-06-2014 19:04:29

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/51_patrol01.dbf
14-06-2014 19:04:29

/CFGSOMQA/datafile/73_idea_dat_01.dbf
14-06-2014 19:04:29

/CFGSOMQA/datafile/67_log_errores_02.dbf
14-06-2014 19:04:29

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/7_log_errores_01.dbf
14-06-2014 19:04:29

/CFGSOMQA/datafile/5_fldsrv_dat_peq01.dbf
14-06-2014 19:04:29

/CFGSOMQA/datafile/14_audit_dat_01.dbf
14-06-2014 19:04:29

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/18_e1adm_dat_peq01.dbf
14-06-2014 19:04:29

/CFGSOMQA/datafile/74_idea_dat_02.dbf
14-06-2014 19:04:29

/CFGSOMQA/datafile/125_cfgser_dat_big_19.dbf
14-06-2014 20:58:21

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/103_cfgser_dat_big_17.dbf
14-06-2014 20:58:21

/CFGSOMQA/datafile/89_cfgser_dat_big_14.dbf
14-06-2014 20:58:21

/CFGSOMQA/datafile/65_cfgser_dat_big_06.dbf
14-06-2014 20:58:21

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/64_cfgser_dat_big_05.dbf
14-06-2014 20:58:21

/CFGSOMQA/datafile/138_cfgser_ind_med01.dbf
14-06-2014 20:58:21

/CFGSOMQA/datafile/46_cfgser_ind_med09.dbf
14-06-2014 20:58:21

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/40_cfgser_dat_big_01.dbf
14-06-2014 20:58:21

/CFGSOMQA/datafile/31_est_act_eve_dat_big_02.dbf
14-06-2014 20:58:21

/CFGSOMQA/datafile/20_cfgserin_dat_med01.dbf
14-06-2014 20:58:21

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/13_cfgserin_dat_peq01.dbf
14-06-2014 20:58:21

/CFGSOMQA/datafile/47_cfgser_ind_med10.dbf
14-06-2014 20:58:21

/CFGSOMQA/datafile/1_system01.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/2_cfgser_dat_big_15.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/4_users_01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/6_sustadm_dat01.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/8_cfgser_ind_med06.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/9_sustadm_ind01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/10_est_act_eve_dat_big_15.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/11_fldsrv_ind_01_01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/12_undo_cfgser01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/15_undo_cfgser02.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/16_cfgserin_dat_peq02.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/17_cfgser_dat_big_02.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/19_cfgser_dat_big_11.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/21_cfgserin_dat_med02.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/22_cfgserin_dat_med03.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/23_cfgser_dat_sm_07.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/24_fldsrv_dat_med01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/25_fldsrv_dat_med02.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/26_histocfg_dat01.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/27_cfgser_dat_big_03.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/28_cfgser_dat_med01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/29_cfgser_dat_med02.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/30_est_act_eve_dat_big_01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/32_est_act_eve_dat_big_16.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/33_cfgser_ind_med07.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/35_log_errores_05.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/36_est_act_eve_dat_big_03.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/37_est_act_eve_dat_big_04.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/38_idea_ind_peq01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/39_est_act_eve_dat_big_05.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/41_cfgser_dat_big_04.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/43_ele_red_dat_sm_02.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/44_ele_red_dat_sm_03.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/45_cfgser_ind_med08.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/48_fldsrv_ind_med_01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/49_cfgser_dat_big_09.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/50_cfgser_dat_big_10.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/53_cfgser_dat_big_12.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/54_est_act_eve_dat_big_06.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/55_est_act_eve_dat_big_08.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/56_cfgser_dat_sm_01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/57_cfgser_dat_sm_02.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/58_cfgser_dat_sm_03.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/59_cfgser_dat_sm_04.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/60_cfgser_dat_sm_05.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/63_cfgser_dat_sm_06.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/66_sysaux01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/68_log_errores_03.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/69_est_act_eve_dat_big_09.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/71_cfgser_dat_sm_08.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/72_cfgser_dat_big_18.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/75_idea_dat_03.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/76_idea_dat_04.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/77_idea_dat_05.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/78_idea_dat_06.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/79_cfgser_dat_big_07.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/80_cfgser_dat_big_08.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/81_fldsrv_ind_01_02.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/82_idea_log01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/85_fldsrv_ind_01_03.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/86_cfgser_ind_peq01.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/88_est_act_eve_dat_big_07.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/101_cfgser_dat_peq_m1_01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/105_est_act_eve_dat_big_10.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/106_userconnect_01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/112_est_act_eve_dat_big_11.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/113_cfgser_dat_sm_10.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/116_fldsrv_ind_01_04.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/120_est_act_eve_dat_big_12.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/121_est_act_eve_dat_big_13.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/126_cfgser_dat_big_20.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/127_log_errores_04.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/128_est_act_eve_dat_big_14.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/129_cfgser_dat_big_21.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/130_frtmovil_ind_peq_01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/131_sysaux02.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/135_e1adm_ind_peq01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/136_cfgserin_ind_peq01.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/137_cfgserin_ind_med01.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/139_cfgser_ind_med02.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/140_cfgser_ind_med03.dbf
14-06-2014 20:58:22

/CFGSOMQA/datafile/141_cfgser_ind_med04.dbf
14-06-2014 20:58:22

NAME
--------------------------------------------------------------------------------
CHECKPOINT_TIME
-------------------
/CFGSOMQA/datafile/142_cfgser_ind_med05.dbf
14-06-2014 20:58:22

109 rows selected.

SQL> set lines 1000
SQL> /

NAME CHECKPOINT_TIME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------
/CFGSOMQA/datafile/42_ele_red_dat_sm_01.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/110_cfgser_dat_sm_09.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/3_ele_red_dat_sm_04.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/102_cfgser_dat_big_16.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/34_cfgser_dat_med1_01.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/84_frtmovil_dat_peq_01.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/51_patrol01.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/73_idea_dat_01.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/67_log_errores_02.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/7_log_errores_01.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/5_fldsrv_dat_peq01.dbf 14-06-2014 19:04:29

NAME CHECKPOINT_TIME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------
/CFGSOMQA/datafile/14_audit_dat_01.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/18_e1adm_dat_peq01.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/74_idea_dat_02.dbf 14-06-2014 19:04:29
/CFGSOMQA/datafile/125_cfgser_dat_big_19.dbf 14-06-2014 20:58:21
/CFGSOMQA/datafile/103_cfgser_dat_big_17.dbf 14-06-2014 20:58:21
/CFGSOMQA/datafile/89_cfgser_dat_big_14.dbf 14-06-2014 20:58:21
/CFGSOMQA/datafile/65_cfgser_dat_big_06.dbf 14-06-2014 20:58:21
/CFGSOMQA/datafile/64_cfgser_dat_big_05.dbf 14-06-2014 20:58:21
/CFGSOMQA/datafile/138_cfgser_ind_med01.dbf 14-06-2014 20:58:21
/CFGSOMQA/datafile/46_cfgser_ind_med09.dbf 14-06-2014 20:58:21
/CFGSOMQA/datafile/40_cfgser_dat_big_01.dbf 14-06-2014 20:58:21

NAME CHECKPOINT_TIME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------
/CFGSOMQA/datafile/31_est_act_eve_dat_big_02.dbf 14-06-2014 20:58:21
/CFGSOMQA/datafile/20_cfgserin_dat_med01.dbf 14-06-2014 20:58:21
/CFGSOMQA/datafile/13_cfgserin_dat_peq01.dbf 14-06-2014 20:58:21
/CFGSOMQA/datafile/47_cfgser_ind_med10.dbf 14-06-2014 20:58:21
/CFGSOMQA/datafile/1_system01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/2_cfgser_dat_big_15.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/4_users_01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/6_sustadm_dat01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/8_cfgser_ind_med06.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/9_sustadm_ind01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/10_est_act_eve_dat_big_15.dbf 14-06-2014 20:58:22

NAME CHECKPOINT_TIME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------
/CFGSOMQA/datafile/11_fldsrv_ind_01_01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/12_undo_cfgser01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/15_undo_cfgser02.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/16_cfgserin_dat_peq02.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/17_cfgser_dat_big_02.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/19_cfgser_dat_big_11.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/21_cfgserin_dat_med02.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/22_cfgserin_dat_med03.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/23_cfgser_dat_sm_07.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/24_fldsrv_dat_med01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/25_fldsrv_dat_med02.dbf 14-06-2014 20:58:22

NAME CHECKPOINT_TIME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------
/CFGSOMQA/datafile/26_histocfg_dat01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/27_cfgser_dat_big_03.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/28_cfgser_dat_med01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/29_cfgser_dat_med02.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/30_est_act_eve_dat_big_01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/32_est_act_eve_dat_big_16.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/33_cfgser_ind_med07.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/35_log_errores_05.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/36_est_act_eve_dat_big_03.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/37_est_act_eve_dat_big_04.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/38_idea_ind_peq01.dbf 14-06-2014 20:58:22

NAME CHECKPOINT_TIME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------
/CFGSOMQA/datafile/39_est_act_eve_dat_big_05.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/41_cfgser_dat_big_04.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/43_ele_red_dat_sm_02.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/44_ele_red_dat_sm_03.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/45_cfgser_ind_med08.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/48_fldsrv_ind_med_01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/49_cfgser_dat_big_09.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/50_cfgser_dat_big_10.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/53_cfgser_dat_big_12.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/54_est_act_eve_dat_big_06.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/55_est_act_eve_dat_big_08.dbf 14-06-2014 20:58:22

NAME CHECKPOINT_TIME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------
/CFGSOMQA/datafile/56_cfgser_dat_sm_01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/57_cfgser_dat_sm_02.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/58_cfgser_dat_sm_03.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/59_cfgser_dat_sm_04.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/60_cfgser_dat_sm_05.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/63_cfgser_dat_sm_06.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/66_sysaux01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/68_log_errores_03.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/69_est_act_eve_dat_big_09.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/71_cfgser_dat_sm_08.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/72_cfgser_dat_big_18.dbf 14-06-2014 20:58:22

NAME CHECKPOINT_TIME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------
/CFGSOMQA/datafile/75_idea_dat_03.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/76_idea_dat_04.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/77_idea_dat_05.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/78_idea_dat_06.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/79_cfgser_dat_big_07.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/80_cfgser_dat_big_08.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/81_fldsrv_ind_01_02.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/82_idea_log01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/85_fldsrv_ind_01_03.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/86_cfgser_ind_peq01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/88_est_act_eve_dat_big_07.dbf 14-06-2014 20:58:22

NAME CHECKPOINT_TIME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------
/CFGSOMQA/datafile/101_cfgser_dat_peq_m1_01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/105_est_act_eve_dat_big_10.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/106_userconnect_01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/112_est_act_eve_dat_big_11.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/113_cfgser_dat_sm_10.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/116_fldsrv_ind_01_04.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/120_est_act_eve_dat_big_12.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/121_est_act_eve_dat_big_13.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/126_cfgser_dat_big_20.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/127_log_errores_04.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/128_est_act_eve_dat_big_14.dbf 14-06-2014 20:58:22

NAME CHECKPOINT_TIME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------
/CFGSOMQA/datafile/129_cfgser_dat_big_21.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/130_frtmovil_ind_peq_01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/131_sysaux02.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/135_e1adm_ind_peq01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/136_cfgserin_ind_peq01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/137_cfgserin_ind_med01.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/139_cfgser_ind_med02.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/140_cfgser_ind_med03.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/141_cfgser_ind_med04.dbf 14-06-2014 20:58:22
/CFGSOMQA/datafile/142_cfgser_ind_med05.dbf 14-06-2014 20:58:22

109 rows selected.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $ls
core database_cfgser_sept03_1310.log database.cfgser16Jun14_junio18.log falta2.log
database_cfgser_feb202014_2.log database_cfgser_sept03.sh database.cfgser16Jun14copia nohup.out
database_cfgser_feb202014_3.log database.cfgipqa database.cfgser17Sep13 prueba.log
database_cfgser_feb202014.log database.cfgipqa.log database.cfgser17Sep13.log report.log
database_cfgser_feb202014.sh database.cfgqa15Mar2013 database.cfgser31Oct.log rest_cfgser_291112_0853.log
database_cfgser_feb24.log database.cfgqa15Mar2013.log database.cfgser31Oct13 rest_dat_cfgser_nov26
database_cfgser_feb24022014.log database.cfgser database.cfgser31Oct13.log rest_dat_cfgser_nov26.log
database_cfgser_may07.log database.cfgser_octu database.cfgsom restore_cfgser.log
database_cfgser_may07.sh database.cfgser06May2013 database.cfgsom.falta restore_cfgser.oct.log
database_cfgser_may07.sh_2.log database.cfgser06May2013.log database.cvrqa16Mar2013 restore_cfgsom.log
database_cfgser_may07.sh2 database.cfgser15Mar2013 database.telivr16Mar2013 restore_cfgsom2.log
database_cfgser_may08.log database.cfgser15Mar2013.log database.telivr16Mar2013.log restore_prueba.log
database_cfgser_may08.sh database.cfgser16Jun14 falta.log
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $ls -lart
total 159278
-rw-r--r-- 1 ora105 oinstall 9457 Oct 2 2011 database.cfgser
-rw-r--r-- 1 ora105 oinstall 58810 Oct 3 2011 restore_cfgser.log
drwxr-xr-x 5 ora105 oinstall 512 Oct 3 2011 ..
-rw-r--r-- 1 ora105 oinstall 8726 Nov 7 2011 database.cfgser_octu
-rw-r--r-- 1 ora105 oinstall 58136 Nov 7 2011 restore_cfgser.oct.log
-rw-r--r-- 1 ora105 oinstall 61876 Feb 3 2012 restore_cfgsom.log
-rw-r--r-- 1 ora105 oinstall 58609 Feb 5 2012 restore_cfgsom2.log
-rw-r--r-- 1 ora105 oinstall 4434 Feb 5 2012 falta.log
-rw-r--r-- 1 ora105 oinstall 6659 Feb 5 2012 falta2.log
-rw-r--r-- 1 ora105 oinstall 427 Feb 6 2012 database.cfgsom.falta
-rw-r--r-- 1 ora105 oinstall 1504 Feb 6 2012 prueba.log
-rw-r--r-- 1 ora105 oinstall 9531 Feb 6 2012 database.cfgsom
-rw-r--r-- 1 ora105 oinstall 24632 Feb 6 2012 restore_prueba.log
-rw-r--r-- 1 ora105 oinstall 9746 Nov 28 2012 rest_dat_cfgser_nov26
-rw-r--r-- 1 ora105 oinstall 29594 Nov 29 2012 rest_dat_cfgser_nov26.log
-rw-r--r-- 1 ora105 oinstall 50344 Nov 29 2012 rest_cfgser_291112_0853.log
-rw-r--r-- 1 ora105 oinstall 8985 Mar 16 2013 database.cfgser15Mar2013
-rw-r--r-- 1 ora105 oinstall 38297 Mar 16 2013 database.cfgser15Mar2013.log
-rw-r--r-- 1 ora105 oinstall 8667 Mar 16 2013 database.cfgqa15Mar2013
-rw-r--r-- 1 ora105 oinstall 37343 Mar 16 2013 database.cfgqa15Mar2013.log
-rw-r--r-- 1 ora105 oinstall 4974 Mar 16 2013 database.telivr16Mar2013
-rw-r--r-- 1 ora105 oinstall 1905 Mar 16 2013 database.cvrqa16Mar2013
-rw-r--r-- 1 ora105 oinstall 36353 Mar 17 2013 database.telivr16Mar2013.log
-rw-r--r-- 1 ora105 oinstall 9810 May 6 2013 database.cfgser06May2013
-rw-r--r-- 1 ora105 oinstall 40714 May 6 2013 database.cfgser06May2013.log
-rw-r--r-- 1 ora105 oinstall 9793 Jun 20 2013 database.cfgipqa
-rw-r--r-- 1 ora105 oinstall 26371 Jun 20 2013 database.cfgipqa.log
-rw-r--r-- 1 ora105 oinstall 9912 Sep 3 2013 database_cfgser_sept03.sh
-rw-r--r-- 1 ora105 oinstall 26930 Sep 3 2013 database_cfgser_sept03_1310.log
-rw-r--r-- 1 ora105 oinstall 9900 Sep 17 2013 database.cfgser17Sep13
-rw-r--r-- 1 ora105 oinstall 26589 Sep 17 2013 database.cfgser17Sep13.log
-rw-r--r-- 1 ora105 oinstall 849 Nov 1 2013 report.log
-rw-r--r-- 1 ora105 oinstall 15354 Nov 1 2013 database.cfgser31Oct13.log
-rw------- 1 ora105 oinstall 80419019 Nov 1 2013 core
-rw------- 1 ora105 oinstall 135 Nov 1 2013 nohup.out
-rw-r--r-- 1 ora105 oinstall 9788 Nov 1 2013 database.cfgser31Oct13
-rw-r--r-- 1 ora105 oinstall 64984 Nov 2 2013 database.cfgser31Oct.log
-rw-r--r-- 1 ora105 oinstall 21935 Feb 20 22:46 database_cfgser_feb202014.log
-rw-r--r-- 1 ora105 oinstall 32762 Feb 24 08:41 database_cfgser_feb24022014.log
-rw-r--r-- 1 ora105 oinstall 19588 Feb 24 11:24 database_cfgser_feb24.log
-rw-r--r-- 1 ora105 oinstall 38175 Feb 25 03:53 database_cfgser_feb202014_2.log
-rw-r--r-- 1 ora105 oinstall 9650 Feb 25 08:58 database_cfgser_feb202014.sh
-rw-r--r-- 1 ora105 oinstall 25101 Feb 25 09:57 database_cfgser_feb202014_3.log
-rw-r--r-- 1 ora105 oinstall 34434 May 8 06:51 database_cfgser_may07.log
-rw-r--r-- 1 ora105 oinstall 460 May 8 08:57 database_cfgser_may08.sh
-rw-r--r-- 1 ora105 oinstall 12014 May 8 09:22 database_cfgser_may08.log
-rw-r--r-- 1 ora105 oinstall 9724 May 8 09:27 database_cfgser_may07.sh
-rw-r--r-- 1 ora105 oinstall 29344 May 8 11:24 database_cfgser_may07.sh_2.log
-rw-r--r-- 1 ora105 oinstall 1610 May 8 15:48 database_cfgser_may07.sh2
-rw-r--r-- 1 ora105 oinstall 10117 Jun 17 18:40 database.cfgser16Jun14
-rw-r--r-- 1 ora105 oinstall 27394 Jun 18 17:40 database.cfgser16Jun14_junio18.log
drwxr-xr-x 2 ora105 oinstall 2048 Jun 20 09:26 .
-rw-r--r-- 1 ora105 oinstall 1610 Jun 20 09:28 database.cfgser16Jun14copia
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $vi database.cfgser16Jun14copia
"database.cfgser16Jun14copia" 35 lines, 1610 characters
connect catalog rman_restore/prueba2012@catrman;
connect target;
run
{
set until time "to_date('14-06-2014 21:00','dd-mm-yyyy hh24:mi')";

allocate channel t1_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t2_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t3_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t4_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t5_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t6_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t7_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
allocate channel t8_cfgser type 'SBT_TAPE'
parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';

recover database;

release channel t1_cfgser;
release channel t2_cfgser;
release channel t3_cfgser;
release channel t4_cfgser;
release channel t5_cfgser;
release channel t6_cfgser;
release channel t7_cfgser;
release channel t8_cfgser;

}
~
~
~
~
~
~
~
~
~
~
"database.cfgser16Jun14copia" 35 lines, 1610 characters
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $rman database.cfgser16Jun14copia

Argument Value Description
-----------------------------------------------------------------------------
target quoted-string connect-string for target database
catalog quoted-string connect-string for recovery catalog
nocatalog none if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
trace quoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debug optional-args activate debugging
msgno none show RMAN-nnnn prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
timeout integer number of seconds to wait for pipe input
checksyntax none check the command file for syntax errors
-----------------------------------------------------------------------------
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00552: syntax error in command line arguments
RMAN-01009: syntax error: found "database": expecting one of: "append, at, auxiliary, catalog, cmdfile, clone, checksyntax, debug, log, msglog, mask, msgno, nocatalog, pipe, rcvcat, script, slaxdebug, send, target, timeout, trace"
RMAN-01007: at line 2 column 1 file: command line arguments
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $rman @database.cfgser16Jun14copia

Recovery Manager: Release 10.2.0.5.0 - Production on Fri Jun 20 09:35:07 2014

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

RMAN> connect catalog *
2> connect target;
3> run
4> {
5> set until time "to_date('14-06-2014 21:00','dd-mm-yyyy hh24:mi')";
6>
7> allocate channel t1_cfgser type 'SBT_TAPE'
8> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
9> allocate channel t2_cfgser type 'SBT_TAPE'
10> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
11> allocate channel t3_cfgser type 'SBT_TAPE'
12> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
13> allocate channel t4_cfgser type 'SBT_TAPE'
14> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
15> allocate channel t5_cfgser type 'SBT_TAPE'
16> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
17> allocate channel t6_cfgser type 'SBT_TAPE'
18> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
19> allocate channel t7_cfgser type 'SBT_TAPE'
20> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
21> allocate channel t8_cfgser type 'SBT_TAPE'
22> parms 'ENV=(NSR_SERVER=bksdc20,NSR_CLIENT=cfgprod,NSR_GROUP=Solaris-BD17,NSR_DATA_VOLUME_POOL=2Meses)';
23>
24> recover database;
25>
26> release channel t1_cfgser;
27> release channel t2_cfgser;
28> release channel t3_cfgser;
29> release channel t4_cfgser;
30> release channel t5_cfgser;
31> release channel t6_cfgser;
32> release channel t7_cfgser;
33> release channel t8_cfgser;
34>
35> }
36>
connected to recovery catalog database

connected to target database: CFGSER (DBID=3640123222, not open)

executing command: SET until clause

allocated channel: t1_cfgser
channel t1_cfgser: sid=536 devtype=SBT_TAPE
channel t1_cfgser: NMDA Oracle v1.2.0

allocated channel: t2_cfgser
channel t2_cfgser: sid=535 devtype=SBT_TAPE
channel t2_cfgser: NMDA Oracle v1.2.0

allocated channel: t3_cfgser
channel t3_cfgser: sid=534 devtype=SBT_TAPE
channel t3_cfgser: NMDA Oracle v1.2.0

allocated channel: t4_cfgser
channel t4_cfgser: sid=533 devtype=SBT_TAPE
channel t4_cfgser: NMDA Oracle v1.2.0

allocated channel: t5_cfgser
channel t5_cfgser: sid=532 devtype=SBT_TAPE
channel t5_cfgser: NMDA Oracle v1.2.0

allocated channel: t6_cfgser
channel t6_cfgser: sid=531 devtype=SBT_TAPE
channel t6_cfgser: NMDA Oracle v1.2.0

allocated channel: t7_cfgser
channel t7_cfgser: sid=540 devtype=SBT_TAPE
channel t7_cfgser: NMDA Oracle v1.2.0

allocated channel: t8_cfgser
channel t8_cfgser: sid=538 devtype=SBT_TAPE
channel t8_cfgser: NMDA Oracle v1.2.0

Starting recover at 20-JUN-14

starting media recovery

archive log thread 1 sequence 95505 is already on disk as file /CFGSOMQA/archives/cfgser_600010270_1_95505.arc
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95463
channel t1_cfgser: reading from backup piece tdpardv8_1_1
channel t1_cfgser: restored backup piece 1
piece handle=tdpardv8_1_1 tag=TAG20140614T192007
channel t1_cfgser: restore complete, elapsed time: 00:00:36
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95463.arc thread=1 sequence=95463
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95464
channel t1_cfgser: reading from backup piece tfpardv8_1_1
channel t1_cfgser: restored backup piece 1
piece handle=tfpardv8_1_1 tag=TAG20140614T192007
channel t1_cfgser: restore complete, elapsed time: 00:00:26
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95464.arc thread=1 sequence=95464
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95466
channel t1_cfgser: reading from backup piece tkpare8j_1_1
channel t1_cfgser: restored backup piece 1
piece handle=tkpare8j_1_1 tag=TAG20140614T192507
channel t1_cfgser: restore complete, elapsed time: 00:00:16
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95465
channel t1_cfgser: reading from backup piece tjpare8j_1_1
channel t1_cfgser: restored backup piece 1
piece handle=tjpare8j_1_1 tag=TAG20140614T192507
channel t1_cfgser: restore complete, elapsed time: 00:00:16
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95465.arc thread=1 sequence=95465
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95466.arc thread=1 sequence=95466
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95468
channel t1_cfgser: reading from backup piece tqparei1_1_1
channel t1_cfgser: restored backup piece 1
piece handle=tqparei1_1_1 tag=TAG20140614T193009
channel t1_cfgser: restore complete, elapsed time: 00:00:16
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95467
channel t1_cfgser: reading from backup piece tnparei1_1_1
channel t1_cfgser: restored backup piece 1
piece handle=tnparei1_1_1 tag=TAG20140614T193009
channel t1_cfgser: restore complete, elapsed time: 00:00:36
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95467.arc thread=1 sequence=95467
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95468.arc thread=1 sequence=95468
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95469
channel t1_cfgser: reading from backup piece ttparerb_1_1
channel t1_cfgser: restored backup piece 1
piece handle=ttparerb_1_1 tag=TAG20140614T193507
channel t1_cfgser: restore complete, elapsed time: 00:00:26
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95469.arc thread=1 sequence=95469
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95470
channel t1_cfgser: reading from backup piece tvparerb_1_1
channel t1_cfgser: restored backup piece 1
piece handle=tvparerb_1_1 tag=TAG20140614T193507
channel t1_cfgser: restore complete, elapsed time: 00:00:26
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95470.arc thread=1 sequence=95470
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95471
channel t1_cfgser: reading from backup piece u1parf4n_1_1
channel t1_cfgser: restored backup piece 1
piece handle=u1parf4n_1_1 tag=TAG20140614T194006
channel t1_cfgser: restore complete, elapsed time: 00:00:36
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95471.arc thread=1 sequence=95471
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95472
channel t1_cfgser: reading from backup piece u3parf4n_1_1
channel t1_cfgser: restored backup piece 1
piece handle=u3parf4n_1_1 tag=TAG20140614T194006
channel t1_cfgser: restore complete, elapsed time: 00:00:16
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95472.arc thread=1 sequence=95472
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95473
channel t1_cfgser: reading from backup piece u6parfe3_1_1
channel t1_cfgser: restored backup piece 1
piece handle=u6parfe3_1_1 tag=TAG20140614T194507
channel t1_cfgser: restore complete, elapsed time: 00:00:16
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95473.arc thread=1 sequence=95473
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95474
channel t1_cfgser: reading from backup piece u9parfe3_1_1
channel t1_cfgser: restored backup piece 1
piece handle=u9parfe3_1_1 tag=TAG20140614T194507
channel t1_cfgser: restore complete, elapsed time: 00:00:17
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95474.arc thread=1 sequence=95474
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95475
channel t1_cfgser: reading from backup piece ubparfnf_1_1
channel t1_cfgser: restored backup piece 1
piece handle=ubparfnf_1_1 tag=TAG20140614T195007
channel t1_cfgser: restore complete, elapsed time: 00:00:26
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95475.arc thread=1 sequence=95475
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95476
channel t1_cfgser: reading from backup piece ueparfnf_1_1
channel t1_cfgser: restored backup piece 1
piece handle=ueparfnf_1_1 tag=TAG20140614T195007
channel t1_cfgser: restore complete, elapsed time: 00:00:16
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95476.arc thread=1 sequence=95476
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95477
channel t1_cfgser: reading from backup piece uhparg0q_1_1
channel t1_cfgser: restored backup piece 1
piece handle=uhparg0q_1_1 tag=TAG20140614T195506
channel t1_cfgser: restore complete, elapsed time: 00:00:16
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95477.arc thread=1 sequence=95477
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95478
channel t1_cfgser: reading from backup piece uiparg0r_1_1
channel t1_cfgser: restored backup piece 1
piece handle=uiparg0r_1_1 tag=TAG20140614T195506
channel t1_cfgser: restore complete, elapsed time: 00:00:16
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95478.arc thread=1 sequence=95478
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95479
channel t1_cfgser: reading from backup piece unpargab_1_1
channel t1_cfgser: restored backup piece 1
piece handle=unpargab_1_1 tag=TAG20140614T200011
channel t1_cfgser: restore complete, elapsed time: 00:00:16
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95479.arc thread=1 sequence=95479
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95480
channel t1_cfgser: reading from backup piece uopargab_1_1
channel t1_cfgser: restored backup piece 1
piece handle=uopargab_1_1 tag=TAG20140614T200011
channel t1_cfgser: restore complete, elapsed time: 00:00:16
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95480.arc thread=1 sequence=95480
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95482
channel t1_cfgser: reading from backup piece uspargjk_1_1
channel t1_cfgser: restored backup piece 1
piece handle=uspargjk_1_1 tag=TAG20140614T200507
channel t1_cfgser: restore complete, elapsed time: 00:00:16
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95481
channel t1_cfgser: reading from backup piece urpargjk_1_1
channel t1_cfgser: restored backup piece 1
piece handle=urpargjk_1_1 tag=TAG20140614T200507
channel t1_cfgser: restore complete, elapsed time: 00:00:26
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95481.arc thread=1 sequence=95481
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95482.arc thread=1 sequence=95482
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95483
channel t1_cfgser: reading from backup piece uvpargt1_1_1
channel t1_cfgser: restored backup piece 1
piece handle=uvpargt1_1_1 tag=TAG20140614T201009
channel t1_cfgser: restore complete, elapsed time: 00:00:26
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95483.arc thread=1 sequence=95483
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95484
channel t1_cfgser: reading from backup piece v1pargt1_1_1
channel t1_cfgser: restored backup piece 1
piece handle=v1pargt1_1_1 tag=TAG20140614T201009
channel t1_cfgser: restore complete, elapsed time: 00:00:17
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95484.arc thread=1 sequence=95484
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95486
channel t1_cfgser: reading from backup piece v7parh6b_1_1
channel t1_cfgser: restored backup piece 1
piece handle=v7parh6b_1_1 tag=TAG20140614T201507
channel t1_cfgser: restore complete, elapsed time: 00:00:16
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95485
channel t1_cfgser: reading from backup piece v5parh6b_1_1
channel t1_cfgser: restored backup piece 1
piece handle=v5parh6b_1_1 tag=TAG20140614T201507
channel t1_cfgser: restore complete, elapsed time: 00:00:16
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95485.arc thread=1 sequence=95485
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95486.arc thread=1 sequence=95486
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95487
channel t1_cfgser: reading from backup piece vqparhp2_1_1
channel t1_cfgser: restored backup piece 1
piece handle=vqparhp2_1_1 tag=TAG20140614T202505
channel t1_cfgser: restore complete, elapsed time: 00:00:26
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95487.arc thread=1 sequence=95487
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95488
channel t1_cfgser: reading from backup piece vrparhp2_1_1
channel t1_cfgser: restored backup piece 1
piece handle=vrparhp2_1_1 tag=TAG20140614T202505
channel t1_cfgser: restore complete, elapsed time: 00:00:17
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95488.arc thread=1 sequence=95488
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95490
channel t1_cfgser: reading from backup piece 00pari2f_1_1
channel t1_cfgser: restored backup piece 1
piece handle=00pari2f_1_1 tag=TAG20140614T203006
channel t1_cfgser: restore complete, elapsed time: 00:00:16
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95489
channel t1_cfgser: reading from backup piece vupari2f_1_1
channel t1_cfgser: restored backup piece 1
piece handle=vupari2f_1_1 tag=TAG20140614T203006
channel t1_cfgser: restore complete, elapsed time: 00:00:16
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95489.arc thread=1 sequence=95489
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95490.arc thread=1 sequence=95490
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95491
channel t1_cfgser: reading from backup piece 03paric1_1_1
channel t1_cfgser: restored backup piece 1
piece handle=03paric1_1_1 tag=TAG20140614T203513
channel t1_cfgser: restore complete, elapsed time: 00:00:16
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95491.arc thread=1 sequence=95491
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95492
channel t1_cfgser: reading from backup piece 05paric1_1_1
channel t1_cfgser: restored backup piece 1
piece handle=05paric1_1_1 tag=TAG20140614T203513
channel t1_cfgser: restore complete, elapsed time: 00:00:16
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95492.arc thread=1 sequence=95492
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95495
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95496
channel t1_cfgser: reading from backup piece 0iparil5_1_1
channel t1_cfgser: restored backup piece 1
piece handle=0iparil5_1_1 tag=TAG20140614T204005
channel t1_cfgser: restore complete, elapsed time: 00:00:16
channel t1_cfgser: starting archive log restore to default destination
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95498
channel t1_cfgser: reading from backup piece 0opariuh_1_1
channel t1_cfgser: restored backup piece 1
piece handle=0opariuh_1_1 tag=TAG20140614T204505
channel t1_cfgser: restore complete, elapsed time: 00:00:16
channel t2_cfgser: starting archive log restore to default destination
channel t1_cfgser: starting archive log restore to default destination
channel t2_cfgser: restoring archive log
archive log thread=1 sequence=95493
channel t2_cfgser: reading from backup piece 09parihk_1_1
channel t1_cfgser: restoring archive log
archive log thread=1 sequence=95497
channel t1_cfgser: reading from backup piece 0mpariuh_1_1
channel t1_cfgser: restored backup piece 1
piece handle=0mpariuh_1_1 tag=TAG20140614T204505
channel t1_cfgser: restore complete, elapsed time: 00:00:16
channel t2_cfgser: restored backup piece 1
piece handle=09parihk_1_1 tag=FULL_CFGSER_201406141805
channel t2_cfgser: restore complete, elapsed time: 00:02:51
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95493.arc thread=1 sequence=95493
channel t2_cfgser: starting archive log restore to default destination
channel t3_cfgser: starting archive log restore to default destination
channel t2_cfgser: restoring archive log
archive log thread=1 sequence=95494
channel t2_cfgser: reading from backup piece 0aparihk_1_1
channel t3_cfgser: restoring archive log
archive log thread=1 sequence=95499
channel t3_cfgser: reading from backup piece 0tparj7t_1_1
channel t3_cfgser: restored backup piece 1
piece handle=0tparj7t_1_1 tag=TAG20140614T205005
channel t3_cfgser: restore complete, elapsed time: 00:00:15
channel t3_cfgser: starting archive log restore to default destination
channel t3_cfgser: restoring archive log
archive log thread=1 sequence=95500
channel t3_cfgser: reading from backup piece 0uparj7t_1_1
channel t3_cfgser: restored backup piece 1
piece handle=0uparj7t_1_1 tag=TAG20140614T205005
channel t3_cfgser: restore complete, elapsed time: 00:00:15
channel t3_cfgser: starting archive log restore to default destination
channel t3_cfgser: restoring archive log
archive log thread=1 sequence=95502
channel t3_cfgser: reading from backup piece 1aparjha_1_1
channel t3_cfgser: restored backup piece 1
piece handle=1aparjha_1_1 tag=TAG20140614T205505
channel t3_cfgser: restore complete, elapsed time: 00:00:15
channel t3_cfgser: starting archive log restore to default destination
channel t3_cfgser: restoring archive log
archive log thread=1 sequence=95501
channel t3_cfgser: reading from backup piece 18parjha_1_1
channel t2_cfgser: restored backup piece 1
piece handle=0aparihk_1_1 tag=FULL_CFGSER_201406141805
channel t2_cfgser: restore complete, elapsed time: 00:01:01
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95494.arc thread=1 sequence=95494
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95495.arc thread=1 sequence=95495
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95496.arc thread=1 sequence=95496
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95497.arc thread=1 sequence=95497
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95498.arc thread=1 sequence=95498
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95499.arc thread=1 sequence=95499
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95500.arc thread=1 sequence=95500
channel t3_cfgser: restored backup piece 1
piece handle=18parjha_1_1 tag=TAG20140614T205505
channel t3_cfgser: restore complete, elapsed time: 00:00:20
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95501.arc thread=1 sequence=95501
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95502.arc thread=1 sequence=95502
channel t3_cfgser: starting archive log restore to default destination
channel t3_cfgser: restoring archive log
archive log thread=1 sequence=95504
channel t3_cfgser: reading from backup piece 1rparjqn_1_1
channel t3_cfgser: restored backup piece 1
piece handle=1rparjqn_1_1 tag=TAG20140614T210006
channel t3_cfgser: restore complete, elapsed time: 00:00:16
channel t3_cfgser: starting archive log restore to default destination
channel t3_cfgser: restoring archive log
archive log thread=1 sequence=95503
channel t3_cfgser: reading from backup piece 1qparjqn_1_1
channel t3_cfgser: restored backup piece 1
piece handle=1qparjqn_1_1 tag=TAG20140614T210006
channel t3_cfgser: restore complete, elapsed time: 00:00:26
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95503.arc thread=1 sequence=95503
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95504.arc thread=1 sequence=95504
archive log filename=/CFGSOMQA/archives/cfgser_600010270_1_95505.arc thread=1 sequence=95505
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/CFGSOMQA/datafile/1_system01.dbf'

media recovery complete, elapsed time: 00:00:04
Finished recover at 20-JUN-14

released channel: t1_cfgser

released channel: t2_cfgser

released channel: t3_cfgser

released channel: t4_cfgser

released channel: t5_cfgser

released channel: t6_cfgser

released channel: t7_cfgser

released channel: t8_cfgser

Recovery Manager complete.
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 20 09:56:54 2014

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL>
SQL>
SQL> desc v$database
Name Null? Type
----------------------------------------- -------- ----------------------------
DBID NUMBER
NAME VARCHAR2(9)
CREATED DATE
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
PRIOR_RESETLOGS_CHANGE# NUMBER
PRIOR_RESETLOGS_TIME DATE
LOG_MODE VARCHAR2(12)
CHECKPOINT_CHANGE# NUMBER
ARCHIVE_CHANGE# NUMBER
CONTROLFILE_TYPE VARCHAR2(7)
CONTROLFILE_CREATED DATE
CONTROLFILE_SEQUENCE# NUMBER
CONTROLFILE_CHANGE# NUMBER
CONTROLFILE_TIME DATE
OPEN_RESETLOGS VARCHAR2(11)
VERSION_TIME DATE
OPEN_MODE VARCHAR2(10)
PROTECTION_MODE VARCHAR2(20)
PROTECTION_LEVEL VARCHAR2(20)
REMOTE_ARCHIVE VARCHAR2(8)
ACTIVATION# NUMBER
SWITCHOVER# NUMBER
DATABASE_ROLE VARCHAR2(16)
ARCHIVELOG_CHANGE# NUMBER
ARCHIVELOG_COMPRESSION VARCHAR2(8)
SWITCHOVER_STATUS VARCHAR2(20)
DATAGUARD_BROKER VARCHAR2(8)
GUARD_STATUS VARCHAR2(7)
SUPPLEMENTAL_LOG_DATA_MIN VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_PK VARCHAR2(3)
SUPPLEMENTAL_LOG_DATA_UI VARCHAR2(3)
FORCE_LOGGING VARCHAR2(3)
PLATFORM_ID NUMBER
PLATFORM_NAME VARCHAR2(101)
RECOVERY_TARGET_INCARNATION# NUMBER
LAST_OPEN_INCARNATION# NUMBER
CURRENT_SCN NUMBER
FLASHBACK_ON VARCHAR2(18)
SUPPLEMENTAL_LOG_DATA_FK VARCHAR2(3)
SUPPLEMENTAL_LOG_DATA_ALL VARCHAR2(3)
DB_UNIQUE_NAME VARCHAR2(30)
STANDBY_BECAME_PRIMARY_SCN NUMBER
FS_FAILOVER_STATUS VARCHAR2(21)
FS_FAILOVER_CURRENT_TARGET VARCHAR2(30)
FS_FAILOVER_THRESHOLD NUMBER
FS_FAILOVER_OBSERVER_PRESENT VARCHAR2(7)
FS_FAILOVER_OBSERVER_HOST VARCHAR2(512)

SQL> select CONTROLFILE_TIME from v$database;

CONTROLFI
---------
16-JUN-14

SQL>
SQL> alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss';

Session altered.

SQL>
SQL> /

Session altered.

SQL> select CONTROLFILE_TIME from v$database;

CONTROLFILE_TIME
-------------------
16-06-2014 19:27:46

SQL>
SQL>
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 6056895885910 generated at 06/14/2014 21:00:00 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95505.arc
ORA-00280: change 6056895885910 for thread 1 is in sequence #95505

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 6056895890628 generated at 06/14/2014 21:00:03 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95506.arc
ORA-00280: change 6056895890628 for thread 1 is in sequence #95506
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95505.arc' no longer
needed for this recovery

ORA-00279: change 6056895897671 generated at 06/14/2014 21:00:06 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95507.arc
ORA-00280: change 6056895897671 for thread 1 is in sequence #95507
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95506.arc' no longer
needed for this recovery

ORA-00279: change 6056895967106 generated at 06/14/2014 21:05:03 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95508.arc
ORA-00280: change 6056895967106 for thread 1 is in sequence #95508
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95507.arc' no longer
needed for this recovery

ORA-00279: change 6056895967186 generated at 06/14/2014 21:05:05 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95509.arc
ORA-00280: change 6056895967186 for thread 1 is in sequence #95509
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95508.arc' no longer
needed for this recovery

ORA-00279: change 6056895988366 generated at 06/14/2014 21:10:04 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95510.arc
ORA-00280: change 6056895988366 for thread 1 is in sequence #95510
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95509.arc' no longer
needed for this recovery

ORA-00279: change 6056895988529 generated at 06/14/2014 21:10:06 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95511.arc
ORA-00280: change 6056895988529 for thread 1 is in sequence #95511
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95510.arc' no longer
needed for this recovery

ORA-00279: change 6056896012309 generated at 06/14/2014 21:15:04 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95512.arc
ORA-00280: change 6056896012309 for thread 1 is in sequence #95512
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95511.arc' no longer
needed for this recovery

ORA-00279: change 6056896012842 generated at 06/14/2014 21:15:06 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95513.arc
ORA-00280: change 6056896012842 for thread 1 is in sequence #95513
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95512.arc' no longer
needed for this recovery

ORA-00279: change 6056896035696 generated at 06/14/2014 21:20:03 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95514.arc
ORA-00280: change 6056896035696 for thread 1 is in sequence #95514
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95513.arc' no longer
needed for this recovery

ORA-00279: change 6056896035953 generated at 06/14/2014 21:20:06 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95515.arc
ORA-00280: change 6056896035953 for thread 1 is in sequence #95515
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95514.arc' no longer
needed for this recovery

ORA-00279: change 6056896067463 generated at 06/14/2014 21:25:03 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95516.arc
ORA-00280: change 6056896067463 for thread 1 is in sequence #95516
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95515.arc' no longer
needed for this recovery

ORA-00279: change 6056896067695 generated at 06/14/2014 21:25:05 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95517.arc
ORA-00280: change 6056896067695 for thread 1 is in sequence #95517
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95516.arc' no longer
needed for this recovery

ORA-00279: change 6056896091947 generated at 06/14/2014 21:30:03 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95518.arc
ORA-00280: change 6056896091947 for thread 1 is in sequence #95518
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95517.arc' no longer
needed for this recovery

ORA-00279: change 6056896092154 generated at 06/14/2014 21:30:05 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95519.arc
ORA-00280: change 6056896092154 for thread 1 is in sequence #95519
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95518.arc' no longer
needed for this recovery

ORA-00279: change 6056896117645 generated at 06/14/2014 21:35:04 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95520.arc
ORA-00280: change 6056896117645 for thread 1 is in sequence #95520
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95519.arc' no longer
needed for this recovery

ORA-00279: change 6056896117766 generated at 06/14/2014 21:35:06 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95521.arc
ORA-00280: change 6056896117766 for thread 1 is in sequence #95521
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95520.arc' no longer
needed for this recovery

ORA-00279: change 6056896121173 generated at 06/14/2014 21:40:03 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95522.arc
ORA-00280: change 6056896121173 for thread 1 is in sequence #95522
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95521.arc' no longer
needed for this recovery

ORA-00279: change 6056896121210 generated at 06/14/2014 21:40:06 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95523.arc
ORA-00280: change 6056896121210 for thread 1 is in sequence #95523
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95522.arc' no longer
needed for this recovery

ORA-00279: change 6056896140679 generated at 06/14/2014 21:45:03 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95524.arc
ORA-00280: change 6056896140679 for thread 1 is in sequence #95524
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95523.arc' no longer
needed for this recovery

ORA-00279: change 6056896140717 generated at 06/14/2014 21:45:06 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95525.arc
ORA-00280: change 6056896140717 for thread 1 is in sequence #95525
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95524.arc' no longer
needed for this recovery

ORA-00279: change 6056896158780 generated at 06/14/2014 21:50:04 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95526.arc
ORA-00280: change 6056896158780 for thread 1 is in sequence #95526
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95525.arc' no longer
needed for this recovery

ORA-00279: change 6056896158814 generated at 06/14/2014 21:50:06 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95527.arc
ORA-00280: change 6056896158814 for thread 1 is in sequence #95527
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95526.arc' no longer
needed for this recovery

ORA-00279: change 6056896178426 generated at 06/14/2014 21:55:03 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95528.arc
ORA-00280: change 6056896178426 for thread 1 is in sequence #95528
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95527.arc' no longer
needed for this recovery

ORA-00279: change 6056896178468 generated at 06/14/2014 21:55:05 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95529.arc
ORA-00280: change 6056896178468 for thread 1 is in sequence #95529
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95528.arc' no longer
needed for this recovery

ORA-00279: change 6056896201687 generated at 06/14/2014 22:00:06 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95530.arc
ORA-00280: change 6056896201687 for thread 1 is in sequence #95530
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95529.arc' no longer
needed for this recovery

ORA-00279: change 6056896210858 generated at 06/14/2014 22:00:09 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95531.arc
ORA-00280: change 6056896210858 for thread 1 is in sequence #95531
ORA-00278: log file '/CFGSOMQA/archives/cfgser_600010270_1_95530.arc' no longer
needed for this recovery

ORA-00308: cannot open archived log
'/CFGSOMQA/archives/cfgser_600010270_1_95531.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 6056896210858 generated at 06/14/2014 22:00:09 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95531.arc
ORA-00280: change 6056896210858 for thread 1 is in sequence #95531

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SQL>
SQL>
SQL>
SQL>
SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/CFGSOMQA/redos/logcfgser4a.rdo
/CFGSOMQA/redos/logcfgser1a.rdo
/CFGSOMQA/redos/logcfgser2a.rdo
/CFGSOMQA/redos/logcfgser3a.rdo
/CFGSOMQA/redos/logcfgser5a.rdo
/CFGSOMQA/redos/logcfgser1b.rdo
/CFGSOMQA/redos/logcfgser2b.rdo
/CFGSOMQA/redos/logcfgser3b.rdo
/CFGSOMQA/redos/logcfgser4b.rdo
/CFGSOMQA/redos/logcfgser5b.rdo

10 rows selected.

SQL>
SQL>
SQL> alter database open resetlogs
2 ;
alter database open resetlogs
*
ERROR at line 1:
ORA-19751: could not create the change tracking file
ORA-19750: change tracking file:
'/CFGSER/INDICE1/tracking_file/tracking_file.f'
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

SQL> alter database disable block change traking;
alter database disable block change traking
*
ERROR at line 1:
ORA-19767: missing TRACKING keyword

SQL>
SQL> alter database disable block change tracing
2 ;
alter database disable block change tracing
*
ERROR at line 1:
ORA-19767: missing TRACKING keyword

SQL>
SQL>
SQL> alter database disable block change
2
SQL>
SQL>
SQL> alter database disable block change tracking ;

Database altered.

SQL>
SQL>
SQL> alter database open;

Database altered.

SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> select file_name, tablespace_name, status from dba_data_files where tablespace_name='TEMP';

no rows selected

SQL> select file_name, tablespace_name, status from dba_data_files where tablespace_name like '%TEMP%';

no rows selected

SQL>
SQL>
SQL> DEsc dba_temp_files
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME NOT NULL VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS CHAR(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER

SQL>
SQL>
SQL> select FILE_NAME, TABLESPACE_NAME from dba_temp_files;
select FILE_NAME, TABLESPACE_NAME from dba_temp_files
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: '/CFGSER/TEMP/cfgser_temp02.dbf'

SQL>
SQL> select 'alter database tempfile '||file#||' drop;' from v$tempfile ;

'ALTERDATABASETEMPFILE'||FILE#||'DROP;'
--------------------------------------------------------------------------------
alter database tempfile 1 drop;
alter database tempfile 2 drop;
alter database tempfile 3 drop;

SQL> alter database tempfile 1 drop;
alter database tempfile 2 drop;
alter database tempfile 3 drop;

Database altered.

SQL>
Database altered.

SQL>
Database altered.

SQL> SQL>
SQL>
SQL>
SQL> select * from database_properties where property_name like '%TEMP%' ;

PROPERTY_NAME
------------------------------
PROPERTY_VALUE
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
DEFAULT_TEMP_TABLESPACE
CFGSER_TEMP
Name of default temporary tablespace

SQL> alter tablespace cfgser_temp add tempfile '/CFGSOMQA/tempfile_01.dbf' size 8G autoextend off ;

Tablespace altered.

SQL>
SQL>
SQL>
SQL> select count(*) from v$datafile where name like '%.dbf' ;

COUNT(*)
----------
109

SQL> select count(*) from v$datafile ;

COUNT(*)
----------
109

SQL> select name from v$tempfile ;

NAME
--------------------------------------------------------------------------------
/CFGSOMQA/tempfile_01.dbf

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL>
SQL>
SQL> startup mount
ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE instance started.

Total System Global Area 4731174912 bytes
Fixed Size 2058456 bytes
Variable Size 536876840 bytes
Database Buffers 4160749568 bytes
Redo Buffers 31490048 bytes
Database mounted.
SQL> SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $nid target = sys dbname = cfgsomqa

DBNEWID: Release 10.2.0.5.0 - Production on Fri Jun 20 10:12:26 2014

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

Password:
Connected to database CFGSER (DBID=3640123222)

Connected to server version 10.2.0

Control Files in database:
/CFGSOMQA/control/control01.ctl
/CFGSOMQA/control/control02.ctl

Change database ID and database name CFGSER to CFGSOMQA? (Y/[N]) => Y

Proceeding with operation
Changing database ID from 3640123222 to 976966621
Changing database name from CFGSER to CFGSOMQA
Control File /CFGSOMQA/control/control01.ctl - modified
Control File /CFGSOMQA/control/control02.ctl - modified
Datafile /CFGSOMQA/datafile/1_system01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/2_cfgser_dat_big_15.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/3_ele_red_dat_sm_04.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/4_users_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/5_fldsrv_dat_peq01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/6_sustadm_dat01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/7_log_errores_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/8_cfgser_ind_med06.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/9_sustadm_ind01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/10_est_act_eve_dat_big_15.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/11_fldsrv_ind_01_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/12_undo_cfgser01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/13_cfgserin_dat_peq01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/14_audit_dat_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/15_undo_cfgser02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/16_cfgserin_dat_peq02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/17_cfgser_dat_big_02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/18_e1adm_dat_peq01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/19_cfgser_dat_big_11.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/20_cfgserin_dat_med01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/21_cfgserin_dat_med02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/22_cfgserin_dat_med03.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/23_cfgser_dat_sm_07.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/24_fldsrv_dat_med01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/25_fldsrv_dat_med02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/26_histocfg_dat01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/27_cfgser_dat_big_03.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/28_cfgser_dat_med01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/29_cfgser_dat_med02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/30_est_act_eve_dat_big_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/31_est_act_eve_dat_big_02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/32_est_act_eve_dat_big_16.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/33_cfgser_ind_med07.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/34_cfgser_dat_med1_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/35_log_errores_05.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/36_est_act_eve_dat_big_03.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/37_est_act_eve_dat_big_04.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/38_idea_ind_peq01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/39_est_act_eve_dat_big_05.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/40_cfgser_dat_big_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/41_cfgser_dat_big_04.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/42_ele_red_dat_sm_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/43_ele_red_dat_sm_02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/44_ele_red_dat_sm_03.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/45_cfgser_ind_med08.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/46_cfgser_ind_med09.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/47_cfgser_ind_med10.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/48_fldsrv_ind_med_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/49_cfgser_dat_big_09.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/50_cfgser_dat_big_10.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/51_patrol01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/53_cfgser_dat_big_12.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/54_est_act_eve_dat_big_06.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/55_est_act_eve_dat_big_08.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/56_cfgser_dat_sm_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/57_cfgser_dat_sm_02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/58_cfgser_dat_sm_03.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/59_cfgser_dat_sm_04.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/60_cfgser_dat_sm_05.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/63_cfgser_dat_sm_06.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/64_cfgser_dat_big_05.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/65_cfgser_dat_big_06.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/66_sysaux01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/67_log_errores_02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/68_log_errores_03.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/69_est_act_eve_dat_big_09.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/71_cfgser_dat_sm_08.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/72_cfgser_dat_big_18.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/73_idea_dat_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/74_idea_dat_02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/75_idea_dat_03.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/76_idea_dat_04.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/77_idea_dat_05.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/78_idea_dat_06.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/79_cfgser_dat_big_07.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/80_cfgser_dat_big_08.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/81_fldsrv_ind_01_02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/82_idea_log01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/84_frtmovil_dat_peq_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/85_fldsrv_ind_01_03.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/86_cfgser_ind_peq01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/88_est_act_eve_dat_big_07.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/89_cfgser_dat_big_14.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/101_cfgser_dat_peq_m1_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/102_cfgser_dat_big_16.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/103_cfgser_dat_big_17.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/105_est_act_eve_dat_big_10.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/106_userconnect_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/110_cfgser_dat_sm_09.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/112_est_act_eve_dat_big_11.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/113_cfgser_dat_sm_10.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/116_fldsrv_ind_01_04.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/120_est_act_eve_dat_big_12.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/121_est_act_eve_dat_big_13.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/125_cfgser_dat_big_19.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/126_cfgser_dat_big_20.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/127_log_errores_04.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/128_est_act_eve_dat_big_14.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/129_cfgser_dat_big_21.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/130_frtmovil_ind_peq_01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/131_sysaux02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/135_e1adm_ind_peq01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/136_cfgserin_ind_peq01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/137_cfgserin_ind_med01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/138_cfgser_ind_med01.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/139_cfgser_ind_med02.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/140_cfgser_ind_med03.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/141_cfgser_ind_med04.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/datafile/142_cfgser_ind_med05.dbf - dbid changed, wrote new name
Datafile /CFGSOMQA/tempfile_01.dbf - dbid changed, wrote new name
Control File /CFGSOMQA/control/control01.ctl - dbid changed, wrote new name
Control File /CFGSOMQA/control/control02.ctl - dbid changed, wrote new name
Instance shut down

Database name changed to CFGSOMQA.
Modify parameter file and generate a new password file before restarting.
Database ID for database CFGSOMQA changed to 976966621.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.

ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $echo $ORACLE_SID
cfgsomqa
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $
ora105@qaora1 [/oracle105/rman/restore/database] $sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 20 10:13:37 2014

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL>
SQL>
SQL> create spfile from pfile
2 ;

File created.

SQL>
SQL>
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 4731174912 bytes
Fixed Size 2058456 bytes
Variable Size 536876840 bytes
Database Buffers 4160749568 bytes
Redo Buffers 31490048 bytes
SQL>
SQL>
SQL>
SQL>
SQL> show parameter dbname
SQL> show parameter db_name

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
db_name string
cfgser
SQL>
SQL>
SQL> alter system set db_name = 'cfgsomqa' scope = spfile;

System altered.

SQL>
SQL> shut abort
ORACLE instance shut down.
SQL>
SQL>
SQL>
SQL> startup mount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 4731174912 bytes
Fixed Size 2058456 bytes
Variable Size 536876840 bytes
Database Buffers 4160749568 bytes
Redo Buffers 31490048 bytes
Database mounted.
SQL>
SQL>
SQL>
SQL> alter database open resetlogs
2 ;

Database altered.

SQL>
SQL>
SQL>
SQL>
SQL>

NOTA
-------------------------------//*
COMANDOS UTILIZADOS POR ING SAMUEL

alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss';
select name, checkpoint_time from v$datafile_header order by 2;

SCN numero de sincronizacion de datafiles

alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss';

Session altered.

SQL>
SQL> /

Session altered.

SQL> select CONTROLFILE_TIME from v$database;

CONTROLFILE_TIME
-------------------
16-06-2014 19:27:46

SQL>
SQL>
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 6056895885910 generated at 06/14/2014 21:00:00 needed for
thread 1
ORA-00289: suggestion : /CFGSOMQA/archives/cfgser_600010270_1_95505.arc
ORA-00280: change 6056895885910 for thread 1 is in sequence #95505

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

canccel

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/CFGSOMQA/redos/logcfgser4a.rdo
/CFGSOMQA/redos/logcfgser1a.rdo
/CFGSOMQA/redos/logcfgser2a.rdo
/CFGSOMQA/redos/logcfgser3a.rdo
/CFGSOMQA/redos/logcfgser5a.rdo
/CFGSOMQA/redos/logcfgser1b.rdo
/CFGSOMQA/redos/logcfgser2b.rdo
/CFGSOMQA/redos/logcfgser3b.rdo
/CFGSOMQA/redos/logcfgser4b.rdo
/CFGSOMQA/redos/logcfgser5b.rdo

10 rows selected.

SQL> alter database open resetlogs
2 ;
alter database open resetlogs
*
ERROR at line 1:
ORA-19751: could not create the change tracking file
ORA-19750: change tracking file:
'/CFGSER/INDICE1/tracking_file/tracking_file.f'
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

SQL> alter database disable block change traking;
alter database disable block change traking
*
ERROR at line 1:
ORA-19767: missing TRACKING keyword

SQL>
SQL> alter database disable block change tracing
2 ;
alter database disable block change tracing
*
ERROR at line 1:
ORA-19767: missing TRACKING keyword

SQL>
SQL>
SQL> alter database disable block change
2
SQL>
SQL>
SQL> alter database disable block change tracking ;

Database altered.

SQL>
SQL>
SQL> alter database open;

----------------------------------------------------------------

ORACLE DATABASE

miércoles, 25 de junio de 2014

RECUPERACION BASE DE DATOS ORACLE (notas - pendiente arreglar)

1 comentario: