Dear Readers,
In this article, we will see the STANDALONE to RAC Conversion.
1)Take the existing database backup using the crontab job
2) Take the database information. (i.e datafile,tempfile,redolog & Controlfile)
3) Take the pfile backup to any location from spfile.
4) Export the SID to JRQ and start the db using the pfile.
Note: Make sure set cluster_database=false in pfile.
5) Start the database using the pfile & connect to rman set the DB ID
6) Restore database controlfile using the below command. Take the control file backuo piece info in backup log file
|
1 2 3 4 5 6 |
run { ALLOCATE CHANNEL C1 TYPE SBT PARMS 'SBT_LIBRARY=/oracle/RDBMS/11204/lib/libddobk.so ENV=(STORAGE_UNIT=ddbea_pol_oracle_kron,BACKUP_HOST=frcbs1011.emea.bpo.accenture.com,ORACLE_HOME=/oracle/RDBMS/11 204)'; restore controlfile from 'JRQ_c-2797262295-20180129-00.ctl'; release channel C1; } |
7) Mount the database.
Alter database mount;
8) Restore the database using the below script
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
run { ALLOCATE CHANNEL C1 TYPE SBT PARMS 'SBT_LIBRARY=/oracle/RDBMS/11204/lib/libddobk.so ENV=(STORAGE_UNIT=ddbea_pol_oracle_kron,BACKUP_HOST=frcbs1011.emea.bpo.accenture.com,ORACLE_HOME=/oracle/RDBMS/11 204)'; ALLOCATE CHANNEL C2 TYPE SBT PARMS 'SBT_LIBRARY=/oracle/RDBMS/11204/lib/libddobk.so ENV=(STORAGE_UNIT=ddbea_pol_oracle_kron,BACKUP_HOST=frcbs1011.emea.bpo.accenture.com,ORACLE_HOME=/oracle/RDBMS/11 204)'; ALLOCATE CHANNEL C3 TYPE SBT PARMS 'SBT_LIBRARY=/oracle/RDBMS/11204/lib/libddobk.so ENV=(STORAGE_UNIT=ddbea_pol_oracle_kron,BACKUP_HOST=frcbs1011.emea.bpo.accenture.com,ORACLE_HOME=/oracle/RDBMS/11 204)'; ALLOCATE CHANNEL C4 TYPE SBT PARMS 'SBT_LIBRARY=/oracle/RDBMS/11204/lib/libddobk.so ENV=(STORAGE_UNIT=ddbea_pol_oracle_kron,BACKUP_HOST=frcbs1011.emea.bpo.accenture.com,ORACLE_HOME=/oracle/RDBMS/11 204)'; send 'set username pol_oracle password w9VR0QQoiH.QvchF8S.p servername frcbs1011.emea.bpo.accenture.com'; set until time "to_date('2018-01-29:20:00:00', 'yyyy-mm-dd:hh24:mi:ss')"; restore database; release channel C1; release channel C2; release channel C3; release channel C4; } |
9) Recover the database
10 ) While recovering the db it’s asking more archive logs. I have restored that particular archive logs to /oracle/home/oracle location
10) Open the database with reset log option
RAC CONVERSION:
1) Take the existing pfile backup in dbs location
2) Create 2 pfiles for insatnce1 & Instance2
3) Start & Stop the instance1 database using the pfile
NODE2:
4) Start the database in node2 using the pfile
5) Create spfile in ASM location using the running pfile
6) Shutdown the database in node2 (Instance 2)
7) Take the existing pfiles backup and update the pfiles as below
8) startup up the db using newly created pfile
9) Set the cluster_Database to true and shutdown the database and start in both nodes
10) STOP both the instance and start the databases using srvctl command
Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates
KTEXPERTS is always active on below social media platforms.
Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts
Instagram : https://www.instagram.com/knowledgesharingplatform
Note: Please test scripts in Non Prod before trying in Production.
Loading...
