This manual describes the steps that are necessary to create a new database, with a new database name from a RMAN backup that is stored on disk.
Create pfile
1 |
<span style="font-size: 14px;">oracle> vi /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initPDBFU.ora</span> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
*.audit_file_dest='/u01/app/oracle/admin/pdbfu/adump' *.audit_trail='db' *.compatible='11.2.0.0.0' *.control_files='/u02/pdbfu/PDBFU/controlfile/o1_mf_9529twfo_.ctl','/u02/pdbfu/fast_recovery_area/PDBFU/controlfile/o1_mf_9529twjz_.ctl' *.db_block_size=8192 *.db_create_file_dest='/u02/pdbfu' *.db_domain='' *.db_name='pdbfu' *.db_recovery_file_dest='/u02/pdbfu/fast_recovery_area' *.db_recovery_file_dest_size=21474836480 *.db_unique_name='pdbfu' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=pdbfuXDB)' *.log_archive_format='%t_%s_%r.dbf' *.open_cursors=300 *.processes=800 *.remote_login_passwordfile='EXCLUSIVE' *.sessions=885 *.undo_tablespace='UNDOTBS1' |
1 2 |
*.log_file_name_convert=(/u02/pdbfusion/PDBFUSION/,/u02/pdbfu/) *.db_file_name_convert=(/u02/pdbfusion/PDBFUSION/,/u02/pdbfu/) |
Create directories
1 2 3 |
oracle> mkdir -p /u02/pdbfu mkdir -p /u02/pdbfu/fast_recovery_area/PDBFU/ mkdir -p /u01/app/oracle/admin/pdbfu/adump |
Create password file
1 |
oracle> orapwd file=$ORACLE_HOME/dbs/orapwPDBFU password=password entries=10 |
Start Database nomount
1 2 3 4 |
oracle> export $ORACLE_SID=PDBFU oracle> sqlplus / as sysdba SQL> startup nomount |
Create tnsnames.ora
1 |
oracle> vi /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora |
1 2 3 4 5 6 7 8 |
PDBFU = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oeltest1.tss.nl)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdbfu.tss.nl) ) ) |
Start RMAN restore
1 |
oracle> rman auxiliary / |
1 |
RMAN> DUPLICATE DATABASE TO 'PDBFU' BACKUP LOCATION '/u02/oradata/rman'; |
Please let me know if this installation manual ‘Clone RMAN new database SID’ was usefull to you. If there are errors or you have suggestions regarding this manual, please let me know.
No rights can be derived from this Installation manual
Regards,
Maarten