842949 wrote:You must start standby database nomount mode, and 1 restore standby controlfile from backup.
i have requirement to set the Datagurad in 11gr2 Database(126.96.36.199) and they are using OMF so for sure i know i cannot use db_file_name_convert and log_file_name_convert.
please clarify me on below points?
1) since DB is of size 100+GB, i will take backup of database and scp the files to DR server and initiate the Restore database to standby command.
here below are my doubtsFolders will create automatically, don't forget set DB_UNIQUE_NAME of standby database, you can use following parameters as
a) since in OMF do we need to per-create the directories in DR side?
for sure i have set the db_create_file_dest and db_recovery_area_dest are availabile. what about full extension of datafiles like
so datafiles in DR will be restore as
so do i need to manually create the directories as Above or Oracle will create by its self based on the pfile parameters and db_unique name?
Can you paste here, you steps for creation of standby database?
set db_create_file_dest='/u02/oradata' set db_create_online_log_dest_1='/u02/oradata' set db_create_online_log_dest_2='/u02/oradata' set db_recovery_file_dest='/u02/fast_recovery_area'
842949 wrote:Looks good article.
i will follow the below steps from jeffhunter
a) keep the standby in NOMOUNT state, after making necessary changes in the pfile with respect to standby like db_unique_name,db_create_file_dest,online_logfile_dest_1,online_logfile_dest_2,db_recovery_file_dest?Yes, look in article "Create and Start the Standby Instance' : *SQL> startup nomount*
b) duplicate target database for standby.Then RMAN automatically restore standby control file and mount it.
but in that document they mentioned to manually create the directories ?I think as you, oracle automatically create folders when you create database.
thats the reason i posted here why we need to create the directories as per OMF since Oracle will create it automatically?
also mahir, i seen your documents for DG BROKER which was very helpfull for me thanks a lot.You are welcome!