Oracle Overview

[Former Member]

Hi All,

I am new to Oracel environment,if any one please provide me the below information.

1)After restroing the databse how will start database

2)Diffrence between BRRECOVER and BRRESTORE

3)Overview of Oracel startup procedure

4)How will run updatestatsics and use

Thanks

[MODERATOR LOCKED.  PLEASE SEARCH FIRST ASK QUESTIONS LATER]

[MODERATOR]

[Former Member]

Hi,

Answer for Question 1 )

Copy control file from source by using the below command at SQL level:

alter database backup controlfile to trace as '/tmp/newcntrl_<SID2>.sql';

Edit the <TRACEFILE> and make the following changes:

Delete everything above STARTUP NOMOUNT

Change STARTUP NOMOUNT to MOUNT

Change “REUSE” to “SET”

Change “NORESETLOGS” to “RESETLOGS”

Change the <SID1> to <SID2> in the entire file

Delete everything below the datafiles.

Connect to db-server with user ORA<SID>

sqlplus “/ as sysdba“

Execute script @/oracle/<SID2>/newcntrl_<SID2>.sql

Database is mounted

Check Alert-File ie.. /oracle/<SID2>/saptrace/background/alert_<SID2>.log

Recover database

recover database until cancel using backup controlfile; 

Apply logs if necessary

alter database open resetlogs;

Restart the database

Switch Logfile

alter system switch logfile ;

Add temp datafiles.

for Question 2)

Brrestore is used to restore the database from the available backup.

Brrecover is used for recovering the database (i.e. Applying offline or online redo log files to get the database in a consistent state)

Question 3)

STARTUP <OPTIONS>

RESTRICT

Only enables Oracle Database users with the RESTRICTED SESSION system privilege to connect to the database. Later, you can use the ALTER SYSTEM command to disable the restricted session feature.

QUIET

Suppresses the display of System Global Area information for the starting instance.

MOUNT

Mounts a database but does not open it.

OPEN

Mounts and opens the specified database.

NOMOUNT

Causes the database not to be mounted upon instance startup.

UPGRADE

Starts the database in OPEN UPGRADE mode and sets system initialization parameters to specific values required to enable database upgrade scripts to be run. UPGRADE should only be used when a database is first started with a new version of the Oracle Database Server.

Question 4)

General Update stats command used after a refresh

brconnect -u / -c -f stats -t oradict_stats -p 4

brconnect -u / -c -f stats -t system_stats -p 4

brconnect -u / -c -f stats -t all

[MODERATOR DELETED CONTENT HERE]

Regards,

NJ

[MODERATOR EDITED]

[former_member213250]

Hello there

You can find lot of documentation just with a simple google search.

Below Link Gives you info regards restore and recover options.

http://help.sap.com/saphelp_nw04/helpdata/en/e0/2caf09b0a3a24f9f7a476fca25114f/frameset.htm

Also check BRTOOLs documentation from belwo link

http://help.sap.com/saphelp_nw04/helpdata/en/e0/2caf09b0a3a24f9f7a476fca25114f/frameset.htm

Regards

Venkat

[Former Member]

Please take look at help.sap.com and SDN to find out answers. You can find many threads and documents easily, about them.

Best regards,

Orkun Gedik