I am trying to learn how to use RMAN , version is 12.2 Read Oracle documentation.... It talked about setting up a Ghost instance first... Thought I did what it supposes to do, 1. copy password file from source and rename it 2. edit listenor.ora to add a static entry for the Ghost instance 3. edit tnsnames.ora to add an entry for the Ghost instance
but when I tried to do RMAN connect to the Ghost instance
it said ORA-12560: TNS:protocol adapter error
I am not sure what did I miss any help is appreciated.
I kind of find the solution myself... anyhow... Oracle Documentation is pretty rough.... but they need to support so many different platforms so it is understandable... anyhow... I meant Ghost instance is like an instance which has nothing but init file and password file and folder structures...
I am in windows env
what I did is use Oracle Database configuration assistant to create a dummy instance with the same feature as the source (no Oracle Auto Naming) then I modify the init file to add the DB_FILE_NAME_CONVERT AND LOG_FILE_NAME_CONVERT parameters, then restart the instance nomount then the RMAN works successfully.... duplicating the instance.... I cannot manually create the "Ghost" instance.
I now will go to next chapter trying to do data-guard....
exact detail steps :
- First use Oracle Database Configuration Assistant to create a instance B12C make sure use the same feature as the source instance such as both turn off Oracle Auto Naming
1.5. setup A12C and B12C on both tsnames.ora for both source and destinations server and tested it
- modify parameter file add these rows :
- remove this line from parameter file :
copy the init text file into spfile
restart B12C nomount
run this in dos
rman target sys/xxxxx@a12c auxiliary sys/xxxx@b12c
rman> duplicate target database to b12c from active database using backupset;