sudo su - oracle
============
============
============
ORACLE DATABASE 11.2.0.1.0
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
Make rman backup validate:
rman target /
connected to target database: ORCL (DBID=1436283480)
what is retention period:
show retention policy;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
=========================================
in ASR Prod:
tar -cvf OracleHome11.2.0.tar db_1/
send rman file to test server:
scp -r * root@10.116.8.6:/home/u02/rmanbkp/
backup database plus archivelogs;
Create user as per requirement:
Create db user
enotest/enotest
mkdir -p /home/u02/app/oracle/product/11.2.0/db_1
cd /home/u02/
chown -R enotest:dba app/oracle/product/11.2.0/db_1
chmod -R 775 app/oracle/product/11.2.0/db_1
chown -R enotest:dba u02/
chmod -R 775 archive u02/
[root@tjps-ASR u02]# mkdir -p archive rmanbkp
chown -R enotest:dba archive rmanbkp
chmod -R 775 archive rmanbkp
scp -r db_home.tar root@172.16.2.65: enotest/
rman_prod_backups –keep all backup here
scp –r <Take particular days backup datewise> root@172.16.2.65:/ORADB/app/orauat/rman_prod_backups
folder structure would be like.
Mkdir –p /OratestC/app/oratest/db/11.2.0/
Mkdir –p /OratestC/oradata
======================================================
RMAN SETUP
SQL> show parameter db_recovery_file_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /mntASR/rmanbkp
db_recovery_file_dest_size big integer 3882M
PATH=$PATH:$HOME/bin
export ORACLE_BASE=/home/u02/app/
export ORACLE_HOME=/home/u02/app/oracle/product/11.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=ORCL
======================
/home/u02/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora
SQL> startup nomount pfile='/home/u02/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora';
SQL> startup nomount pfile='/home/u02/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora';
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
Linux-x86_64 Error: 2: No such file or directory
1.
SQL> startup nomount pfile='/home/u02/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora';
ORACLE instance started.
Total System Global Area 7482626048 bytes
Fixed Size 2214416 bytes
Variable Size 5637146096 bytes
Database Buffers 1811939328 bytes
Redo Buffers 31326208 bytes
2.
[enotest@tjps-ASR rmanbkp]$ rman target / nocatalog
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jun 11 12:03:34 2018
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (not mounted)
using target database control file instead of recovery catalog
3.
-rwxrwxr-x. 1 enotest dba 33373184 Jun 7 15:34 Archive_20180606_98t4oa39_1_1
-rwxrwxr-x. 1 enotest dba 462848 Jun 7 15:35 Archive_20180606_9bt4oaac_1_1
-rwxrwxr-x. 1 enotest dba 10190848 Jun 7 15:35 Controlback_20180606_9ct4oaad_1_1
-rwxrwxr-x. 1 enotest dba 1187659776 Jun 7 15:35 Fullback_20180606_99t4oa3h_1_1
-rwxrwxr-x. 1 enotest dba 1212416 Jun 7 15:35 Fullback_20180606_9at4oaa9_1_1
RMAN> restore controlfile from '/home/u02/rmanbkp/Controlback_20180606_9ct4oaad_1_1';
Starting restore at 11-JUN-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=461 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/home/u02/app/oracle/product/11.2.0/db_1/dbs/cntrlORCL.dbf
Finished restore at 11-JUN-18
4.
RMAN> alter database mount;
5.
catalog start with '/home/u02/rmanbkp/';
RMAN> catalog start with '/home/u02/rmanbkp/';
searching for all files that match the pattern /home/u02/rmanbkp/
List of Files Unknown to the Database
=====================================
File Name: /home/u02/rmanbkp/Fullback_20180606_99t4oa3h_1_1
File Name: /home/u02/rmanbkp/Archive_20180606_9bt4oaac_1_1
File Name: /home/u02/rmanbkp/Controlback_20180606_9ct4oaad_1_1
File Name: /home/u02/rmanbkp/Fullback_20180606_9at4oaa9_1_1
File Name: /home/u02/rmanbkp/Archive_20180606_98t4oa39_1_1
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /home/u02/rmanbkp/Fullback_20180606_99t4oa3h_1_1
File Name: /home/u02/rmanbkp/Archive_20180606_9bt4oaac_1_1
File Name: /home/u02/rmanbkp/Controlback_20180606_9ct4oaad_1_1
File Name: /home/u02/rmanbkp/Fullback_20180606_9at4oaa9_1_1
File Name: /home/u02/rmanbkp/Archive_20180606_98t4oa39_1_1
6.
SQL> (select 'set newname for datafile '||FILE_ID||' to '''||file_name||''';'fro m dba_data_files);
'SETNEWNAMEFORDATAFILE'||FILE_ID||'TO'''||FILE_NAME||''';'
-------------------------------------------------------------------------------- ----------------------------------------
set newname for datafile 4 to '/u01/app/oracle/oradata/orcl/users01.dbf';
set newname for datafile 3 to '/u01/app/oracle/oradata/orcl/undotbs01.dbf';
set newname for datafile 2 to '/u01/app/oracle/oradata/orcl/sysaux01.dbf';
set newname for datafile 1 to '/u01/app/oracle/oradata/orcl/system01.dbf';
set newname for datafile 5 to '/u01/app/oracle/oradata/orcl/example01.dbf';
set newname for datafile 6 to '/u01/app/oracle/oradata/orcl/MX_DATA15X.dbf';
set newname for datafile 7 to '/u01/app/oracle/oradata/orcl/MX_INDEX15X.dbf';
set newname for datafile 8 to '/u01/app/oracle/oradata/orcl/dash_TS01.DBF';
set newname for datafile 9 to '/u01/app/oracle/oradata/orcl/dashadmin_TS01.DBF';
set newname for datafile 10 to '/u01/app/oracle/oradata/orcl/iam_TS01.DBF';
set newname for datafile 11 to '/u01/app/oracle/oradata/orcl/iam_admin_TS01.DBF' ;
set newname for datafile 12 to '/u01/app/oracle/oradata/orcl/cas_TS01.DBF';
set newname for datafile 13 to '/u01/app/oracle/oradata/orcl/users02.dbf';
set newname for datafile 14 to '/u01/app/oracle/oradata/orcl/dashadmin_TS02.DBF' ;
set newname for datafile 15 to '/u01/app/oracle/oradata/orcl/dash_TS02.dbf';
set newname for datafile 16 to '/u01/app/oracle/oradata/orcl/iam_TS02.dbf';
set newname for datafile 17 to '/u01/app/oracle/oradata/orcl/iam_TS03.dbf';
set newname for datafile 18 to '/u01/app/oracle/oradata/orcl/iam_admin_TS02.dbf' ;
set newname for datafile 19 to '/u01/app/oracle/oradata/orcl/MX_DATA15X1.dbf';
set newname for datafile 20 to '/u01/app/oracle/oradata/orcl/MX_INDEX15X1.dbf';
set newname for datafile 21 to '/u01/app/oracle/oradata/orcl/cas_TS02.dbf';
set newname for datafile 22 to '/u01/app/oracle/oradata/orcl/sysaux02.dbf';
set newname for datafile 23 to '/u01/app/oracle/oradata/orcl/system02.dbf';
set newname for datafile 24 to '/u01/app/oracle/oradata/R2015X/MX_DATA15X.dbf';
set newname for datafile 25 to '/u01/app/oracle/oradata/R2015X/MX_INDEX15X.dbf';
set newname for datafile 26 to '/u01/app/oracle/oradata/orcl/MX_V6DATA15X.dbf';
set newname for datafile 27 to '/u01/app/oracle/oradata/orcl/MX_V6INDEX15X.dbf';
set newname for datafile 28 to '/u01/app/oracle/oradata/orcl/system03.dbf';
set newname for datafile 29 to '/u01/app/oracle/oradata/orcl/sysaux03.dbf';
set newname for datafile 30 to '/u01/app/oracle/oradata/orcl/MX_INDEX15X02.dbf';
set newname for datafile 31 to '/u01/app/oracle/oradata/orcl/MX_DATA15X02.dbf';
31 rows selected.
7.
[enotest@tjps-ASR oracle]$ mkdir -p oradata
[enotest@tjps-ASR oracle]$ chmod -R 775 oradata/
drwxrwxr-x. 2 enotest dba 4096 Jun 11 12:36 oradata
drwxrwxr-x. 3 enotest dba 4096 Jun 7 14:57 product
/home/u02/app/oracle/oradata
8.
RMAN> @/home/u02/rmanbkp/restore_rman.sql
9.
10.
RMAN>list backup of archivelog all;
Thread Seq
1 6605
RUN{
set until sequence 6607 thread 1;
recover database;
}
RUN{
set until sequence 6581 thread 1;
recover database;
}
RUN{
set until sequence 6580 thread 1;
recover database;
}
RMAN-06556: datafile 1 must be restored from backup older than SCN 402423025
402423025
11.
RMAN> recover database;
Starting recover at 11-JUN-18
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/11/2018 14:15:34
ORA-19698: /u01/app/oracle/oradata/orcl/redo01.log is from different database: id=1427058923, db_name=ORCL
12.
Rename online LOGFILES
alter database rename file '/u01/app/oracle/oradata/orcl/redo03.log' to '/home/u02/app/oracle/oradata/redo03.log';
alter database rename file '/u01/app/oracle/oradata/orcl/redo02.log' to '/home/u02/app/oracle/oradata/redo02.log';
alter database rename file '/u01/app/oracle/oradata/orcl/redo01.log' to '/home/u02/app/oracle/oradata/redo01.log';
select open_mode, name from v$database;
different database: id=1427058923, db_name=ORCL
1436283480
run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup as COMPRESSED BACKUPSET format '/u01/backup/rman/%d_%t_%s_%p' tag 'ASR_full_backup' database;
SQL 'alter system switch logfile';
SQL 'alter system checkpoint';
crosscheck archivelog all;
backup AS COMPRESSED BACKUPSET archivelog all format '/u01/backup/rman/%d_Arch_Log%t_%s_%p';
backup tag = cf1 format '/u01/backup/rman/%d_Control_file%t_%s_%p' current controlfile;
release channel c1;
release channel c2;
}
EOF
https://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm#BHCJCBAF
grep MemTotal /proc/meminfo
uname -m
grep SwapTotal /proc/meminfo
cat /proc/version
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6.i686
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6.i686
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6.i686
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6.i686
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
•On Oracle Linux 6, Red Hat Enterprise Linux 6, and Asianux Server 4:
?unixODBC-2.2.14-11.el6 (x86_64) or later
?unixODBC-2.2.14-11.el6.i686 or later
?unixODBC-devel-2.2.14-11.el6 (x86_64) or later
?unixODBC-devel-2.2.14-11.el6.i686 or later
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
# more /etc/oraInst.loc
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
/home/u02/app/oracle/product/11.2.0/db_1/dbs
http://www.juliandyke.com/Research/RMAN/BackupCommand.php
bharath kr 212
100058TJ
to /opt/run/
6- mAY
4-aPR
====================================================
rman target /
RMAN>set dbid=1436283480
rman >startup nomount pfile='/home/u02/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora';
delete all control file and datafile , if there is any .
/home/u02/app/oracle/oradata/cntrlorcl01.dbf
/home/u02/app/oracle/flash_recovery_area/orcl/control02.ctl'
RMAN> restore controlfile from '/home/u02/rmanbkp/ORCL_Control_file978689059_2434_1';
RMAN> alter database mount;
RMAN>catalog start with '/home/u02/rmanbkp/';
RMAN>@/home/u02/rmanbkp/restore_rman.sql;
12.
Rename online LOGFILES
alter database rename file '/u01/app/oracle/oradata/orcl/redo03.log' to '/home/u02/app/oracle/oradata/redo03.log';
alter database rename file '/u01/app/oracle/oradata/orcl/redo02.log' to '/home/u02/app/oracle/oradata/redo02.log';
alter database rename file '/u01/app/oracle/oradata/orcl/redo01.log' to '/home/u02/app/oracle/oradata/redo01.log';
RMAN> recover database;
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 6607 and starting SCN of 402980631
RMAN> RUN{
set until sequence 6607 thread 1;
recover database;
}
SQL> alter database open resetlogs;
Database altered.
> - Change database name using "nid" command
SQL> shut immediate
SQL>startup mount;(using spfile , if pfile not in use).
SQL> select open_mode, name from v$database;
OPEN_MODE NAME
-------------------- ---------
MOUNTED ORCL
$ nid TARGET=sys DBNAME=ENOTEST
Password: as sysdba
17.- Change ORACLE_SID in environment file and start database with reset logs:
And bash_profile.
ORACLE_SID=ENOTEST
export $ORACLE_SID
[orauat@TJPSB007 dbs]$ vi initTJTG.ora
(change db name from ORCL TO new named as ENOTEST)
db_name = ENOTEST
mv initorcl.ora initENOTEST.ora
SQL>startup nomount pfile='/home/u02/app/oracle/product/11.2.0/db_1/dbs/initENOTEST.ora';
SQL> alter database mount;
SQL> alter database open resetlogs;
SQL> select open_mode, name from v$database;
OPEN_MODE NAME
-------------------- ---------
READ WRITE ENOTEST
cd /home/u02/app/diag/rdbms/enotest/ENOTEST/trace/
==============================================
> - Change database name using "nid" command
SQL> shut immediate
SQL> startup nomount pfile='/ORADB/app/orauat/11.2.0/dbs/initTJTG.ora';
SQL> alter database mount;
SQL> select open_mode, name from v$database;
OPEN_MODE NAME
-------------------- ---------
MOUNTED TJTG
$ nid TARGET=sys DBNAME=UAT
Password: as sysdba
No comments:
Post a Comment