Recovery Catalog


Step 1: Create a user to own Recovery Catalog..and grant him the necessary privilage


  **   create user recovery identified by recovery;

  **   grant connect,resource,recovery_catalog_owner to recovery...


Step 2 : Create a default tablespace for the recovery owner..

     **   create tablespace recovery
            datafile "....................path............." size 50m autoextend on;


Step 3: Make the user use the default tablespace which is created

     **  Alter user recovery default tablespace recovery;


Step 4: Creating catalog In the other screen just connect rman catalog..


       **    rman catalog username/password

                ex: rman catalog recovery/recovery

later inside rman

  rman > create catalog;
             ---> This commands creates a catalog database...

 rman > register database;
            ---> This commands tries to register your database in the catalog which is created but over here we
                   get an error like "Target Database not Connected "...

  rman >  CONNECT TARGET /
            --> When we get an error that it is not connected to the database we need to first connect the target
                   database...Once it is connected...it says the database is still not registered in the catalog...


rman >  register database;
           ---> Once you get that error above it says its not registered yet..give the above command again now
                  the database will get registered and will have full re-sync of the database...

 Thats it Recovery Catalog is Created.......


  rman > backup database 

                 When you give observe for the line which will not come saying
                   control file is used...instead of recovery catalog....-----> this line will be told before creating                          catalog database

Comments

Post a Comment

Popular posts from this blog

Space_Count **   select user_bytes/1024/1024 from dba_data_files         where tablespace_name='<tbs_name>'; ** select sum(user_bytes)/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>';            This will give us the space used in a particular datafile..... Tablespace_Size ** select bytes/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>'; ** select sum(bytes)/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>';             This command will give the tablespace size what size is the tablespace created of..
Read more
Index Re-building.. ALTER INDEX <IDX_NAME> REBUILD ONLINE; If your issue is its huge table and it might take more time to execute then you can use Parallel execution method. 1. Take your session in Parallel DML mode. ALTER SESSION ENABLE PARALLEL DML; 2. Take your table in Parallel Mode ALTER TABLE <TABLE_NAME> PARALLEL; 3. Run Rebuild Index command. ALTER INDEX <IDX_NAME> REBUILD ONLINE; 4.  Take your session back to normal mode. ALTER SESSION DISABLE PARALLEL DML; That is it !!!
Read more
Renaming Database Well Rename your database in a very easy way..without affecting the DBID or to the SID... Step 1 :  Backup Controlfile to text Step 2:  Create  a pfile of your database Step 3:  Edit your controlfile with database name...keeping only resetlogs Step 4:  Edit pfile with dbname and controlfile parameter.. Step 5:  Startup with nomount option with the updated pfile.. Step 6:  Create a new controlfile Step 7:  Update the new controlfile in pfile and Startup with that pfile Step 8:  Create a new Spfile from the updated Pfile....               Thats it Database is renamed.......... Sql > alter database backup controlfile to trace as '/home/oracle/control.txt [ oracle@localhost :~ ]  vi control.txt CREATE CONTROLFILE REUSE DATABASE "ORACLE" RESETLOGS  ARCHIVELOG     MAXLOGFILES 16     MAXLOGMEMBERS 3     MAXDATAFILES 100 ...
Read more