RMAN recovery steps and troubleshooting

RMAN recovery steps and troubleshooting
1. Install OS + Oracle Software on the testing machine, including configuring oracle users, groups, and environment variables (omitted). 2. Start recovery from different machines. copy the latest backup set, initialization parameters, and password file of the source database to the test machine [oracle @ ora10g backupsets] $ scp * 20141012*192.168.1.213:/tmpThe authenticity of host '2017. 168.1.213 (192.168.1.213) 'Can't be established. RSA key fingerprint is 78: 0e: 33: cb: 3f: 04: e4: 5d: d1: 71: 29: a4: 3f: 3a: 79: 41.Are you sure you want to continue connecting (yes/no )? YesWarning: Permanently added '2017. 168.1.213 '(RSA) to the list of known hosts.oracle@192.168.1.213's password: Connection closed by 192.168.1.20.lost connection [oracle @ ora10g backupsets] $ scp * 20141012*192.168.1.213:/tmporacle@192.168.1.213's password: ora10g-4175411955_20141012_860776699_315.arc 100% 4336KB 2.1 MB/s ora10g-4175411955_20141012_860776704_316.db 100% 165 MB 2.1 MB/s 0ora10 G-4175411955_20141012_860776830_317.arc 100% 418KB 116.5kb/s ora10g-c-4175411955-20141012-00.ctl 100% 7424KB 2.4 MB/s [oracle @ ora10g backupsets] $ scp $ ORACLE_HOME/dbs/initora10g. ora oracle@192.168.1.213:/tmporacle@192.168.1.213's password: initora10g. ora 100% 1136 1.1KB/s [oracle @ ora10g backupsets] $ scp $ ORACLE_HOME/dbs/orapwora10g oracle@192.168.1.213:/tmporacle@192.168.1.213's p Assword: orapwora10g 100% 1536 1.5KB/s if no initora10g is generated. when the ora parameter file is initialized, create an SQL> create pfile from spfile. After the file is created, place the default path under $ ORACLE_HOME/dbs. modify the initialization parameter [root @ bak tmp] # cat initora10g. ora ora10g. _ db_cache_size = 0ora10g. _ java_pool_size = 0ora10g. _ large_pool_size = 0ora10g. _ shared_pool_size = 0ora10g. _ streams_pool_size = 0 *. audit_file_dest = '/oracle/admin/ora10g/adump '*. background_dump_dest = '/oracle/admin/or A10g/bdump '*. compatible = '10. 2.0.1.0 '*. control_files = '/oradata/ora10g/control01.ctl', '/oradata/ora10g/control02.ctl', '/oradata/ora10g/control03.ctl' # Restore Controlfile *. core_dump_dest = '/oracle/admin/ora10g/cdump '*. db_block_size = 8192 *. db_domain = ''*. db_file_multiblock_read_count = 16 *. db_name = 'ora10g '*. db_recovery_file_dest = '/oracle/flash_recovery_area '*. db_recovery_file_dest_size = 2147483648 *. dispatch Ers = '(PROTOCOL = TCP) (SERVICE = ora10gXDB )'*. job_queue_processes = 10 *. log_archive_format = '% t _ % s _ % r. dbf '*. nls_language = 'simplified CHINESE '*. nls_territory = 'China '*. open_cursors = 300 *. pga_aggregate_target = 0 *. processes = 150 *. remote_login_passwordfile = 'clusive '*. sga_target = 0 *. undo_management = 'auto '*. undo_tablespace = 'undotbs1 '*. user_dump_dest = '/oracle/admin/ora10g/udump' Note: assume that the directory used by the test machine here is different from the source database. Note that the red part is the modified content. 3. Copy the password file and the modified initialization parameter file to the corresponding location of the Test Machine [oracle @ bak ~] $ Mv/tmp/initora10g. ora $ ORACLE_HOME/dbs [oracle @ bak ~] $ Mv/tmp/orapwora10g $ ORACLE_HOME/dbs

-------------------------------------- Recommended reading --------------------------------------

RMAN: Configure an archive log deletion policy

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

-------------------------------------- Split line --------------------------------------

4. create a directory on the Test Machine Based on the path specified in the initialization parameter file (note that the directory must have read and write permissions for oracle users) [root @ bak tmp] # mkdir/oradata/ora10g-p [root @ bak tmp] # mkdir/oracle/admin/ora10g/adump-p [root @ bak tmp] # mkdir /oracle/admin/ora10g/bdump [root @ bak tmp] # mkdir/oracle/admin/ora10g/cdump [root @ bak tmp] # mkdir/oracle/admin/ora10g/udump [root @ bak tmp] # chown oracle: oinstall/oradata-R [root @ bak tmp] # chmod 755/oradata-R [root @ bak tmp] # chown oracle: oi Nstall/oracle-R [root @ bak tmp] # chmod 755/oracle-R 5. start the instance to nomountSQL> startup nomountORA-00371: not enough shared pool memory, shocould be atleast 72265318 bytes because it is assumed that the test machine configuration is lower than the source library, and is not sure how to assign SGA, in the initialization parameter, set all memory allocation values to 0, including sga_target. Since no memory component is automatically allocated, manually set sga_target = 1g SQL>! [Oracle @ bak ~] $ Vim/u01/app/oracle/product/10.2.0/db_1/dbs/initora10g. ora... *. sga_target = 1G
... After saving the modification, restart the instance [oracle @ bak ~] $ Sqlplus/as sysdba SQL * Plus: Release 10.2.0.1.0-Production on Sun Oct 12 17:25:50 2014 Copyright (c) 1982,200 5, Oracle. all rights reserved. connected to an idle instance. SQL> startup nomountORA-01261: Parameter db_recovery_file_dest destination string cannot be translatedORA-01262: Stat failed on a file destination directoryLinux Error: 2: No such file or directory since you just forgot to create/oracle/flash_re Covery_area directory. Therefore, an error is reported. If the test machine does not want to enable FRA, comment out the parameter SQL>! [Oracle @ bak ~] $ Vim/u01/app/oracle/product/10.2.0/db_1/dbs/initora10g. ora
... # *. Db_recovery_file_dest = '/oracle/flash_recovery_area' # *. db_recovery_file_dest_size = 2147483648... [oracle @ bak ~] $ Sqlplus/as sysdba
SQL * Plus: Release 10.2.0.1.0-Production on Sun Oct 12 17:28:08 2014 Copyright (c) 1982,200 5, Oracle. all rights reserved. connected to an idle instance. SQL> startup nomountORACLE instance started. total System Global Area 1073741824 bytesFixed Size 1223512 bytesVariable Size 264242344 bytesDatabase Buffers 805306368 bytesRedo Buffers 2969600 bytesSQL> Note: if you cannot use OS Local verification when logging on to SQLPLUS, you only need to create Resolution after listening 6. Restore the control file of the Test Machine [oracle @ bak ~] $ Rman target/Recovery Manager: Release 10.2.0.1.0-Production on Sun Oct 12 17:42:07 2014 Copyright (c) 1982,200 5, Oracle. all rights reserved. connected to target database: ora10g (not mounted) RMAN> restore controlfile from '/tmp/ora10g-c-4175411955-20141012-00.ctl'; Starting restore at 12-OCT-14using target database control file instead of recovery alogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid = 156 devtype = DISK channel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore complete, elapsed time: 00: 00: 05 output filename =/oradata/ora10g/export filename =/oradata/ora10g/export filename =/oradata/ora10g/export restore at 12-oc14 RMAN> alter database mount; database mountedreleased channel: ORA_DISK_1

 

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

 

For more details, please continue to read the highlights on the next page:

1 2 3 Next Page