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;