Anybody knows how to create a recovery database using rman, I never have made it.
I want to know all steps than I must to do.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny" Click HERE to vist my website!
But First I must create a db call rmandb for example and later register my database??
How rman knows what database I want to register??
C:\>rman target sys/password@tsh1 rcvcat rman/rman@dba1 msglog 'C:\Oracle\Backup\TSH1\TSH1_Daily_Backup.log'
Recovery Manager: Release 126.96.36.199.0 - Production
RMAN-06005: connected to target database: TSH1 (DBID=955315395)
RMAN-06008: connected to recovery catalog database
RMAN> register database;
while connected to the target database through recovery catalog you should explicity register the database in the recover catalog..
The article is by one of our members Tim Hall refer to his site..
Its as simple as
1. create a RMAN database sat RMANDB
2. create a user for the RMANDB say RMANUSR
3. grant connect,rescourse to RMANUSR
4. grant recovery_catalog_owner to RMANUSR
5. rman connect target sys/password
6. rman> register database.
Better still go through the Oracle Backup and Recovery Guide.
Click Here to Expand Forum to Full Width