Salman Bin Muhammad: RAC on ASM 11g Rman Backup restore to Non Rac Single Instance Machine with SET NEWNAME

Note:- STEP 01 and 02 are mainly required when you configure Grid Infrastructure.

STEP 01

userdel -r oracle

userdel -r grid

groupdeloinstall

groupdeldba

groupdeloper

groupdelasmadmin

groupdelasmdba

groupdelasmoper

OUT PUT

[root@clone ~]# userdel -r oracle

[root@clone ~]# userdel -r grid

userdel: user grid does not exist

[root@clone ~]# groupdeloinstall

[root@clone ~]# groupdeldba

[root@clone ~]# groupdeloper

groupdel: group oper does not exist

[root@clone ~]# groupdelasmadmin

groupdel: group asmadmin does not exist

[root@clone ~]# groupdelasmdba

groupdel: group asmdba does not exist

[root@clone ~]# groupdelasmoper

groupdel: group asmoper does not exist

[root@clone ~]#

STEP 02

/usr/sbin/groupadd -g 510 oinstall

/usr/sbin/groupadd -g 511 asmadmin

/usr/sbin/groupadd -g 512 asmdba

/usr/sbin/groupadd -g 513 asmoper

/usr/sbin/groupadd -g 514 dba

/usr/sbin/groupadd -g 515 oper

OUTPUT

[root@clone ~]# /usr/sbin/groupadd -g 510 oinstall

[root@clone ~]# /usr/sbin/groupadd -g 511 asmadmin

[root@clone ~]# /usr/sbin/groupadd -g 512 asmdba

[root@clone ~]# /usr/sbin/groupadd -g 513 asmoper

[root@clone ~]# /usr/sbin/groupadd -g 514 dba

[root@clone ~]# /usr/sbin/groupadd -g 515 oper

STEP 03

useradd -u 501 -g oinstall -G asmadmin,asmdba,asmoper grid

useradd -u 502 -g oinstall -G dba,asmdba,oper oracle

OUTPUT

[root@clone ~]# useradd -u 501 -g oinstall -G asmadmin,asmdba,asmoper grid

[root@clone ~]# useradd -u 502 -g oinstall -G dba,asmdba,oper oracle

STEP 04

mkdir -p /u01/app/11.2.0/grid

mkdir -p /u01/app/grid

mkdir -p /u01/app/oracle

OUTPUT

[oracle@clone app]$ mkdir -p /u01/app/11.2.0/grid

[oracle@clone app]$ mkdir -p /u01/app/grid

[oracle@clone app]$ mkdir -p /u01/app/oracle

STEP 05

chown -R grid:oinstall /u01

mkdir -p /u01/app/oracle

chown -R oracle:oinstall /u01/app/oracle

chmod -R 775 /u01/

OUTPUT

[root@clone u01]# chown -R grid:oinstall /u01

[root@clone u01]# mkdir -p /u01/app/oracle

[root@clone u01]# chown-R oracle:oinstall /u01/app/oracle

[root@clone u01]# chmod -R 775 /u01/

su - oracle

cd /home/oracle

vi .bash_profile

add the following lines in .bash_profile

export ORACLE_HOSTNAME=clone.edi.pict.com.pk

export ORACLE_UNQNAME=pictdb

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

export ORACLE_SID=pictdb

export PATH=$PATH:$ORACLE_HOME/bin

then save and quit

STEP 06

Make the following Directories

mkdir -p /u01/app/oracle/admin/pictdb/adump

mkdir -p /u01/pictdb/controlfile/

mkdir -p /u01/app/oracle

mkdir -p/u01/oracle/product/oradata/pictdb/

Output

[root@clone ~]# mkdir -p /u01/app/oracle/admin/pictdb/adump

[root@clone ~]# mkdir -p /u01/pictdb/controlfile/

[root@clone ~]# mkdir -p /u01/app/oracle

STEP 07

Create Pfile

cd /u01/app/oracle

vipfile.txt

(Note:- Copy below all the lines in pfile.txt)

*.audit_file_dest='/u01/app/oracle/admin/pictdb/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files=‘/u01/app/oracle/oradata/pictdb/control01.ctl','/u01/app/oracle/oradata/pictdb/control02.ctl'

*.cursor_sharing='FORCE'

*.db_block_size=8192

*.db_create_file_dest=''

*.db_domain=''

*.db_name='pictdb'

*.db_recovery_file_dest=''

*.db_recovery_file_dest_size=858993459200

*.diagnostic_dest='/u01/app/oracle'

*.log_archive_dest_state_2='ENABLE'

*.log_buffer=99682688

*.open_cursors=3000

*.pga_aggregate_target=2522873856

*.processes=1500

*.remote_login_passwordfile='EXCLUSIVE'

*.sec_case_sensitive_logon=FALSE

*.session_cached_cursors=1000

*.sessions=2000

*.sga_max_size=2g

*.sga_target=2g

*.undo_tablespace='UNDOTBS1'

SAVE AND QUIT

STEP 08

[oracle@clone oracle]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 27 11:41:06 2013

Connected to an idle instance.

STEP 09

SQL> startup nomountpfile='/u01/app/oracle/pfile.txt';

ORACLE instance started.

Total System Global Area 2137886720 bytes

Fixed Size 2230072 bytes

Variable Size 486541512 bytes

Database Buffers 1543503872 bytes

Redo Buffers 105611264 bytes

STEP 10

SQL> create spfile from pfile='/u01/app/oracle/pfile.txt';

File created.

STEP 11

SQL>shu abort

ORACLE instance shut down.

STEP 12

SQL> startup nomount

OUTPUT

ORACLE instance started.

Total System Global Area 2137886720 bytes

Fixed Size 2230072 bytes

Variable Size 486541512 bytes

Database Buffers 1543503872 bytes

Redo Buffers 105611264 bytes

SQL>

STEP 13

SQL> exit

STEP 14

su - root

[root@clone u01]# chown -R oracle:oinstall /u01/habib/

STEP 15

su - oracle

STEP 16

[oracle@clone ~]$ cd /u01/habib/bakup-Feb-25-13/

ls -ltra

OUTPUT

[oracle@clone bakup-Feb-25-13]$ ls -ltra

total 36973672

-rwxrwxr-x 1 oracle oinstall14533926912 Feb 26 10:16 datafiles_PICTDB_1385_1_1.bkp

-rwxrwxr-x 1 oracle oinstall11333345280 Feb 26 10:20 datafiles_PICTDB_1386_1_1.bkp

-rwxrwxr-x 1 oracle oinstall 36339712 Feb 26 10:20 PICTDB_c-4197939688-20130225-00.ctl

-rwxrwxr-x 1 oracle oinstall10967695360 Feb 26 10:11 datafiles_PICTDB_1384_1_1.bkp

-rwxrwxr-x 1 oracle oinstall 302272512 Feb 26 10:20 archivelogs_PICTDB_1388_1_1.bkp

-rwxrwxr-x 1 oracle oinstall 320047104 Feb 26 10:20 archivelogs_PICTDB_1389_1_1.bkp

-rwxrwxr-x 1 oracle oinstall 36339712 Feb 26 10:21 PICTDB_c-4197939688-20130225-01.ctl

-rwxrwxr-x 1 oracle oinstall 2523136 Feb 26 10:21 controlfiles_PICTDB_1391_1_1.bkp

-rwxrwxr-x 1 oracle oinstall 291505664 Feb 26 10:21 archivelogs_PICTDB_1390_1_1.bkp

drwxrwxr-x 2 oracle oinstall 4096 Feb 26 10:21 .

drwxrwxr-x 3 oracle oinstall 4096 Feb 26 11:04 ..

NOTE: the permission should be like this

STEP 17

Enter user-name: sys/oracle as sysdba

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter system set control_files='/u01/app/oracle/oradata/pictdb/control01.ctl','/u01/app/oracle/oradata/pictdb/control02.ctl' scope=spfile;

System altered.

STEP 18

SQL> startup nomount force

OUTPUT

ORACLE instance started.

Total System Global Area 2137886720 bytes

Fixed Size 2230072 bytes

Variable Size 486541512 bytes

Database Buffers 1543503872 bytes

Redo Buffers 105611264 bytes

STEP 19

SQL> show parameter control

OUTPUT

NAME TYPE VALUE

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

control_file_record_keep_time integer 7

control_files string /u01/app/oracle/oradata/pictdb

/control01.ctl, /u01/app/oracl

e/oradata/pictdb/control02.ctl

STEP 20

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

STEP 21

[oracle@clonedbs]$ cd /u01/app/oracle/

STEP 22

[oracle@clone oracle]$ vi pfile.txt

Output

*.audit_file_dest='/u01/app/oracle/admin/pictdb/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.cursor_sharing='FORCE'

*.db_block_size=8192

*.db_create_file_dest=''

*.db_domain=''

*.db_name='pictdb'

*.db_recovery_file_dest=''

*.db_recovery_file_dest_size=858993459200

*.diagnostic_dest='/u01/app/oracle'

*.log_archive_dest_state_2='ENABLE'

*.log_buffer=99682688

*.open_cursors=3000

*.pga_aggregate_target=2522873856

*.processes=1500

*.remote_login_passwordfile='EXCLUSIVE'

*.sec_case_sensitive_logon=FALSE

*.session_cached_cursors=1000

*.sessions=2000

*.sga_max_size=2g

*.sga_target=2g

*.undo_tablespace='UNDOTBS1'

*.control_files='/u01/app/oracle/oradata/pictdb/control01.ctl','/u01/app/oracle/oradata/pictdb/control02.ctl'

STEP 23

[oracle@clone oracle]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Feb 28 11:06:15 2013

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: initialization of internal recovery manager package failed

RMAN-04005: error from target database:

ORA-01031: insufficient privileges ( in case of error , use the following )

[oracle@clone oracle]$ rman

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Feb 28 11:06:23 2013

RMAN> connect target sys/oracle

connected to target database: PICTDB (not mounted)

RMAN>

STEP 24

RMAN> restore controlfile from '/u01/habib/bakup-Feb-28-13/ PICTDB_c-4197939688-20130228-00.ctl';

OUTPUT

Starting restore at 27-FEB-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=1146 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u01/app/oracle/oradata/pictdb/control01.ctl

output file name=/u01/app/oracle/oradata/pictdb/control02.ctl

Finished restore at 27-FEB-13

STEP 25

RMAN> alter database mount;

OUTPUT

RMAN> alter database mount;

database mounted

STEP 26

RMAN> catalog start with '/u01/habib/bakup-Feb-28-13';

OUTPUT

searching for all files that match the pattern /u01/habib/bakup-Feb-25-13

List of Files Unknown to the Database

=====================================

File Name: /u01/habib/bakup-Feb-25-13/PICTDB_c-4197939688-20130225-01.ctl

File Name: /u01/habib/bakup-Feb-25-13/archivelogs_PICTDB_1390_1_1.bkp

File Name: /u01/habib/bakup-Feb-25-13/datafiles_PICTDB_1384_1_1.bkp

File Name: /u01/habib/bakup-Feb-25-13/controlfiles_PICTDB_1391_1_1.bkp

File Name: /u01/habib/bakup-Feb-25-13/datafiles_PICTDB_1385_1_1.bkp

File Name: /u01/habib/bakup-Feb-25-13/PICTDB_c-4197939688-20130225-00.ctl

File Name: /u01/habib/bakup-Feb-25-13/datafiles_PICTDB_1386_1_1.bkp

File Name: /u01/habib/bakup-Feb-25-13/archivelogs_PICTDB_1389_1_1.bkp

File Name: /u01/habib/bakup-Feb-25-13/archivelogs_PICTDB_1388_1_1.bkp

Do you really want to catalog the above files (enter YES or NO)? YES

cataloging files...

cataloging done

List of Cataloged Files

=======================