Remote database recovery using RMAN backup piece Information

1. Mount the Backup Directory of the backup server. 1. Create a directory for storing the backup files. catdba is not used here. Therefore, the path of the Backup Directory of the production database must be the same as that of mkdirprodba.

1. Mount the Backup Directory of the backup server. 1. Create a directory for storing the backup files. catdir is not used here. Therefore, mkdir/prod/ba must be the same as the backup directory of the production database.

1. Mount the Backup Directory of the Backup Server

1. Create a backup file storage directory. catalog is not used here, so it must be the same as the backup directory path of the production database.

Mkdir/prod/backup/

2. Mount the Backup Directory of the Backup Server

Showmount-e 192.168.8.148

Mount 192.168.8.148:/arc_bk/other_bk/prod/backup

Bdf

2. pfile required to create a Remote Test Database

1. Generate pfile in the production database

Create pfile = '/tmp/initfact. ora' from spfile;

2. Create the required pfile for the Remote Test Database

Vi $ Oracle_HOME/dbs/initfact. ora

Fact. _ db_cache_size = 180355072

Fact. _ java_pool_size = 4194304

Fact. _ large_pool_size = 4194304

Fact. _ shared_pool_size = 100663296

Fact. _ streams_pool_size = 0

*. Audit_file_dest = '/u01/apps/oracle/admin/fact/adump'

*. Background_dump_dest = '/u01/apps/oracle/admin/fact/bdump'

*. Compatible = '10. 2.0.1.0'

*. Control_files = '/u01/fact/control01.ctl', '/u01/fact/control02.ctl', '/u01/fact/control03.ctl'

*. Core_dump_dest = '/u01/apps/oracle/admin/fact/cdump'

*. Db_block_size = 8192

*. Db_domain =''

*. Db_file_multiblock_read_count = 16

*. Db_name = 'fact'

*. Db_recovery_file_dest = '/u01/apps/oracle/flash_recovery_area'

*. Db_recovery_file_dest_size = 2147483648

*. Dispatchers = '(PROTOCOL = TCP) (SERVICE = factXDB )'

*. Job_queue_processes = 10

*. Log_archive_dest_1 = 'location =/u01/arch1'

*. Open_cursors = 300

*. Pga_aggregate_target = 96468992

*. Processses = 150

*. Remote_login_passwordfile = 'clusive'

*. Sga_target = 290455552

*. Undo_management = 'auto'

*. Undo_tablespace = 'undotbs1'

*. User_dump_dest = '/u01/apps/oracle/admin/fact/udump'

3. ensure the availability of the Remote Test Database Data Directory

1. Create a directory

Mkdir-p/u01/apps/oracle/admin/fact/adump

Mkdir-p/u01/apps/oracle/admin/fact/bdump

Mkdir-p/u01/apps/oracle/admin/fact/cdump

Mkdir-p/u01/apps/oracle/admin/fact/udump

Mkdir-p/u01/fact/

Mkdir-p/u01/apps/oracle/flash_recovery_area

Mkdir-p/u01/fact/datafiles

Mkdir-p/u01/fact/logfiles

2. Determine Permissions

Ls-l/u01/apps/oracle/admin/fact/

Ls-l/u01/fact

Ls-l/u01/

Ls-l/u01/apps/oracle/

3. view disk space

Bdf

4. ensure the availability of Remote Test Database Backup Information

Make sure that the data in the nfs directory can be read and written by the nobody.

Ls-l/prod/backup/

5. Start the Remote Test Database to nomount

When using rman, the corresponding memory needs to be used. Therefore, the database must be started to nomount at least.

Export ORACLE_SID = fact

Sqlplus/as sysdba

Startup nomount;