Skip to main content

RESTORATION

 Restoration is one of the major concept and critical one in oracle database

With the help of R-man backup we can restore any database at any cost

Without full rman backup we cannot restore a database


Steps for restoration:

We need to complete R-man backup (level 0) at the same time take backup for p-file (p-file = parameter file)

Copy the R-man backup pieces in p-file from source server to target server

Before restoration make sure same version of binaries hascto be installed

We need to change the p-file locations as per the existing database

Once the p-file is ready we need to export the enviromental variables


Production (DC) standby (DR)

   Source Target

R man 

Back up pieces>> win scp>> location

                  Copy>>>>>>>>>>>paste

                                         Sql> startup nomount

                                         Sql> rman target

                                    Rman> restore controlfile/path/controlfilelocation

                                         Alter database mount;

                                         Catlog starts with path location/path/path

                                         Restore database

                                         Recover database

Select * from v$ sql> select distinct ( checkpoint_change# )

recovery_file from v$datafile_headers;

No rows selected sql> 110185

1108756 110186 only one number should come

Checkpoint 110187

                                              Sequence number

Archives 110 catlog starts with 110scr num path recover 

                                              Database

                                          Alter database open resetlogs

                                          Select open_mode from v$database

                                             Read write

                                   



Some interview questions


What is db link ( database link )?

A db link is a pointer that defines a one way communication path from oracle database server to another server


What is primary key?

The primary key is the colum or set of colums that uniquely idenrifies each row in the table


What is unlimited table space?

Auto extend / unlimited


Can you take export in stand by

Export can be taken in standby and can be imported in primary by changing mode to snapshot

Comments

Post a Comment

Popular posts from this blog

Oracle database single instance architecture

Oracle database single instance architecture  Maine database runs on a single machine we referred to this architecture as the Oracle database single instance architecture this setup involves having one Oracle database instance running on the mission serving its clients   The term Oracle database instance simply refers to the combination of memory structure and database process that collectively represent the database service.  However this Architectire has a significant availability risk.  If anything goes wrong with the mission that database becomes UN available.
Post a Comment
Read more

Table spaces

 Tablespace consists of one or more data files.  A data file belongs to only one tablespace. Segments, Extents, and Blocks • Segments exist within a tablespace • Segments are made up of a collection of extents • An extents is a collection of logically contiguous data blocks - Cannot span multiple data files • Data blocks are mapped to disk blocks SYSTEM and SYSAUX Tablespaces • The SYSTEM and SYSAUX tablespaces are mandatory tablespaces. • They are created at the time of database creation. • They must be online. • The SYSTEM tablespace is used for core functionality (for example, data dictionary tables). • The auxiliary SYSAUX tablespace is used for additional database components.
Post a Comment
Read more