SELECT TABLE_NAME,INSERTS,UPDATES,DELETES
FROM USER_TAB_MODIFICATIONS
WHERE TABLE_NAME='TABLA'
It is possible to manually flush this data by calling the procedure DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO if you want to get up-to-date information at query time (internally the monitoring data is flushed before all statistics collection operations). You can then see which tables have stale statistics by querying the STALE_STATS column in the USER_TAB_STATISTICS view
martes, 25 de noviembre de 2014
lunes, 24 de noviembre de 2014
PRUEBA RESTORE ORACLE 11G
Fecha del backup: 05-NOV-2014 21:33:45
=~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2014.11.21 10:58:28 =~=~=~=~=~=~=~=~=~=~=~=
date
Fri Nov 21 10:58:41 COT 2014
[oracle@bddesarrollo ~]$
[oracle@bddesarrollo ~]$
[oracle@bddesarrollo ~]$
[oracle@bddesarrollo ~]$ cd /u02/backup/rman/prueba_restauracion
[oracle@bddesarrollo prueba_restauracion]$ ls -lrt
total 11264448
-rwxrwxrwx 1 oracle oinstall 14590464 Nov 21 10:51 archivelog_FONPETP_2spmskhp_1_1_20141105.bak
-rwxrwxrwx 1 oracle oinstall 21856256 Nov 21 10:51 controlfile_c-2150325182-20141105-00.bak
-rwxrwxrwx 1 oracle oinstall 5798445056 Nov 21 10:53 full_FONPETP_2opmsj5l_1_1_20141105.bak
-rwxrwxrwx 1 oracle oinstall 5576212480 Nov 21 10:55 full_FONPETP_2ppmsj5l_1_1_20141105.bak
-rwxrwxrwx 1 oracle oinstall 123649465 Nov 21 10:55 full_asdbp_110514.dmp.gz
-rwxrwxrwx 1 oracle oinstall 28048 Nov 21 10:55 full_asdbp_110514.log.gz
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 11:01:28 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> SYS@fonpetd> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ asmcmd
ASMCMD> cd +DG_DATA
ASMCMD> ls -lrt
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'
Type Redund Striped Time Sys Name
Y ASDBD/
Y ASM/
Y DB_UNKNOWN/
Y FONPETP/
N fonpetd/
ASMCMD> cd fonpetd/
ASMCMD> ls -lrt
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'
Type Redund Striped Time Sys Name
Y CONTROLFILE/
N DATAFILE/
Y ONLINELOG/
N TEMPFILE/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> rm CONTROLFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 10.
ORA-15032: not all alterations performed
ORA-15173: entry 'CONTROLFILE' does not exist in directory 'fonpetd' (DBD ERROR: OCIStmtExecute)
ASMCMD> rm DATAFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> rn ONLINELOG/
commands:
--------
md_backup, md_restore
lsattr, setattr
cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
mkdir, pwd, rm, rmalias
chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
offline, online, rebal, remap, umount
dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
spmove, spset, startup
chtmpl, lstmpl, mktmpl, rmtmpl
chgrp, chmod, chown, groups, grpmod, lsgrp, lspwusr, lsusr
mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr
volcreate, voldelete, voldisable, volenable, volinfo
volresize, volset, volstat
ASMCMD> ^[[A rm ONLINELOG/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo01a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo02a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo03a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo08b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo08a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo09a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo09b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo10a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo10b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo11a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo11b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo12b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 15.
ORA-15032: not all alterations performed
ORA-15173: entry 'ONLINELOG' does not exist in directory 'fonpetd' (DBD ERROR: OCIStmtExecute)
ASMCMD> ls -l
Type Redund Striped Time Sys Name
N DATAFILE/
N TEMPFILE/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> rm pwd
+DG_DATA/fonpetd
ASMCMD> rm DATAFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD-8002: entry '*' does not exist in directory '+DG_DATA/fonpetd/DATAFILE/'
ASMCMD> rm TEMPFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 25.
ORA-15032: not all alterations performed
ORA-15173: entry 'temp01.dbf' does not exist in directory 'TEMPFILE' (DBD ERROR: OCIStmtExecute)
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> ls TEMPFILE/
ASMCMD> ls DATAFILE/
ASMCMD> ls -l
Type Redund Striped Time Sys Name
N DATAFILE/
N TEMPFILE/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> exit
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [+ASM] ? fonpetd
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 11:05:29 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@fonpetd> alter system set db_name='FONPETP' scope=spfile; start up nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> alter system set db_name='FONPETP' scope=spfile;
System altered.
SYS@fonpetd> alter system set db_file_name_convert='+DG_DATA/fonpetp','+DG_DATA/fonpetd' scope=spfile;
System altered.
SYS@fonpetd> alter system set log_file_name_convert='+DG_DATA/fonpetp','+DG_DATA/fonpetd' scope=spfile;
System altered.
SYS@fonpetd> shu immeiate diate;
ORA-01507: database not mounted
ORACLE instance shut down.
SYS@fonpetd> startup nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary /. oraenvnv
ORACLE_SID = [fonpetd] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:08:28 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpett backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:08:35
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:08:35
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:08:43
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:08:43
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN>
RMAN>
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:08:46 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:08:48
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:08:48
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN> restore controlfile from 'controlfile_c-2150325182-20141105-00.bak /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
Starting restore at 21/11/2014 11:10:17
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/21/2014 11:10:17
RMAN-06171: not connected to target database
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary / oraenv
ORACLE_SID = [fonpetd] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ oraenvrman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:10:33 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN>
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary / oraenv
ORACLE_SID = [fonpetd] ? ^C
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$ ps -efa | grep smon
oracle 3435 1 0 Sep23 ? 00:00:59 asm_smon_+ASM
oracle 3629 1 0 Sep23 ? 00:03:20 ora_smon_asdbd
oracle 27198 1 0 11:08 ? 00:00:00 ora_smon_fonpetd
oracle 27310 25482 0 11:11 pts/0 00:00:00 grep smon
[oracle@bddesarrollo prueba_restauracion]$ ps -efa | grep smon oraenvps -efa | grep smon oraenvrman auxiliary / oraenvrman auxiliary / oraenvrman auxiliary / oraenvrman auxiliary / oraenvps -efa | grep smonps -efa | grep smon oraenvrman auxiliary / oraenvrman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:12:03 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:12:31
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:12:31
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN> s catalog start with '/u02/backup/rman/prueba_restauracion/';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 11/21/2014 11:13:26
RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted
RMAN> restore controlfile from /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "/"
RMAN> restore controlfile from 0 '/u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
Starting restore at 21/11/2014 11:13:51
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/21/2014 11:13:51
RMAN-06171: not connected to target database
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ connrman auxiliary /target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:13:59 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: FONPETP (not mounted)
RMAN> restore controlfile from '/u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
Starting restore at 21/11/2014 11:14:05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=199 device type=DISK
channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/21/2014 11:14:06
ORA-19870: error while restoring backup piece /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak
ORA-19504: failed to create file "+DG_DATA/fonpetd/controlfile/control01.ctl"
ORA-17502: ksfdcre:4 Failed to create file +DG_DATA/fonpetd/controlfile/control01.ctl
ORA-15173: entry 'controlfile' does not exist in directory 'fonpetd'
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ asmcmd
ASMCMD> cd +DG_DATA/fonpetd/controlfile
ASMCMD-8002: entry 'controlfile' does not exist in directory '+DG_DATA/fonpetd/'
ASMCMD> mkdir +DG_DATA/fonpetd/controlfile
ASMCMD> cd +DG_DATA/fonpetd/
ASMCMD> l -l s -l
Type Redund Striped Time Sys Name
N DATAFILE/
N TEMPFILE/
N controlfile/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> mkdir ONLINELOG
ASMCMD> exit
[oracle@bddesarrollo prueba_restauracion]$ asmcmd. oraenvrman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:16:24 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-12001: could not open channel default
RMAN-10008: could not create channel context
RMAN-10002: ORACLE error: ORA-15021: parameter "remote_dependencies_mode" is not valid in asm instance
RMAN-10006: error running SQL statement: alter session set remote_dependencies_mode = signature
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [+ASM] ? fonpetd
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ . oraenvrman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:16:31 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: FONPETP (not mounted)
RMAN>
RMAN> xit exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman target /. oraenvrman target /asmcmd. oraenvrman target /auxiliary
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:16:55 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:16:56
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:16:56
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN> catalog start with -/u02/backup/rman/prueba_restauracion/ - '/u02/backup/rman/prueba_restauracion/';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 11/21/2014 11:17:50
RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:18:55
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:18:55
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:18:57 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:18:58
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:18:58
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN> run
2> {
3> DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location /u02/backup/rman/prueba_restauracion/'; '/u02/backup/rman/prueba_restauracion/';
4> }
Starting Duplicate Db at 21/11/2014 11:19:51
contents of Memory Script:
{
sql clone "alter system set db_name =
''FONPETP'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile from '/u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''FONPETP'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
Starting restore at 21/11/2014 11:20:00
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=393 device type=DISK
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
output file name=+DG_DATA/fonpetd/controlfile/control01.ctl
output file name=+DG_FRA/fonpetd/controlfile/control02.ctl
Finished restore at 21/11/2014 11:20:07
database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=393 device type=DISK
contents of Memory Script:
{
set until scn 110586010;
set newname for datafile 1 to
"+DG_DATA/fonpetd/datafile/system01.dbf";
set newname for datafile 2 to
"+DG_DATA/fonpetd/datafile/sysaux01.dbf";
set newname for datafile 3 to
"+DG_DATA/fonpetd/datafile/undotbs101.dbf";
set newname for datafile 4 to
"+DG_DATA/fonpetd/datafile/users01.dbf";
set newname for datafile 5 to
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf";
set newname for datafile 6 to
"+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf";
set newname for datafile 7 to
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf";
set newname for datafile 8 to
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf";
set newname for datafile 9 to
"+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf";
set newname for datafile 10 to
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf";
set newname for datafile 11 to
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf";
set newname for datafile 12 to
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf";
set newname for datafile 13 to
"+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf";
set newname for datafile 14 to
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf";
set newname for datafile 15 to
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf";
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 21/11/2014 11:20:13
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to +DG_DATA/fonpetd/datafile/system01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00005 to +DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00007 to +DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf
channel ORA_AUX_DISK_1: restoring datafile 00008 to +DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf
channel ORA_AUX_DISK_1: restoring datafile 00010 to +DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00011 to +DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00012 to +DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00015 to +DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak
channel ORA_AUX_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak tag=TAG20141105T211012
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:13:55
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00002 to +DG_DATA/fonpetd/datafile/sysaux01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to +DG_DATA/fonpetd/datafile/undotbs101.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to +DG_DATA/fonpetd/datafile/users01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00006 to +DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf
channel ORA_AUX_DISK_1: restoring datafile 00009 to +DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf
channel ORA_AUX_DISK_1: restoring datafile 00013 to +DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf
channel ORA_AUX_DISK_1: restoring datafile 00014 to +DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak
channel ORA_AUX_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak tag=TAG20141105T211012
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:14:45
Finished restore at 21/11/2014 11:48:55
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=16 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=17 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=18 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/undotbs101.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=19 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=20 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=21 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=22 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=23 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=24 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=25 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=26 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=27 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=28 STAMP=864215336 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=29 STAMP=864215336 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=30 STAMP=864215336 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf
contents of Memory Script:
{
set until scn 110586010;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 21/11/2014 11:48:57
using channel ORA_AUX_DISK_1
starting media recovery
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=8884
channel ORA_AUX_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
channel ORA_AUX_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak tag=TAG20141105T213317
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+DG_FRA/fonpetp/archivelog/2014_11_21/thread_1_seq_8884.859.864215339 thread=1 sequence=8884
channel clone_default: deleting archived log(s)
archived log file name=+DG_FRA/fonpetp/archivelog/2014_11_21/thread_1_seq_8884.859.864215339 RECID=1 STAMP=864215338
media recovery complete, elapsed time: 00:00:03
Finished recover at 21/11/2014 11:49:02
Oracle instance started
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''FONPETD'' comment=
''Reset to original value by RMAN'' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''FONPETD'' comment= ''Reset to original value by RMAN'' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "FONPETD" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 2920
LOGFILE
GROUP 1 ( '+DG_DATA/fonpetd/onlinelog/redo01a.rdo', '+DG_FRA/fonpetp/onlinelog/redo01b.rdo' ) SIZE 50 M REUSE,
GROUP 2 ( '+DG_DATA/fonpetd/onlinelog/redo02a.rdo', '+DG_FRA/fonpetp/onlinelog/redo02b.rdo' ) SIZE 50 M REUSE,
GROUP 3 ( '+DG_DATA/fonpetd/onlinelog/redo03a.rdo', '+DG_FRA/fonpetp/onlinelog/redo03b.rdo' ) SIZE 50 M REUSE,
GROUP 8 ( '+DG_DATA/fonpetd/onlinelog/redo08b.rdo', '+DG_DATA/fonpetd/onlinelog/redo08a.rdo' ) SIZE 50 M REUSE,
GROUP 9 ( '+DG_DATA/fonpetd/onlinelog/redo09a.rdo', '+DG_DATA/fonpetd/onlinelog/redo09b.rdo' ) SIZE 50 M REUSE,
GROUP 10 ( '+DG_DATA/fonpetd/onlinelog/redo10a.rdo', '+DG_DATA/fonpetd/onlinelog/redo10b.rdo' ) SIZE 50 M REUSE,
GROUP 11 ( '+DG_DATA/fonpetd/onlinelog/redo11a.rdo', '+DG_DATA/fonpetd/onlinelog/redo11b.rdo' ) SIZE 50 M REUSE,
GROUP 12 ( '+DG_DATA/fonpetd/onlinelog/redo12b.rdo', '+DG_DATA/fonpetd/onlinelog/redo12a.rdo' ) SIZE 50 M REUSE
DATAFILE
'+DG_DATA/fonpetd/datafile/system01.dbf'
CHARACTER SET WE8ISO8859P1
contents of Memory Script:
{
set newname for tempfile 1 to
"+DG_DATA/fonpetd/tempfile/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "+DG_DATA/fonpetd/datafile/sysaux01.dbf",
"+DG_DATA/fonpetd/datafile/undotbs101.dbf",
"+DG_DATA/fonpetd/datafile/users01.dbf",
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf",
"+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf",
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf",
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf",
"+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf",
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf",
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf",
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf",
"+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf",
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf",
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to +DG_DATA/fonpetd/tempfile/temp01.dbf in control file
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/sysaux01.dbf RECID=1 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/undotbs101.dbf RECID=2 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/users01.dbf RECID=3 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf RECID=4 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf RECID=5 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf RECID=6 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf RECID=7 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf RECID=8 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf RECID=9 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf RECID=10 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf RECID=11 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf RECID=12 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf RECID=13 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf RECID=14 STAMP=864215362
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/undotbs101.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf
Reenabling controlfile options for auxiliary database
Executing: alter database force logging
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 21/11/2014 11:50:00
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ sqlplus dabba_fopnpet as sgsysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 11:50:16 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> select count(1) from dba_segments;
COUNT(1)
----------
6314
SYS@fonpetd> select name, , open_mode, dbid from v$database;
NAME OPEN_MODE DBID
--------- -------------------- ----------
FONPETD READ WRITE 1247845184
SYS@fonpetd> col name format a50
SYS@fonpetd> set lines 1000 pages 10000
SYS@fonpetd> seect lect name, bytes s, status from v$datafile;
NAMEBYTES STATUS
-------------------------------------------------- ---------- -------
+DG_DATA/fonpetd/datafile/system01.dbf 1461714944 SYSTEM
+DG_DATA/fonpetd/datafile/sysaux01.dbf 2006974464 ONLINE
+DG_DATA/fonpetd/datafile/undotbs101.dbf 1073741824 ONLINE
+DG_DATA/fonpetd/datafile/users01.dbf 196608000 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.db 5309988864 ONLINE
f
+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf 594214912 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf 3463774208 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg 2621440000 ONLINE
0.dbf
+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf 104857600 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf 9154789376 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.db 5146411008 ONLINE
f
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf 3145728000 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf 1073741824 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf 3.4318E+10 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf 7130316800 ONLINE
15 rows selected.
SYS@fonpetd> col name format a50 6
SYS@fonpetd> /
NAME BYTES STATUS
-------------------------------------------------------- ---------- -------
+DG_DATA/fonpetd/datafile/system01.dbf 1461714944 SYSTEM
+DG_DATA/fonpetd/datafile/sysaux01.dbf 2006974464 ONLINE
+DG_DATA/fonpetd/datafile/undotbs101.dbf 1073741824 ONLINE
+DG_DATA/fonpetd/datafile/users01.dbf 196608000 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf 5309988864 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf 594214912 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf 3463774208 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf 2621440000 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf 104857600 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf 9154789376 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf 5146411008 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf 3145728000 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf 1073741824 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf 3.4318E+10 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf 7130316800 ONLINE
15 rows selected.
SYS@fonpetd> selec select member, status from v$logfile;
MEMBER STATUS
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------
+DG_DATA/fonpetd/onlinelog/redo12b.rdo
+DG_DATA/fonpetd/onlinelog/redo12a.rdo
+DG_DATA/fonpetd/onlinelog/redo11a.rdo
+DG_DATA/fonpetd/onlinelog/redo11b.rdo
+DG_DATA/fonpetd/onlinelog/redo10a.rdo
+DG_DATA/fonpetd/onlinelog/redo10b.rdo
+DG_DATA/fonpetd/onlinelog/redo09a.rdo
+DG_DATA/fonpetd/onlinelog/redo09b.rdo
+DG_DATA/fonpetd/onlinelog/redo08b.rdo
+DG_DATA/fonpetd/onlinelog/redo08a.rdo
+DG_DATA/fonpetd/onlinelog/redo03a.rdo
+DG_FRA/fonpetp/onlinelog/redo03b.rdo
+DG_DATA/fonpetd/onlinelog/redo02a.rdo
+DG_FRA/fonpetp/onlinelog/redo02b.rdo
+DG_DATA/fonpetd/onlinelog/redo01a.rdo
+DG_FRA/fonpetp/onlinelog/redo01b.rdo
16 rows selected.
SYS@fonpetd> ^[[6~
SYS@fonpetd>
SYS@fonpetd> shw p pw p pw pa ow parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +DG_FRA
db_recovery_file_dest_size big integer 70G
recovery_parallelism integer 0
SYS@fonpetd> show show para meter unique
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string FONPETD
SYS@fonpetd> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string FONPETD
SYS@fonpetd> spw show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string fonpetd
SYS@fonpetd> exit show
SYS@fonpetd>
SYS@fonpetd>
SYS@fonpetd> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> xi exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ asmcmd
ASMCMD> rm cd +DG_DATA/fonpet petd
ASMCMD> ls l -l
Type Redund Striped Time Sys Name
N DATAFILE/
N ONLINELOG/
N TEMPFILE/
N controlfile/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD> rm DATAFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> rm ONLINELOG/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo01a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo02a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo03a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo08b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo08a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo09a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo09b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo10a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo10b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo11a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo11b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo12b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 6.
ORA-15032: not all alterations performed
ORA-15173: entry 'redo12a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
ASMCMD> rm TEMPFILE/
ORA-15032: not all alterations performed
ORA-15178: directory 'TEMPFILE' is not empty; cannot drop this directory (DBD ERROR: OCIStmtExecute)
ASMCMD> rm controlfile/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> rm TEMPFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336, line 11.
ORA-15032: not all alterations performed
ORA-15173: entry 'temp01.dbf' does not exist in directory 'TEMPFILE' (DBD ERROR: OCIStmtExecute)
ASMCMD> ls -l
Type Redund Striped Time Sys Name
N DATAFILE/
N ONLINELOG/
N TEMPFILE/
N controlfile/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD> ls -l DATAFILE/
ASMCMD> ls -l ONLINELOG/
ASMCMD> ls -l TEMPFILE/
ASMCMD> ls -l controlfile/
ASMCMD> rm dir controlfile/
ASMCMD> M mkdir CONTROLFILE rm DATAFILE/
ASMCMD> rm ONLINELOG/
ASMCMD> rm TEMPFILE/
ASMCMD> ls -l
Type Redund Striped Time Sys Name
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD> mkdir DATAFILE/
ASMCMD> mkdir ONLINELOG/
ASMCMD> mkdir TEMPFILE/
ASMCMD> mkdir CONTOLFIL N CONTROLFILE
ASMCMD> LS -L ls-lrt -lrt
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'
Type Redund Striped Time Sys Name
N CONTROLFILE/
N DATAFILE/
N ONLINELOG/
N TEMPFILE/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD> exit
[oracle@bddesarrollo prueba_restauracion]$ sqlplus da_ / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 12:00:14 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@+ASM>
SYS@+ASM> startup nomount;
ORA-01031: insufficient privileges
SYS@+ASM> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [+ASM] ? fonpetd
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ . oraenvsqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 12:00:45 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@fonpetd>
SYS@fonpetd> startup nomout unt
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> show parameer ter dba_ _name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string FONPETD
SYS@fonpetd> show parm ameter uniqie ique
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string FONPETD
SYS@fonpetd> show parameter instance
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 1
instance_groups string
instance_name string fonpetd
instance_number integer 0
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 1
SYS@fonpetd> alter system st et db_name=FONPETP scope=spfile;
System altered.
SYS@fonpetd> show parameter convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string +DG_DATA/fonpetp, +DG_DATA/fon
petd
log_file_name_convert string +DG_DATA/fonpetp, +DG_DATA/fon
petd
SYS@fonpetd> shu i alter system st et db_file_name_convert='+DG_DATA/fonpetp, +DG_DATA/fonpetd' sc cope=spfile;
alter system set db_file_name_convert='+DG_DATA/fonpetp, +DG_DATA/fonpetd' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-01678: parameter db_file_name_convert must be pairs of pattern and
replacement strings
SYS@fonpetd> alter system set db_file_name_convert='+DG_DATA/fonpetp','+DG_DATA/fonpetd' scope=spfile;
System altered.
SYS@fonpetd> alter system set log_file_name_convert='+DG_DATA/fonpetp0, ','+DG_DATA/fonpetd' scope=spfile;
System altered.
SYS@fonpetd> s shu mmediate immediate, ;
ORA-01507: database not mounted
ORACLE instance shut down.
SYS@fonpetd> startup nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> exi ext
SP2-0042: unknown command "ext" - rest of line ignored.
SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
[oracle@bddesarrollo prueba_restauracion]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 12:05:11 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: FONPETP (not mounted)
RMAN> restore controlfile from /u02/backup/rman/prueba_restauracion '/u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
Starting restore at 21/11/2014 12:05:38
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=393 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DG_DATA/fonpetd/controlfile/control01.ctl
output file name=+DG_FRA/fonpetd/controlfile/control02.ctl
Finished restore at 21/11/2014 12:05:39
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> crosscheck backup;
Starting implicit crosscheck backup at 21/11/2014 12:06:08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
Crosschecked 10 objects
Finished implicit crosscheck backup at 21/11/2014 12:06:10
Starting implicit crosscheck copy at 21/11/2014 12:06:10
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 21/11/2014 12:06:10
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2jpmpuph_1_1_20141104.bak RECID=2034 STAMP=862780213
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2ipmpuph_1_1_20141104.bak RECID=2035 STAMP=862780209
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2lpmq03u_1_1_20141104.bak RECID=2037 STAMP=862781567
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/controlfile_c-2150325182-20141104-00.bak RECID=2039 STAMP=862781604
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2ppmsj5l_1_1_20141105.bak RECID=2040 STAMP=862866617
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2opmsj5l_1_1_20141105.bak RECID=2041 STAMP=862866614
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2qpmskgv_1_1_20141105.bak RECID=2042 STAMP=862867999
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2rpmskh0_1_1_20141105.bak RECID=2043 STAMP=862868000
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2spmskhp_1_1_20141105.bak RECID=2044 STAMP=862868025
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/controlfile_FONPETP_2tpmski1_1_1_20141105.bak RECID=2045 STAMP=862868034
Crosschecked 10 objects
RMAN-08591: WARNING: invalid archived log deletion policy
RMAN> cro crosscheck archivel l ogg ll all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
specification does not match any archived log in the repository
RMAN> cro delete expired backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
2034 2031 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/full_FONPETP_2jpmpuph_1_1_20141104.bak
2035 2032 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/full_FONPETP_2ipmpuph_1_1_20141104.bak
2037 2034 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/archivelog_FONPETP_2lpmq03u_1_1_20141104.bak
2039 2036 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/controlfile_c-2150325182-20141104-00.bak
2040 2037 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/full_FONPETP_2ppmsj5l_1_1_20141105.bak
2041 2038 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/full_FONPETP_2opmsj5l_1_1_20141105.bak
2042 2039 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/archivelog_FONPETP_2qpmskgv_1_1_20141105.bak
2043 2040 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/archivelog_FONPETP_2rpmskh0_1_1_20141105.bak
2044 2041 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
2045 2042 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/controlfile_FONPETP_2tpmski1_1_1_20141105.bak
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2jpmpuph_1_1_20141104.bak RECID=2034 STAMP=862780213
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2ipmpuph_1_1_20141104.bak RECID=2035 STAMP=862780209
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2lpmq03u_1_1_20141104.bak RECID=2037 STAMP=862781567
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/controlfile_c-2150325182-20141104-00.bak RECID=2039 STAMP=862781604
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2ppmsj5l_1_1_20141105.bak RECID=2040 STAMP=862866617
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2opmsj5l_1_1_20141105.bak RECID=2041 STAMP=862866614
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2qpmskgv_1_1_20141105.bak RECID=2042 STAMP=862867999
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2rpmskh0_1_1_20141105.bak RECID=2043 STAMP=862868000
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2spmskhp_1_1_20141105.bak RECID=2044 STAMP=862868025
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/controlfile_FONPETP_2tpmski1_1_1_20141105.bak RECID=2045 STAMP=862868034
Deleted 10 EXPIRED objects
RMAN-08591: WARNING: invalid archived log deletion policy
RMAN> delete expired ARCHIVELOG ALL;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
specification does not match any archived log in the repository
RMAN> restore
RMAN> catalog da start i with '/u02/backup/rman/prueba_restauracion';
searching for all files that match the pattern /u02/backup/rman/prueba_restauracion
List of Files Unknown to the Database
=====================================
File Name: /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak
File Name: /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_asdbp_110514.dmp.gz
File Name: /u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_asdbp_110514.log.gz
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak
File Name: /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak
List of Files Which Where Not Cataloged
=======================================
File Name: /u02/backup/rman/prueba_restauracion/full_asdbp_110514.dmp.gz
RMAN-07517: Reason: The file header is corrupted
File Name: /u02/backup/rman/prueba_restauracion/full_asdbp_110514.log.gz
RMAN-07517: Reason: The file header is corrupted
RMAN> restore database;
Starting restore at 21/11/2014 12:08:27
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DG_DATA/fonpetp/datafile/system01.dbf
channel ORA_DISK_1: restoring datafile 00005 to +DG_DATA/fonpetp/datafile/indic_fonpet_movim_01.dbf
channel ORA_DISK_1: restoring datafile 00007 to +DG_DATA/fonpetp/datafile/indic_fonpet_movim.dbf
channel ORA_DISK_1: restoring datafile 00008 to +DG_DATA/fonpetp/datafile/indic_fonpet_movim_reorg0.dbf
channel ORA_DISK_1: restoring datafile 00010 to +DG_DATA/fonpetp/datafile/ts_fonpet_movim_01.dbf
channel ORA_DISK_1: restoring datafile 00011 to +DG_DATA/fonpetp/datafile/indic_fonpet_movim_02.dbf
channel ORA_DISK_1: restoring datafile 00012 to +DG_DATA/fonpetp/datafile/ts_fonpet_movim_02.dbf
channel ORA_DISK_1: restoring datafile 00015 to +DG_DATA/fonpetp/datafile/ts_fonpet_movim_2.dbf
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak
channel ORA_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak tag=TAG20141105T211012
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:14:06
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to +DG_DATA/fonpetp/datafile/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to +DG_DATA/fonpetp/datafile/undotbs101.dbf
channel ORA_DISK_1: restoring datafile 00004 to +DG_DATA/fonpetp/datafile/users01.dbf
channel ORA_DISK_1: restoring datafile 00006 to +DG_DATA/fonpetp/datafile/indic_fonpet_param.dbf
channel ORA_DISK_1: restoring datafile 00009 to +DG_DATA/fonpetp/datafile/ts_fonpet_param.dbf
channel ORA_DISK_1: restoring datafile 00013 to +DG_DATA/fonpetp/datafile/ts_fonpet_rep.dbf
channel ORA_DISK_1: restoring datafile 00014 to +DG_DATA/fonpetp/datafile/ts_fonpet_movim.dbf
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak
channel ORA_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak tag=TAG20141105T211012
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:14:55
Finished restore at 21/11/2014 12:37:28
RMAN>
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ aexport rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 12:53:47 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: FONPETP (DBID=2150325182, not open)
RMAN> LIST BACKU UP OF ARCHIVELOG ALL<
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "<"
RMAN> LIST BACKUP OF ARCHIVELOG ALL< < ;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
2043 13.91M DISK 00:00:00 05/11/2014 21:33:45
BP Key: 2046 Status: AVAILABLE Compressed: NO Tag: TAG20141105T213317
Piece Name: /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
List of Archived Logs in backup set 2043
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 8884 110575832 05/11/2014 20:00:09 110586010 05/11/2014 21:33:15
RMAN> restoe o recover list backup of controlfile<
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "<"
RMAN> list backup of controlfileñ ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, controlfile, database, datafile, foreign, spfile, tablespace"
RMAN-01008: the bad identifier was: controlfile
RMAN-01007: at line 1 column 17 file: standard input
RMAN> lit l list backup of controlfile;
specification does not match any backup in the repository
RMAN> recover database until logseq 8884; 5. ;
Starting recover at 21/11/2014 12:55:15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=580 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/21/2014 12:55:16
ORA-19698: +DG_FRA/fonpetp/onlinelog/redo01b.rdo is from different database: id=1247845184, db_name=FONPETD
RMAN> re exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysbasdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 12:57:04 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> show parameer ter db_bame
SYS@fonpetd> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string FONPETP
SYS@fonpetd> alter system se set db_name=' 'FONPETP' scope=spfi D' scope=spfie ile;
alter system set db_name='FONPETD' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-32016: parameter "db_name" cannot be updated in SPFILE
SYS@fonpetd> shu immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> startup nomount pfile; ;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> alter system set db_name='FONPETD' scope=spfile
2 ;
System altered.
SYS@fonpetd> al alter shu immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
ORA-01103: database name 'FONPETP' in control file is not 'FONPETD'
SYS@fonpetd> show parameter lo convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string +DG_DATA/fonpetp, +DG_DATA/fon
petd
log_file_name_convert string +DG_DATA/fonpetp, +DG_DATA/fon
petd
SYS@fonpetd> alter alter sye ession = ystem set db_name=FONPETD P scope? =sf pfile;
System altered.
SYS@fonpetd> shu immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
[oracle@bddesarrollo prueba_restauracion]$ .oa oraenv}
ORACLE_SID = [fonpetd] ? *AS +as ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ cd +DG_FRA/fonpetp/onlinelog/redo01b.rdo
-bash: cd: +DG_FRA/fonpetp/onlinelog/: No such file or directory
[oracle@bddesarrollo prueba_restauracion]$ ls -lasmcmd
ASMCMD> cd +DG_FRA/fonpetp/onlinelog/
ASMCMD> ls -lr
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'
Type Redund Striped Time Sys Name
N redo03b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_3.707.864215385
N redo02b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_2.706.864215383
N redo01b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_1.705.864215383
ASMCMD> rm ls l- -l
Type Redund Striped Time Sys Name
N redo01b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_1.705.864215383
N redo02b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_2.706.864215383
N redo03b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_3.707.864215385
ASMCMD> rm redo*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> exit
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [+ASM] ? fonped petd
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 13:01:35 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> alter database mount;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 11/21/2014 13:01:42
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
RMAN> startup mount;
Oracle instance started
database mounted
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
2043 13.91M DISK 00:00:00 05/11/2014 21:33:45
BP Key: 2046 Status: AVAILABLE Compressed: NO Tag: TAG20141105T213317
Piece Name: /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
List of Archived Logs in backup set 2043
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 8884 110575832 05/11/2014 20:00:09 110586010 05/11/2014 21:33:15
RMAN> recover database until logeq 8884 5;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "scn, sequence, time"
RMAN-01008: the bad identifier was: logeq
RMAN-01007: at line 1 column 24 file: standard input
RMAN> recover database until logseq 8885;
Starting recover at 21/11/2014 13:02:37
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=8 device type=DISK
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=8884
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
channel ORA_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak tag=TAG20141105T213317
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+DG_FRA/fonpetp/archivelog/2014_11_21/thread_1_seq_8884.707.864219759 thread=1 sequence=8884
channel default: deleting archived log(s)
archived log file name=+DG_FRA/fonpetp/archivelog/2014_11_21/thread_1_seq_8884.707.864219759 RECID=27540 STAMP=864219759
media recovery complete, elapsed time: 00:00:03
Finished recover at 21/11/2014 13:02:43
RMAN> alter database open resetlogs;
database opened
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman target /. oraenvrman target /sqlplus / as ssdbaysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:05:37 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> select name, dbid, statos s us
SYS@fonpetd>
SYS@fonpetd> ^[[A^[[A exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdbarman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 13:06:01 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: FONPETP (DBID=2150325182)
RMAN> sql 'select name, dbid , open_mode rom v from v$database';
using target database control file instead of recovery catalog
sql statement: select name, dbid, open_mode from v$database
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman target /sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:06:40 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> select name, dbid, open_mode from v$database;
NAMEDBID OPEN_MODE
--------- ---------- --------------------
FONPETP 2150325182 READ WRITE
SYS@fonpetd> altr syste set m set shu shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
Database mounted.
SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ dbnewid
-bash: dbnewid: command not found
[oracle@bddesarrollo prueba_restauracion]$ dbnewidnid
DBNEWID: Release 11.2.0.3.0 - Production on Fri Nov 21 13:07:56 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Keyword Description (Default)
----------------------------------------------------
TARGET Username/Password (NONE)
DBNAME New database name (NONE)
LOGFILE Output Log (NONE)
REVERT Revert failed change NO
SETNAME Set a new database name only NO
APPEND Append to output log NO
HELP Displays these messages NO
[oracle@bddesarrollo prueba_restauracion]$ nid TARGET=7/ as sysda DBNAME=FONPED
DBNEWID: Release 11.2.0.3.0 - Production on Fri Nov 21 13:08:15 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to database FONPETP (DBID=2150325182)
Connected to server version 11.2.0
Control Files in database:
+DG_DATA/fonpetd/controlfile/control01.ctl
+DG_FRA/fonpetd/controlfile/control02.ctl
Change database ID and database name FONPETP to FONPED? (Y/[N]) => y Y
Proceeding with operation
Changing database ID from 2150325182 to 2659586623
Changing database name from FONPETP to FONPED
Control File +DG_DATA/fonpetd/controlfile/control01.ctl - modified
Control File +DG_FRA/fonpetd/controlfile/control02.ctl - modified
Datafile +DG_DATA/fonpetp/datafile/system01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/sysaux01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/undotbs101.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/users01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_param.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_reorg0.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_param.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_02.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_02.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_rep.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_2.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/tempfile/temp01.db - dbid changed, wrote new name
Control File +DG_DATA/fonpetd/controlfile/control01.ctl - dbid changed, wrote new name
Control File +DG_FRA/fonpetd/controlfile/control02.ctl - dbid changed, wrote new name
Instance shut down
Database name changed to FONPED.
Modify parameter file and generate a new password file before restarting.
Database ID for database FONPED changed to 2659586623.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
[oracle@bddesarrollo prueba_restauracion]$ nid TARGET=/ DBNAME=FONPEDnid TARGET=/ DBNAME=FONPEDtDDTD
DBNEWID: Release 11.2.0.3.0 - Production on Fri Nov 21 13:09:09 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
NID-00106: LOGIN to target database failed with Oracle error:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
Change of database name failed during validation - database is intact.
DBNEWID - Completed with validation errors.
[oracle@bddesarrollo prueba_restauracion]$ .sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:09:18 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
ORA-01103: database name 'FONPED' in control file is not 'FONPETP'
SYS@fonpetd> show parameter dba_name
SYS@fonpetd> show mara p parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string FONPETP
SYS@fonpetd> shw show parameter ^[[A alter exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
[oracle@bddesarrollo prueba_restauracion]$ rmarrman rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 13:10:46 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: FONPETP (not mounted)
RMAN> list incart nation of database;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 11/21/2014 13:10:51
ORA-01507: database not mounted
RMAN> alter exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ salter system setrman target /sqlplus / as sysdbanid TARGET=/ DBNAME=FONPETDsqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:11:07 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> altersytem set system set dbn _name=^[[5~ 'FONPED. '
2
SYS@fonpetd> shu abort;
ORACLE instance shut down.
SYS@fonpetd> start startuu p nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> alter system set db_name='FONPED'
2 scope=spfile;
System altered.
SYS@fonpetd> shu abort;
ORACLE instance shut down.
SYS@fonpetd> startup nomoun mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
Database mounted.
SYS@fonpetd> alter database open resetlogs;
Database altered.
SYS@fonpetd> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
Database mounted.
SYS@fonpetd> alter exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdbarman target /sqlplus / as sysdbanid TARGET=/ DBNAME=FONPETD
DBNEWID: Release 11.2.0.3.0 - Production on Fri Nov 21 13:14:32 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to database FONPED (DBID=2659586623)
Connected to server version 11.2.0
Control Files in database:
+DG_DATA/fonpetd/controlfile/control01.ctl
+DG_FRA/fonpetd/controlfile/control02.ctl
Change database ID and database name FONPED to FONPETD? (Y/[N]) => y
Proceeding with operation
Changing database ID from 2659586623 to 1247841337
Changing database name from FONPED to FONPETD
Control File +DG_DATA/fonpetd/controlfile/control01.ctl - modified
Control File +DG_FRA/fonpetd/controlfile/control02.ctl - modified
Datafile +DG_DATA/fonpetp/datafile/system01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/sysaux01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/undotbs101.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/users01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_param.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_reorg0.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_param.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_02.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_02.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_rep.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_2.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/tempfile/temp01.db - dbid changed, wrote new name
Control File +DG_DATA/fonpetd/controlfile/control01.ctl - dbid changed, wrote new name
Control File +DG_FRA/fonpetd/controlfile/control02.ctl - dbid changed, wrote new name
Instance shut down
Database name changed to FONPETD.
Modify parameter file and generate a new password file before restarting.
Database ID for database FONPETD changed to 1247841337.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
[oracle@bddesarrollo prueba_restauracion]$ orapwd file?=$ORACLE_HOME /NETnet/u01/app/oracle/product/11.2.0/dbhome_1/network/dbs/pwdf/orapwfonpetd passwoforce=Y password?0=Nuevuevo123 entries?=43
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:15:46 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@fonpetd> startup nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> alter show parameter db_bame name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string FONPED
SYS@fonpetd> alter syte set alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01103: database name 'FONPETD' in control file is not 'FONPED'
SYS@fonpetd> a alter syste se mt set db_name=FON 'FONPETD' soc cope? =spfile;
System altered.
SYS@fonpetd> shu s shu a i¿ shu abort;
ORACLE instance shut down.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
Database mounted.
SYS@fonpetd> alter database open s resetlogs;
Database altered.
SYS@fonpetd>
=~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2014.11.21 10:58:28 =~=~=~=~=~=~=~=~=~=~=~=
date
Fri Nov 21 10:58:41 COT 2014
[oracle@bddesarrollo ~]$
[oracle@bddesarrollo ~]$
[oracle@bddesarrollo ~]$
[oracle@bddesarrollo ~]$ cd /u02/backup/rman/prueba_restauracion
[oracle@bddesarrollo prueba_restauracion]$ ls -lrt
total 11264448
-rwxrwxrwx 1 oracle oinstall 14590464 Nov 21 10:51 archivelog_FONPETP_2spmskhp_1_1_20141105.bak
-rwxrwxrwx 1 oracle oinstall 21856256 Nov 21 10:51 controlfile_c-2150325182-20141105-00.bak
-rwxrwxrwx 1 oracle oinstall 5798445056 Nov 21 10:53 full_FONPETP_2opmsj5l_1_1_20141105.bak
-rwxrwxrwx 1 oracle oinstall 5576212480 Nov 21 10:55 full_FONPETP_2ppmsj5l_1_1_20141105.bak
-rwxrwxrwx 1 oracle oinstall 123649465 Nov 21 10:55 full_asdbp_110514.dmp.gz
-rwxrwxrwx 1 oracle oinstall 28048 Nov 21 10:55 full_asdbp_110514.log.gz
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 11:01:28 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> SYS@fonpetd> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ asmcmd
ASMCMD> cd +DG_DATA
ASMCMD> ls -lrt
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'
Type Redund Striped Time Sys Name
Y ASDBD/
Y ASM/
Y DB_UNKNOWN/
Y FONPETP/
N fonpetd/
ASMCMD> cd fonpetd/
ASMCMD> ls -lrt
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'
Type Redund Striped Time Sys Name
Y CONTROLFILE/
N DATAFILE/
Y ONLINELOG/
N TEMPFILE/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> rm CONTROLFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'CONTROLFILE' does not exist in directory 'fonpetd' (DBD ERROR: OCIStmtExecute)
ASMCMD> rm DATAFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> rn ONLINELOG/
commands:
--------
md_backup, md_restore
lsattr, setattr
cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
mkdir, pwd, rm, rmalias
chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
offline, online, rebal, remap, umount
dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
spmove, spset, startup
chtmpl, lstmpl, mktmpl, rmtmpl
chgrp, chmod, chown, groups, grpmod, lsgrp, lspwusr, lsusr
mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr
volcreate, voldelete, voldisable, volenable, volinfo
volresize, volset, volstat
ASMCMD> ^[[A rm ONLINELOG/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo01a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo02a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo03a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo08b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo08a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo09a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo09b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo10a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo10b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo11a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo11b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo12b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'ONLINELOG' does not exist in directory 'fonpetd' (DBD ERROR: OCIStmtExecute)
ASMCMD> ls -l
Type Redund Striped Time Sys Name
N DATAFILE/
N TEMPFILE/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> rm pwd
+DG_DATA/fonpetd
ASMCMD> rm DATAFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD-8002: entry '*' does not exist in directory '+DG_DATA/fonpetd/DATAFILE/'
ASMCMD> rm TEMPFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'temp01.dbf' does not exist in directory 'TEMPFILE' (DBD ERROR: OCIStmtExecute)
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> ls TEMPFILE/
ASMCMD> ls DATAFILE/
ASMCMD> ls -l
Type Redund Striped Time Sys Name
N DATAFILE/
N TEMPFILE/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> exit
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [+ASM] ? fonpetd
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 11:05:29 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@fonpetd> alter system set db_name='FONPETP' scope=spfile; start up nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> alter system set db_name='FONPETP' scope=spfile;
System altered.
SYS@fonpetd> alter system set db_file_name_convert='+DG_DATA/fonpetp','+DG_DATA/fonpetd' scope=spfile;
System altered.
SYS@fonpetd> alter system set log_file_name_convert='+DG_DATA/fonpetp','+DG_DATA/fonpetd' scope=spfile;
System altered.
SYS@fonpetd> shu immeiate diate;
ORA-01507: database not mounted
ORACLE instance shut down.
SYS@fonpetd> startup nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary /. oraenvnv
ORACLE_SID = [fonpetd] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:08:28 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpett backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:08:35
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:08:35
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:08:43
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:08:43
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN>
RMAN>
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:08:46 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:08:48
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:08:48
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN> restore controlfile from 'controlfile_c-2150325182-20141105-00.bak /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
Starting restore at 21/11/2014 11:10:17
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/21/2014 11:10:17
RMAN-06171: not connected to target database
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary / oraenv
ORACLE_SID = [fonpetd] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ oraenvrman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:10:33 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN>
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary / oraenv
ORACLE_SID = [fonpetd] ? ^C
[oracle@bddesarrollo prueba_restauracion]$
[oracle@bddesarrollo prueba_restauracion]$ ps -efa | grep smon
oracle 3435 1 0 Sep23 ? 00:00:59 asm_smon_+ASM
oracle 3629 1 0 Sep23 ? 00:03:20 ora_smon_asdbd
oracle 27198 1 0 11:08 ? 00:00:00 ora_smon_fonpetd
oracle 27310 25482 0 11:11 pts/0 00:00:00 grep smon
[oracle@bddesarrollo prueba_restauracion]$ ps -efa | grep smon oraenvps -efa | grep smon oraenvrman auxiliary / oraenvrman auxiliary / oraenvrman auxiliary / oraenvrman auxiliary / oraenvps -efa | grep smonps -efa | grep smon oraenvrman auxiliary / oraenvrman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:12:03 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:12:31
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:12:31
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN> s catalog start with '/u02/backup/rman/prueba_restauracion/';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 11/21/2014 11:13:26
RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted
RMAN> restore controlfile from /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "/"
RMAN> restore controlfile from 0 '/u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
Starting restore at 21/11/2014 11:13:51
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/21/2014 11:13:51
RMAN-06171: not connected to target database
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ connrman auxiliary /target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:13:59 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: FONPETP (not mounted)
RMAN> restore controlfile from '/u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
Starting restore at 21/11/2014 11:14:05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=199 device type=DISK
channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/21/2014 11:14:06
ORA-19870: error while restoring backup piece /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak
ORA-19504: failed to create file "+DG_DATA/fonpetd/controlfile/control01.ctl"
ORA-17502: ksfdcre:4 Failed to create file +DG_DATA/fonpetd/controlfile/control01.ctl
ORA-15173: entry 'controlfile' does not exist in directory 'fonpetd'
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ asmcmd
ASMCMD> cd +DG_DATA/fonpetd/controlfile
ASMCMD-8002: entry 'controlfile' does not exist in directory '+DG_DATA/fonpetd/'
ASMCMD> mkdir +DG_DATA/fonpetd/controlfile
ASMCMD> cd +DG_DATA/fonpetd/
ASMCMD> l -l s -l
Type Redund Striped Time Sys Name
N DATAFILE/
N TEMPFILE/
N controlfile/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> mkdir ONLINELOG
ASMCMD> exit
[oracle@bddesarrollo prueba_restauracion]$ asmcmd. oraenvrman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:16:24 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-12001: could not open channel default
RMAN-10008: could not create channel context
RMAN-10002: ORACLE error: ORA-15021: parameter "remote_dependencies_mode" is not valid in asm instance
RMAN-10006: error running SQL statement: alter session set remote_dependencies_mode = signature
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [+ASM] ? fonpetd
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ . oraenvrman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:16:31 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: FONPETP (not mounted)
RMAN>
RMAN> xit exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman target /. oraenvrman target /asmcmd. oraenvrman target /auxiliary
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:16:55 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:16:56
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:16:56
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN> catalog start with -/u02/backup/rman/prueba_restauracion/ - '/u02/backup/rman/prueba_restauracion/';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 11/21/2014 11:17:50
RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:18:55
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:18:55
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman auxiliary /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 11:18:57 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FONPETP (not mounted)
RMAN> run
{
DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location ' /u02/backup/rman/prueba_restauracion/';
}
2> 3> 4>
Starting Duplicate Db at 21/11/2014 11:18:58
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2014 11:18:58
RMAN-05501: aborting duplication of target database
RMAN-05576: CONTROLFILE backup not found for database FONPETP with DBID 2150325182 in /u02/backup/rman/prueba_restauracion/
RMAN> run
2> {
3> DUPLICATE DATABASE 'FONPETP' DBID 2150325182 TO fonpetd backup location /u02/backup/rman/prueba_restauracion/'; '/u02/backup/rman/prueba_restauracion/';
4> }
Starting Duplicate Db at 21/11/2014 11:19:51
contents of Memory Script:
{
sql clone "alter system set db_name =
''FONPETP'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile from '/u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''FONPETP'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
Starting restore at 21/11/2014 11:20:00
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=393 device type=DISK
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
output file name=+DG_DATA/fonpetd/controlfile/control01.ctl
output file name=+DG_FRA/fonpetd/controlfile/control02.ctl
Finished restore at 21/11/2014 11:20:07
database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=393 device type=DISK
contents of Memory Script:
{
set until scn 110586010;
set newname for datafile 1 to
"+DG_DATA/fonpetd/datafile/system01.dbf";
set newname for datafile 2 to
"+DG_DATA/fonpetd/datafile/sysaux01.dbf";
set newname for datafile 3 to
"+DG_DATA/fonpetd/datafile/undotbs101.dbf";
set newname for datafile 4 to
"+DG_DATA/fonpetd/datafile/users01.dbf";
set newname for datafile 5 to
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf";
set newname for datafile 6 to
"+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf";
set newname for datafile 7 to
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf";
set newname for datafile 8 to
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf";
set newname for datafile 9 to
"+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf";
set newname for datafile 10 to
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf";
set newname for datafile 11 to
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf";
set newname for datafile 12 to
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf";
set newname for datafile 13 to
"+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf";
set newname for datafile 14 to
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf";
set newname for datafile 15 to
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf";
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 21/11/2014 11:20:13
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to +DG_DATA/fonpetd/datafile/system01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00005 to +DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00007 to +DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf
channel ORA_AUX_DISK_1: restoring datafile 00008 to +DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf
channel ORA_AUX_DISK_1: restoring datafile 00010 to +DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00011 to +DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00012 to +DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00015 to +DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak
channel ORA_AUX_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak tag=TAG20141105T211012
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:13:55
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00002 to +DG_DATA/fonpetd/datafile/sysaux01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to +DG_DATA/fonpetd/datafile/undotbs101.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to +DG_DATA/fonpetd/datafile/users01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00006 to +DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf
channel ORA_AUX_DISK_1: restoring datafile 00009 to +DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf
channel ORA_AUX_DISK_1: restoring datafile 00013 to +DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf
channel ORA_AUX_DISK_1: restoring datafile 00014 to +DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak
channel ORA_AUX_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak tag=TAG20141105T211012
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:14:45
Finished restore at 21/11/2014 11:48:55
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=16 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=17 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=18 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/undotbs101.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=19 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=20 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=21 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=22 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=23 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=24 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=25 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=26 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=27 STAMP=864215335 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=28 STAMP=864215336 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=29 STAMP=864215336 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=30 STAMP=864215336 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf
contents of Memory Script:
{
set until scn 110586010;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 21/11/2014 11:48:57
using channel ORA_AUX_DISK_1
starting media recovery
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=8884
channel ORA_AUX_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
channel ORA_AUX_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak tag=TAG20141105T213317
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+DG_FRA/fonpetp/archivelog/2014_11_21/thread_1_seq_8884.859.864215339 thread=1 sequence=8884
channel clone_default: deleting archived log(s)
archived log file name=+DG_FRA/fonpetp/archivelog/2014_11_21/thread_1_seq_8884.859.864215339 RECID=1 STAMP=864215338
media recovery complete, elapsed time: 00:00:03
Finished recover at 21/11/2014 11:49:02
Oracle instance started
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''FONPETD'' comment=
''Reset to original value by RMAN'' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set db_name = ''FONPETD'' comment= ''Reset to original value by RMAN'' scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "FONPETD" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 2920
LOGFILE
GROUP 1 ( '+DG_DATA/fonpetd/onlinelog/redo01a.rdo', '+DG_FRA/fonpetp/onlinelog/redo01b.rdo' ) SIZE 50 M REUSE,
GROUP 2 ( '+DG_DATA/fonpetd/onlinelog/redo02a.rdo', '+DG_FRA/fonpetp/onlinelog/redo02b.rdo' ) SIZE 50 M REUSE,
GROUP 3 ( '+DG_DATA/fonpetd/onlinelog/redo03a.rdo', '+DG_FRA/fonpetp/onlinelog/redo03b.rdo' ) SIZE 50 M REUSE,
GROUP 8 ( '+DG_DATA/fonpetd/onlinelog/redo08b.rdo', '+DG_DATA/fonpetd/onlinelog/redo08a.rdo' ) SIZE 50 M REUSE,
GROUP 9 ( '+DG_DATA/fonpetd/onlinelog/redo09a.rdo', '+DG_DATA/fonpetd/onlinelog/redo09b.rdo' ) SIZE 50 M REUSE,
GROUP 10 ( '+DG_DATA/fonpetd/onlinelog/redo10a.rdo', '+DG_DATA/fonpetd/onlinelog/redo10b.rdo' ) SIZE 50 M REUSE,
GROUP 11 ( '+DG_DATA/fonpetd/onlinelog/redo11a.rdo', '+DG_DATA/fonpetd/onlinelog/redo11b.rdo' ) SIZE 50 M REUSE,
GROUP 12 ( '+DG_DATA/fonpetd/onlinelog/redo12b.rdo', '+DG_DATA/fonpetd/onlinelog/redo12a.rdo' ) SIZE 50 M REUSE
DATAFILE
'+DG_DATA/fonpetd/datafile/system01.dbf'
CHARACTER SET WE8ISO8859P1
contents of Memory Script:
{
set newname for tempfile 1 to
"+DG_DATA/fonpetd/tempfile/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "+DG_DATA/fonpetd/datafile/sysaux01.dbf",
"+DG_DATA/fonpetd/datafile/undotbs101.dbf",
"+DG_DATA/fonpetd/datafile/users01.dbf",
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf",
"+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf",
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf",
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf",
"+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf",
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf",
"+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf",
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf",
"+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf",
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf",
"+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to +DG_DATA/fonpetd/tempfile/temp01.dbf in control file
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/sysaux01.dbf RECID=1 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/undotbs101.dbf RECID=2 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/users01.dbf RECID=3 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf RECID=4 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf RECID=5 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf RECID=6 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf RECID=7 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf RECID=8 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf RECID=9 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf RECID=10 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf RECID=11 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf RECID=12 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf RECID=13 STAMP=864215362
cataloged datafile copy
datafile copy file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf RECID=14 STAMP=864215362
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/undotbs101.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=14 STAMP=864215362 file name=+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf
Reenabling controlfile options for auxiliary database
Executing: alter database force logging
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 21/11/2014 11:50:00
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ sqlplus dabba_fopnpet as sgsysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 11:50:16 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> select count(1) from dba_segments;
COUNT(1)
----------
6314
SYS@fonpetd> select name, , open_mode, dbid from v$database;
NAME OPEN_MODE DBID
--------- -------------------- ----------
FONPETD READ WRITE 1247845184
SYS@fonpetd> col name format a50
SYS@fonpetd> set lines 1000 pages 10000
SYS@fonpetd> seect lect name, bytes s, status from v$datafile;
NAMEBYTES STATUS
-------------------------------------------------- ---------- -------
+DG_DATA/fonpetd/datafile/system01.dbf 1461714944 SYSTEM
+DG_DATA/fonpetd/datafile/sysaux01.dbf 2006974464 ONLINE
+DG_DATA/fonpetd/datafile/undotbs101.dbf 1073741824 ONLINE
+DG_DATA/fonpetd/datafile/users01.dbf 196608000 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.db 5309988864 ONLINE
f
+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf 594214912 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf 3463774208 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg 2621440000 ONLINE
0.dbf
+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf 104857600 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf 9154789376 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.db 5146411008 ONLINE
f
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf 3145728000 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf 1073741824 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf 3.4318E+10 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf 7130316800 ONLINE
15 rows selected.
SYS@fonpetd> col name format a50 6
SYS@fonpetd> /
NAME BYTES STATUS
-------------------------------------------------------- ---------- -------
+DG_DATA/fonpetd/datafile/system01.dbf 1461714944 SYSTEM
+DG_DATA/fonpetd/datafile/sysaux01.dbf 2006974464 ONLINE
+DG_DATA/fonpetd/datafile/undotbs101.dbf 1073741824 ONLINE
+DG_DATA/fonpetd/datafile/users01.dbf 196608000 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_01.dbf 5309988864 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_param.dbf 594214912 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim.dbf 3463774208 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_reorg0.dbf 2621440000 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_param.dbf 104857600 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_01.dbf 9154789376 ONLINE
+DG_DATA/fonpetd/datafile/indic_fonpet_movim_02.dbf 5146411008 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_02.dbf 3145728000 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_rep.dbf 1073741824 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim.dbf 3.4318E+10 ONLINE
+DG_DATA/fonpetd/datafile/ts_fonpet_movim_2.dbf 7130316800 ONLINE
15 rows selected.
SYS@fonpetd> selec select member, status from v$logfile;
MEMBER STATUS
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------
+DG_DATA/fonpetd/onlinelog/redo12b.rdo
+DG_DATA/fonpetd/onlinelog/redo12a.rdo
+DG_DATA/fonpetd/onlinelog/redo11a.rdo
+DG_DATA/fonpetd/onlinelog/redo11b.rdo
+DG_DATA/fonpetd/onlinelog/redo10a.rdo
+DG_DATA/fonpetd/onlinelog/redo10b.rdo
+DG_DATA/fonpetd/onlinelog/redo09a.rdo
+DG_DATA/fonpetd/onlinelog/redo09b.rdo
+DG_DATA/fonpetd/onlinelog/redo08b.rdo
+DG_DATA/fonpetd/onlinelog/redo08a.rdo
+DG_DATA/fonpetd/onlinelog/redo03a.rdo
+DG_FRA/fonpetp/onlinelog/redo03b.rdo
+DG_DATA/fonpetd/onlinelog/redo02a.rdo
+DG_FRA/fonpetp/onlinelog/redo02b.rdo
+DG_DATA/fonpetd/onlinelog/redo01a.rdo
+DG_FRA/fonpetp/onlinelog/redo01b.rdo
16 rows selected.
SYS@fonpetd> ^[[6~
SYS@fonpetd>
SYS@fonpetd> shw p pw p pw pa ow parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +DG_FRA
db_recovery_file_dest_size big integer 70G
recovery_parallelism integer 0
SYS@fonpetd> show show para meter unique
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string FONPETD
SYS@fonpetd> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string FONPETD
SYS@fonpetd> spw show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string fonpetd
SYS@fonpetd> exit show
SYS@fonpetd>
SYS@fonpetd>
SYS@fonpetd> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> xi exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [fonpetd] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ asmcmd
ASMCMD> rm cd +DG_DATA/fonpet petd
ASMCMD> ls l -l
Type Redund Striped Time Sys Name
N DATAFILE/
N ONLINELOG/
N TEMPFILE/
N controlfile/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD> rm DATAFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> rm ONLINELOG/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo01a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo02a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo03a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo08b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo08a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo09a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo09b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo10a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo10b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo11a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo11b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo12b.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'redo12a.rdo' does not exist in directory 'ONLINELOG' (DBD ERROR: OCIStmtExecute)
ASMCMD> rm TEMPFILE/
ORA-15032: not all alterations performed
ORA-15178: directory 'TEMPFILE' is not empty; cannot drop this directory (DBD ERROR: OCIStmtExecute)
ASMCMD> rm controlfile/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> rm TEMPFILE/*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
Use of uninitialized value $is_dir in string eq at /u01/app/oracle/product/11.2.0/grid/lib/asmcmdbase.pm line 4336,
ORA-15032: not all alterations performed
ORA-15173: entry 'temp01.dbf' does not exist in directory 'TEMPFILE' (DBD ERROR: OCIStmtExecute)
ASMCMD> ls -l
Type Redund Striped Time Sys Name
N DATAFILE/
N ONLINELOG/
N TEMPFILE/
N controlfile/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD> ls -l DATAFILE/
ASMCMD> ls -l ONLINELOG/
ASMCMD> ls -l TEMPFILE/
ASMCMD> ls -l controlfile/
ASMCMD> rm dir controlfile/
ASMCMD> M mkdir CONTROLFILE rm DATAFILE/
ASMCMD> rm ONLINELOG/
ASMCMD> rm TEMPFILE/
ASMCMD> ls -l
Type Redund Striped Time Sys Name
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD> mkdir DATAFILE/
ASMCMD> mkdir ONLINELOG/
ASMCMD> mkdir TEMPFILE/
ASMCMD> mkdir CONTOLFIL N CONTROLFILE
ASMCMD> LS -L ls-lrt -lrt
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'
Type Redund Striped Time Sys Name
N CONTROLFILE/
N DATAFILE/
N ONLINELOG/
N TEMPFILE/
N spfilefonpetd.ora => +DG_DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.271.854439285
ASMCMD>
ASMCMD>
ASMCMD> exit
[oracle@bddesarrollo prueba_restauracion]$ sqlplus da_ / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 12:00:14 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@+ASM>
SYS@+ASM> startup nomount;
ORA-01031: insufficient privileges
SYS@+ASM> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [+ASM] ? fonpetd
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ . oraenvsqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 12:00:45 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@fonpetd>
SYS@fonpetd> startup nomout unt
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> show parameer ter dba_ _name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string FONPETD
SYS@fonpetd> show parm ameter uniqie ique
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string FONPETD
SYS@fonpetd> show parameter instance
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 1
instance_groups string
instance_name string fonpetd
instance_number integer 0
instance_type string RDBMS
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 1
SYS@fonpetd> alter system st et db_name=FONPETP scope=spfile;
System altered.
SYS@fonpetd> show parameter convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string +DG_DATA/fonpetp, +DG_DATA/fon
petd
log_file_name_convert string +DG_DATA/fonpetp, +DG_DATA/fon
petd
SYS@fonpetd> shu i alter system st et db_file_name_convert='+DG_DATA/fonpetp, +DG_DATA/fonpetd' sc cope=spfile;
alter system set db_file_name_convert='+DG_DATA/fonpetp, +DG_DATA/fonpetd' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-01678: parameter db_file_name_convert must be pairs of pattern and
replacement strings
SYS@fonpetd> alter system set db_file_name_convert='+DG_DATA/fonpetp','+DG_DATA/fonpetd' scope=spfile;
System altered.
SYS@fonpetd> alter system set log_file_name_convert='+DG_DATA/fonpetp0, ','+DG_DATA/fonpetd' scope=spfile;
System altered.
SYS@fonpetd> s shu mmediate immediate, ;
ORA-01507: database not mounted
ORACLE instance shut down.
SYS@fonpetd> startup nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> exi ext
SP2-0042: unknown command "ext" - rest of line ignored.
SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
[oracle@bddesarrollo prueba_restauracion]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 12:05:11 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: FONPETP (not mounted)
RMAN> restore controlfile from /u02/backup/rman/prueba_restauracion '/u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak';
Starting restore at 21/11/2014 12:05:38
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=393 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DG_DATA/fonpetd/controlfile/control01.ctl
output file name=+DG_FRA/fonpetd/controlfile/control02.ctl
Finished restore at 21/11/2014 12:05:39
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> crosscheck backup;
Starting implicit crosscheck backup at 21/11/2014 12:06:08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
Crosschecked 10 objects
Finished implicit crosscheck backup at 21/11/2014 12:06:10
Starting implicit crosscheck copy at 21/11/2014 12:06:10
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 21/11/2014 12:06:10
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2jpmpuph_1_1_20141104.bak RECID=2034 STAMP=862780213
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2ipmpuph_1_1_20141104.bak RECID=2035 STAMP=862780209
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2lpmq03u_1_1_20141104.bak RECID=2037 STAMP=862781567
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/controlfile_c-2150325182-20141104-00.bak RECID=2039 STAMP=862781604
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2ppmsj5l_1_1_20141105.bak RECID=2040 STAMP=862866617
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2opmsj5l_1_1_20141105.bak RECID=2041 STAMP=862866614
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2qpmskgv_1_1_20141105.bak RECID=2042 STAMP=862867999
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2rpmskh0_1_1_20141105.bak RECID=2043 STAMP=862868000
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2spmskhp_1_1_20141105.bak RECID=2044 STAMP=862868025
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u03/backups/rman/fonpetp/controlfile_FONPETP_2tpmski1_1_1_20141105.bak RECID=2045 STAMP=862868034
Crosschecked 10 objects
RMAN-08591: WARNING: invalid archived log deletion policy
RMAN> cro crosscheck archivel l ogg ll all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
specification does not match any archived log in the repository
RMAN> cro delete expired backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
2034 2031 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/full_FONPETP_2jpmpuph_1_1_20141104.bak
2035 2032 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/full_FONPETP_2ipmpuph_1_1_20141104.bak
2037 2034 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/archivelog_FONPETP_2lpmq03u_1_1_20141104.bak
2039 2036 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/controlfile_c-2150325182-20141104-00.bak
2040 2037 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/full_FONPETP_2ppmsj5l_1_1_20141105.bak
2041 2038 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/full_FONPETP_2opmsj5l_1_1_20141105.bak
2042 2039 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/archivelog_FONPETP_2qpmskgv_1_1_20141105.bak
2043 2040 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/archivelog_FONPETP_2rpmskh0_1_1_20141105.bak
2044 2041 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
2045 2042 1 1 EXPIRED DISK /u03/backups/rman/fonpetp/controlfile_FONPETP_2tpmski1_1_1_20141105.bak
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2jpmpuph_1_1_20141104.bak RECID=2034 STAMP=862780213
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2ipmpuph_1_1_20141104.bak RECID=2035 STAMP=862780209
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2lpmq03u_1_1_20141104.bak RECID=2037 STAMP=862781567
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/controlfile_c-2150325182-20141104-00.bak RECID=2039 STAMP=862781604
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2ppmsj5l_1_1_20141105.bak RECID=2040 STAMP=862866617
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/full_FONPETP_2opmsj5l_1_1_20141105.bak RECID=2041 STAMP=862866614
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2qpmskgv_1_1_20141105.bak RECID=2042 STAMP=862867999
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2rpmskh0_1_1_20141105.bak RECID=2043 STAMP=862868000
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/archivelog_FONPETP_2spmskhp_1_1_20141105.bak RECID=2044 STAMP=862868025
deleted backup piece
backup piece handle=/u03/backups/rman/fonpetp/controlfile_FONPETP_2tpmski1_1_1_20141105.bak RECID=2045 STAMP=862868034
Deleted 10 EXPIRED objects
RMAN-08591: WARNING: invalid archived log deletion policy
RMAN> delete expired ARCHIVELOG ALL;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
specification does not match any archived log in the repository
RMAN> restore
RMAN> catalog da start i with '/u02/backup/rman/prueba_restauracion';
searching for all files that match the pattern /u02/backup/rman/prueba_restauracion
List of Files Unknown to the Database
=====================================
File Name: /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak
File Name: /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_asdbp_110514.dmp.gz
File Name: /u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_asdbp_110514.log.gz
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u02/backup/rman/prueba_restauracion/controlfile_c-2150325182-20141105-00.bak
File Name: /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak
File Name: /u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak
List of Files Which Where Not Cataloged
=======================================
File Name: /u02/backup/rman/prueba_restauracion/full_asdbp_110514.dmp.gz
RMAN-07517: Reason: The file header is corrupted
File Name: /u02/backup/rman/prueba_restauracion/full_asdbp_110514.log.gz
RMAN-07517: Reason: The file header is corrupted
RMAN> restore database;
Starting restore at 21/11/2014 12:08:27
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DG_DATA/fonpetp/datafile/system01.dbf
channel ORA_DISK_1: restoring datafile 00005 to +DG_DATA/fonpetp/datafile/indic_fonpet_movim_01.dbf
channel ORA_DISK_1: restoring datafile 00007 to +DG_DATA/fonpetp/datafile/indic_fonpet_movim.dbf
channel ORA_DISK_1: restoring datafile 00008 to +DG_DATA/fonpetp/datafile/indic_fonpet_movim_reorg0.dbf
channel ORA_DISK_1: restoring datafile 00010 to +DG_DATA/fonpetp/datafile/ts_fonpet_movim_01.dbf
channel ORA_DISK_1: restoring datafile 00011 to +DG_DATA/fonpetp/datafile/indic_fonpet_movim_02.dbf
channel ORA_DISK_1: restoring datafile 00012 to +DG_DATA/fonpetp/datafile/ts_fonpet_movim_02.dbf
channel ORA_DISK_1: restoring datafile 00015 to +DG_DATA/fonpetp/datafile/ts_fonpet_movim_2.dbf
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak
channel ORA_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/full_FONPETP_2ppmsj5l_1_1_20141105.bak tag=TAG20141105T211012
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:14:06
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00002 to +DG_DATA/fonpetp/datafile/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to +DG_DATA/fonpetp/datafile/undotbs101.dbf
channel ORA_DISK_1: restoring datafile 00004 to +DG_DATA/fonpetp/datafile/users01.dbf
channel ORA_DISK_1: restoring datafile 00006 to +DG_DATA/fonpetp/datafile/indic_fonpet_param.dbf
channel ORA_DISK_1: restoring datafile 00009 to +DG_DATA/fonpetp/datafile/ts_fonpet_param.dbf
channel ORA_DISK_1: restoring datafile 00013 to +DG_DATA/fonpetp/datafile/ts_fonpet_rep.dbf
channel ORA_DISK_1: restoring datafile 00014 to +DG_DATA/fonpetp/datafile/ts_fonpet_movim.dbf
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak
channel ORA_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/full_FONPETP_2opmsj5l_1_1_20141105.bak tag=TAG20141105T211012
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:14:55
Finished restore at 21/11/2014 12:37:28
RMAN>
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ aexport rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 12:53:47 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: FONPETP (DBID=2150325182, not open)
RMAN> LIST BACKU UP OF ARCHIVELOG ALL<
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "<"
RMAN> LIST BACKUP OF ARCHIVELOG ALL< < ;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
2043 13.91M DISK 00:00:00 05/11/2014 21:33:45
BP Key: 2046 Status: AVAILABLE Compressed: NO Tag: TAG20141105T213317
Piece Name: /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
List of Archived Logs in backup set 2043
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 8884 110575832 05/11/2014 20:00:09 110586010 05/11/2014 21:33:15
RMAN> restoe o recover list backup of controlfile<
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02001: unrecognized punctuation symbol "<"
RMAN> list backup of controlfileñ ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, controlfile, database, datafile, foreign, spfile, tablespace"
RMAN-01008: the bad identifier was: controlfile
RMAN-01007: at line 1 column 17 file: standard input
RMAN> lit l list backup of controlfile;
specification does not match any backup in the repository
RMAN> recover database until logseq 8884; 5. ;
Starting recover at 21/11/2014 12:55:15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=580 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/21/2014 12:55:16
ORA-19698: +DG_FRA/fonpetp/onlinelog/redo01b.rdo is from different database: id=1247845184, db_name=FONPETD
RMAN> re exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysbasdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 12:57:04 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> show parameer ter db_bame
SYS@fonpetd> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string FONPETP
SYS@fonpetd> alter system se set db_name=' 'FONPETP' scope=spfi D' scope=spfie ile;
alter system set db_name='FONPETD' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-32016: parameter "db_name" cannot be updated in SPFILE
SYS@fonpetd> shu immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> startup nomount pfile; ;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> alter system set db_name='FONPETD' scope=spfile
2 ;
System altered.
SYS@fonpetd> al alter shu immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
ORA-01103: database name 'FONPETP' in control file is not 'FONPETD'
SYS@fonpetd> show parameter lo convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string +DG_DATA/fonpetp, +DG_DATA/fon
petd
log_file_name_convert string +DG_DATA/fonpetp, +DG_DATA/fon
petd
SYS@fonpetd> alter alter sye ession = ystem set db_name=FONPETD P scope? =sf pfile;
System altered.
SYS@fonpetd> shu immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
[oracle@bddesarrollo prueba_restauracion]$ .oa oraenv}
ORACLE_SID = [fonpetd] ? *AS +as ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ cd +DG_FRA/fonpetp/onlinelog/redo01b.rdo
-bash: cd: +DG_FRA/fonpetp/onlinelog/: No such file or directory
[oracle@bddesarrollo prueba_restauracion]$ ls -lasmcmd
ASMCMD> cd +DG_FRA/fonpetp/onlinelog/
ASMCMD> ls -lr
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'
Type Redund Striped Time Sys Name
N redo03b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_3.707.864215385
N redo02b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_2.706.864215383
N redo01b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_1.705.864215383
ASMCMD> rm ls l- -l
Type Redund Striped Time Sys Name
N redo01b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_1.705.864215383
N redo02b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_2.706.864215383
N redo03b.rdo => +DG_FRA/FONPETD/ONLINELOG/group_3.707.864215385
ASMCMD> rm redo*
You may delete multiple files and/or directories.
Are you sure? (y/n) y
ASMCMD> exit
[oracle@bddesarrollo prueba_restauracion]$ . oraenv
ORACLE_SID = [+ASM] ? fonped petd
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@bddesarrollo prueba_restauracion]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 13:01:35 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> alter database mount;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 11/21/2014 13:01:42
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
RMAN> startup mount;
Oracle instance started
database mounted
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
2043 13.91M DISK 00:00:00 05/11/2014 21:33:45
BP Key: 2046 Status: AVAILABLE Compressed: NO Tag: TAG20141105T213317
Piece Name: /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
List of Archived Logs in backup set 2043
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 8884 110575832 05/11/2014 20:00:09 110586010 05/11/2014 21:33:15
RMAN> recover database until logeq 8884 5;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "scn, sequence, time"
RMAN-01008: the bad identifier was: logeq
RMAN-01007: at line 1 column 24 file: standard input
RMAN> recover database until logseq 8885;
Starting recover at 21/11/2014 13:02:37
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=8 device type=DISK
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=8884
channel ORA_DISK_1: reading from backup piece /u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak
channel ORA_DISK_1: piece handle=/u02/backup/rman/prueba_restauracion/archivelog_FONPETP_2spmskhp_1_1_20141105.bak tag=TAG20141105T213317
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+DG_FRA/fonpetp/archivelog/2014_11_21/thread_1_seq_8884.707.864219759 thread=1 sequence=8884
channel default: deleting archived log(s)
archived log file name=+DG_FRA/fonpetp/archivelog/2014_11_21/thread_1_seq_8884.707.864219759 RECID=27540 STAMP=864219759
media recovery complete, elapsed time: 00:00:03
Finished recover at 21/11/2014 13:02:43
RMAN> alter database open resetlogs;
database opened
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman target /. oraenvrman target /sqlplus / as ssdbaysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:05:37 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> select name, dbid, statos s us
SYS@fonpetd>
SYS@fonpetd> ^[[A^[[A exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdbarman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 13:06:01 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: FONPETP (DBID=2150325182)
RMAN> sql 'select name, dbid , open_mode rom v from v$database';
using target database control file instead of recovery catalog
sql statement: select name, dbid, open_mode from v$database
RMAN> exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ rman target /sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:06:40 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> select name, dbid, open_mode from v$database;
NAMEDBID OPEN_MODE
--------- ---------- --------------------
FONPETP 2150325182 READ WRITE
SYS@fonpetd> altr syste set m set shu shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
Database mounted.
SYS@fonpetd> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ dbnewid
-bash: dbnewid: command not found
[oracle@bddesarrollo prueba_restauracion]$ dbnewidnid
DBNEWID: Release 11.2.0.3.0 - Production on Fri Nov 21 13:07:56 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Keyword Description (Default)
----------------------------------------------------
TARGET Username/Password (NONE)
DBNAME New database name (NONE)
LOGFILE Output Log (NONE)
REVERT Revert failed change NO
SETNAME Set a new database name only NO
APPEND Append to output log NO
HELP Displays these messages NO
[oracle@bddesarrollo prueba_restauracion]$ nid TARGET=7/ as sysda DBNAME=FONPED
DBNEWID: Release 11.2.0.3.0 - Production on Fri Nov 21 13:08:15 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to database FONPETP (DBID=2150325182)
Connected to server version 11.2.0
Control Files in database:
+DG_DATA/fonpetd/controlfile/control01.ctl
+DG_FRA/fonpetd/controlfile/control02.ctl
Change database ID and database name FONPETP to FONPED? (Y/[N]) => y Y
Proceeding with operation
Changing database ID from 2150325182 to 2659586623
Changing database name from FONPETP to FONPED
Control File +DG_DATA/fonpetd/controlfile/control01.ctl - modified
Control File +DG_FRA/fonpetd/controlfile/control02.ctl - modified
Datafile +DG_DATA/fonpetp/datafile/system01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/sysaux01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/undotbs101.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/users01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_param.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_reorg0.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_param.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_02.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_02.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_rep.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_2.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/tempfile/temp01.db - dbid changed, wrote new name
Control File +DG_DATA/fonpetd/controlfile/control01.ctl - dbid changed, wrote new name
Control File +DG_FRA/fonpetd/controlfile/control02.ctl - dbid changed, wrote new name
Instance shut down
Database name changed to FONPED.
Modify parameter file and generate a new password file before restarting.
Database ID for database FONPED changed to 2659586623.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
[oracle@bddesarrollo prueba_restauracion]$ nid TARGET=/ DBNAME=FONPEDnid TARGET=/ DBNAME=FONPEDtDDTD
DBNEWID: Release 11.2.0.3.0 - Production on Fri Nov 21 13:09:09 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
NID-00106: LOGIN to target database failed with Oracle error:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
Change of database name failed during validation - database is intact.
DBNEWID - Completed with validation errors.
[oracle@bddesarrollo prueba_restauracion]$ .sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:09:18 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
ORA-01103: database name 'FONPED' in control file is not 'FONPETP'
SYS@fonpetd> show parameter dba_name
SYS@fonpetd> show mara p parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string FONPETP
SYS@fonpetd> shw show parameter ^[[A alter exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
[oracle@bddesarrollo prueba_restauracion]$ rmarrman rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Nov 21 13:10:46 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: FONPETP (not mounted)
RMAN> list incart nation of database;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 11/21/2014 13:10:51
ORA-01507: database not mounted
RMAN> alter exit
Recovery Manager complete.
[oracle@bddesarrollo prueba_restauracion]$ salter system setrman target /sqlplus / as sysdbanid TARGET=/ DBNAME=FONPETDsqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:11:07 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SYS@fonpetd> altersytem set system set dbn _name=^[[5~ 'FONPED. '
2
SYS@fonpetd> shu abort;
ORACLE instance shut down.
SYS@fonpetd> start startuu p nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> alter system set db_name='FONPED'
2 scope=spfile;
System altered.
SYS@fonpetd> shu abort;
ORACLE instance shut down.
SYS@fonpetd> startup nomoun mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
Database mounted.
SYS@fonpetd> alter database open resetlogs;
Database altered.
SYS@fonpetd> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
Database mounted.
SYS@fonpetd> alter exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdbarman target /sqlplus / as sysdbanid TARGET=/ DBNAME=FONPETD
DBNEWID: Release 11.2.0.3.0 - Production on Fri Nov 21 13:14:32 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to database FONPED (DBID=2659586623)
Connected to server version 11.2.0
Control Files in database:
+DG_DATA/fonpetd/controlfile/control01.ctl
+DG_FRA/fonpetd/controlfile/control02.ctl
Change database ID and database name FONPED to FONPETD? (Y/[N]) => y
Proceeding with operation
Changing database ID from 2659586623 to 1247841337
Changing database name from FONPED to FONPETD
Control File +DG_DATA/fonpetd/controlfile/control01.ctl - modified
Control File +DG_FRA/fonpetd/controlfile/control02.ctl - modified
Datafile +DG_DATA/fonpetp/datafile/system01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/sysaux01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/undotbs101.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/users01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_param.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_reorg0.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_param.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_01.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/indic_fonpet_movim_02.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_02.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_rep.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/datafile/ts_fonpet_movim_2.db - dbid changed, wrote new name
Datafile +DG_DATA/fonpetp/tempfile/temp01.db - dbid changed, wrote new name
Control File +DG_DATA/fonpetd/controlfile/control01.ctl - dbid changed, wrote new name
Control File +DG_FRA/fonpetd/controlfile/control02.ctl - dbid changed, wrote new name
Instance shut down
Database name changed to FONPETD.
Modify parameter file and generate a new password file before restarting.
Database ID for database FONPETD changed to 1247841337.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
[oracle@bddesarrollo prueba_restauracion]$ orapwd file?=$ORACLE_HOME /NETnet/u01/app/oracle/product/11.2.0/dbhome_1/network/dbs/pwdf/orapwfonpetd passwoforce=Y password?0=Nuevuevo123 entries?=43
[oracle@bddesarrollo prueba_restauracion]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 21 13:15:46 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SYS@fonpetd> startup nomount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
SYS@fonpetd> alter show parameter db_bame name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string FONPED
SYS@fonpetd> alter syte set alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01103: database name 'FONPETD' in control file is not 'FONPED'
SYS@fonpetd> a alter syste se mt set db_name=FON 'FONPETD' soc cope? =spfile;
System altered.
SYS@fonpetd> shu s shu a i¿ shu abort;
ORACLE instance shut down.
SYS@fonpetd> startup mount;
ORACLE instance started.
Total System Global Area 1402982400 bytes
Fixed Size 2228304 bytes
Variable Size 1073745840 bytes
Database Buffers 318767104 bytes
Redo Buffers 8241152 bytes
Database mounted.
SYS@fonpetd> alter database open s resetlogs;
Database altered.
SYS@fonpetd>
Suscribirse a:
Entradas (Atom)
