Sangram keshari's Oracle Blog

The Fusion Middleware Administration & Database Administration Blog

How to Install and Configure GoldenGate 11.2 [CLASSIC CAPTURE]

Posted by SangramKeshari on May 6, 2014

Download Godengate from https://edelivery.oracle.com

ggdownload

[oracle@oradbasm11gbox01 ~]$mkdir -p /u01/app/oracle/goldengate/112100

[oracle@oradbasm11gbox01 ofm_gg_GoldenGate]$ cp fbo_ggs_Linux_x64_112100_ora11g_64bit.zip /u01/app/oracle/goldengate/112100
[oracle@oradbasm11gbox01 ofm_gg_GoldenGate]$ cd /u01/app/oracle/goldengate/112100
[oracle@oradbasm11gbox01 112100]$ ls -ltr
total 84472
-rwxr-x— 1 oracle oinstall 86406274 Feb 6 01:33 fbo_ggs_Linux_x64_112100_ora11g_64bit.zip

Read the rest of this entry »

Posted in GoldenGate, Uncategorized | Tagged: , , , , , , , | 1 Comment »

How to do Networking Configuration in Oracle Linux 6.5 on VirtualBox

Posted by SangramKeshari on May 6, 2014

This article is to understand the Oracle VirtualBox and Linux Networking basic configuration.
To configure Oracle DBA RAC LAB we need different type of network added to the virtual machine.

NAT — To Access Internet
Host Only Network — To Access the host
Internal Network — To Use in Interconnect
or/and
Bridged Network — To Use in Interconnect

Network Address Translation (NAT)
This is the process where a network device, usually a firewall, assigns a public address to a computer (or group of computers) inside a private network.
If all you want is to browse the Web, download files and view e-mail inside the guest, then this default mode should be sufficient for you.

Bridged networking
This is for more advanced networking needs such as network simulations and running servers in a guest. When enabled, VirtualBox connects to one of your installed network cards and exchanges network packets directly, circumventing your host operating system’s network stack.

Internal networking
This can be used to create a different kind of software-based network which is visible to selected virtual machines, but not to applications running on the host or to the outside world.

Host-only networking
This can be used to create a network containing the host and a set of virtual machines, without the need for the host’s physical network interface. Instead, a virtual network interface (similar to a loopback interface) is created on the host, providing connectivity among virtual machines and the host.

Once Your Virtual Machine is created. If not already created follow the sequence in https://sangramkeshari.wordpress.com/vm/
Go to Virtual Machine –> SETTINGS –> NETWORK

1> Choose NAT in Adapter 1. Click Next Tab Adapter 2.
l65netw11

2> Choose Host-Only Adapter in Adapter 2. Click Next Tab Adapter 3.
l65netw12

3> Choose Internal Network in Adapter 3. Click Next Tab Adapter 4.
l65netw13
4> Choose Bridged Adapter in Adapter 4.
l65netw14
5>
l65netw0
6> Go To SYSTEM –> PREFERENCE -> NETWORK CONNECTIONS
l65netw2-1
7> Choose eth0 and Click on EDIT
l65netw3-1
8> Choose eth1 and Click on EDIT. Go to IPV4 Setting Choose DHCP and Apply
l65netw5-1
9> Choose eth2 and Click on EDIT. Go to IPV4 Setting. Add IP as you see in the Screenshot
l65netw6-1
10> Choose eth2 and Click on EDIT. Go to IPV4 Setting. Add IP as you see in the Screenshot
l65netw7-1
11> Go to IPV4 Setting. Add IP as you see in the Screenshot
l65netw8-1
12>

Add Entry in – /etc/hosts file 192.168.56.65
Restart Network – service network restart

l65netw9-1

13> Check IP configurations details – ifconfig
l65netw10-1

Posted in Linux, OS, VM | Tagged: , , | 1 Comment »

VirtualBox Guest Addition and Configure Shared Folder with Guest OS

Posted by SangramKeshari on March 5, 2014

1. VirtualBox Guest Addition

Devices -> Click – Insert Guest Addition
vm-guest-add-438-0

Click OK
vm-guest-add-438-1

Click Run
vm-guest-add-438-2

vm-guest-add-438-4

System -> Shutdown or init 0
vm-guest-add-438-5

2. Configure Shared Folder with Guest OS

Edit Settings -> Select Shared Folders -> Click the + to add
vm-guest-add-438-6

vm-guest-add-438-7

To access shared folder by oracle user
/usr/sbin/usermod -u 54321 -g oinstall -G dba,vboxsf oracle

vm-guest-add-438-11

Posted in Linux, VM | Tagged: , , , , | Leave a Comment »

Oracle Linux 6.5 64 bit Installation on VirtualBox

Posted by SangramKeshari on March 5, 2014


Follow the sequence :

1) How to Install Oracle VM Virtual Box 4.3.8 http://wp.me/pLTxm-kp
2) How to Install VirtualBox 4.3.8 Oracle VM VirtualBox Extension Pack http://wp.me/pLTxm-kJ
3) How to create a new Virtual Machine using Virtual Box for Oracle Linux 64 bit http://wp.me/pLTxm-kU
4) Making the Virtual Machine ready to Install Oracle Linux 6.5 64 bit http://wp.me/pLTxm-ls

5) Oracle Linux 6.5 64 bit Installation

Steps through screenshots
1
ol65-0
2
ol65-1
3
ol65-2
4
ol65-3
5
ol65-4
6
ol65-5
7
ol65-6
8
ol65-7
9
ol65-8
10
ol65-9
11
12
ol65-11
13 Creating a custom layout
ol65-12
14
ol65-13
15 Going to create a new partition
ol65-14
16 Steps 14, 15, 16 going to fail because we don’t have free space to create a new partition
ol65-15
17 Editing existing partitions to release free space
ol65-16
18 Editing the root partition logical volume to 20 GB. You can set it for as per your requirement.
ol65-17
19 Editing swap space logical volume to 6 GB. You can set it for as per your requirement.
ol65-18
20 Editing /home logical volume to 10 GB. This keeps the user data. You can set it for as per your requirement.
ol65-19

23 Double Click on free space
ol65-22
24 Creating /u01 of 30 GB
ol65-23
25 Creating /u02 of 20 GB
ol65-24
26 Creating /u03 of 10 GB
ol65-25
27 Creating /tmp of 2 GB
ol65-26
28
ol65-27
29
ol65-28
30
ol65-29
31
ol65-30
32
ol65-31
33
ol65-32
34
Base System -> Base -> Choose Everything from Optional Packages
Base System -> Compatibility Libraries
Base System -> Console Internet Tools
Base System -> Debugging Tools ->
Base System -> Directory Client
Base System -> Hardware Monitoring Utilities
Base System -> Java Platform
Base System -> Large Systems Performance
Base System -> Network File System Client
Base System -> Networking Tools -> Choose Everything from Optional Packages
Base System -> Performance Tools
Base System -> Perl Support

ol65-33
35 Base System -> Base -> Choose Everything
ol65-33-a
36 Base System -> Compatibility Libraries -> Choose Everything
ol65-34
37 Servers -> Server Administration tools -> Choose Everything
ol65-35
38 System Management -> System Management -> Choose Everything
ol65-35-a
39 Desktop -> Select Everything
ol65-36
40 Developement -> Additional Developement -> Choose Everything
ol65-37

UEK3 Kernel repo -> UEK3 Kernel repo -> Choose Everything

41
ol65-38
42
ol65-39
43
ol65-afterReboot-0
44
ol65-afterReboot-1
45
ol65-afterReboot-2
46
ol65-afterReboot-3
47
ol65-afterReboot-4
48
ol65-afterReboot-5
49
ol65-afterReboot-6
50
ol65-afterReboot-7
51
ol65-afterReboot-8
52
ol65-afterReboot-9
53
ol65-afterReboot-10
54
ol65-afterReboot-11

Posted in Linux, VM | Tagged: , , , | Leave a Comment »

Making the Virtual Machine ready to Install Oracle Linux 6.5 64 bit

Posted by SangramKeshari on March 4, 2014



1) How to Install Oracle VM Virtual Box 4.3.8 http://wp.me/pLTxm-kp
2) How to Install VirtualBox 4.3.8 Oracle VM VirtualBox Extension Pack http://wp.me/pLTxm-kJ
3) How to create a new Virtual Machine using Virtual Box for Oracle Linux 64 bit http://wp.me/pLTxm-kU
4) Download the Oracle Linux 6.5 64 bit ISO from https://edelivery.oracle.com/linux

edel-0

edel-1

edel-2

edel-3

edel-4

edel-5

edel-6

5)

Click on the CD Icon in the attributes section and Choose the ISO Image.

Lin65-Install-0

Lin65-Install-1

Lin65-Install-2

Posted in Linux, VM | Tagged: , | Leave a Comment »

How to create a new Virtual Machine using Virtual Box for Oracle Linux 64 bit

Posted by SangramKeshari on March 3, 2014

1) Virtual Machine Location Preference
2) Virtual Machine Creation
3) Virtual Machine CPU Allocation
4) Virtual Machine Network Configuration

1) Virtual Machine Location Preference

vm-pref-0

vm-pref-1

2) Virtual Machine Creation

vm-CreateNewVM-0

vm-CreateNewVM-1

vm-CreateNewVM-2

vm-CreateNewVM-3

vm-CreateNewVM-4

vm-CreateNewVM-5

vm-CreateNewVM-6

vm-CreateNewVM-7

vm-CreateNewVM-8

vm-CreateNewVM-9

3) Virtual Machine CPU Allocation

vm-CreateNewVM-11

vm-CreateNewVM-12

4) Virtual Machine Network Configuration

vmnet-0

vmnet-1

vmnet-2

vmnet-2

vmnet-3

vm-CreateNewVM-13

Posted in VM | Tagged: , , , | Leave a Comment »

How to Install VirtualBox 4.3.8 Oracle VM VirtualBox Extension Pack

Posted by SangramKeshari on March 3, 2014

Download Oracle VM VirtualBox Extension Pack Software from https://www.virtualbox.org/wiki/Downloads
click on “All supported platforms” to download Oracle_VM_VirtualBox_Extension_Pack-4.3.8-92456.vbox-extpack

vm438-ext-pck-0

Scroll down and click I Agree
vm438-ext-pck-1

vm438-ext-pck-2

vm438-ext-pck-3

vm438-ext-pck-4

Posted in VM | Tagged: , , | 2 Comments »

How to Install Oracle VM Virtual Box 4.3.8

Posted by SangramKeshari on March 3, 2014

Download Virtual Box Software from https://www.virtualbox.org/wiki/Downloads

click on “x86/amd64” to download VirtualBox-4.3.8-92456-Win.exe

vm438_0

vm438_1

vm438_2

vm438_3

vm438_4

vm438_5

vm438_6

vm438_7

Click Install
vm438_8

vm438_9

Posted in VM | Tagged: , , | Leave a Comment »

Recovery of Redo Log Group [CURRENT] using RMAN

Posted by SangramKeshari on February 20, 2014

SQL> l
1* select a.group#, a.sequence#, a.status, a.archived, b.member from v$log a, v$logfile b where a.group#=b.group#
SQL> /

GROUP# SEQUENCE# STATUS ARC MEMBER
———- ———- —————- — ————————————————–
3 0 UNUSED YES +DATA/orcl/onlinelog/group_3.263.805381707
3 0 UNUSED YES +FRA/orcl/onlinelog/group_3.259.805381713
2 0 UNUSED YES +DATA/orcl/onlinelog/group_2.262.805381695
2 0 UNUSED YES +FRA/orcl/onlinelog/group_2.258.805381703
1 1 CURRENT NO +DATA/orcl/onlinelog/group_1.261.805381679
1 1 CURRENT NO +FRA/orcl/onlinelog/group_1.257.805381689

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

asmcmd rm +FRA/orcl/onlinelog/group_1.257.805381689
asmcmd rm +DATA/orcl/onlinelog/group_1.261.805381679

SQL> startup
ORACLE instance started.

Total System Global Area 481259520 bytes
Fixed Size 1337352 bytes
Variable Size 381683704 bytes
Database Buffers 92274688 bytes
Redo Buffers 5963776 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 16265
Session ID: 20 Serial number: 3

Alert LOG:

ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: ‘+FRA/orcl/onlinelog/group_1.257.805381689’
ORA-17503: ksfdopn:2 Failed to open file +FRA/orcl/onlinelog/group_1.257.805381689
ORA-15012: ASM file ‘+FRA/orcl/onlinelog/group_1.257.805381689’ does not exist
ORA-00312: online log 1 thread 1: ‘+DATA/orcl/onlinelog/group_1.261.805381679’
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/onlinelog/group_1.261.805381679
ORA-15012: ASM file ‘+DATA/orcl/onlinelog/group_1.261.805381679’ does not exist
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_16440.trc:
ORA-00313: open failed for members of log group 1 of thread
ORA-00312: online log 1 thread 1: ‘+DATA/orcl/onlinelog/group_1.261.805381679’
ORA-00312: online log 1 thread 1: ‘+FRA/orcl/onlinelog/group_1.257.805381689’
USER (ospid: 16440): terminating the instance due to error 313

SQL> startup mount;
ORACLE instance started.

Total System Global Area 481259520 bytes
Fixed Size 1337352 bytes
Variable Size 381683704 bytes
Database Buffers 92274688 bytes
Redo Buffers 5963776 bytes
ORA-03113: end-of-file on communication channel
Process ID: 16683
Session ID: 1 Serial number: 3

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 481259520 bytes
Fixed Size 1337352 bytes
Variable Size 381683704 bytes
Database Buffers 92274688 bytes
Redo Buffers 5963776 bytes
SQL> alter database clear logfile group 1;
alter database clear logfile group 1
*
ERROR at line 1:
ORA-01507: database not mounted

SQL> alter database mount;

Database altered.

SQL> alter database clear logfile group 1;
alter database clear logfile group 1
*
ERROR at line 1:
ORA-00350: log 1 of instance orcl (thread 1) needs to be archived
ORA-00312: online log 1 thread 1: ‘+DATA/orcl/onlinelog/group_1.261.805381679’
ORA-00312: online log 1 thread 1: ‘+FRA/orcl/onlinelog/group_1.257.805381689’

alter database clear unarchived logfile group 1; –This group number could a different
alter database open;

Alert LOG:

Thu Feb 20 09:08:08 2014
Completed: alter database clear unarchived logfile group 1
Thu Feb 20 09:08:40 2014
alter database open
Block change tracking file is current.
Thu Feb 20 09:08:40 2014
Thread 1 opened at log sequence 2
Current log# 2 seq# 2 mem# 0: +DATA/orcl/onlinelog/group_2.262.805381695
Current log# 2 seq# 2 mem# 1: +FRA/orcl/onlinelog/group_2.258.805381703
Successful open of redo thread 1

ASMCMD> cd ORCL/
lsASMCMD>
AUTOBACKUP/
BACKUPSET/
CONTROLFILE/
ONLINELOG/
ASMCMD> cd ONLINELOG/
ASMCMD> ls -ltr
WARNING:option ‘r’ is deprecated for ‘ls’
please use ‘reverse’

Type Redund Striped Time Sys Name
ONLINELOG UNPROT COARSE FEB 20 09:00:00 Y group_1.257.840013685
ONLINELOG UNPROT COARSE FEB 20 09:00:00 Y group_2.258.805381703
ONLINELOG UNPROT COARSE FEB 20 09:00:00 Y group_3.259.805381713
ASMCMD> pwd
+FRA/ORCL/ONLINELOG
ASMCMD> cd +DATA/ORCL/ONLINELOG
ASMCMD> ls -ltr
WARNING:option ‘r’ is deprecated for ‘ls’
please use ‘reverse’

Type Redund Striped Time Sys Name
ONLINELOG MIRROR COARSE FEB 20 09:00:00 Y group_1.261.840013679
ONLINELOG MIRROR COARSE FEB 20 09:00:00 Y group_2.262.805381695
ONLINELOG MIRROR COARSE FEB 20 09:00:00 Y group_3.263.805381707

Posted in ASM, RMAN | Tagged: , , , , | 1 Comment »

Backup and Recovery of all Control Files using RMAN

Posted by SangramKeshari on February 20, 2014

RMAN> configure controlfile autobackup on;

rman target / catalog rcatowner@rcat

Recovery Manager: Release 11.2.0.1.0 – Production on Wed Feb 19 20:18:15 2014

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

connected to target database: ORCL (DBID=1333162410)
recovery catalog database Password:
connected to recovery catalog database

RMAN> show retention policy;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

RMAN> backup database;

Starting backup at 19-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.805381479
channel ORA_DISK_1: starting piece 1 at 19-FEB-14
channel ORA_DISK_1: finished piece 1 at 19-FEB-14
piece handle=+FRA/orcl/backupset/2014_02_19/nnndf0_tag20140219t201838_0.302.839967519 tag=TAG20140219T201838 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.805381481
channel ORA_DISK_1: starting piece 1 at 19-FEB-14
channel ORA_DISK_1: finished piece 1 at 19-FEB-14
piece handle=+FRA/orcl/backupset/2014_02_19/nnndf0_tag20140219t201838_0.303.839967563 tag=TAG20140219T201838 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:36
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/home/oracle/BACKUP/br01.dbf
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.805381481
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.805381483
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.805381757
channel ORA_DISK_1: starting piece 1 at 19-FEB-14
channel ORA_DISK_1: finished piece 1 at 19-FEB-14
piece handle=+FRA/orcl/backupset/2014_02_19/nnndf0_tag20140219t201838_0.304.839967601 tag=TAG20140219T201838 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 19-FEB-14

Starting Control File and SPFILE Autobackup at 19-FEB-14
piece handle=+FRA/orcl/autobackup/2014_02_19/s_839967616.305.839967617 comment=NONE
Finished Control File and SPFILE Autobackup at 19-FEB-14

sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 19 20:26:47 2014

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> alter database backup controlfile to ‘/home/oracle/BACKUP/ctrl.bkp’;

Database altered.

SQL> select name from v$controlfile;

NAME
——————————————————————————–
+DATA/orcl/controlfile/current.260.805381675
+FRA/orcl/controlfile/current.256.805381675

rman target /
Recovery Manager: Release 11.2.0.1.0 – Production on Thu Feb 20 05:57:18 2014

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

connected to target database: ORCL (DBID=1333162410)

RMAN> report schema;

using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORCL

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 690 SYSTEM *** +DATA/orcl/datafile/system.256.805381479
2 570 SYSAUX *** +DATA/orcl/datafile/sysaux.257.805381481
3 100 UNDOTBS1 *** +DATA/orcl/datafile/undotbs1.258.805381481
4 5 USERS *** +DATA/orcl/datafile/users.259.805381483
5 100 EXAMPLE *** +DATA/orcl/datafile/example.265.805381757
6 25 BR_TBS *** /home/oracle/BACKUP/br01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 29 TEMP 32767 +DATA/orcl/tempfile/temp.264.805381753

asmcmd rm +DATA/ORCL/CONTROLFILE/Current.260.805381675
ORA-15032: not all alterations performed
ORA-15028: ASM file ‘+DATA/ORCL/CONTROLFILE/Current.260.805381675’ not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
asmcmd rm +FRA/ORCL/CONTROLFILE/Current.256.805381675
ORA-15032: not all alterations performed
ORA-15028: ASM file ‘+FRA/ORCL/CONTROLFILE/Current.256.805381675’ not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)

ASMCMD> rm -rf Current.260.805381675
ORA-15032: not all alterations performed
ORA-15028: ASM file ‘+DATA/ORCL/CONTROLFILE/Current.260.805381675’ not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)

srvctl stop database -d orcl

asmcmd rm +DATA/ORCL/CONTROLFILE/Current.260.805381675
asmcmd rm +FRA/ORCL/CONTROLFILE/Current.256.805381675

sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 20 06:14:16 2014

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 481259520 bytes
Fixed Size 1337352 bytes
Variable Size 377489400 bytes
Database Buffers 96468992 bytes
Redo Buffers 5963776 bytes
ORA-00205: error in identifying control file, check alert log for more info

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

rman target / catalog rcatowner@rcat

Recovery Manager: Release 11.2.0.1.0 – Production on Thu Feb 20 06:14:35 2014

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

connected to target database: ORCL (not mounted)
recovery catalog database Password:
connected to recovery catalog database

RMAN> recover database;

Starting recover at 20-FEB-14
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/20/2014 06:14:51
ORA-00210: cannot open the specified control file

RMAN> alter database mount;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/20/2014 06:15:03
ORA-00205: error in identifying control file, check alert log for more info

RMAN> restore controlfile from autobackup;

Starting restore at 20-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=26 device type=DISK

recovery area destination: +FRA
database name (or database unique name) used for search: ORCL
channel ORA_DISK_1: AUTOBACKUP +fra/ORCL/AUTOBACKUP/2014_02_19/s_839967616.305.839967617 found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20140220
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20140219
channel ORA_DISK_1: restoring control file from AUTOBACKUP +fra/ORCL/AUTOBACKUP/2014_02_19/s_839967616.305.839967617
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=+DATA/orcl/controlfile/current.260.840003437
output file name=+FRA/orcl/controlfile/current.256.840003439
Finished restore at 20-FEB-14

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> alter database open;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/20/2014 06:17:36
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

RMAN> alter database open RESETLOGS;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/20/2014 06:17:43
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: ‘+DATA/orcl/datafile/system.256.805381479’

RMAN> recover database;

Starting recover at 20-FEB-14
Starting implicit crosscheck backup at 20-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=27 device type=DISK
Crosschecked 15 objects
Finished implicit crosscheck backup at 20-FEB-14

Starting implicit crosscheck copy at 20-FEB-14
using channel ORA_DISK_1
Crosschecked 5 objects
Finished implicit crosscheck copy at 20-FEB-14

searching for all files in the recovery area
cataloging files…
cataloging done

List of Cataloged Files
=======================
File Name: +fra/ORCL/AUTOBACKUP/2014_02_19/s_839967616.305.839967617
File Name: +fra/ORCL/ARCHIVELOG/2014_02_20/thread_1_seq_37.300.839988057
File Name: +fra/ORCL/ARCHIVELOG/2014_02_19/thread_1_seq_36.296.839973725

using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 36 is already on disk as file +FRA/orcl/archivelog/2014_02_19/thread_1_seq_36.296.839973725
archived log for thread 1 with sequence 37 is already on disk as file +FRA/orcl/archivelog/2014_02_20/thread_1_seq_37.300.839988057
archived log for thread 1 with sequence 38 is already on disk as file +DATA/orcl/onlinelog/group_2.262.805381695
archived log file name=+FRA/orcl/archivelog/2014_02_19/thread_1_seq_36.296.839973725 thread=1 sequence=36
archived log file name=+FRA/orcl/archivelog/2014_02_20/thread_1_seq_37.300.839988057 thread=1 sequence=37
archived log file name=+DATA/orcl/onlinelog/group_2.262.805381695 thread=1 sequence=38
media recovery complete, elapsed time: 00:00:01
Finished recover at 20-FEB-14

RMAN> alter database open;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/20/2014 06:18:39
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

RMAN> alter database open RESETLOGS;

database opened
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

Posted in ASM, RMAN | Tagged: , , , , , , , , | 1 Comment »